How can I calculate values of fields if one has value NULL? I use the control source property of a field and if a field has null (i.e 4 + null) the value is...

I have a form inside which several complex calculations are executed according to user input and selections. A few text-boxes at the end contain the final...

How can I make a field inside a form, or better from within the table directly to read the last Invoice number from the table and assign a default value an...

I have a form with a subform inside which both manipulate 2 tables: Quotations and QuotationDetails (One-to-many rs). I have a button which when pressed will...

I call an append query from a form using code: DoCmd.OpenQuery "Quotation-to-Invoice Query", , acAdd How can I skip the 2 confirmation dialogs that follow?...

I execute the following code that will append data into 2 related tables: Private Sub Command129_Click() DoCmd.OpenQuery "Quotation-to-Invoice Query",...

I use the vbYesNo in a msgbox, like: MsgBox ("Are you sure ?", vbYesNo, "Confirm") How do i retrieve the answer then? What is the reference name to retrieve...

Why can't I just disable a button within a form, in the same way I do with other controls like text boxes? I use the command: Command129.Enabled =...

I have a subform attached to a query which includes some variables defined inside the query (i.e TotVAT: *). In my subform I have a boolean variable for VAT....

Hi Group! I have a very strange problem in every Access Version i use with a custom filter. My forms are designed in a way that the user can filter by...

I use Access07 for a custome accounting program. I have been using it for a couple of years without problems but now I added a quotation through the...

I have a form which has these fields: ID, Degree 1, Degree 2. The user choose from combobox the id and then write the degrees.But I want like the user dont...

I have a table with 5 fields. The first field has name thes second which is and the primary key, is a ID, and the rest are empty. I would like when the user...

I try to make a form and when i put the finish button from Command buuton wizard i take the message that Microsoft Office Acces failed to create the Visual...

When I execute DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 i.e. find and replace through form records, the "find and replace" searches for IDs,...

I have a strange issue that I can not figure out. I have a sub form that if I open the sub form alone I can add records to the form. When I try to...

I have a text box in a form that, when a string such as "Smith" is entered it finds all records with "Smith" in the 'Last Name' field. The trouble is that...

How do I remove £ signs from a column in a combo box? The field is set to currency data type in the table for mathematical accuracy. I can remove £ signs...

Good morning! I'm still having trouble refreshing my list box, despite all my efforts at refresh or requery. The user enters data on a form that is accessed...

Hello I have a customer form that has tabs. On tab A you can access a popup form to enter data, then the data is displayed in a listbox on tab c. How do I...