Search results

Hi, I'm looking to take a product code which is currently being entered into one field in the format of A-01-002 with a description as another field and creating 3 new fields with the text between each delimitor having it's own field. For example the two fields txtProductNumber and...

Hi, I'm having a problem showing a memo field in both my query and the report based on that same query. I can change the table properties to "text" instead of "memo" and it shows up fine, but when i set it to memo all I get is a bunch of these: . I need this comment box to be longer than 50...

Hi, I was wondering if there was a way to set up a counter using VBA? In the subform I have set up, in datasheet mode, a user will take 6 measurements (4 fields in a measurement), in the same order. I would like to be able to attatch a number from 1 to 6 to each of these measurements. When the...

Hi, The main form is set to on current making the subform visible = false. Upon pressing an option box the subform becomes visible. I would also like the focus to move to the subform at this same time but am getting a runtime error 2110, I believe. Access doesn't like moving focus to...

Hi, I have a main form called tblMeasEvent and a subform called tblMeasurement_subform. When the Black control in the subform is < .35 I would like the main form to add the record. Any ideas how to do this? Thanks