Search results

Is it possible to store a form's name as a string and then refer to that form by that string name? For instance, I have a form named "frm_payoff_process" that contains a textbox named "txtRecevedTotal", and I can refer to it with the following code: Forms!frm_payoff_process!txtReceivedTotal...

I'm trying to build a query that I know should be a simple one, but I can't seem to make it work. I have two tables: one is just account numbers, and the other has information on transactions run in our system. I'm trying to create a query that will return all of the accounts from the first...

I'm having a bit of trouble with the syntax for DCount, and I was hoping that someone could set me straight. I have a query called qry_recons, and I'm trying to count all of the results of the query that have a value of "ML" in the field LOAN_TYPE and that have a value of "Y" in the field...

I've been asked to provide account details on a number of accounts in our system, so I'm building a query that pulls account details from one table and financial details from another. The query needs to include a field that sums all of the payments that a client made over a particular time...

I have ten queries that I run at the beginning of each month that identify different transactions run by my team during the previous month. I'm trying to put together a report that lists each of these transaction types and the number that were run. It feels like this should be a super simple...

I'm having a problem that is driving me batty. I have a workbook that has two worksheets with corresponding data, named Input and Data. I've written some code that is designed to update a particular cell in the active row on Input (using data from a cell in the corresponding row on Data) when...

Hi everyone. I have an unbound form in which a user enters data relating to a credit dispute, and when they hit the Save button I have a sub that is intended to insert that data into a table. This is a bit out of my comfort zone, so I found some code from another forum and adjusted it to my...

I'm having a strange problem using the MonthName function. I have code that (among other things) checks to see if a directory exists and then creates it if it doesn't already. The thing is, it works correctly for every month except June; for some reason, the MonthName function spells the month...

Hi everyone. I've recently started dipping my toes into modules and macros in Access, so please be gentle with me. :) I have a form where the user enters a begin date and and end date and then pushes a button. The button runs a query and is then supposed to export data to an unformatted .xlsx...