Search results for query: *

TTThio, Thanks for the advise. However, that part I already know. What I am trying to do is to put the above expression as the Query Criteria automatically using VBA. Currently, I use doCmd.openQuery to open the query in Design mode. Then, I use Sendkeys to move the cursor to the Criteria...

Hello, Suppose I have a query that pulls the following fields: 1. Date 2. Amount of payments I also have a form that has: 1. StartDate Text box 2. EndDate Text box 3. OpenQuery Button What I want to achieve is to enable user to specify the date range for the query. How can I change the...

Hello, Try this: 1. Create a new form. 2. Create 5 textboxes, and name them "Text1", "Text2", ... "Text5" 3. Create a button and put the following code in the OnClick Event of the button: '********************** Dim i As Integer Dim strText As String Dim cControl...

I experienced similar problem when exporting Data from Access to Excel. The following article at Microsoft web site may help: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q216400 Or simply go to microsoft.com and search the following: PRB: Cross-Process COM Automation Can Hang...

I do not know exactly how you managed to open the second database from the first one, but I assume you declared a new Database object and then set its value to the second database. If that was how you got in (let's say that the second database is called DB2), all you need to do is to execute...