Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ArtimusTek

    Referencing a Subform from Multiple Forms

    Well guess what.. I figured out how to make one form, but with data entry.. so i only have one form... however.. In the sub form, when i set Model as "123" it sets StoreItem.Column(1). However, when i set a new record.. and change the Model.. the old StoreItem.Column(1) changes.. and the value...
  2. ArtimusTek

    Referencing a Subform from Multiple Forms

    Yeh i thought that would be a nice way to do it.. but trying to avoid it. I was thinking, maybe theres a better way to make only 1 form.. instead of 3. Right now the forms are; 1. A form that is solely for Data Entry 2. A form that is for modifying single records 3. A form that allows the user...
  3. ArtimusTek

    Cap 1st letter(s) of word(s) in Field

    Should be the same. It formats the whole text box, not just the first letter. Numbers shouldn't interfere either.
  4. ArtimusTek

    Cap 1st letter(s) of word(s) in Field

    You can give 2 things a try. 1. Enable AutoCorrect in MS Access Tools > AutoCorrect Options.. and enable Capitalization. 2. An input mask such as; Private Sub TextBox_LostFocus() Me.TextBox = StrConv(Me.TextBox, vbProperCase) End Sub
  5. ArtimusTek

    Referencing a Subform from Multiple Forms

    Hi guys, my first post on Tek Tips. I got a little problem, i stayed back 2 hours at work trying to figure it out but no luck. I have a subform, that runs a query on another value in that subform.. and i use this to reference it; Forms![ServiceJobCardMod]![ServicePartsList].Form![ModelCombo]...

Part and Inventory Search

Back
Top