Recent content by lhooker

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.