Recent content by robgriff

I'm having problems with the new security check in Word 2003 & XP (sp3) that warns users that they about to open a connection to a data source. Our Access application contains several automated word merges that don't work in the above versions of Word. I'm aware of the MS KB article workaround...

I'm attempting to update the the project name of an .mdb using a VB application. I've successfully connected to the .mdb using the OpenCurrentDatabase method. However, when I attempt to access the CodeProject method (where I assume the Project Name property resides) I'm getting run-time errors...

I have several forms that use Rich Textbox Controls - Microsoft RichTextbox Control 6.0 (SP4) They all behave OK in Access 2000 and AccessXP. However, in Access2003 I'm receiving the error "you entered an expression that has an invalid reference to the property Locked". Is there a known...

Does anyone know a way of opening an mdb but bypassing the autoexec using VBA code? I'm using VB to create an object as a new Access.Application then calling the OpenCurrentDatabase method. I've tried using sendkeys to send the Shift key but had no luck with this. Any suggestions?

I'm having problems with dates in Excel that are being formatted in the American style. Using VBA I'm building a .csv file and opening it in Excel with automation. The dates in the .csv file are formatted correctly but when the file is saved as an .xls file any dates that begin with a number...

Does anyone know a way of opening an mdb with the shift key in VBA code? I'm creating an object as a new Access.Application then using the OpenCurrentDatabase method. I just need to set some Startup Options on the mdb then close it down. Any help appreciated.

Each time I open an mdb in Access 2000 Runtime I'm receiving the following message: Please wait while Windows configures Microsoft Access 2000 SR-1 Runtime. The process takes a couple of minutes and then the application opens and performs normally. Is there any way to prevent Windows from...

I'm attempting to change some properties of controls within specific Form Sections. One particular form is giving the following error: Run-time error '2467': The expression you entered refers to an object that is closed or doesn't exist. The code in question looks like this (the error is...

I'm importing data from several .csv files into my MS Access V97 application through modules. The trouble is that some of the .csv files have header rows and some do not. When connecting to the .csv file, is there a way of declaring whether the file has a header row or not? I've been able to...