Search results

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.

Create a module and create a procedure in there that contains the code you want to run upon starting up. Example Public Function Startup() ' Your code Here End Function Then create a macro and call it AutoExec. Select "Run Code" from the actions and set it to run the function you just...

I had tried using Form_Error but it doesn't even trigger that event!

You need to seperate the fields you are trying to insert into with "," plus I am assuming the number of fields in the table is equal to the number of values you are passing?? If not then declare your field names. I always do this anyways. Also if you are inserting text you need to add quotes...

This is an annoying little problem and I was wondering if anyone could lend any insight as to how to solve it. I am using Access 2007. Create a blank form and go to form view. Press the backspace key. The computer will beep and you probably won't even notice but the status bar will quickly...

Took ages to work this one out. Thanks Bob you got me in the right direction. The GridEx component wasn't releasing the ADO connection. To cut a long story short basically the component allows you to store its setup (layout, data mode etc) into a layout file which can then be loaded when...