Recent content by Sandworm

Thanks all for your advices. Thought I'd try JANR's advie 1st, with the following results: Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String, strFilePath As String) ' strTQName is the name of the table or query you want to send to Excel ' strSheetName is the name of...

Thanks for the suggestion Trevor unfortunately I currently only have internet access over a very limited wireless network and it wont allow me to download anything like .mdb currently or most other things come to think of it. Any chance you could paste a screen shot or give a brief explanantion...

Thanks Trevor G I'll try the TransferSpreadsheet option but it still doesnt resolve the issue of loading the data into already prepared speadsheets with headers. I know I could pre-load some formatting macros and run them once the data is in, however the former option is the more prefereable. Is...

I might be a bit slow here. Im trying to export (output to) several queries to Excel 2003 from Access 2003. Specifically I want several queries to "export to" individual worksheets in one workbook. Im just unsure of the simple "output to" address line to acieve this. Currently Ive only got the...

I want to create a query field that automumbers the dataset from (1 to inf). looked on access help but cant find what im looking for - anyone help. Is it just a simple operator Im not aware of? Thanks in advance.

Thanks for the reply "d profesor" the URN field is indeed a string as number formatting conflicts with the necessity to suffix the numbers alphabetically. - I'll give the Nz D(Lookup..... a go. Regarding the second element. I was hoping to automate the process of suffix numbering by the vb...

Hi all. This is my first time in the forum and hoping I can get some assitance. I've wrote loads of vb before in Excel (mostly with the assistance of the macro writer) and adapted the code from that point. So Im pretty familiar with If....Else statements, MsgBox's and other bits however Access...