Search results

Hi, I have this really strange problem that has never happened before. I open the DAO recordset: Set rstCalls = CurrentDb.OpenRecordset("Select * From Calls Where SerialNumber = '500'") I know for sure that the recordset should return 6 records and it always returns just 1 If I change the...

Hi, I have a function that accepts the field name as a parameter Sub MyFunction(ByVal strName) In the function I set the DAO recordset: Set rst = CurrentDb.OpenRecordset("MeterVolumes") Then I want to use the parameter strName as the field name of that recordset .AddNew rst!strName =...

Hi, After I import the Excel spreadsheet into new Access table, keeping the excel columns as the Access fields name, I want to be able to find out the names of the fields. Say for instance, I know for sure that one field name will have the following name "Pages/MO Feb. 2003"...but I will also...

Hi, I was wondering if anyone knows how to export different tables to one excel workbook, putting each table into separate sheet within the book. Thanks.

Hi, I wonder if anyone could show me how to rename the several worksheets within one excel workbook that I access from within the Access module. What I do is I let user choose a excel file, then create Excel object Dim xls As Excel.Workbook Dim wks As Excel.Worksheet Set xls =...

Hi, I want to do the following: Before I import the excel spreadsheet into Access table, I want to be able to access that spreadsheet and change the data type of some columns in it. Since I don't want my user do it manually, I am looking for the VBA code to solve this problem. Please advise...

Hi, I need to output the table (22000 records) to excel spreadsheet. When I use the following code DoCmd.OutputTo acOutputTable, "tblAutoPassExport", acFormatXLS I receive the error message saying that 'Too many records to output'. Is there a way around this limitation? I'll appreciate your...

Hi, I need to convert Access 97 database to Access 2000. I did not go through Convert option, but simply imported all the objects from 97 to new 2000 database. Once I have done that, I encounter lots problems that I didn't have in Access 97. For instance, some of my INSERT INTO queries run...

Thanks "Errors" is just the part of the name of the table

Hello, I was wondering if anyone could tell me how to delete the tables using VBA? The trick is I woulnd't know the exact names of the tables. I would want to delete all the tables that contain "Errors" in their names. Please advise. Thanks.

Hi, I believe many of Access developers have been involved into working with Excel files (import/export) via VBA. So, I was hoping someone could help me with topic. When I import the Excel file into Access table, I lose some data due to errors such data type conversion failure, etc. Is there...

I will be doing this on regular basis Thanks

Hello, I want to import certain sheets from the excel spreadsheet into one access table. I know how to import one sheet: DoCmd.TransferSpreadsheet acImport, , "Table1", path, True, "Group_Billing!" But is there a way to import a few sheets? Thanks.

Hello, I have this task. I need to convert the excel file into the text file before I import it into the the Access table. While I convert it into the text file I need to take into consideration the scientific numbers that spreadsheet contatin, so they would be converted properly. I do not...

Hi, I have a very generic question Can anyone give me an example of the VBA function and funciton call I need to pass parameter to function ByRef and then return three parameters back to the place where the function was called from Thanks.

well yes but after I get my recordset using sql.....how I can query against the new recordset?

Hi, Is there such thing in VBA as cursor I mean could I say select records into the recordset and then treat recordset as it were a table Example: sql= Select * from Table1 where Name="sabavno" Set rst1 = CurrentDb.OpenRecordset(sql,dbOpenDynaset) I will get a recordset, that supposenly...

Hi, I have been struggling with this long enough. Here is what I need to do using ONE query 1) SELECT DISTINCT IIF([F1]=1,"Y","X") as NAME, Transit from Table1 where Transit=7753 the above depending on the transit number as a criteria will return either one or two records NAME: TRANSIT: Y...

Hi, I was wondering if I could do something like follwing and what is the right syntax for that Select COUNT ( select fld1, fld2, fld3, fld4, fld5 from query1) I know I could create another query and say SELECT COUNT(*) from query1 But I need to count it in one query Thanks.

so, you're saying that the following will work sql1 = "select * from rst where rst!Name <> "Paul" Set rst1 = CurrentDb.OpenRecordset(sql1, dbOpenDynaset)