Search results for query: *

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...

What is Table2 though?

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...

Thank You LS. Do you mean: Option Compare Database Option Explicit Public gstrSQL As String (instead of Dim gstrSQL As String)?? Janice

Thanks, LS. How would you declare a global variable that can be seen throughtout the entire app? Just place it outside of the subroutines? Janice

One more thing - the buttons are on different forms. Janice

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...

Hi What does the Select statement do? I want to become a SQL-wiz someday. Janice :-)

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...