I would like to turn off all fields when a check box is checked so no more data can be entered into a record. Suggestions? Thank you. Ted Clore

In a table I have a column with numbers from 1-1000. I need to sort them by odds and evens. For example 1,3,5,7,9,11.....999 and after 999 the next number...

I am trying to design a db for technical analysis results. i need to be able to multiply the values in a regularly updated record and show the results in a...

Hi all We have a split database Access 2000 and one of the users has managed to add a record displaying Chinese characters! The problem is that the record...

I have a table named 'invoices' with a field named 'invoice#'. I am creating a form which a person fills out different fields. The form is named 'FInvoices'....

I am taking a records and management course in college and have worked with access, excel, powerpoint, and word. My instructor keeps wanting me to index the...

I created a switchboard using switchboard manager and accidentally deleted the "switchboard" icon from my Forms objects. I can't run the switchboard even...

I am working between 2 vsns of Access, namely 2000 at home and 2003 at the office. I do most of the development work at home and copy the database at the...

Hi All, I am a novice as far as Ms Access is concerned. The problem I am facing is I am having 2 tables A & B containing the same fields. Changes made in...

I'm creating a script file and I need to populate my lookup tables. How would I write code to populate the values 1, 2 , ....9 (Only an example so no better...

I know it will be devastatingly obvious but can someone explain what I need to put in the On Click property of a Command Button to have it save the...

Followed the help file instructions for setting a database password. Now I can't open any database at all. I am stopped at the user/password box. I can't even...

MS ACCESS HELP-Status Reports Forms I am currently in charge of monitoring my divisions weekly status reports. At the end of each week everyone in my division...

I have a repicated 2003 database that I have used for 2 years without problems. The size of the database has not increased nor any design changes...

Hello in a table I have a field (F1) in which we have first and last name entered together . For Example JOHN SMITH . I created 2 new fields one called FNAME...

I created a crosstab query. When I did that I got columns of data that were created by the crosstab query. They are called 11, 12, 30 and 40 through 49. I'd...

I am attempting to create an Access 2003-based mileage log with data generated by a Palm Treo application (Trip Deluxe). I have it almost completed execpt for...

Can a Form or a Report has more than ONE source?? (ie. two or three queries).. Thanks

I have a database, the back end is in SQL server and the front-end (forms, Query's mudules) is in Access. I will be distributing this to my client who will...

I've been given this database to convert to Access 2000. In the folder where it resides is a file called SYSTEM.MDA What is it and what do I do with it?