Search results

I know this was a while ago but I have just been having the same issue. The problem was fixed by using the 'OutputTo' command instead of 'TransferSpreadsheet', no apostophes appear in the text cells. Hope this helps someone as I have been looking at this for 2 or 3 days with much frustration...

I know this was a while ago but I have just been having the same issue. The problem was fixed by using the 'OutputTo' command instead of 'TransferSpreadsheet', no apostophes appear in the text cells. Hope this helps someone as I have been looking at this for 2 or 3 days with much frustration...

Thanks Guys I have since used the code: Interaction.AppActivate "Microsoft Access" and this works a treat Cheers Kenny

I have a module controlling an application called Business Objects. Basically a report is run on Business Objects then saved as a PDF file or printed. This works perfectly, however Access remained 'Greyed out' after the application has been terminated. This usually only means clicking on a form...

Rich Can you elaborate? just to clarify the code for each supplier is completely different. It is to import data and convert it to a standard format. In an ideal world all our clients would supply a standard file, however most are only willing to dump a file from their own system Cheers

Thanks for this. I was hoping to avoid listing all cases as we currently have arround fifty clients, however I may have no choice.

Is it possible to call a procedure from a module dependent on a value in a combo box. e.g. There are three clients (TOM, DICK and HARRY). Each has a different procedure that can be run only for them. There is a combo box CmbSupplier which will have the client selected. Based on this selection...

I use me.refresh as I find requery does not always work.

Learning Tree International I used these Guys and found their courses comprehensive and easy to follow.

David I have an example of a video shop database. If you e-mail me I can get your address and send it to you. This comes form a course I was on, so feel free to use it for ideas, but best not to fob it iff as your own. Kenny

When I use DoCmd.RunCommand acCmdSpelling the spell check moves on from the text box and checks all fields in all records, there are around 20000 records at any one time. The reason for using send keys was that it was the only way I could replicate the action of manually highlighting the text...

I have been trawling this site for a solution to the problem of spellchecker checking all records and fields without success. I have however used a bit of code to resolve the issue (For me anyway): Mytextbox.SetFocus SendKeys "{f2}^+{home}{f7}" This may or may not be significant, however...

Alternativley, does anyone have code for importing all tabs in a spreadsheet at once? Kenny

I am supplied with a spreadsheet with 40+ tabs. At different times I want to a import different tabs based on a marker in against the tab name in a table. Previously I have written a line of code for each tab as all records were required at once.I now need to import selected groups at different...