Search results

I had time to run this code today. I immediately got the message box, "Me.FilterOn was not enabled/true", even though I should have data for the report.

Thank you. I will take a look at that maybe this weekend. I'm headed off to my daughter's later so I've got to get some stuff done today but thank you for noticing that

After trial and error. I got it to work exactly as I wanted. When the subform populates with the records based off the DemoClientID on the main form, it opens a report with that information to print. I wanted to share my results for others that need to do this. Private Sub...

I have a form that filters data by the DemoClientID to the subform. When a Client is selected on the form it brings up all the records for that Client in the subform. I have created a report that contains all the data I want to display and I have created a button to open that report. I want the...

I don't think it was said I would get an error. I found a way around it. Thanks

I posted all that i have tried in #3. For everything i tried, i thought i gave of a response. I tried =Nz(DMax("ReceiptNr","tblDemoTrans"), 0)+1 in Afterinsert and Beforeinsert. The ReceiptNr field remained blank.

I am trying to populate the field. I was not aware it would NOT be saved. I tried BeforeInsert and AfterInsert. It does not save.

It enters it on the form, but doesn't save it to the table. If i enter another record, it uses the same number and when i check the table, there's a 0 there.

That returned the number I need. I put it in control source and it doesn't work. Where do i put it?

Thank you. I put it in the Control Source. =Max([ReceiptNr])+1 this gets me a 1. If i try DMax, it changes it back to Max.

Yes =[Me]![ReceiptNr].[Value]=DMax("ReceiptNr","tblDemoTrans")+1 I get Expected: line number or label or statement or end of statement DMax("ReceiptNr","tblDemoTrans") + 1 I get Expected: = the table is populated.

I tried DMax("ReceiptNr","tblDemoTrans") + 1 and =[Me]![ReceiptNr].[Value]=DMax("ReceiptNr","tblDemoTrans")+1 and ReceiptNr=DMax("ReceiptNr","tblDemoTrans")+1 in current event. I doesn't like any of them. With =[Me]![ReceiptNr].[Value]=DMax("ReceiptNr","tblDemoTrans")+1 I get Syntax error...

I have a form with Vendors that enters information to the tblDemoTrans and a subform that the Receipt information from the Vendor entered into. I want to do a DMax on the ReceiptNr field in the subform. I have tried: DMax("ReceiptNr","tblDemoTrans") + 1 and...

they are both bound by EmployeeID. Do you know where i can find information or how i would go about running a code manually to Requery?

Let's try a new employee. The wages are entered in tblemployees because most are salary. There is only 1 employee "Stacey" that could get OT, the rest are salary and the amount never changes. Go to Employee #6 - "Stacey" Enter 2 Hours Of OT Enter on line 1 Date: 6/1/25 Check#: 9000...

The DB and the directions are posted over here. https://www.access-programmers.co.uk/forums/threads/after-update.333880/post-1961799

I'm not sure my process in incorrect. I've worked hard to get the calculations right. I agree, taxes shouldn't be calculated until all entries are complete, thus why i posted the database and the directions so people can see what is happening as entries are done and yes, you are correct, OT...

On the Main Menu, click on the Utilities button, then click the Payroll button. In the subform for the first Employee, the type is W2 Payroll check, MyUCA is 51100, enter the check amount of $334.34. As an example, the employee gets $75.00 for insurance premium. To recalculate the tax on the...