Search results for query: *

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

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

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.

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

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!

Me.Parent.RCH_CheckDate.SetFocus

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

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?

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

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

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

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

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

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!

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

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

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?

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.

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

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