Search results

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...

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...

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...