Search results

I have a Main (Home) form that has a sub navigation form (frmNavigationSubform). Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form. Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3. NavigationButton2’s Navigation Target Name = 1 (frm #1)...

JHB, I keep getting this "Type mismatch (Run-time error Error '13')" all of a sudden. Stops at this line of code Set rst = dbs.OpenRecordset("SELECT * FROM [" & MyData & "]") I can see the tables name when I have the pointer on "MyData". But when I have the pointer on rst it says...

Worked!!! Too good! Just the way I wanted. Thanks a lot again. You are awesome.

JHB Thanks a lot. The code did work great. One more thing can I pass the table name from the database. Tables I need start with name P1_TableName1, P1_TableName2 and so on. Can we loop through all tables to find any table name starting with P1 and pass the name to a variable? Till all P1's...

Hello gurus, I have been struggling for the past three days with this. I really need this to be done. I need my columns with data un-pivoted and also have a title column adjacent populated with “column names” for data reference. I did achieve a bit of it but the Do loop is not working for me...

Hey all, Finally a member. Looking forward.