Recent content by ClaraBarton

trWhere = TempVars("DateLimit") & " And " & "TransactionID = " & TempVars("AccountID") Returns: Year([CkDate]) = 2025 And TransactionID = 47 YESSS!!! Thank you so much!

This is giving me a serious headache strWhere = TempVars("DateLimit") And & TempVars("AccountID") DateLimit is "Year([CkDate]) = " & Year(Date) and AccountID is long (autonumber) I've tried quotes all over the place and nothing seems to work.

You were right that I had my relationship wrong. I needed all account records and matching transactions. The popup refers to the register and when it didn't have records it didn't have an account. Got it fixed and thank you very much.

I apologize! Turns out it depends on what you use for a PDF reader. Adobe does fine. Some others do not. Thanks for your feed back.

Yes, I am PRINTING my report to Adobe pdf. No one else has seen this problem? It's on Google and there doesn't seem to be a fix. Thought someone here might have an answer.

exporting my Access report to pdf shrinks the report a lot when the pdf is opened. I'm talking about importing when pdf is opened. Sorry.

Click on split to open the edit menu. I can't figure how to send a valid account number to add a new transaction

PDF definitely reduces the report when importing

I have a report that I need to print in booklet form. If I run it to Word it loses a lot of formatting. If I run it to pdf it shrinks the pages. Is there something I'm missing?

I have a form of accounts and a subform register of transactions. Clicking on a transaction opens a form to edit current transaction or create a new one. If the account has no transactions, it does not return an account ID or the name of the account. If I've created a new account, the register...

I'm attaching the form here. I can't figure out where to go on the SORT option. How do I fit the individual queries into the main one?

Thank you. Turns out it was trickier than I thought. You've simplified it.

OldID will be deleted when everything works. Also fCatTypeID and fCatGroupID in tblCategory. It's called tblCombo because it's the basis of little combo boxes. TypeID is not related to type in Description that I'm trying to pull above.

I created a helper table for some small tables I.e. tblCombo for color, type, group, etc. So then I use Pat Hartman's Address Book. It worked great until I created the helper table. Using her code to BuildSql I get: SELECT tblCategory.CategoryID, tblCategory.Category, tblCombo.Data AS Type...

Whoa! I did not know you could do that! THANK YOU so much!