Search results

This is the second database where this has happened to me. I have code to print a report (with several sub-reports) to PDF. When it prints, only the first couple reports appear. The rest of the pages on the PDF are blank. If I try manually saving to PDF (Save As > PDF or XPS), I get the error...

Okay, so what I'm understanding is that when opening the report, the code should first use a make table query, creating a table in the FE database that backs the report. When a user closes out of the report, the temp table is deleted? My other thought was that I'd keep the table structure in a...

Rainlover, Thanks for your help, but I have to admit, I'm a little lost. I'm not sure if you're building off smig's approach or scrapping that approach completely. I'm getting that I back the report with the temp table, but where in the code is the table being created? I see the recordset is...

Rainlover, I have a couple questions. 1) Using the code provided by smig, I should remove these lines? rsTempTable.Close Set rsTempTable = Nothing Tempdb.Close Set Tempdb = Nothing2) I'm still unsure how to have my report backed by this temp table/recordset. In the code, I don't see where...

From here, how do I set the data source of the report? I think I'm still backing the report by the temp table, right? But how do I set the recordset to that specific temp table? Also, will I run into a problem scrolling through the report in print preview since I'm setting rsTempTable to nothing...

Awesome! I will give this a try. Thanks for your help.

Yes, I know it's not ideal. My reports have actually been running fine. But when I print them to PDF, much of the info is missing in the PDF. I usually print it using an OutputTo command in VBA. But even manually printing to PDF causes the same problem, and manually I receive an error "cannot...

Hello, I'm looking into storing query data in temp tables to help my reports run better. From what I'm reading, it seems best to have the temp tables in a separate db, and to break the links to avoid bloating of the FE database. I'm unsure how to do this with VBA, especially since my temp...

Hello, I have a report that I print to PDF through VBA (docmd.output to...). I have printed this report to PDF with no problems in the past. I changed some of the underlying queries and now I'm having issues with the PDF. The report itself looks fine in print preview. But the PDF shows errors...

I am building a database for a coworker. For one table, he'd like to extract data from different companies' financial reports, specifically a Schedule RC-B (schedule of securities). The format it comes in is PDF, but there are options to download XBRL, SDF and Taxonomy. My computer doesn't...

I'm not sure what you mean by object_SubForm and subform container. When I moved to a new database, everything worked fine. Should I assume my db is corrupt and just work from the new one?

Form: frmContractForm Sub: frmContractSub Compiling didn't show any errors. When I deleted all the On Current code for the subform, they both opened with no error messages from the Navigation Pane. But there are calculated fields just producing #Name? errors. I even added a new calculated...

Hello, I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error Method 'Form' of object '_SubForm' failed. After that, it opens (subform and all), but some calculated text...

The front end is on a shared drive that all users use. I have a backup on my own drive that works fine. I saved that backup to the shared drive, but she is still having the problem.

Hello, I have a combobox with a value list as the control source. I have a user who clicks the drop-down, but there are no options. Every other user is able to view these options, and this user has no problem with any other combobox with a value list. Has anyone seen this problem before...

I actually built this code a while back, but realized this potential problem today, so that's why there's more to it. I was able to get it working, but I just had to slightly tweak your code:strWhere = "ExceptionName Like ""*" & Replace(Me.txtName, Chr(34), String(2, Chr(34))) & "*""" Notice the...

I tried doing this in the VBA code, but as soon as I finished writing that line of code, I received an error message that says: Compile error: Expected list separator or ). Here is my code: 'Set strWhere for Name If Nz(Me.txtName, "") <> "" Then strWhere = strWhere & " AND ExceptionName Like...

Yes. So in the example I gave, there will probably only be one record with that specific string, but we would need that record to come up in the report, with the quotes.

Yes, that's what I'm saying. I think you're suggesting changing the text in the table, but I can't actually do that, as it's exact language from the contract.

Hello, I have a form that filters a report. Users have the option to filter the report based on text in a certain field (the field is ExceptionName). So the user can type in Index, and any record with Index in the ExceptionName field will appear. The field used to filter the report is a combobox...