Recent content by rw0706

Thanks for the replies everyone! The method vbaInet posted seems to be doing the trick for most of the entries, I'll just modify the query with if statements and change the code slightly for the 10% of the entries that are formatted differently. The nice thing is that I only have to do this...

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

Thanks, forgot all about the 255 max. Changed it and everything worked nicely!

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

Thanks guys, that did the trick.

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

One more thing: how do I set the focus to a control in the subform, called 'black'. The above works for getting the control to the subform, and the first control in the subform is called black. Then then next 4 fields are filled by a measurement system that has a macro set up so that it auto...

Thanks Steve and Rabbie! I ended up doing this and it works like a charm (knocks on wood). Me.tblMeasurement_subform.Visible = True Me.tblMeasurement_subform.SetFocus

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