Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
No current record error from transpose
I'm trying to create a module to transpose a table. Testing the module using CTRL+G and "?Transposer("Table 1","TableTrans") in the "Immediate" pane results in an error "3021 No Current Record" and the resulting table has the first field filled...- TSchrupp
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
"Rotate" table in query
I made an error in the new format for this query. It should be Item Contract Date1Amount Date2Amount ... Field1 A 0.00 0.00 Field2 A 0.00 0.00 Sorry for the confusion Tim- TSchrupp
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
"Rotate" table in query
Hi all, I have a table linked from another db with this structure: Date Contract Field1 Field2 Field3 ... 1/1 A 0.00 0.00 0.00 I need to select the the FieldX column names as data, with the corresponding data as a row into this format: Item Date Contract...- TSchrupp
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with Dlookup
I'm a relative newbie to this, so any assistance will be appreciated. I am attempting to write a VBA module to populate a combo box with a list of valid data based on input from a previous field. My problem is that the module returns only the value for the first record in the lookup table...- TSchrupp
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
