I have inherited a database that has a list of image files in the database but the actual files are located in various places on 3 different network drives, I...

Good afternoon, I have some difficulties on getting an output of the report. I have a report created in Access with a conditional format set on one field (out...

I have a query that produces finanial data by clinet and period (month). I'd like to create an expression to pull a field from the prior period of the same...

This has to be simple...but I must be making it more complicated. I have a database for all our volunteers. I have an inactive colum for those who are no...

I have created an access database that I would like others to be able to add data to. In some cases, I don't want to show the data over the web, just add to it...

I used the database splitter to split my database into a front end and back end. Now I want them back together in 1 database. How do you re-join a database...

Hello, I know you can drop individual tables with the Drop statement...but is there any way to drop all tables without specifying the table names? Thanks

I'm needing to launch the built in "PivotTable Wizard" (which is avaialbe when you select to create a new form in Access 2k) from code. Can anyone point me to...

I have created a database in Access 2000, we have many people working in this database. Recently some people have been moved to Access 2002. We have recently...

Hi Ken, I saw from another posting that you have a Ph.D. in chemistry. I need some help. I have a database that has over 30,000 chemicals in it. I need...

This is a similar question to the one posted by Jeff on 1/26/05. Can anyone help?? The Access report has conditional formatting of red text if the criteria is...

simple stuff here, haven't been a programmer in about 15 years (things have changed a bit). created a form "switchboard" with a listbox that queries...

On my Form I have a box that automatically fills in with an employees date of hire (txtdateofhire). I want another box (txtyearsofservice) on my form to figure...

Hi, I have a mysql table linked to an access table. However, I loose the autonumber property when I link the tables. In MS ACCESS it appears just as a...

In access 2003, duplicate a cell with data into the remaining empty cells in the same column. As excel will do by draging the info down through the empty cells...

How do I set the default value of a date to be updated each time the record is changed? This field will tell me the last time I accessed and updated...

I am trying to select multiple columns by clicking the field selector and then dragging to include columns in the next screen over to the right. But as soon...

I have two tables with these pertinent fields: tblProfiles txtProfileID (PK) txtDescription tblProfilesAssociations txtProfileID (PK) establishes relationship...

Hi, I am using access 97 and I am trying to copy tables from one database to another one which I have just created. The problem I have is that the CopyObject...

Sometimes when I try to go into the code window in Access 2003, I sometimes get the error below, which terminates Access. Funny thing is that it happens on...