I have a field with NUMBER datatype, SINGLE field size, Fixed format and 0 Decimals. When I enter the value 100317090407 the number rewrites itself as...

We are trying to limit the age when imputting the data on forms. We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the age to 18. Are...

We have a database for our valves & hydrants for which I'm attempting to improve in many areas. One such area is the location field can contain a lot of...

Hi all, I have Table "T_Data" in my database. In "T_Data" I have 220000 records. I need to export them into txt files. I need some kind of macro which...

Hey Y'all, I am creating an employee training database where I can run reports and queries about who has taken what type of course. What kind of...

I have a registration from that has numerous fields and would to like if the register this year pull all the fields from old over to new db - I can either...

I've created a database with about 15 tables for a participant data in a research study. Each participant will complete the 15 assessment measures. My...

Sorry, I was assuming you knew how to write Access code. You will need to create a VB function to perform this task. I don't have much time now as I have to go...

I have a table of stuff stored in a repository and an attached table of inventory dates, linked one-to-many by an Autonumber ID field. I regularly need to...

Access 2007 I have a formulas table with the following fields: Auto FormulaID Ingredient Percent 267 127 FlourA 51 268...

Hi All. I have created a standard report as a type of template. Users can access this report in layout view and change label captions, positions of fields...

I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an...

Hi I have a database that was set up very quickly a few years ago, it is for recording the booking out of equipment to staff at a college. The database now...

I'm just curious if it makes sense to use junction tables in this instance: student - studentID, studentfirst, studentlast, gender, age (adult, teen, or...

I have Access 2000 on the job. I have two tables (CDCR#, Last Name, First Name, and DOB are the only fields) and with many medical related fields. ...

I'm sure this question has an easy answer. Just can't figure it out on my own. How do I design a situation where I can have multiple cross-references created...

Is there a way to do the following? The scenario: The “Animals� database contains the “AnimalsInfo� table. tblAnimalInfo contains the “AnimalType�...

Is it possible to lock a table so that new records can be added but existing ones can not be deleted?

Hi, I have a job list form with basic info on it. I want to be able to click on the job number text box which then opens up a more detailed form and applies...

When I update a feild in MS Word, Access opens up to get the proper information, but does not close when it is finished. Essentially, every time I update a...