Recent content by briancross

That did the trick!! Thanks so much!

ID acct string 12345 1234 - 123456789 - 2008/04/04 12345 1234 - 123456789 - 2008/04/04 12345 1234 - 123456789 - 2008/04/04 3 54321 1234 - 123456789 - 2008/04/11 1 98765 1234 - 123456789 - 2008/04/18 98765 1234 - 123456789 - 2008/04/18 98765 1234 - 123456789 - 2008/04/18 3 This is...

ugh, sorry...it's for excel. I do most of my VBA work in access and this is my go to site when I get hung up. Never even crossed my mind.

Hello, I am trying to create a user-defined function that accepts a string (ID), scans cells in a column (L) for the value "1", checks to see if the cell in the same column row immediately above equals ID, and returns a value stored in the row above, and 24 columns to the right. Returning the...

John's solution was what I was looking for. Thank you!!! I was using code to set DataEntry, but it gave me the same problem that setting the property was giving me.

I have a form that I need to have open blank. From what I have read, the best way to do this is to set the data entry property of the form to Yes. However, on this form I have other controls that allow the user to filter and select individual records. The form fails at this point, presumably as...

I've been looking into this for a few days now and haven't come across an easy solution (or any for that matter). These controls do not need to be included with each record. There are 3 groups: PSRR, TRR and Comments. PSRR and TRR (both review meetings, that may or may not be required for each...

I am currently building a report, however I am running into a roadblock that is stopping me from reaching my desired result. Each record in the detail section of my report has a standard tabular section (with column names in the report header). Below that are three more groups of controls that...