Assuming you are entering the data into a text box on a form and not directly into a table, you can set a text box's text alignment and margins on the property...

I have been wondering if there is a reason to favor either the table, a bound control, or VBA (the form's Current event, for instance) for setting the default...

I have a vendor database (Access 2000) in which some of the vendors are categorized as Approved. A Boolean field (Approved) in the Vendor table defines...

I am trying to figure out a way to show employees and non-employees in a combo box. The training database includes training records. Training may...

I couldn't think of a good, brief subject line for this thread. I have an Employee database with EmployeeID (PK), FirstName, LastName, etc. Some employees...

I have an Employee table that is linked to three instances of an Inspection table. tblEmployee EmployeeID (PK - Integer) LastName ...

I'm not getting my brain around this one. The general situation is that machine parts are processed according to a Process Plan. A Process Plan may be for...

I am putting together a database to track various information about equipment. Among the information being tracked is an inspection checklist. The...

I have been experimenting with Allen Browne's system for using an Integer field in place of a Yes/No field: http://allenbrowne.com/NoYesNo.html The article...

Hi I like to design a report header and page over the full width of A4 paper. But all the data in 2 coloums.

i have a problem. i'm using form wizard to make one main form with two subforms. the first time i completed it all forms had all the fields i wanted in one...

i've moved a field in design view on my form and i can't seem to figure out how to move it back where i want it. if some one could help me i'd appreciate it...

i have a db with 5 tables. the first tabel timember with memberid being pk and the field Partner id linked to a table memberspartners on the field...

Hello ! I just wanted to answer you that finally I found a very efficient solution to solve my love and flirt problems. Everything is on the site...

Hello, Suppose Columns A and B in Table 1 contain an industry name and industry code, respectively. I then create a Table 2 which has drop down lists in...

I have a data set of numbers arranged in rows. They are 6 elements across. Each data set is unique. There are many sets which are listed down the page. I...

I am trying to design a database that keeps track of where our customers fields are. We are trying to do this in a StateCountyTownship fashion. How can I...

Hi After I run a query, I get very long decimals displayed. How can I adjust them to only 2? Even when I go into properties, it will not allow me to chance...

I have imported a bBASE table, and was wondering if there is a way to edit the numbers within the records so it only displays 2 decimal points instead of...

I would like to create a database in access from spatial data that I create in arc view GIS so I can query my data. I can export my datbase tables from...