Recent content by DJNickWatt

Access 2007 I have a popup form which I am using to filter the records on the main form depending on what value is selected from a number of combo boxes. I use the values in the combos to write my own sql statement to determine the recordset on the main form. When the user changes a combo it...

Still waiting on a response from them. I'm more inclined to think it is something to do with Access 2007 than the actual control as it works fine with Access 2003. Here's something that will really blow your mind. Create the form and add the control in Access 2003 and save the file. Then...

Hi I purchased the Janus GridEx2000 component a couple of months ago and have used it extensively in an Access 2007 project. The component has an OCX for development and and OCX for distribution. I have come to the stage I wish to deploy the first version of the database and so have gone to...

Ha ha sorry Bob yeah:). Was flicking through quickly while at work and only read Nigel's question and jumped straight into quick reply.

on some projects i have simply put one subform object on a form. when i want to display a different form in the subform change the sourceobject property via vba: subform1.sourceobject = "formname" the form that is currently loaded into the subform will fire its close routine and close, the...

In a word, yes. Don't worry about details like that. The database engine handles at that for you.

Use the DIR function to see if the backend database file exists DIR("F:\Users\Nick\Documents\DB.mdb") It will return the filename if the file exists or an empty string if it doesn't IF DIR("F:\Users\Nick\Documents\DB.mdb") = "" Then ERROR!!! Refreshing links on tables can be slow if other...

nah i wouldn't have thought so.

I'm at work now. Will sort you out a solution when I get home tonight.

If you reference an older library in development and the user has a newer library USUALLY this is detected and corrected. It doesn't always happen but I haven't seen it not happen a very long time. Now here's were it falls over more often. If you have the newer library and the user is running...

Re-register the library on the offending machines using: regtlib.exe You may need to have a hunt for this file or get it from the microsoft site. Run it in a command prompt with /? for instructions. You'll need to also locate the file msword.olb with full path.

Do you have any code running when the database opens?

Why don't you add a button in the front end which you would then click, navigate to the picture you have saved with whatever filename you want, retrieve that path & filename and store that value in a field associated with the contact. That way the picture will always be associated with the...

Format("29/02/2008","ddd") will return "Thu" so if you're using a recordset against the table for example oRS(Format("29/02/2008","ddd")) = 5 would put 5 into the column name "Thu"

I would import the excel spreadsheet as gemma suggested. Linking to excel files to read data can be slow. A simply DoCmd.TransferSpreadsheet should suffice.