Search results

Thank you ! ! ! I wanted everyone to know that my problems were resolved. Someone mentioned in one of previous posts that I should let everyone know. Obviously, I made too many posts.

I used the EXCEL 'Transpose' featureand the code below to resolve my problems. Do Until Counter = 30 Counter = Counter + 1 varX = DLookup("Question" & Counter, "Answers_Horizontal") strAs = "A" & Counter Forms("Questions").Controls(strAs) = varX Loop

This worked . . . Thanks ! ! !

1. Right 2. Using the EXCEL 'Transpose' feature No, . using the EXCEL 'Transpose' feature Thanks ! ! !

I did already . . . I used the EXCEL 'Transpose' feature.

How can I substitute "A1" in a "Forms" statement within a loop (as shown below) to move to the next textbox in a form. Dim strAs As String Dim Counter As Integer Counter = 0 Do Until Counter = 30 Counter = Counter + 1 varX = DLookup("Question" & Counter, "Answers_Horizontal") strAs =...

The EXCEL 'Transpose' feature solved my problem. Thanks to all who tried to help ! ! !

Unfortunately, I'm not aware on how to do this.

The data in the table comes from an existing EXCEL spreadsheet. I've import the data into a table, but the data is vertical. not horizontal, I'm not aware that DLookup or any function can accomplish this. I need the data to be horizontal.

All I want is to read a MS Access table with two (2) columns into variables. Once the value are in variables, I will import the values into a routine that insert the values into a form. All I need is the MS Access tables (two (2) columns) stored into variables.

Still, no records. All I want is to read a MS Access table with two (2) columns into variables.

I don't know how.

There are only two (2) columns.

I want to retrieve values in one table (column 1) and write the content into another table (horizontally). I currently do not have any workable code.

No, I want all contents from the first column saved into variables.

Thank you ! ! ! . . . but "lRecCount" returns zero records

Can someone provide me an example on VBA code that will allow me to read an existing table in MS Access (with 2 columns) and store the first column contents into variables ?

How can I make [A1] an acceptable varible that will be allowed with the below "Forms" statement ? That is make [A1] change to [A2], [A3 , [A4], [A5], [A6] . . . etc. [Forms]![Form_Questions]![A1] = varX I tried the statement below, but it did not work. Counter = 1 Do While Counter <= 25...

George, I'm not sure. Also, how would I set up Outlook globally (via VBA) ?

I figured out what is happening with my delayed e-mails. It is due to Microsoft Outlook's "Delay Delivery" option. You can locate it by opening an e-mail, click on "Options", then click on "Delay Delivery". Locate the "Delivery options" section and uncheck the "Do not deliver before" box. When I...