Recent content by tuoggy

That sounds like exactly what I am looking for. I was going to make a command button on the form to run the macro when I finished it. Code would be much appreciated!!!

Hey guys, I got a pretty simple one I think... I'm using Access 2007 designing a 2000 DB. I am creating a simple service order db for a client. I have the following: SERVICE_LOG - Table ORDER_QUERY - Query SERVICE_ORDER - Report I'm currently trying to figure out a way to create a macro...

Yes, there is a field for salesperson in the Job Log Table. Having the timesheet entry person enter the salesperson is really just the last line of protection to make sure that it goes to the right person in the end. That's why we don't just print the salesperson from the job log table...

Okay, I'm sure this is an easy fix. I just can't figure out how to do it. I have a Job Log database that I created a couple years ago. I have recently been asked to make a few changes to it. We use this to calculate how much time each employee has spent on a job, as a job log, and also as a...

I am having some trouble with user security. When I initially set up security on a database, it automatically assigned user pin numbers but now when I try to add a new user, it is asking for pin numbers. Is there some way to create pin numbers using the same convention that Access uses? or is...

Now I realize that this isn't necessarily what the reporting in Access was designed for, but in order to make it more user friendly, I have been asked to design a letter through report rather than to use the mail merge function in Word, which upon printing will update that it has been printed...

Thank you very much, I guess I never saw that option. That makes it very simple.

I'm not sure if this is possible in Access, but I was wondering if there is a way to automatically run an Update query when a report is printed. More specifically, I have confirmation reports, and I want the date printed and confirmation sent fields to be updated upon printing. I have an...

Got it, it works, now I can move on to something else. Thanks again

I'm back, same problem different line. So now that I have gotten the code in and we are testing the database (for some reason this didn't turn up in our initial testing) I am getting an error message when I try to update the record and move to the next one. Run-Time error '3075': Syntax error...

That did it! Thanks again Adam and everyone who helped. You guys are great!!!

I have attached the 3 images. The Participants has all the non applicable fields hidden, and the input Form is just an initial Wizard made form. Hope this is what you needed

Okay that fixed the gender field!!! There are no more Syntax errors. The final remaining problem I'm having is with the Capacity MsgBox. For some reason it isn't comparing the DCOUNT to the Capacity in the Cabins Table. Any Ideas? <edit> Okay, what I meant by the previous statement is that...

Okay, still on this issue... Here's the code: Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("[Last Name]", "Participants", "[Last Name]=Forms![Participants Data Entry]!Cabin") >= DLookup("[Capacity]", "Cabin", "[Cabin ID]=Forms![Participants Data Entry]!Cabin") Then MsgBox "This...

I'm still getting the syntax error. After I get the error it highlights the top line. Is it a problem that it's set for Before Update? Do I need to create a button to click to run the code and go to the next record? Currently I just Tab or Enter through the form. And every line is red in...