Search results for query: *

Private Sub ClockNo_NotInList(NewData As String, Response As Integer) Dim cn As Connection Dim rs As ADODB.Recordset If MsgBox(NewData & " is not in the selection provided. Would you like to add it?", vbQuestion + vbYesNo, "Unknown Course") = vbYes Then Set cn = CurrentProject.Connection Set...

Sorry, but I am not sure what you mean.

In my form there is data entered, there is also a subform where data is entered. Is there a way for me to check the subform (it is in datasheet view) when the main form is closed to see if the required fields contain data. I have code that checks the fields on the main form but I am having...

I just used the lookup wizard in the table for the field. Is there another way I could or should have done it?

The lookup isn't trying to pull information from the subform. It is pulling information from another table. The user will type in a Workcenter Number and the description field will display the name of that workcenter. The subform is where they will inter part numbers and info pertaining to...

I am having some trouble and will try to explain as clearly as possible. I have a form for data entry, on this main form there is also a subform. I have made the form to resemble a physical paper form that will still be filled out (employers request). I have set the tab order as the same order...

I am sorry my question seemed "academic" I have not had much experience with Access or writing code.

I have a main form which contains a subform for entering some information. I only want the user to be able to enter four records at time in this subform. Is there a way for me to limit how many records can be entered in the subform?

Yes there are relationships. Main and Supervisor tables are related by Clock No Main and Part table by Part No Main and Work Center by Work Center No Main and Defect Code tables by Defect Code

Let me explain my set up a little, maybe that will help. -Main Table- Ticket No Part No Defect Code Work Cener No Clock No -Supervisor Table- Clock No Supervisor Employee -Work Center Table- Work Center No Work Cener Desc -Part Table- Part No Part Desc -Defect Code- Defect Code Defect Code...

I was instructed to build a database to keep track of scrapped parts. The company will also be filling out a scrap ticket form manually (not sure why but I have no control over that). In the database, employees want the Part Description to pop in the form once the part number is entered. I...