Search results for query: *

Thanks Gerry I have done enough work in MS Access to realize the importance of giving the fields unique names and will be consistent with any names of items that are also in the dbase (minus the prefix tags). I am finding the "single line" tables useful but not as flexible as I would like...

OK, thanks a lot! That makes a lot more sense. rags

What happens when you pull the half picture back into view then minimize and then re-maximize your screen? I am guessing that the picture reappears in total. If so, you may want to make sure your graphics drivers are updated and/or add some memory (RAM) to the computer. IMO, further research...

Thanks fumei I thought about using tables but didn't think that that it would be as feasible to identify an entry for future data retrieval like the form text field (which has an identifier). I have given you a star for a helpful tip as I hadn't thought of using "single-line tables" in this...

I am trying to create some forms in Word using the Form features. I have many entries that are adjacent in the same line so I need the formfields to hold a certain area in that line so that entering letters does not move the rest of the document. Can this be done? I need the form to be able...

The first thing that I would check would be the file's properties (right click .. properties) to see if "read only" is checked for the file that you can not update. If that isn't it then it may be that you need to either add administrative rights to your user Id or make the file with...

Glad to know that gjd! Good luck to you. rags

Resolved A long process to a simple answer. Setting up a multiple field PK worked if you use the PK button on the menu bar. It didn't work using the rt. click on the box beside the field in the design view of the table. Although the PK symbols showed up with the latter method as it is...

thanks Michael What I have found out is even more baffling. I installed Access 97 on my home computer and brought in the raw shell (tables with no relationships, data, or primary keys set). There are 7 tables that I use. I pulled up the one that I was trying to set up the two column key and...

I think the problem lies with me wanting to use one of the new keyed fields (indexed with dupes OK) in a relationship forcing referential integrity. What I was hoping was that there was a way to use the two newly keyed fields together as a unique "two field primary key" to force...

OK .. Here's what I want: Table A Field A = Facility ID # (dupes OK) Field B = Emissions Unit # (duplicates OK) Table B Facility ID # (dupes OK) Emissions ID # (dupes OK) In Table B - do not want any one Facility ID# to have a duplicate Emissions ID# The problem I run into is that Access...

Thanks Roy-Vidar I have run the repair utility a couple of times and I think the last option you mentioned (importing to a new database) will be my next step. Thanks for your help on this matter and have a happy holiday season. rags

Roy-Vidar I deleted all data from the table. Turned all primary keys off and set the indexes to no. Deleted all indexes. Then added the two back as you stated. I get an "Invalid Index Definition" error message when I try to save it. Can you think of why this may be happening? I...

I am non-programmer by trade developing a database program to enter data into predefined tables that must maintain a certain structure according to the federal agency that wants the data. I called the agency and they had provided the tables as a shell and stated that these tables they provided...

Glohamer's suggestion is seconded here. Hold shift key down when opening the database file.

I have solved my problem which was basically due to stupidity. Glohamer - thanks for your reply. Your information could be useful in other ways if needed. rags

Hope someone can help me with this one! I have developed a form with three tab subforms using Access 97. All records are unlocked and there are no restrictions that I can see on sharing the tables for multiple user entries. When entering data with only one user, the main form and all of the...