Search results

Thanks for your reply; that was one possible technique which wasn't quite right for this task. I have literally just figured it out tho: for anyone else, here 'tis: DoCmd.TransferSpreadsheet acImport, 8, "sampletable", "sourcefile.xls", True, "a1:d5" where a1:d5 is the range. Thanks all...

Hi, I have an Excel sheet which I want to copy the content of and paste into a Access table. I can achieve this by literally copying the data in Excel, then moving to Access and pasting it in. Can anyone suggest a nicely automated way of achieving this with a macro? You thoughts are very...

Smashing... works a treat thanks! BTW - my main experience is in Oracle and DB2 so this Access stuff is really quite different to me! Can you recommend a decent book on the VBA side of things? All the Access books i've seen just seem to spend their time telling you how to use wizards etc - and...

Hi All, Here's the situation: I click a button on a form and this fires a query nicely. The thing is, I want the query results to be added to a listbox. Does anyone know a suitable technique? tia, Dan

One more quicky: any thoughts as to achieve the following: Now I've got my query reuslts, is there an easy way to put them straight into a combo box? Thanks so much dre

As easy as that eh?! Works splendedly - thanks!

Dudes & Dudettes, I have what is probably a straightforward problem but its solution eludes me. I have a textbox (TBOX) in which the user types some text. I have a command button (CmdBtn) which the user clicks. What I initially want to do is use the text from the textbox as the condition for...