Search results for query: *

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

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

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

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]="VARIABLE1"),(IIf([FIELD2]="*VARIABLE2*",[RETURN1])),[RETURN2]) I've also tried variations using...

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 "This will affect your data, Continue?" 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...