Search results for query: *

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

Hi Duane, thanks for the swift reply. Sorry, I realise now that my description was somewhat ambiguous What I want do do is: if a particular field [xyz] in the query that the report gets its data from is true, then I want to hide a textbox on the report else if xyz is false the the textbox is...

Is it possible to show/hide a field (xyz) in a report depending on the value in that field? e.g. field(xyz) has text then field(xyz) is made visible else if field (xyz) is blank then field(xyz) is hidden TIA 'Life is what happens to you while you are busy making other plans' John W. Lennon...

Hi Duane Sorry for the delay getting back but I have just returned from leave. following on from your reply I added a save routine when I selected the report button and it worked. I will put it down to the 'friday afternoon before a holiday' brain drain :-) I should have known better! Many...

I hope the following makes sense. I have set up a query that is populated from a record that uses six tables, all linked to the main record number. This works fine and I can see all the data required but occasionally it does not populate. I have to move away from the record, open the query and...

Sorry People Last remaining brain cell has just flickered into life! I should not have used the dropdown box doh! 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980