Hi, I have a form on which is a sub form, also on the main form is a combo box, when I change the value in the combo box I want to change the RecordSource...

I have a form based on a table called tblProgress where such fields as name, date, weather conditions and street name are stored. I then have a subform on...

Hello, I have a simple database to track my CD collection -- two tables, tbl_Albums and tbl_Artists. Tbl_Artists contains one field, the artist name, and...

Hi: I've a MAIN and RESULTS forms. I've a RESULTS query that deppend of a textbox inside MAIN form. this is the criteria option in the query: Like...

My sub form (sfrmWorkTypeForTender) sits on a main form (frmTenders) and the record source for the subform is tblWorkTypeForTender. Ive tried using a query...

I have two exact db with main form consisting of Main form and subform, same exact links. On db 1 the main form when looking up serv doc the pts assoc with...

I have data in "query1" and field1 name is "number" in form-datasheet view like this number (This is in Access Form) 601366 112121 654545 013554 I need to...

How do I stop a form page with command buttons from opening when accessing a database? I want to start at the TABLES tab

users have access to two diffrent forms "FORMA" and "FORMB" from three different forms. The first access works: ACCESS1 (only allows user to select FORMA...

I have made forms for resolution 1024x768. Now my friend got a new monitor with resolution 1280x1024. The forms look still quite like on the screen 1024x768. I...

I have a a small form for entry purposes linked on a Call ID, my challenge is every time the staff try to enter a new entry to it, the cursor jumps back to the...

I have an Access 97 applicaton. One of my screen has code in the Form_Activate event. For some reason the event gets fired 3 times. Is this a MS bug? Any...

Hi, Can anyone tell me if there is any way of running a bit of code every time the focus moves from one control to another on a form? I know that I can use...

Good Morning Folks, I am trying to find either an add-in or code to automatically put a file explorer inside an Access form. I would like to browse thru a...

I have built a form (a menu, really) for our construction managers. By pushing a command button area A manager can access his 4 forms, same for area B, C,...

If I have a Flat table "Contact Numbers" (No Relationships) Which has within it fields "FirstName" and "LastName" I am using an SQL statement to concatenate...

I have a form which includes a subform. The subform has 3 tabs. When I select a different tab, the entire form aligns on the first field in the subform. I...

The form opens with the first record. You can then scroll through the records or add a new record. However if you change any data the record locks. You can...

I have a form with a text box (Memo data type) that allows user comments. I also run some SQL later on that inserts these comments elsewhere. If the user types...

I have a fairly simple database with several tables with connected forms for the users to enter data. One of the forms allways comes up with an new record when...