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!

Register Log in
  • Congratulations derfloh 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. CVesta81

    Running Code After Shifting Focus Out of a Subform

    Hello, I have a form (frmProductsEdit1) and a subform (frmSubPackaging) attached to the form. If any field on the subform changes, I want code to run once the focus is back on the main form that updates the revision date for the specific product code (done by an update query). The code I am...
  2. CVesta81

    Hello, I currently have a table

    This is perfect! Thank you so much! I made my code more efficient as well. Thanks!
  3. CVesta81

    Hello, I currently have a table

    Also, I apologize for not putting a title on this post. I was too focused on re-reading it prior to sending that I forgot to add a subject line.
  4. CVesta81

    Hello, I currently have a table

    Hello, I currently have a table called "tblPictureIndex" that is referenced on my form in Access. I have a button on my form that is meant to clear out two fields in the table based on a field on the form called "CutCode" (also referenced in the same table). My code is listed below: Private...
  5. CVesta81

    Move from a control in a subform to a control in the main form

    Perfect! Missinglinq, you were right! I was referencing the field and not the control. The names were very similar, but not identical. I appreciate everyone's help with this!
  6. CVesta81

    Move from a control in a subform to a control in the main form

    Me.Parent.RCH_CheckDate.SetFocus
  7. CVesta81

    Move from a control in a subform to a control in the main form

    OK, so neither of those worked for me for some reason. I am including the code in the LostFocus for the last control in my subform (Private Sub Notes_LostFocus()). I am getting the message, "Run-time error '438': Object doesn't support this property or method." What am I doing wrong? Do I...
  8. CVesta81

    Move from a control in a subform to a control in the main form

    Is it possible to help me with the code? I'm not familiar with setting focus to a parent. This is the code I tried: Forms!frmA1SalesOrders.SetFocus Forms!frmA1SalesOrders!RCH_CheckDate.SetFocus What am I doing wrong?
  9. CVesta81

    Move from a control in a subform to a control in the main form

    Hello, I have a main form with a subform in it. The main form's name is frm1ASalesOrders and the subform's name is frmA3SalesOrderDetail. I am trying to program a Lost Focus event so that when the last control in the subform loses its focus, the control RCH_CheckDate gets the focus in the...
  10. CVesta81

    Change the Input Mask of a Field based on the content of another in Access

    I got it to work. My only question is I'm assuming this code doesn't work correctly if I have a continuous form with both Canada and USA in the form. I tried it and it seemed to switch back and forth between formats when I would click on the different records. Anyway around this? If not, I can...
  11. CVesta81

    Change the Input Mask of a Field based on the content of another in Access

    OK, So here is my code. It doesn't appear to be working. What am I doing wrong? Private Sub Form_Current() Me.Country.SetFocus Select Case Country.Text Case "USA" Zip.InputMask = "#####-####" Case "CANADA" Zip.InputMask = "??? ???" End...
  12. CVesta81

    Change the Input Mask of a Field based on the content of another in Access

    I have not. Where would I place such code? Would I use this in the "On Current" part of the form?
  13. CVesta81

    Change the Input Mask of a Field based on the content of another in Access

    Hello, Is it possible to change the input mask of a particular field based on the content of another? My example here is I have a field named, "zipcode" and I would like to change the input mask of that field depending if the country field reads, "USA" or "Canada". As you may or may not know...
  14. CVesta81

    Add record to multiple tables in MS Access

    Actually, I solved this one onmy own. I used a pass through public variable and then assigned a each table the ID. thanks for your help!
  15. CVesta81

    Add record to multiple tables in MS Access

    There must be something screwed up with my relationships in my database, because the Master/Child properties are correct. I have all forms set for Data Entry but only the main form shows. As an alternative method, is it possible to run an Append Query when I close the form? I would envision...
  16. CVesta81

    Add record to multiple tables in MS Access

    So here is the issue in a nutshell. I am trying to create a database for data entry. The database has been created but I can't get the data entry part to work. When I try to create a new record utilizing a form linked to Table1, I am fine. The problem is that when I try to update information...
  17. CVesta81

    Add record to multiple tables in MS Access

    I have done this and everything matches up. When I load the form, the subforms are completely blank, even when I add data to the main form. Is there something else I'm missing?
  18. CVesta81

    Add record to multiple tables in MS Access

    I can't seem to get this to work. Could you give a little more detail as to how to do it? When I set up the two subforms, they are blank. I'm guessing because the new customer number doesn't exist in the table yet? I'm still confused as to how to get the new customer number in each table.
  19. CVesta81

    Add record to multiple tables in MS Access

    PHV, Is there any VBA code I would need to use, or just simply set up the two linked forms with the primary keys?
  20. CVesta81

    Add record to multiple tables in MS Access

    Hi! I have an Access database with three main tables, "tbl1Customers (MASTER)", "tbl2Contacts (MASTER)", and tbl3Addresses (MASTER)". For simplicity purposes, I will refer to these tables as Table1, Table2, and Table3 respectively. I want to be able to add a new record to Table1, and have that...

Part and Inventory Search

Back
Top