Hi all 1) I am rank ameture at Access 2) I am having trouble getting started with a particular database project 3) Words are all I have to express my...

Hello, I have table that stores a "year" value. Is it better to have this field's data type as a Text or Number value. There is no dates, just a year...

I need a table that can record an unknown set of records for testing. For example, I want the user to record test results. But, until the tests are created,...

I would like to know if it is possible to link records in one table to columns in another with standard db design (i.e. without coding the addition or removal...

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 imported several tables into a database. One of the columns is the city column. All of the records that are in the table are related to one particular...

I just inherited a poorly designed database and have been assigned the task of cleaning it up, properly normalizing tables with 30 fields (!) in them - yes,...

Access 2000 on XP Home Edition I have run into a first-time situation where the Link Text Wizard will not access a legitimate text file. Instead of opening...

This must have ben asked a lot, but can't find how to do it. I want a text field (lets say 10 char long) to be stored right align padded with blanks on the...

Help! I spent hours on designing forms for data entry and got it the way I want it. Now when I want to view form or test data entry, the entire screen is blank...

I need to set up Print and Preview Command Buttons associated with an option group (with 3 options). The options relate to reports set up to show information...

Can anyone tell me if there is a way to take some information off a table (in MS Access of course), and create an Organizational Chart? I have a staff...

To illustrate table look-ups and relationships, most examples I've ever seen use EmployeeID as the example, with the EmployeeID looking to an Employee table...

I want to be able to record a different range of IP addresses for different types of devices. I want the database to give me the next available IP address.

I am trying to create a database to keep track of static IP addresses associated to devices. This has also got to store the location of the device, the type of...

I have compiled a list of IP's used at our office. My table consist of five fields, the key field is the IP address's. When I print or even look at the Data...

I am creating a master list of our customers with location, product and ratings do you have any suggestions to make this an effective tool?

I will try and explain this the best I can. In my table I need fields L_1_1, L_1_2, L_1_3, L_2_1, L_2_2, L-2_3.....notice how the second number increments. I...

How to change or edit colour of command button ? Thanks in advance. Kennykee

I built a small database to track HOA information that included lot number, address info, plat numbers, maps, books, pages, dates etc. that had about 25-30...