How do i write a validation rule that state that the entry must be between $2000.00 and $10,000.00 My error message will read not less tan $2000.00 but not...

Database purpose: Museum collection records Using Access 2003, I was able to input VB code that allows me to view linked images in Form view. All images are...

Enter "review date" and "review frequecy" to auto-populate "next review date" For example if the user enters a review frequency of annual, and a review date...

I have a query in Access 2007. It contains a date from one table, and a date from a table that has a one to many relationship (and a few other text fields)....

I am using Access 2000. I tried posting this problem under Access Forms Coding but did not receive satisfactory replies to resolution. My Customer Work...

I have a combobox in which the afterupdate triggers a msgbox. In only want this msgbox to show if the combobox value has really changed. Sometimes a user...

Hi All I have a reasonably simple database but even after running "Compact & Repair" it seems the whole .mdb file is much larger than it should be compared to...

Ms Access 2003 I'm trying to convert text to a number in a query where the column is grouped. Val(whateverthetextis) works fine, but then when I click the...

I am building a macro to find and replace zeros (0) that are imported from Excel (blank cells). I have used a combination of Select Object, RunCommands and...

ACCESS

I would like to know if anyone can use their msn account on outlook2007

Hi, I have been working with Access for sometime. I have seen this group mention a lot about indexes. What is the different between Index and Primary Key? SF

I am trying to export a table from Access 2003 with more than 100,000 records into Excel 2007 and am not having any luck. I do not find the 2007 file...

Query Performance Hello, Using Access ’03… For those who know/understand how queries are processed… Is there a performance difference between these two...

MAIN FORM: CLIENTSDETAILSTAKEN---PRIMARY KEY: CLIENT ID RELATIONSHIP: ONE TO MANY SECONDARYFORM: ENQUIRIES FOREIGNKEY: CLIENT ID In the first form, there is a...

I too am new to Live Mail and cannot get any messages to send. I am receiving fine, but when I try to send it keeps showing an error with "server does not...

I currently have one table which contains all my customer information with all the contact information repeated for each person in that company. I want to...

Access 2003 I'm attempting to append customer records to a table and avoid duplicates. I made the table with a unique index consisting of: First ...

Hi, In Access 2007 you have the possibility of creating a link to an outlook (2007) folder. This works fine when linking to the contacts folder. When I try...

I am trying to run a module in Access 2007. I receive a message, "The macros in this project are disabled. Please refer to the online help documentation of...