Search results

I have a Data entry Form to enter the payment info. I have Invoice ID and Invoice amount etc... in Invoice Table. I want the Invoice amount to appear automatically in the Payment form based on the Invoice Number I enter. I have Invoice number in both tables, Invoice Table(Primary Key) and...

I am getting run time error 3075 syntax error missing operator in query expression '[Job Number] = ' Here is my code: Private Sub Job_Number_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("[Job Number]", "[Job]", "[Job Number]= " & Me.[Job Number] & " ")) Then MsgBox "Job Number doesn't...

I have two tables Invoice and Payment. I am running a query to get the Invoice balance. Invoice Balance=Invoice table.Invoice Amount-Payment Table.Amount received. Some times the same invoice has multiple payments and if I want to show each time when an invoice gets paid, I want the query to...

:o I have two tables Invoice and payment. In the invoice table I have job number, Invoice number and Invoice amount, and in the payment table I have Job number, invoice number and payment. I would like to do an Outstanding invoice subform in the payment form, where it will show all the...

I have a drop down list in a table with name and commission rate. When I choose the name it displays but I want both the name and the commission rate to display in my table. I want to use a data entry form to enter values in the table and I want the same in the form too (when I choose a name I...

:o I have this code: Private Sub Job_Number_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("[Job Number]", "Job", "[Job Number]= " & Me.[Job Number] & " ")) Then MsgBox "Job Number doesn't exist Enter a job number that already exist." Me.[Job Number].Undo Cancel = True End If End Sub...

I have a form where I have all the data showing from a table to edit the data. It is a continous form with no data entry. Only edits and deletions are allowed. I want to get rid of the extra space after the data in the last column. I tried everything I could in the form properties. Please help...

Hi I have a table called Fish Data with anglers name and fish weight. I want to run a parameter query where the user will enter fish weight and the query should bring the closest match from the Fish data table. How do you get the closest number match. The fish weights are entered with two...

Hi I am an associate professor at a state college and I use access to create small databases. Currently I am helping a friend to sep a DB for a fishing totrnament. I have a table with anglers and their fish weight. In the DB, user enters a weight (randomly selected) and the query should find...