I have a table like the following:
Name Login Date
XX 1/1/2002
XX 1/2/2002
XX* 1/3/2002
XY 1/2/2002
XY* 1/4/2002
XZ 1/8/2002
XZ* 1/10/2002
Its sorted my Name followed by LoginDate. I want to retrieve the latest login date (the starred records). Does anyone...
Steve
I understand what you're saying, and your solution definitely makes sense. But the reason I need to build the query is Visual Basic is that I have variables within the SQL statement that come from codes in other modules. For example:
Private Sub cmdButton1_Click()
'Declare SQL...
Thanks. Well here's what I have so far. I got a command button on a form which has the following VBA code linked to the "on click" property.
Private Sub cmdButton1_Click()
'Declare SQL string
Dim strSQL as String
Dim strSQLinsert, strSQLselect, strSQLfrom as String...
Thank you. I think you might be right. However, the queries are built within modules. So I'm not sure how I can re-set the ODBC property to 0. I've tried the following:
Dim dbsCurrent As Database
Set dbsCurrent = CurrentDb
' Change the default QueryTimeout of the Northwind...
I'm running a query which is populating a large amount of records from a table sitting on a server elsewhere. The query gave me an "ODBC - call failed" due to the excess amount of data volume.
My knowledge on the database connectivity side is limited, is there anything I can do as a...
First time user of this forum, hopefully someone can help me. I have a table that looks something like:
ClientID StatusChangeDate
001 06/25/2002
001* 06/21/2002
002 07/01/2002
003 06/29/2002
003* 06/25/2002
003* 05/14/2002
... ...
Its sorted w/ ClientID...
Thank you very much. What if I want to leave the first record and remove the other duplicates? For example:
CardNumber PaymentDate AmountDue ... ...
10001 12/4/2001 $5.00
10002 10/7/2001 $4.50
10006 11/15/2001 $15.60
10006* 11/3/2001 $15.60
10007 10/8/2001...
Thank you very much. What if I want to leave the first record and remove the other duplicates? For example:
CardNumber PaymentDate AmountDue ... ...
10001 12/4/2001 $5.00
10002 10/7/2001 $4.50
10006 11/15/2001 $15.60
10006* 11/3/2001 $15.60
10007 10/8/2001...
Thanks LittleSmudge. I understand your code. However, I have another button that actually execute the query - by running the strSQL statement. It looks like:
Private ExecuteQuery_Click()
DoCmd.RunSQL strSQL
... ...
End Sub
But the compiler does not recognize the variable strSQL...
Thanks LittleSmudge. I understand your code. However, I have another button that actually execute the query - by running the strSQL statement. It looks like:
Private ExecuteQuery_Click()
DoCmd.RunSQL strSQL
... ...
End Sub
But the compiler does not recognize the variable strSQL...
I have a process which involves importing text files into tables - using the File -> Get External Data option in Access. Followed by choosing various steps neccessary.
Is there a solution to automate this process? The Macro only offers limited capabilities. I'm a beginner Access user, so...
Thank You LittleSmudge! That was very helpful :-)
Now, I have another similiar problem. On the form, Instead of having the dates in 1 combo box like above, I want them in two combo boxes - as below:
cmbMonth: January cmbYear: 2002
February 2003...
I'm a novice Access user, so pardon me if some of the terms I refer to is not precise...
This should be pretty simple for some of you advanced users - I have a form that contains a combo box which is bound to a table. When a certain record is selected (in the combo box), I want to feed that...
Hi. I have a list of names and e-mail addresses:
John Doe johndoe@company.com
John Smith johnsmith@anothercomapny.com
... ...
I want to strip the domain name from the e-mail address so that only "company.com" and "anothercompany.com" is left.
Can someone help me...
Hi everyone
I have database that's connected to a server elsewhere. The volume of the data that I work with is quite large.
Anyhow, the query (append) I'm having trouble with runs fine when I don't pass a parameter to it. But when I do pass a parameter (i.e. field "Date" has...
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.