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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.