I tried to add a subform to my main form but can not get the subform to show only those records associated with the account on the main form. Instead it...

I've two forms in my DB and I want to update ID number in Form B automatically when I enter a new ID number in From A. How can I do it?

Thanks in advance for your help. I have a form that with tabs on it. On one of the tabs I have a sub form. They're linked by employee id. When I set a...

I have a bunch of combo boxes that are unbound and get their values from this type of query: In this particular example it takes the violator_ID and name from...

This works on Access by using an Append Query and Setting the columns to Forms!frmForm1.Field1 for example. Now I am using SQL and Acess is an adp file, I...

Is there a way, in code, to determine the label that is associated with a specific text box, checkbox, combo box, etc.? The idea would be to loop through the...

I tried to open a form with an event which give an error like below: 3146 DAO.Recordset ODBC--call failed. Can anyone please tell me what does this mean?...

Hi all, I'm tired by setting the form's Allow Design Changes to Design View Only to every form. Is there a way to set the default form's Allow Design Changes...

Gaziantep Fitoterapi Merkezi Suat ilikçioðlu Bilimsel Formüller Bilimselligin ilk planda oldugu, tedavide ve yasantimizda kullandigimiz yontemlerin ele...

I am creating a form with about 20 check boxes on it and one button. Each checkbox will represent a query that needs to be run. So the user will select...

I have a subform that displays options available on different models of tractors. On my main form, I have a combo box (cmbModelNumber) that I want to filter...

hello i will be very thankful if u can help me with this question i have, i want to add a field in a report which can show me the opening balance and a column...

I've created an AutoLookup query i.e. joining Customer and Order tables...using the CustomerID from order table and auto fields from Customer table. I'm...

I have a form and subform where I would like to total number of hours for each employee based on three categories: Vacation, Personal, Other. I would like...

I created a table in Access and a form, from the table. I would like to add an additional table in the Access form. Can someone please advise me on how to...

I'm trying to repair a user's Access database to the original functionality. Previously, when the Find Record button was pressed, the Access Find feature...

,Our server was updated to Windows Sever 2003. Since then the forms designed in Access that contain IIF statements in some TextBox began to behave so that...

what's going on

Unmatch Function "fomat" in expression, Error. Someone please help -- Message posted via...

I've a client fond of the "binocular" search ; I'd like to call it from a button on a form ; any method to do this ? A docmd perhaps ?