Recent content by ajking

Remou, you are a star! many thanks! 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

That code worked fine for the first time but when I tried it again a windows type popup appeared which had a title -" 'file now available' with the following text in the body: 'Email_CNS.xls' is now available for editing Choose Read-Write to open it for editing" I shut the database down and...

Excel 2003 sp3. As I said, the import works fine and my access form populates correctly. I just want to automate the opening of the workbook and to close it after the import. 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

Hi Remou If the excel form is not open I get an error message: "error 3274 - external table is not in the expected format" 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

This happened to me a few times and the only way I could get out of it was to create a new database and import all the tables, forms, queries etc. into it. 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

I have a project where I take an excel form with three sheets and import the data into access. I have got it working using: DoCmd.TransferSpreadsheet acImport, 8, "tbTechnical", "C:\CNS Excel Import\Email_CNS.xls", True, "ExportTechnical" DoCmd.TransferSpreadsheet acImport, 8...

I have had a rethink and I what I have come up with is that all three worksheets are now imported into their equivalent Temp table. The Main Technical record does not have an autonumber field but the Technical_ID is generated by using Dlast to obtain the last record no. this number is...

Probably a basic question but I importing 3 excel sheets(Cust, tech, survey) into access tables "Customer", "TempTechnical", "TempSurvey". The excel workbook comes in from multiple locations and, once imported,it is deleted. I have sorted out the import using VBA. this works fine. The Access...

Yeah, you're right. Put it down to a very senior moment, late on a friday afternoon, after a week of my boss saying "This is what I want! You are the one to do it! and and I want it now!" There's a bottle of Chardonnay waiting for me at home:-) Many thanks 'Life is what happens to you while...

I was thinking along those lines but I am wondering now if I could carry out the whole import process programmatically using VBA [ponder] 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

I have an excel workbook which is emailed to me from different people. In this workbook there are 3 sheets Techinfo;Customerinfo;requestinfo I have created an access database with 3 tables that have the same name. The data imports ok (It would be great if you could import all 3 sheets at the...

Hi Jimmy. Thanks for the input but I didn't have any timer running. However, it seems to be ok at the moment even though this has happened 2-3 times before, I can't work out what it is I am doing to trigger the problem.[ponder] 'Life is what happens to you while you are busy making other...

I have been using the VB editor for years without any problem now, suddenly, it has a mind of its own. when I type me. the "[COLOR=red]me.[/color red]" turns red immediately and the object list, which should open after me., just flashs for an instance and then disappears. if I continue the line...

Many thanks for your swift reply. I said it would be simple and that I was suffering a "friday brain dump" cheers 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

I have an subform on my main form. This sub form has 4 listboxes which are used to populate textboxes on the main form. This works fine but when I go to a new record and then enter the sub form, the listboxes have retained the selections from the previous record. It's probably very simple but I...