Recent content by tmguru

Thanks JHB. The situation is that when a user enters something in the cboItemName combo box, the last Category used for that item auto populates in the cboCategoryName combo box. When that happens I expect that the AfterUpdate event or the OnChange event would trigger. But neither do. The...

Yikes!! I see what you mean JHB. I never intended to use the qryExpenseDetail query in this procedure. I wrote a query qryCurrentMonthSpend which I used in the set rst line because it already has all of the fields I need except the calculated field which I obviously could add to the query...

Sure can - here it is. Thanks! -tmguru

Hi arnelgp, Unfortunately the procedure is still having the same too few parameters error. I attached a .docx with a screenshot of the error and a screenshot of the debug screen that followed, Here is the full procedure with your latest code: Private Sub cboCategoryName_AfterUpdate() Dim dbs...

Hi arnelgp, I'm not exactly familiar with what you are asking for (do you mean a Like statement?). Here's the sql for qryCurrentMonthSpend, which is dependent on qryExpenseDetail so the sql for that is below too. What and where do you suggest I change something? qryCurrentMonthSpend...

Hi MarkK, I just saw your reply and tried the code as a verbatim replacement for mine. I got an error similar to the one I got using arnelgp's code. See attached docx. Thanks! -tmguru

Hi arnelgp, I copied and pasted the new code and still got the same error on the same line. -tmguru

arnelgp & JHB Thank you for your suggestions! I do like the simplicity of arnelgp's idea but I was curious why my code wasn't working so JHB I appreciate you pointing out what was wrong. Arniegp - I tried your code but got an error 'Too few parameters' - see the attached docx. JHB - I fixed...

Hi all, I really have tried to figure this out but can't. I think Google may ban me soon!! (jk) I am building a budget database and have a expense entry form that I want to populate some text controls with data from a pre-existing query to let the user know how much was spent in the...

Hi LukeSky, Can you please just post the description of the method you used instead of having to open your database. Thanks!

Doc Man & ridders, thanks so much for your suggestions! I will make some changes based on your suggestions!

Of course you're right on the column names not needing to be the same. I remembered that right after posting. The "sort of" referred to my issue with RI. The lookups in the tables were created by the Analyze Table tool when I imported the initial Excel spreadsheet. I used the default table...

Yes, I'm taking this a step at a time. I do believe I'll be able to normalize within the procedure. It will take some column renaming but I suspect it's very doable. I created some VBA code to import the columns into my three table and it worked, sort of. I got the data into the tables but...

The Excel file will always have the same name/location but will be a new file every month. There is (currently) some manual normalization that has to take place in the Excel file before the records can be imported. I'll look to find a way to automate the Excel normalization later. I have...

Thanks very much Doc Man! I'm still new-ish to Access and macros. I think I can see how the insert statement would work in a macro for one record. Would I create an if loop using goto record next in the source table to loop through the rows until I get an error when I reach the end? If not or...