Ok, so I'm starting over from scratch. It seems like the more I read the more confused I become. Anyway, I need to create this database where we can...

In the past I could fool the system and reset the linked table properties by modifying the property for a particular row and then saving the...

Apologies if previously asked; I have looked, but not found a (probably obvious) solution: Problem: I want to set up a table in a database which lists all the...

Hi - I'm new to the group, and new to advanced table design. I am creating a multitable database. I will have 4 base tables, then 3-4 secondary tables which...

I am new to Access and trying to create a database that reflects all employees / candidates with their relevant skill. I'm not sure how to go about showing...

Hi All, I am new to Access and 'Referential Integrity' is a new concept for me. In order to understand it better I started working on some sample tables with...

I know that there is a way to calculate averages in Access. But, where do you put the equation and how should it look. I need to get the average of...

My app has custom menu bars, does not display the database window and uses RWOP queries. Users are clamoring for the ability to create ad-hoc queries. I have...

I'm using Access 2003 with the perl DBI interface. Perform the following steps: (1) Search for a record using "SELECT ... WHERE...". (2) If I cannot find it,...

I want to dynamiccally change table structure in Access 2000 code. that is dynamiccally add table structure field. when a table's records have changed, the...

Hi, I am creating a simple database to maintain survey data and calculate some statistics. I work for myself but there might be an oppportunity to sell...

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

Hi experts, I'm porting a database developed in Access to a Web site. In Access, I define a number of queries that are then used in other queries just as...

Hi there, I'm trying to put a field for an elapsed time into a table, for track cycling results. I need to keep times in an hh:mm:ss.000 format, or at...

I understand that by typing a in the format portion of the field properties, it will convert any lower case text entered into upper case. My problem is on...

I've inherited a database that we're using to record stats. Basicly its got customer details and a referance number and most importantly a few different dates....

i have a linked odbc table; i can manually refresh through linked table manager, but is there any way to somehow automatically refresh?

I posted a database design question earlier, but am having trouble determining what would be the best solution. First of all, thanks to Tim F. for your...

I need to clear about 200,000 checkmarks in my database, does anyone know how I can do this? I have tried REPLACE with (-1 with 0) and (Yes with No) but...

I want to print an outline of the type and size of each field in my DB tables. When I go to Tools-Analyze-Documenter-Tables it shows me tons of other...