Recent content by polina

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.