Search results

After several years not doing things I am updating a 2007 database. I added a combo box which works fine together with calculated expression from the combo box result. The box returns a field Funds from table members and the calculated expression is =[Funds].[column](1). This brings up the...

I have an an Access database which allows the user to select data to be available for mail merging via Word 2007. It selects the required data into a temporary table which word connects to via an ODBC connection. This works fine for standard mail merge (letters, envelopes, labels) I have been...

In a routine I wrote to encrypt a login password for a database I have come across an oddity. For each character in the entered password I compare it in turn to each of the values of the chr function to obtain the index of that character in the Ascii table so it can be used to construct the...

I am creating a form that displays a chart. The Form is created via the Chart Wizard which uses a query to construct the data to be charted. The query requests 2 parameters from the user. If the user hits the cancel button on the parameter request form, an error message comes up. "An error...

I have been developing a database for a charity. It is developed in Access 2002 but is to be run on machines some of which use access 2002 and some access 2007. For user convenience the action alerts need to be suppressed. In access 2002 this is done via Tools/Options then the Edit/Find tab and...

May be an elementary question but I would appreciate any help available. I have a startup form made with a tabbed control, with separate tabs giving access to different facilities. Can I apply different permissions to the separate tabs of the control? So one person can access the Data Entry tab...

I am building a database for a large charity on a voluntary basis. My machine has Access 2002. The charity has just supplied me with a laptop with access 2003 to develop the database. Code which works on my access 2002 machine throws up errors on access 2003, (broken or missing references to...