Search results

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!

the query I want is 2qryRegister. All the others feed into it. The problem is when I add the transaction totals. Is there a way I can get all that together?

I have a query that groups transactions together by ID: But when I use this query and add another table it loses its grouping: What am I doing wrong? The addition table is left join.

I’ve worked on this so long that I can no longer see the trees for the forest. I want to transfer money from one account to another so (on your advice) I’ve created a self join table. Mostly this works except for when there is more than one transfer (bottom subform) in the Check. The code on...

Wow! You nailed it! It's a foreign key with nothing in it but it's in there twice. Thank you so much!

I removed the CkAmount from qryTransactions. If I remove the Sum from Cleared It says Does not include as a part of an Aggregated function. The only thing it will accept is sum. There are not 2 ID's 19. It is an autonumber.