Search results

Thanks LPurivs...I will give that a go.

There is a button to exit the main form. I need this to go behind that. I am just looking for it to not allow the form to be closed if there are checkboxes checked.

Is there a way to loop through controls on a continuous form? On an exit command, I would like to see if any check boxes on a continuous subform are checked. I am running into the problem that if I select 2 boxes, and then deselect one....on exit the focus is on the de-selected box and it lets...

to be more clear, I actually have it so that you select a date from a combo box on a separate form, then click a button to open the new form. The query behind the new form looks at that combo box for its parameter. But it seems like the textbox I am using the Dlookup in, is only considering...

Hello, I am sorry..this may be long and confusing. Ill do my best. I have an issue concerning a text box with a Dlookup value. It is on a continuous form which uses a parameter query as its record source. The parameter is date. So I would open the form, select a date, and the form only shows...

The data has already been filtered by this point so any transactions that balance eachother can be eliminated. The point of this is that an account gets hit several times a day, but must net to zero...so I am looking for any outstanding amounts

Hello All, I am looking for any advice on the following dilemma. I have a table with new monetary transactions that come in every day. I would like to have the transactions(one debit and one credit) that net to zero eliminated from the table automatically. What I was thinking was to have an abs...

Thanks Ken, the sad part is that book is about 2 ft behind me. I am going to look at that.

Hello, I am wondering if it is possible through VBA to assign all files in an existing folder(I assume using an array) to a variable...but instead of using a file dialog box, have Access automatically store the contents of the folder. The point is to not have to stop the program for a user to...

Thank you all...I will try the above suggestions

Hello, I am a new member...thanks for any help anyone can provide. I have a table with a column in which the fields will come in with various lengths and combinations of characters. I need to look up certain values from this field, and assign a value to another field based on that. For example...