Search results

Hi all, I am getting a runtime error when I am referencing a control of an open form in the module I created to print a report. I want to print a report if there is any value other than "0" in the txtbox of the form called DropAmount. I needed to create a module for the print job to be...

Hello everyone, I am sure this may be just a simple thing and may have been asked before. I found some solution to DLookup but I am not currently using DLookup so need to find another way. Below is the code I have behind BtnLogin to validate username and password. Right now it is not comparing...

This is where I was getting confused. I was under impression that with err handler, you catch the error, fix it, then resume with the rest of the code. Thanks for clarifying. Now the question is, how do I permanently fix the error for duplicate form number so it won't need to have an handler...

Ok. So the flow would be Code ran without error (number generated )=> Form Printed => Exit Code ran => error => error handler ( number generated) =>Exit Handler => Exit On a second scenario, will it go to PrintReopt or would it skip?

Ok I think I understood the logic now. Few reasons to have loop, there one to have user foolproof. Anyways, just to make sure, PrintReort will go between "Exit_Handler" and " Exit Sub", correct?? Where criteria works just fine. That took a long time to figure out, but it is perfectly working...

Since last year everything went back to manual recording with manual sequential forms and logs. So I'm still trying to follow and learn VBA. So would I enter GoTo Exit_Handler in the If statement or outside as it is displayed on your code. Print is noting but a receipt that prints at the end...

That's what I am trying to accomplish by error handler "Problem". But somehow, either its not saving the record correctly or it's duplicating the record.

The_Doc_Man, you are right about getting trap for a duplicate Key. I thought putting a trap right after error handling would catch it first before running the rest of the code, and "Resume Next" will resume the running code next in line after the trap (which is a Printout).

Field is set to have unique record thus the error when duplicate number is assigned.

Apologies for reviving the old thread and never able to respond. I was transferred to different location and many other accounting projects was assigned to me so never got back to my pet project. Now I am back and trying to resolve this. I applied your code, but it now doesn't produce the paper...

Hello, Self teaching VBA and Access. So not a pro on either. somehow I was able to manage have access print two copies of the report, but now I would like to have two footers on both copies, one should say "Original" and 2nd "Duplicate". How could it be done. Searched online but couldn't...

Unfortunately that is the policy. I may agree or disagree to it but not in control of it. As far as rolling 90 Days goes, holidays doesn’t effect anything. It’s just 90 days.

No financial gain or loss for individual points but a tracking to reward emp with perfect attendance at the end of financial year, and identity abusers. Some may get termed.based on the points they accumulated during rolling year. This 0.50 point drop is help emp who don’t call out often and...

My apologies everyone, i forgot to mention that policy is based on rolling year as well. so today being 2/28/18, anything prior to 2/28/17 is dropped. The policy is to take away 0.50 point from the oldest point earn in that rolling year, therefore creating the "Credit" field concept won't work...

What would be the margin and settings?

Thank you both, Mark and Galaxiom, for taking interest and responding. I am making an attempt to decipher provided codes and the direction you are trying to point me in and follow your advice. As I stated previously, just have very basic knowledge of Access and VBA. Right now I managed to...

It is rolling 90 days. We will calculate 90 days from last occurance. If there is no other occurrence during those 90 days, emp will have a 0.50 dropped. How would this function work? Would I need to create any queries? Thank you for responding.

Hello, Screaming for Help! right now. I am not an Access pro. Just know basics to develop small DBs and enough VB to do small things like printing a form. Our store uses points based system to keep track of attendance for all employee. For example, if you called out, 1 point will be assigned...

Is it possible to add two fields on separate records on the continuous form? I have a sales amount for each month displayed on the form. I would like to sum only two month at at time and display that on unbound txtbox, how can this be done? EX: 1 Jan $5000 2 Feb $6000 --- |$11000| 3...

Duplicating Sequential numeric form numbers Hello everyone, I created DB for item check in/out. Everytime item is issued, it prints the form with sequential form #. I couldn't use the Autonumber as it skips the number so used DMax to assign next number. It worked great until few days ago. Now...