I have a form in datasheet view and I want different background for the lines depending on the value of a field of the line. Is this possible? Thanks in...

I am trying to take numeric data and recode it in order to be used in a report. There is a null value and I am trying to recode it. My coding is below. ...

I have an Access 2000 database that I used for quite some time in Access 2000. I'm now using Access 2003, and every time I open this database I receive a...

I have sbs 2003 standard. Finally got around to sorting out permission, I.E. Managed to remove Domain Admin rights to every user. However as a result my only...

I get an "out of memory" message when starting Access 95 from WindowsXP (in compatibility mode for win98). It has started OK for the past year, but displayed...

Hi, I am working on a database that i want to be able to export a table from into excel. When i do this (I made a macro that exports it to a certain file) it...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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