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...

I am sorry I do not understand when you say move the code to BeforeUpdate event. I thought I have the code within BeforeUpdate event. Thank you for your assistance.

: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...

It didn't work.:o

In the design view it looks fine, there is no space after the last column. But in the form view it shows lots of space after the last column. Please take a look at the screenshot attachment of both views. Thank you again for your help and timely reply.:o

Thank you for your reply. I do not have a subform. I created this based on a Table and it is the main form.:o

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...

Thank you Paul. It is working now. You are a GREAT help. :o

Paul if you see this could you please assist me with this. I have decided to store the MysteryWt entered in the form to a table called MysteryWeight under the field name MysteryWt. If I want to pass the MysteryWt (from the MysteryWeight table) to the query to find the closest match from the...

Thank you Paul. You were great in timely help. You made my day! Everything is working now after I followed your advice to hit enter key.

Sorry I didn't understand when you say tab off the txt box. Are you saying tab space after the form name? When I use the form to enter wt and open the query 1 , it has all the records.

I have attached the DB

I have attached Fishing DB. Thank you for all your help.

Query1AnglerNameMysteryWtBaggs,Wade1.30Shelton,Craig7.00Jolly,Doug 5.00Sweeney,Robert1.10Engle,Tina12.00Dyer,Jim5.70Thayer,Jason4.30McDow,John7.80Wright,Eric2.50Richardson,Douglas1.20Davis,Brianna2.80Armstrong,Robin7.20Bastura,Patrick3.40Allen,Bobby2.80

I changed the form name and txtbox name to without spaces, Query ran, but returned all the entries instead of closest match. Here is the code: SELECT TOP 1 [Fish Data].AnglerName, [Fish Data].[MysteryWt] FROM [Fish Data] ORDER BY Abs(Forms!EnterMysteryWeight.MysteryWt-[MysteryWt]); Thank you.

Thank you, but it didn't work. Here is the code: SELECT TOP 1 AnglerName, [MysteryWt] FROM [Fish Data] ORDER BY Abs([Forms!Enter Mystery Weight. Mystery Wt]-[MysteryWt]); Error message says, " is not a valid name. Make sure itdoesnot include an invalid name, punctuation that it is not too...