Recent content by rmrufe

I believe I resolved my own issue. When selecting Contact Name in the Associated Jobs section, it did not match the contact name in the Associated Contacts section, which is why it wasn't printing correctly. I made sure the Contact Name matched the name in the Associated Contacts and it worked...

The database is attached. This is the version prior to making any changes to the Job Number via the Modify AutoNumber query. Again, all I did was go to the Modify AutoNumber query and change the number is the Field from 17001 to 18000.

To be a little bit more specific on the issue I'm having: The Job Report has 3 sections: -Client information -Contact information -Job Details When I click my Print Job button, the Client Information section appears in my Print Preview, but with no data in those fields. The Contacts and Job...

I just checked the table I created for jobs in Design View. The Job Number field is AutoNumber.

I went to the query > Design View > then changed the number I had in the Field section from 17000 to 18000. The 17000 set of numbers was used for 2017 jobs. Jobs in 2018 shall begin with 18001.

Please forgive me as I am not an expert in maintain Access databases. I built a very simple database for a family member's company to track jobs (Job Number is an AutoNumber), clients and contacts. With the new year, I modified the Job Number, but now it is affecting my ability to print job...

That did the trick! I can't thank you enough. I've been trying to solve this for weeks with and have been running into dead end after dead end. Words can't express how thankful I am!

Yes, had the form open when running the query and I'm still prompted to enter a parameter. When I close the query, I'm still prompted to enter the parameter 3 times when I click the "Print Job Report" command button on the form. The report generates successfully when I enter the parameter 3...

No, the form wasn't open when I tried typing the Criteria in the query.

Thanks again. I tried the recommended Criteria code and it's now prompting me to enter two parameters to run the query.

It's a subform of the Client form.

The Job Number field is in the subform.

I appreciate your help, pbaldy. Thanks for posting that link. Unfortunately, I think I'm having trouble deciphering which section to look that. I'm guessing the "Not in these forms" section because I'm editing criteria in a query? Then I'm assuming I look at the "On Sub 1" line since the field...

Are you talking about my reference to the subform on the Criteria line of my query? Or did I type something incorrectly in my VBA code for the On-Click event?

This is my first post, and I'm brand new to developing MS Access databases, so please bear with me. I built a database in MS Access 2010 (attached via zip file) with three tables: Clients (primary key: Client Code, which is a Text datatype), Contacts (primary key: Contact Name, which is a Text...