Search results

Thanks Can you ask one more question.... Can I manipulate the recordset as it were a table Say, can I use such sql statement: Select * from rst where rst!Name <> "Paul" Please advise Thanks

i've got sql="Select Name, Transit from Table1 where Transit=" & varTransit Set rst = CurrentDb.OpenRecordset(sql1, dbOpenDynaset) Then I want to know how many records have been returned and assign that number to the variable.

hi, how to count the number of records returned in the recordset? thanks

Hi, I have this subquery that does not work If anyone could take a look at that, I'd appreciate it SELECT NewQuery.Name1, NewQuery.TRANSIT, NewQuery.OP_STATUS, NewQuery.GL_INPUT_TYP FROM NewQuery where NewQuery.Name1= IIf([Count([NewQuery.Name1])=2,[Name1]<>"RBFG",[Name1]) Thanks

Hi, Please help me to construct the subquery. I have a query that returns either one or two records. If query returns two records, one record will always have value "RB", and the second could have anything. Select NAME from transits where transit=5 NAME: RB ST I need to create a subquery...

Hi, I have this problem. My list has a query as its source code. (For example: Select * from charges where AssetType = "Monitor";) You've noticed that there is a semi-colon that gets assigned at the end by Access 97 (there is not semi-colon at the end of the query's SQL in Access 2000) I...

Hi, The spreadsheet file I want to import has 2 sheets in it. Using this line, I only get the first sheet imported: DoCmd.TransferSpreadsheet acImport, , "Eroom", path, True How to import two sheets of into two different tables? Thanks.

Hi, In order for me to import the excel file, I have to take the exact path from the user (which I do using a text box) txtPath.SetFocus path = txtPath.Text DoCmd.TransferSpreadsheet acImport, , "1", path, True But that is of course a headache for the user to type the whole path into the...

Hello, I need to code the process of importing the excel file into the Access. The excel file name and location is known and therefore I should open a window so the user would choose the file to be improted himself. Please help. Thaks.

You were right ...it was the references problem I have installed SQL Server recently and after that TRIM$ function stopped working. So I had to refresh references used in my Access application. Now it works fine. Thank you very much for your help. I appreciate it a lot.

I have just tried TRIM......removed Configuraion table........it still gives the same error....

But i need to have Configuration table involved in this query. And this query worked fine before.....what is wrong with TRIM$?

Well, sorry....i just renamed BlackBerryRecord to Record........if you rename table back to BlackBerryRecord......then query will be good

ok, table and a query is in db attached

No, ... it is the same structure

No...but I've replaced the table that was used in the query with a table from another db....

I have this string assigned to the variable in the query: strFullName = Trim$([BlackBerryRecord].[LastName]) & ", " & [BlackBerryRecord].[FirstName] It worked find, but all of the sudden started given me the error FUNCTION ISN'T AVAILABLE IN EXPRESSIONS IN QUERY EXPRESSION '...

Hi I have two 70000 records tables and I need to compare them in order to find the differences and insert them into the thrid temporary table. E.g. Table 1 RecID Name 1 John 2 Maria 3 Mark 4 Tim Table2 RecID Name 1...

Hi I am wondering if I could rename the table using vba code... Thanks

Hi, At some point in my program I do delete everything from one table and then copy records from another to that table again... DoCmd.RunSQL ("DELETE * FROM tblFIFROLL") DoCmd.RunSQL ("SELECT tblFIFROLL1.*, * INTO tblFIFROLL FROM tblFIFROLL1") If hit ESC while the second SQL statements...