Recent content by Reese

EventID is an AutoNumber field in the table and an unformated textbox in the form. What do you mean by delimiters? Does that still apply? Also, I would rather avoid having designated "open to view on screen" vs. "print to pdf" command buttons on every form, and I would also prefer to avoid...

Oh, and I tried printing to PDF on another computer, with a different copy of the front end database that I hadn't updated with the slight changes that I made yesterday. The Windows Print to PDF still works fine on that one.

I tried that with the following specific code and got a run-time error '2498'. DoCmd.OutputTo acOutputReport, "ZooMobile Billing Invoice Digital", acFormatPDF, "C:\Users\Education\Desktop\Scrap", "[Event_ID]=" & Me.InvoiceTxt The "[Event_ID]=" & Me.InvoiceTxt is vital, because that specifies...

I have a database that has several reports that we print to PDF using Window's 10 "Print to PDF" printer. Starting yesterday, for some reason, it won't work. Access just says "Microsoft Access couldn't print your object". I did make some changes to the database yesterday, but they were to a...

Okay, we're on the same page now! I've made the changes and it seems to work so far. I'm going to do some more testing to make sure it smoothly integrates with my other forms, reports, etc. before I fully change over but I think it should work fine. Here's the query that I now have: SELECT...

Ok, I think that I'm following you. Before trying to solve my actual problem, I'm trying to recreate my current query using your technique. Here's the module that I have: Public Function get_TourEstimateCost(CostCategory, EstimatedYouth, EstimatedAdults, BOCESParticipants, CostPerPerson...

Oh! I didn't even realize that you were using VBA. That's the kind of novice I am when it comes to Modules. Though, to be honest, your most recent thing with ret just confuses the hell out of me. And, before I continue exploring this option, please tell me this: If this is in VBA, how can I...

When you say "every unique field in block of code here, but with better names" which of the following do you mean? - That you just put place holders in and I should use the names of the actual fields in the tables? - That you are renaming my fields to something better for purposes of this...

Also, Plog, if I were to use modules and functions, would they be able to be sources for fields in subforms and subreports? The calculated cost needs to be displayed in a subform that's tied to the form that all of these fields are visible in and data being entered in by the user. Then they...

Plog-- You're absolutely right. And it is incredibly frustrating. I'm sure modules and functions would be better but I know nothing about them other than a few that I managed to write with a lot of copy/pasting from other's work and guess work. I have no idea how to do one to calculate...

I have a rather complicated calculation query designed to calculate the estimated cost of a Guided Tour based on the estimated number of children, adults, free chaperones and what type of Cost Category it is (Full Price, Discount, etc. or one of the several BOCES programs that we have unique...

After looking into SharePoints, I have some concerns. How different is SharePoint to use than MS Access? Would I need to learn an entirely new software in order to transfer my database to it? I'm asking this because, to be honest, my job isn't IT. My actual job at the zoo is as an...

John, thanks for the info and for the link. I'll check it out and let you know how things progress.

Ok, I looked more into SharePoint and I'm not sure what SharePoint services I need to meet my objectives. Based on the goals I mentioned above, could anyone tell me which one of the following I would need: - SharePoint Online (and which of the the three option plans on that page) -...

Hello everyone, I have a rather extensive split database that has a back-end on a local server and two front-ends on the same local network. I am looking into the possibility of changing the database to be shared via the web for a few different reasons: - We want to expand to include users...