Recent content by Huck

You're welcome

Have you tried:- Not like "Slovenia" and not like "Croatia"? That should work

Thanks Mailman - I'm not sure about using VBA but I'll give your suggestion a try. I want a message box to pop up before the query is ran to remind the user that they should import new data before running this particular query. I'll let you know how I get on. Huck

Hello. I'm trying to attach a macro to an update query and need to know first if this is possible and if so, how do I do it? Before the update query is ran, the user needs to ensure they have imported & appended new data to a table which then needs updating with a new date. I've never used...

Thanks Bob, I'll give that a try and see what happens. Thanks Paul also for your help.

I am the only one that uses the database and there is no frontend/backend. I do a compact & repair every time I use it but have not come across Decompile before. What does this actually do?

Tried that and got the following message in the brand new database - "The wizard is unable to access information in the file [filename]. Please check that the file exists and is in the correct format." Also tried it in the same database and got the original error message back. Argghhhh!

No, password has remained the same and there are no other protections in the spreadsheet. It's a good one this isn't it..?

The password is definitely to modify only, not to open and this has been the case forever - that was why I was thinking Access may be the problem. I completly flummoxed now!

Thanks for the reply Paul but unfortunately removing the password is not an option. There are a number of worksheets & pivots in the spreadsheet and I only link to one of them (that contains the raw data). The spreadsheet has always been password protected in this way and has not caused issues...

Hi, hoping someone can help me with a ridiculous problem I am having in Access. I have a 2003 database that links to an 2003 Excel Spreadhseet. The spreadsheet is passworded to modify but anyone can open it to read it but not modify it. Inexplicably, I now get an error message in my database...

It works for me if I copy the database to my desktop then do the Backup function from there. It should save it back to the desktop with a date.

Click on the Office button in the top left hand corner, select Access Options in the bottom right hand corner of the box that appears, then select Customize and take it from there.

Thank you Bob & Brian - I've now got what I need! Your help is much appreciated. Huck

Hi I'm trying to creat a field that picks up only the characters to the left of either "-" or "/" in the string. The number of characters to return can vary. eg the field [billref] can be 1234567-001 or 1234567/abc-001 or 12345678-001 or 12345678/abcdef-001. I only need the numbers to the left...