Search results for query: *

thanks, but not that simple I'm afraid. This is a file which has <65,000 lines, for some reason it ramdomly excludes lines for no apparent reason, ie data types, null values etc.. This seems to be totally reliant on the excel version type.

Hi there.... Has anybody ever come against an issue where Access will cut lines of data off a excel upload depending on the excel version the file is saved under?? For example, I am uploading a daily file which when saved as excel 97 loses lines upon upload, I've been told that if I save under...

Beautiful, works like a charm...thanks a million.

Hi there, I'm trying to use a pop up input box to set the reporting date for a number of queries, this is my code but instead of updating with the date I get what appears a calculation of dd/mm/yyyy... ps some of you might recognise this code as it came from this site...thanks. Mike Sub...

Thanks Rudy, I had tried this originally but no luck.. Decided to use a lookup table instead.. Thanks for the help.

Thanks heaps for all the info, but still can't get it to work, really seems to hate those folders. I think I'll try a new method.

Unfortunatly not using spaces is not a option, what do you mean by enclosing in quotes, is it as follows? &quot;C:\Program Files\MSOFFICE\Excel\EXCEL.EXE C:\&quot;folder&quot;\accesstest.xls&quot; thanks for the info..

I'm having trouble opening my excel sheet via the call shell commang my code is pretty simple as follows but I can't seem to get access to recognise the folder. This works but only because the target file does not sit in a folder. Any ideas?? Private Sub CmdOpenXlFile_Click() On Error GoTo...

Thanks for the info but its actually a calculation based on two seperate variables, Basically, if the value in field 1 = A and the value in field 2 = B then return the value in field 2, or use a &quot;Text&quot; value.. if not then simply return the value in field 1 i know i've done this...

Hi all, I'm having a hell of a time trying to return the correct value on a double iif statement. The SQL is as follows and I think it should work, any ideas???? IIf(([FIELD1]=&quot;VARIABLE1&quot;),(IIf([FIELD2]=&quot;*VARIABLE2*&quot;,[RETURN1])),[RETURN2]) I've also tried variations using...

Not too sure whatr you mean, I've been using the TrSpreadshehet method as follows. Do you mean linking the xls as a updatable sheet and running the query into the linked sheet? Function ExportDaily() DoCmd.SetWarnings True DoCmd.Hourglass True On err GoTo err: Dim stExportFileName As String...

Hi, I've built a funky command running a query and exporting to excel for daily reporting, the problem is I have graphs linked to a specific worksheet and access won't write over it will continue to creat new sheets. very gratefully thanking in advance

I've written a macro importing data from a external source with a message box reading &quot;This will affect your data, Continue?&quot; with a ok & cancel option. Its great when I click ok but a cancel hit returns a VB error as does a cancel on the confirm import when I continue with the...