Search results

Could you possibly build a replication of the table in another database and then use it to archieve older records? At least enough to get you a little time out of it. You wouldnt be deleting them, merely relocating them in a safe and consistent environment.

Would the upsizing utility be an option. If you have reached the limit and are still going, I highly recommend using the right tool for the job. Upsize to SQL and develop the FE in Access.

The primary key MUST BE UNIQUE to each record, and can be used to easily identify the record. You can prevent duplication of data by using the primary key, or else there would be no such thing as junction tables (which is what I belive the initial question was refrencing).

YOu cant have multiple primary keys per say, but you can have a concatinated key which is TWO fields sat as a single key. This would be the best way to ensure that you do not have the same product twice on the same day. You do the by selecting the two fields (highlight), then click on the...

To the best of my knowledge, no. But dont give up hope. You may post in the VBA section to see if someone knows how to access that attribute and display it in a lable, but I doubt it.

While in design view of the form, go to FILE-PAGE PROPERTIES. The third tab will allow you to set columns.

If I am understanding the question correctly, you want the DESCRIPTIONS of the fileds to appear as the FORM LABELS when they are placed on a form. If so, then you need to ensure that the CAPTIONS property for the fields in the TABLE are set to the DESCRIPTIONS. Open the table in design view...

Close but no bannana Try placing the > in the FORMAT area of the properties (one row up)for the field within the TABLE. That should get the results you want. Input mask will allow you to format a field with special characters like (***)***-**** for a phone number. If you click on the ellipses...

Not trying to sound callous, but you do have to bring something to the table. If you have absolutely no knowledge of access and don’t understand how to create or use a query, you should look more to using an application that you are more familiar with. If you are developing something, you need...

First off, base your form off of a query, even if it is from a single table. Now in the criteria row beneath the "serial number" field, place [Please enter Serial Number] Include the brackets. Then when you open your form you will be presented with a pop...

I think that you now require some assistance a bit above what I can offer. What you may want to do is actuall post this as a new line of questioning into the code section of the forums. Design and structure are my strong points, but when we get into the more complicated code I am not the best...

Its late, I am tired, but here is a small example. Tell me if this is the path you are trying to go down. Look in the relationship window and see what is happening. It is a very simple exapmle, but we can work from this common ground.

Relationships What you have to keep in mind is there are different types of relationships between tables; One-to-Many, One-to-One, and Many-to-Many. The prefered relationship between tables is One-to-Many, because it usually indocates that you have normalized the table properly. From the...

Sorry, only noticed the very last reply and missed the one before it. What you need to do is in the after update function of the frame, change out the textbox. Actually create a textbox for each of the answeres (based off of the table) and STACK them. Enable/Disable & the VISIBLE settings can...

What you are looking to do is pass the information from one form to another with a global variable. When the click the switchboard item, have it open the form you have in mind for entering the site ID. Look in the properties under the events tab for the for the On Close event. You can then...

"as far as exiting the program we want to close Access completely, but when we click on this exit button, it will only close the database, leaving Access still open" Make sure the event behind the button is DoCmd.Quit and not something else. For the option group to change the display on the...

Please forgive my hesitance in giving out any personal information such as a phone number. It is my experience in the past the all questions are best left within the forum. I have no problem helping you achieve what you are try to do, but I must insist that it be done via these forums. Sorry

Ok, first off what i see is the form design itself. It is a bit cumbersom and could be laid out better. I took your basics and added them to a form that contains a tab controll. Secondly, I based the form off of a parameter query that will prompt the user to enter the site ID. The last item I...

Example I have attached a small example. What I have here are tables with an established relationship. I create the main form from the tblSite and the subform from the tblSiteData. I also added the drop down combo box record selection to it for demonstration. This was simply done using the...

Is the data stored in multiple tables? tblSite ~SiteID ~SiteName ~Address tblSiteData ~SiteID ~SiteData1 ~SiteData2 ~SiteData3 I will throw together a small example of a subform for you, but the table structure should be as normalized as possible.