Search results for query: *

So I have a load action that automatically refreshes the page during a successful save (via the Save_Button.Click) Private Sub Main_Add_Load(sender As Object, e As EventArgs) Handles MyBase.Load, Save_Button.Click The issue is that when the user clicks the save button I need to check to make...

So I inherited a program that has the following formula: =SUMIF('National Feeder'!$C$40:$C$45,markets!$E$73,'National Feeder'!$D$40:$D$45) However I need to add ISERROR to this formula somehow, and when I try: =SUM(IF(ISERROR('National Feeder'!$C$40:$C$45,markets!$E$73,'National...

So what I am trying to do is to figure out between two tables which one has the bigger Record ID. Once I find that out I want to output this number with a +1 to a text box. Dim DataConnect As New Data_Connection_Final Dim Staff As String = "" Dim DataPullStaff As New...

So I am trying to make an IF statement that if the date logic stays as default (1/1/1900) then I want my program to do one thing, else do something else. If StaffEnd_DT.Value.Equals("1/1/2000 12:00:00 AM") Or StaffEnd_DT.Value.Equals("1/1/1900 12:00:00 AM") Then When I try to debug, it looks...

So I am trying to have my Excel workbook copy and paste values when the value changes in my dropdown box. I was hoping someone could help me understand how to connect my code. So far I have the following: Dim ws As Worksheet Dim dd As DropDown Set ws = ActiveSheet Set dd =...

Good Morning! I haven't dealt much in exporting to Excel from SQL so I was hoping I could be pointed in the right direction. I am trying to export all my tables (22) from SQL Server into Excel, then zip the entire set. I also want to allow the user to decide where the zip file will be saved...

So I am not sure the best way to approach this problem. I want to update a table the following way: I want to create a duplicate record but put a tag on the old record, for example: Name: John Role: Manager Rate: 22.00 Name: John Role: Historical______Manager Rate: 22.00 I was thinking...

I had this idea but I am not sure how to go about implimenting this process. I have a combo box on my form that when loaded houses my table names (From Access). I want to be able to open an Excel file and compare it with this table, then spit out the differences in another Excel file. I am...

So I have been trying to figure this issue out and am not sure where to begin. I have a datagrid which I have coded where the user is able to select 1 row only. I wanted to create an edit button that would capture the data within that row and then populate another form's text boxes that the...

So I have a dilemma I am trying to work through. I have 1 access table with 13 fields (Name, Jan Proj, Feb Proj, Mar Proj, Apr Proj, May Proj, Jun Proj, Jul Proj, Aug Proj, Sep Proj, Oct Proj, Nov Proj, Dec Proj). The names can contain duplicates and the Month Proj contains either a 0 or a...

I have an outlook ribbon that I have created, however I came across a problem. I just want the ribbon to show when the user clicks into the "Sent Items" folder, but I am not sure the syntax that is needed. I am guessing it needs to go into the Ribbon Load: Private Sub Ribbon1_Load(ByVal...

I have never attempted this type of form question capture and was looking for a little help. I have 1 table with ID, Name and Description I need a form that displays the Name and Description to the user with the following button choices: Favorite, Yes, Maybe, No Then depending on what the...

USING OFFICE 2010 So I have an issue when a user clicks on a checkbox it will hide or show certain rows. Within these rows are dropdown boxes and checkboxes that I have coded to show or hide. Every once in awhile I notice that all the dropdown boxes bunch up at the top of the row. Is there a...

This problem just started happening and I don't know why. Before I was able to go into the properies of my Measures and edit the formats, not the system is not allowing me to click through the tabs. What am I doing wrong? I am even trying on previous pyi files that I have edited the formats...

I am trying to find documentation on how to use SAS datasets and Cognos Transformer. I know a little bit to be dangerous but I would love to find documentation out there to broaden my knowledge of the subject.

OK so I have been using DLookUp, and it works for everything I need on the form, except for the clickable hyperlink. I have checked the following: Table field: Is Hyperlinked Query: Hyperlink pulls in correctly So I need something in my text or list box that can give me a clickable...

I have saved on CD all my AOL 4.0 email files. On WIN XP I could open the aol.exe file and access all my emails saved on the disk. Now Windows 7 won't allow me to open the aol.exe file. How do I open these emails now? Is there a program out there that I can run that would recognize the format?

On my form I have a dropdown box and then a button. The dropdown box houses different numbers 1 - 10, and the button when clicked is supposed to open a PNG file based on an if/then statement. The problem is I am not sure what VBA code I need to write behind my button in order to have the PGN...

I am trying to figure out the code to do a IF/Then statement using ShellExecute. I want to say something like this: If Me.linkbox.value = "001" then shellexecute (C:\desktop\001.png) end if If Me.linkbox.value = "002" then shellexecute (C:\desktop\002.png) end if

OK I am having a little trouble with this issue and from my Internet research I have complied the following code: Private Sub Submit_Click() If Me.combobox1.Value = "Table1" Then DoCmd.OutputTo acOutputTable, "Table1", acFormatXLS, "C:\Documents and Settings\Igawa\Desktop\temp.xls" Set...