Search results

  1. B

    Check box on continuous form

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

    Dlookup not bringing back right record

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

    Eliminate records that net to zero

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

    Assign Files in Folder to Variable

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

    Criteria for all numbers or letters

    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...
Back
Top Bottom