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

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

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 Combo Box based on a look up table for a percentage field. The percentage field has been set up as follows: Field Name: Percent Data Type: ...

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

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

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

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

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

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

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

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 a field with NUMBER datatype, SINGLE field size, Fixed format and 0 Decimals. When I enter the value 100317090407 the number rewrites itself as...

Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...

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

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

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

I have 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are unique...

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