Search results for query: *

Hello Randy700, I'm populating the listbox on form open. I want to select the first item in that listbox, because it determines child data in the other listboxes, seen below in Sub Populate() Private Sub cboReportID_Click() Call Populate End Sub Private Sub Form_Open(Cancel As Integer)...

Hello, I am having a problem with an Access listbox - I need to select the first (or any) item in the listbox. I used the [listbox].selected(0) = true method, which works. Only problem is, my form freezes up. I can't select anything else, on any control on the form. Any help would be greatly...

Hello, I am having the same problem - need to select the first (or any) item in the listbox. I used the [listbox].selected(0) = true method, which works. Only problem is, my form freezes up. I can't select anything else, on any control on the form. Any help would be greatly appreciated.

Hello Karl, Thanks for the reply. The error I was getting actually had nothing to do with the join. Apparently VBA likes to see a dot notation between the database name and the table name, as well as between table and column names. It has to be: database.table.column Once I changed that it...

Hello, I have the following query in an Excel vba macro: SELECT [DELTEK_ORG_ACCT].[ACCT_ID] , [DELTEK_ACCT].[ACCT_NAME] FROM DELTEK_ORG_ACCT INNER JOIN DELTEK_ACCT ON [DELTEK_ORG_ACCT].[ACCT_ID]=[DELTEK_ACCT].[ACCT_ID] WHERE...

I am using the following cross-tab query to form a recordset: strSQL = "TRANSFORM Max(tblCrossTab.Hours) AS MaxOfHours SELECT tblCrossTab.EmpName, Sum(tblCrossTab.Hours) AS [Total Of Hours] FROM tblCrossTab GROUP BY tblCrossTab.EmpName PIVOT tblCrossTab.Month;" How do I loop through...