Recent content by SomeDude

I tried the Eval( function in the queries. No effect. The qdf doesn't have any direct references to the form frm_Loans. The qdf is referencing a table (tbl_Loans) and the 2 queries (which reference frm_Loans). It seems like the qdf should pick up what the queries pick up since it's the...

I'm creating an amortization schedule database using Access 2010. I designed it such that I'll input actual principal and interest amounts in tbl_LoanActivity when I get statements in. I'd like to be able to press a button to update forecasted principal and interest amounts, then later I'll...

I'm working on an invoicing database, and I've got a form called 'frm_Invoices' that has not only the invoice on it, but a combobox so the user can find a particular invoice quickly. The problem I'm having is with using the combobox to find an invoice using the 'SearchForRecord' command...

I've got a database I'm using to replace MS Money. I've got some qdf queries to insert data to a table, but two particular qdf's give me a "Compile error: type mismatch". I'm getting the error on the "Set qdf_qry_Ins_forecast_Transfers_To = db.CreateQueryDef(" and "Set...

That worked! Thanks! :)

I'm developing an Invoicing database (which I've attached a sanitized copy) where I'd like to have an invoice number combo box show only invoices relevant to the client previously selected in the client name combo box. I downloaded an example from Microsoft's templates website (which I've also...

JHB, thanks. I noticed the DateAdd function, and the # prefix and suffix around [Forms]![HomePage]![DateHorizon]. I played around with the code just a bit and here is the end result: Option Compare Database Private Sub InsertTransactionsBttn_Click() Dim db As DAO.Database Dim...

Here's the database I'm working with.

Sorry for the delay in responding...I've been wrapping up month-end. In response to why I didn't just delete "NewQueryDef"...I'm that much of a newbie. :o Thank you for your patience. I am seriously trying to "get" this. In an attempt to get around the data type conversion error and how you...

Thanks, JHB. I added the db. prefix. I went back to click on the button on the HomePage and got a 'Run-time error 3012: Object 'NewQueryDef' already exists.' So, I got rid of the name (db.CreateQueryDef("", _). Also, I think my syntax for the Execute command was incorrect, so I changed it to...

JHB: Thanks. I added the spaces before each " per your example. plog: You asked about errors I'm getting. When I press the button on my form I get a 'Compile error: Sub or Function not defined'. Debugger highlights 'Public Sub InsertTransactionsBttn_Click()' in yellow, and CreateQueryDef is...

Perhaps I'm going about this all wrong. If so, kindly tell me. I'm no stranger to SQL, but am still quite new to VBA (and don't have enough money to take a class). I'm an accountant and I'd like to build my own personal financial database in Access. One thing I like about MS Money is the...

Welcome from Texas! I've been using Access off and on for a number of years, but never really got immersed in it until after my boss left earlier this year. I'm an accountant, and I've been doing repetitive tasks in Excel for years. Then I figured out how to program repetitive tasks, and...