I have a report that I need to be able to add up the numbers in a field of my report and display a total on the report. For example: I could have item 1...

Err msg: Err Msg: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key...

What is the recommended method for updating the links in multiple front-ends on multiple computers after moving a back-end to a new server? Access 2003 and...

I need to change form view between datasheet and single form by click command button. What code for this action. Thank you for help

Linking from Access to Word... (2003) The following code works and writes the date in the way I want. {MERGEFIELD "Date2" \@ yyyy/MM/dd} The following adds...

I have created a form bound to a query that displays as a datasheet. The query has a field called 'Vendor_Id' and I would like to use a combo box to set the...

Hello fellow VB programmers, am at a loss with this one.. I have a 2-toggle button frame on a form. The point of the toggling is to hide / make visible...

I am trying to check if a Date field is null, and I can't seem to get the syntax right. I have tried the following 3 ways: If Forms!! Null Then If Forms!! Is...

Hi, I've got a list I've created and I want to create a query to see certain records with blanks in them. I have tried in my criteria to use Blank or Is...

Created a form, and when I view this form I comes up blank. No fields, they are there in the design view but that is it. Thanks.

Hi I am a complete novice to Access and I use Win2K with Access 2K. I have table that lists a series of codes, and a series of colors to match each code. In...

On each of my task forms, I would like my personal name to go in the "owner" spot. How can I put my name in there where it says "unknown"? I need this so...

I have a report that prints dates (they come in from a table column which is date/time). In certain circumstances, when the dates are blank, the user wants me...

I've recently converted one of our old 97 mdb's to 2002, compiled it and rolled it out to users. I now have a problem when one of the reports is opened in that...

there are no icons under format for spacing and my e-mail is on double spacing

I have 4 date boxes on a form, date boxes 1-3 are completed by the operator, but I want date box4 to be the maximum of boxs 1-3 (but only after all 3 boxes...

I'm new to the database splitting concept. I split a database (I don't think I used the wizard.) Everything is working like a champ except my relationships...

Hi I run Win2k with Access 2K. I have a table that lists a number of different descriptions (ie Zinc, Steel, Aluminium etc etc). I have a form that has a...

Could you recommend me please what is the best way to play with graphics ? I am using MS Access 2003 and VBA and I would like to display some images in forms...

I retrieve a list of students that have completed training and want to compare this list with the students that missed the class. I have played with "Unmatched...