Hello, I have an Excel spreadsheet that has a column of lengthy entries. When I import this spreadsheet into Access 2002, the lengthy field gets messed...

I'm tasked with setting up a database using access. I'm not familiar with the software. Where can I get free on-line tuition on the software?

All, I put in a ComboBox to select between Active and Inactive Records in a table, using the RecordSource Code, It works, except now any fields from other...

Help please, Can anyone let me know how to create a column in access in which the data is calculated by the addtion of the values in the two previous columns.

Hello all! Does anyone have suggestions for "Best Practices" or some benchmarks for what good documentation standards are for Dbase designs in the IT...

My facility has an air quality permit that lists equipment, the regulations that the equipment is subject to, conditions that apply to that equipment, and the...

Hi, whenever i select the Lookup Wizard in Design view, i keep getting the error message "Method'Currentdb of object'_Application' failed" Before when i tried...

I had an answer earlier but with not enough details to try it. The answer was from Dev Ashish and provided code to paste into a new module of the database I'm...

Currently we run Access 2003 on several machines on XP pro machines networked with Microsoft Networking. All the tables are in a separate and central database...

Hello there is a table where the data related to the number of cases of a particular disease are stored with year, name of the county, age groups and so on...

I have two fields within a table called, 1stName and Surname. How could I create a third field called NameComb, which is simplay; + I tried adding that to...

I have multiple checkboxes that are used to determine if equipment meets certain criteria, based on those check boxes selected I want to populate a seperate...

Hello There is a column in one of my table that contains address information. Is there a way that I can split the column into 2 columns, one getting the...

Seems like this should be easy but it's not working for me . . . I'm creating a db that will contain basic employee address information, the states in which...

Hi All, At the moment I am designing a huge and sprawling database that hopes to track products from the moment an order is placed to the moment that it...

I would like to know how best to build a database to collect words for a specialized dictionary for in-house use. I am an environmental lawyer trying to make...

Hello, I seem to need to set up 2 relationships between the same 2 tables - which is forbidden & almost certainly means I'm designing the tables wrongly. The...

I have two fields in a database one for recording brief details of progress in completing a task (a text field) and an associated field that records the date...

Hi, I am using DAO to create a field called BEVerNo in a linked table called UserOptions. The field is created without any problems. I then run an SQL...

I want to create two tables from my source data. The source data contains patient registrations and encounters based on date and time of registration. I want...