Recent content by Rob Sang

Attempting to open the properties window takes the focus away from the main window and the status bar shows that one of the properties is selected. You can use the cursor to change which property is selected by pressing up and down. Basically, the window is being instantiated but the required...

Someone from IT department is coming to do a "repair" install in the morning. Another day lost.

Well it probably is something obscure in the registry. The window is opening (or rather, an object is being created in memory) but not drawing to the screen.

Actually, I think we've tracked down the problem to a botched Windows upgrade (SP2) rather than anything in Access.

An interesting idea, but it still ain't there at maximum resolution :(

Has anyone else come across a bug where it is impossible to bring up the properties for an object in a form? I right click them and go down to properties and click and . . . nothing! It's gone, restarting doesn't work, it happens on all databases and even a reinstall doesn't seem to have fixed...

Hi, I have inherited a database that includes the ability to upload files to a remote server through the interface. The code for this is fairly straightforward and uses FSO. The key function call being: fso.CopyFile (sfol & file), (dfol & strName), True Anyway, this causes errors when users...

Actually, yes I did figure it out. I didn't use a module in the end, I adjusted the code so that it fit into the button click subroutine. The code from the microsoft site (the module you've based your code on) seems to be flawed also, as the line Dim objWord As Word.Document results in a...

Thanks, that's sorted it out!

Okay, so I've written this code to launch a mail merge from an Access form. It works fine to merge ALL the records in the database, but if I change the SQL line to read: SQLStatement:="SELECT * FROM [Customers] WHERE [MailingListID] = '" & MailingListID & "'" random craziness ensues, with...

I tried that but I get an error telling me that a user defined type has not been defined. It seems to be referring to Word.Document. I think this is because the code has to be defined in a module but if that's so I don't know how to execute it from the form. I also don't know how to refer to...

I have a form in to enter a new record into a table. I also have a mail merge document in Word based on that same table. What I would like is if the button for adding a record also opened the mail merge document and merged it with the data from that record. I'm not afraid to get my hands dirty...