Search results

Yeah, that'll be the rights thing I was talking about I expect. Mine fell over on one of the system restore folders. I suppose you could always make it check the file attributes and ignore hidden folders, unless you needed them listed....

OK. Nice and easy. Just use transferspreadsheet with the acExport option at the start, the help file will explain the rest. But - you 'll need to have a PC running the database, and use the Timer event (in conjunction with the Timer Interval property) to check what the time is, say, every...

No worries! Let us know if you get stuck again :)

So having the recordset and db declarations outside the routine is still causing problems?

Oh.... Bob Larson, provider of the original bit of code that I developed upon, did have them on separate lines. I didn't realise it didn't do them all...! Still works OK on mine though, unless a folder isn't shared with everyone, then it throws an error up. I guess if I ran the routine on a...

Can you upload your database so I can see what you've got so far? I don't really understand what you're getting at at the moment.

It'll do it as often as you call it. What exactly is it that you need to do? Export from Access to a spreadsheet, or the other way round?

Hmmm... is the spreadsheet opening OK by itself? Could it be corrupted? Stumped otherwise....

Have you read through the link above?

Yes it is - you could put form.requery in either a button, or the afterupdate events of your combo boxes.

Ah ha! http://social.technet.microsoft.com/Forums/en-US/itprovistasecurity/thread/5f7307c9-14fa-40b0-ab16-55f7cf90f4b8

Actually, a bit of googling reveals that this error could relate wo the URLMON.DLL file in Windows 7. Are they using this version?

Sound slike a non MS piece of software from the message box title as well. What software is running on the affected PCs?

Just the one thread per topic is best :)

What code runs when the database is opened?

Bit confused about this generic builder thing... can you explain as though to a 5 year old?

Happy 1200th post :) Would you have to cycle through each cell in the range you want, adding the contents to a string as you go, then put the string in as the comment?

Hi - I would think myvar, in the first example, would need not to be in quotes - otherwise you're populating the variable with the string "forms.myform.username", rather than what that property is referencing.

Hi - welcome to the forum! Can you uplaod a stripped out copy of the DB so we can see exactly what's going on?

You could always write it :)