Recent content by JonWolgamuth

I have a database here at work (not developed by me) where there is a text field that is laid out thusly: Undelimited_Field LLL-LLLL-3 LLLLL-LL-5 LL-LLLLLLL-19 I need to be able to parse the field into 3 fields, the last one being a number field. Is there a quick and easy way to create a...

PHV, methinks I was making it too difficult! Thanks for the excellent response!

PHV, if the field is NOT enabled, then it is grayed out and does not allow the same sort of searchability that a locked field allows. I'd like to try to figure out how to disallow the double-click from updating the field if it is locked, but certainly let me know if I'm heading in the wrong...

I have a form that I wanted to improve for the users by allowing them to double click in a cell and autopopulate today's date (using the on double-click > textfieddate=date() approach). However, I also don't want this field updated until the user hits an edit button which unlocks the editable...

Perfect. The first solution worked. Thanks for taking the tiem to help me, Bob!

I created a database quite a while back that has multiple combo boxes for the users to select "Reported By", "Analyst Assigned", and "Tester Assigned". What we've discovered after using the database for a while is that these three fields are often, but not always, the same person. It was...

I believe you both have identified the problem. Windows 2000 apparently does not recognize Environ("username"). Ed, is there a relatively simple way to get the username of a user on a Win2000 box? Thanks to both of you! Jon

I have the following query to accommodate a multi-user setup and assign work. SELECT entity_discrepancy.RowNumber, entity_discrepancy.FieldDiscrepancy, entity_discrepancy.TaxId, entity_discrepancy.TinType, entity_discrepancy.AmsSystemKey, entity_discrepancy.DmsSystemKey...

mpastore, Thanks for the quick reply. After some searching, I wondered if instr might work, but didn't know exactly how to put it together. I'll let you know how it works. Thanks again! Jon

I am looking for a way to search a field on a table for a special character. I want to identify each record which has a comma embedded. I have tens of thousands of records to search through. I did a keyword search, but am having difficulty since I don't know what keywords to search for. Any...

I've done some searching via keyword, and I cannot find the answer here--which is amazing to me, so perhaps I'm not doing my search accurately. Anyway, to the point, I'm working on a database which the analysts in our area will use to record the work we're currently working on. It will be a...

grnzbra, thanks for sticking with me! That was exactly the problem! Have a great day! Jon

Not sure I understand. I don't have a "count code", I'm merely using grouping to determine how many times the transaction shows. Jon

I have a database where users enter transactions. Some transactions require that the users enter a quantity (which I "sum"), and other transactions are by definition 1, so I just "count" those). There are certain transactions where the quantity is optional. For some reason...

I've read the excellent FAQ on name parsing, but I'm getting data that needs to be parsed that is in more than the 9 different formats that are listed. Here are the formats I have to work with (all in one field) FirstName MiddleName LastName Suffix FirstName MiddleInitial LastName Suffix...