Search results

Thanks for the suggestions guy! I have convinced the users that having this functionality doesn't really jive with their more important objective; sorting and filtering the records in order to print a report.

Yes, there are navigation buttons in the form footer for Next Page and Previous Page. And I can see hidden that someone tried doing the Page 1, Page 2, Page 3 . . . links, but that's not a current function on the form. And I don't discount what you're saying about 100 being a lot of records to...

Working on a project for a client, and I'm usually pretty good at coming up with VBA solutions to unique problems. This one has me stumped. The recordsource is a query with over 6,000 records. The form currently lists the records in datasheet format with header and footer for things like...

I think I figured it out. Form.Refresh!

I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table...

And here's the message I've been waiting to see for about 2 days!!!

And BAM!!!! There's the mistake! I had entered a parameter into the Parameter window for the query earlier, and although I had removed the query, I had not removed the parameter! I believe that it's successfully grinding through the records now, behind this window :) Thanks for all your help!

Annnd, I'm right back where I started with the darn "Too few parameters. Expected 1." message. Regardless of whether I specify the RecordSource or the Filter (with the FilterOn set to true), I get that message!! I pretty much understood why I was getting that error before, because I was...

I think I was just able to implement your suggestion, Paul. I decided that rather than setting the Report filter in the OnOpen event, I would set the RecordSource, and include in it a WHERE clause. I think it might have worked!!! More to come . . .

I'm still wrestling with implementing your final suggestion, Paul. First, I tried to implement exactly what you suggested. I entered the following code into the OnOpen event of the Report: Me.Filter = "PWSID = '" & Forms![RequiredTestSheets_frm]![txtPWSID] & "'" Yes, PWSID is the name of a...

Ahhhhh, that makes perfect sense, thanks! PS. John Galt Rocks!!!

Now that I've had time to try to put the solution to work, I've encountered a stumbling block. Here's my code currently. Dim db As DAO.Database Dim rs As DAO.Recordset Dim qd As DAO.QueryDef Dim FileCount As Integer Dim strFileName As String Dim strRptName As String...

Oh My Goodness!!! I just realized that I was making this more difficult than necessary. I was thinking that I would apply the solution to two different annual projects, one I just completed and the second I'm undertaking today. But the SECOND project has no need for fillable fields, so for...

Thanks Pat. That's exactly the purpose of the bookmarks, and I considered the solution to which you refer, but determined that implementing it was slightly over my head :)

So after a little more research, and deciding to shift gears a tad, I found this page that talks about using Adobe Acrobat 8 to insert bookmarks based on the xml structure in the PDF. So, this begs the question: How to I get my Access Report, when printed to a PDF, to contain any xml structure...

Thanks Paul. I envisioned that some code would go into the Detail's OnFormat event, but now I' not sure . . .

Thanks again, Paul. That code looks like it might be useful, but I can't find the point in any of the code where the function AddBookmarks is called.

Thanks for the response, Paul. But surely the time required to open each of the 378 resulting PDFs to run form field recognition would be greater than the time I'm currently spending creating the 378 bookmarks in the one PDF. A year ago when I was developing this process the first time around...

I've done several Google searches on this topic, this morning, and have not found much useful that didn't cost hundreds of dollars. And I'm quite sure that my program is not going to fork over the money for a costly solution that will only save me an hour or so. I have an Access application...

Works like a charm. I thought that was the problem before sending my last response, but had only tried the " ' ' " fix, which had been unsuccessful. Thanks for your help! Oh, and this is the successful strSQL: strSQL = "Select * from PWSIDmorGroups WHERE [PWSID] = " & Chr(34) & Me.cmbPWSID &...