Search results

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.

or this?

Like this?

SELECT qryTransactions.TransactionID, qryTransactions.Cleared, Nz(-[Credit],0)+Nz([debit],0) AS CkAmount, -Nz([CatCredit],0)+Nz([CatDebit],0) AS CatAmount, qryTransfers.TAmount, Sum(IIf([Cleared]=True,+[CkAmount],0)) AS ClearedAmt...

it's an optional variable. still working on it. Nevermind. For anyone else with my original problem: I'd like to tell you what the problem was. Before I started all this NotInList code for my combos, I had set up a form in the "ListItemsEditForm" under data and forgot about it. After going...

If Not IsNull(" & strForm & ") Then ...

I've (again!) done my job and worked through this (walked the code) and I still need help Private Sub cboPayee_NotInList(NewData As String, Response As Integer) Dim intAnswer As Integer intAnswer = MsgBox("Add to the name list?", vbYesNo, "Missing Name") Select Case intAnswer Case...

okaaay! The problem is actually in my pop up form, and not the NotInList. Although you helped me fix that too. Thank you for your guidance. I always try and Try and TRY to check everything before asking...

Oh, you're right! It works for 3 which is what I've been testing.

'frm = This Form (me) 'strCombo = This Combo (cboUserName) 'strForm = the form used to add to the table or query Public Sub EditCombo(frm As Form, strCombo As String, Optional strForm As String) Dim strOpenArgs As String Dim lCallsID As Long Dim strSql As String...

That's what I did. Still get the message. Private Sub cboPayee_NotInList(NewData As String, Response As Integer) Dim intAnswer As Integer intAnswer = MsgBox("Add to the name list?", vbYesNo, "Missing Name") Select Case intAnswer Case vbYes EditCombo Me, "cboPayee"...