Recent content by Eavie

OK I put the update function in and it made no difference, the same error message still came up and it still didn't list my Excel forms

Ah I get what you mean, no there was no other code to begin with but I'll try and run the updateConst() function before the Import function now and see what happens

Do you mean run the updateConst() function? I tried that before and in my previous databases it wouldn't work so I took that line of code out and it worked fine... I probably sound like a complete novice but I really appreciate your help

Yeah, the code is saved in a module called globals and contains the following code;

The pubPath and pubRange variables are pulled from a path and range table... I don't understand why they won't work on this database if they work for others. Do you think it is something to do with my registry, meaning it can't find the location of the excel files and therefore can't use a range?

Ok all that comes up is a wee message box that says; pubPath(1): lstExcelFiles.Value: pubRange(1): Does that mean anything?

How do I run them with a message box, still reasonably new to coding databases so I'm still learning. That exact code works for a previous database but is refusing to work for a new one, both are saved in the exact same place on the same drive...

Hi all, I have created a database that imports mulitple spreadsheets as needed. An Import button on my form brings up another form that lists the Excel files that I can import. It works for my past databases but when I click Import and it brings up my second form it says 'Run Time Error 2522-...

I have a form that does the same thing, I enter 2 dates and then I have two seperate buttons, one to view print preview and one to print the report. Below is the code for the preview report button; For printing the report I have another button that links to a macro, on-click. The macro is...

Yep, I had problems with my old database because I only had Access2000 but it was upgraded there to Access2003 and it works fine with no problems. I just don't know if it's a problem with my code or a problem with my permissions as a user on the network...

Yeah they're on the same drive, in the same folder

Everything comes up fine for that, I just don't understand why that exact code works for my previous databases and not this one... I don't know if maybe it has something to do with my permissions maybe changing... I can still access the files though so I don't know why they would have been changed

I've tried that too... The error is coming up at the DoCmd.TransferSpreadsheet line of the code and I tried running it in the Immediate window pane and it throws up a different error 'Runtime Error 3051 Reserved Error'

Hi everyone, Still relatively new to this so bare with me a bit. I am making a database that provides the user with a list of files to import at the click of a button. It works perfectly for the other databases I have made but for some reason it now won't work. I've tried starting the database...

Hi all, I'm new to this so tell me if I'm asking too much :) I have a table in Excel that lists the values I need vertically, I can only get my database to import them in a horizontal table. Problem is I'm not allowed to change the Excel table around so my current method, although working...