I have a results database with multiple tables (Best Results & Competition). One table (Best Results) holds records of best event results attended per athlete...

I have Sub-Forms in Datasheet view on Forms that are in Form view - but I would like to be able to set the column widths of the Datasheet and prevent the user...

Hi Im a bit of a newbie to Access so any help with this problem is gratefully received. I have a form with a subform in it. The subform called...

I'm using Access 2000. I have a field for First Name and Surname. These fields are used in generating (mail merge) in a report letter. Naturally when entering...

I need to have a Text control remain transparent during focus. I have overlayed this control over an image so the user can type text over the image. As soon as...

I was just looking to improve my db preformace and right now I have it so that when I open a form that it runs a filter filter. I was just wondering if it...

Does anyone in here knows how to disbble "startup" proctection in the tool menu? I setup the startup protection in the tool menu to protect my access form and...

My organization has two large Access 97 databases. Every couple of weeks I make sure the users are out of the databases, then compact them. My question is:...

=IIf(IsNull(),,IIf(IsNull(),,)) If have the next IIF formula in my report =IIf(IsNull(),,IIf(IsNull(),,)) This formula works, it shows the fields porhora...

Please can anyone help, I am using Office 2000 professional and have created a large d/base. I am having trouble with the form in that after a few minutes use...

Hi, I added a combo box to a form to aid in finding a different record. When an item is selected from the combo box the form fields are changed to the record...

I am looking to dynamically display a second combo box when a selection in the first combo box is chosen. For instance, the first combo box might contain a...

I have a main form and a subform and have arranged the tab order to tab through the main form fields, then the sub form fields. I had this working perfectly...

Is anyone aware of a utility that can search through a compiled access application which can identify the names of all the text boxes within the app? We are...

Is there a way to force a Return in a memo field? I import a memo field that is one long string. Ex.: R1, R2, R3, R45, R63-R75,R100-R200,R299... When I use...

I am trying to create a form that has 2 date fields. Court Date, and Due Date. The Court Date is just a basic Date field, but when I exit that field or enter...

When entering a new record in the subform and going to the next record, all fields in the entered record display the #Deleted# message. However, upon closing...

I took someones Access 97 DB and converted it to 2002 so I could create them a series of forms. I then converted back and opened as 97 from my 2002 copy and...

Hello. I write to this forum because I do not know how to otherwise report this bug that has been haunting my program for a very long time. Today I were...

How can I lock entered data. I don't want anyone to be able to change the data in the form after it has already been entered (on a consistent basis). Also, I...