Search results

So could I put If IsNull(Forms!NameOfMainForm!NameOfSubform!Forms.NameOfFieldOnSubform) Then..... For some reason it is not working for me like the same code for the main form (code is in Unload event of main form)

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

When I debug it is stopping at the line of code that says .Update if that helps. quest, where would I ad that code?

Here is the code I have in my NotInList event 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") =...

Thank you!! Thanks so much for the help, I am going to play around with it and see what I can do. My only question, is there a way to limit the number of Part Numbers entered into that subform? Thanks again!!

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 Clock No Supervisor Employee Work Center No Work Center No Work Cener Desc Part Part No Part Desc Defect Code Defect Code Defect Code Desc They want one...

I was instructed to build a database to keep track of scrapped parts. A form will also be manually filled out within the company (not sure why they are doing that but that's out of my hands). On this form there is a ticket No at the top and each ticket number can have up to four scrapped part...

One Clock No does have only one Supervisor and one Employee. Can you explain what you mean to me a little more. I am not sure if I understand how lookups work. Does the Table B already have to have the data in it? All tables will be starting out empty.

I haven't used access for a long time so I am very rusty. I have a few tables but I'll just use two for an example: Table A Ticket No Part No Defect Code WorkCenter No Clock No (Ticket No is Primary Key) Table B Clock No Supervisor Employee (Clock No is Primary Key) Is there a way for me to...

Suggestions anyone?

I have a form that is based on a query with a 5 digit number as the primary key. I would like to be able to search for a specific record based on that number in the form. Here is a little background, when the form is opened it prompts for the password then for the first number they wish to...

Ok this may be a dumb question but here goes, how do I go about creating an unbound combo box and still have it store the data in the correct record in the table? It sounds as if a combo box will be easier but I am a little lost right now.

Well I did think of that and tried it. The only field filled in for a record in the table is the Sales Order Num (it is passed to the table from the previous form) so when I would go in the form find the correct Sales Order Num and type the data in for it, I would get a message saying I was...

When a form is opened I would like an input box to appear, promtpting the user to enter a Sales Order Num. If that number is in the table that the form is based off of I would like the form to open to that record, if not, a message box or another imput box appears telling the user that the...

This has me stumped, hopefully I can explain it clearly. I have a form with 6 fields on it, 4 of those fields are required. Once all the required fields have been filled in I have a check box that should fill in (this is used later on a report that is kind of like a check list to see which...

no luck Well I must be doing something wrong because my query has no records in it. First I started a query and showed the three tables, a - b - c. Then I drug SONum from table a to table be and from table be to table c. Then I chose the fields I wanted. My question is since SONum is in all...

I would like to create a summary report that will show the major aspects of a record. However these major aspects come from three different tables and I know I need to somehow join them in a query (I tried a Union query but couldn't quite figure it out). Here are the fields: Table a...

More info on that suggested approach?? I don't understand it exactly

I have a date field, once a user goes in and changes the data in that field I would like a message box to display that they must write a comment as to why it was changed and then open the comments for so the comment can be entered. I tried to put code in the On_Change() event but it would...

I just set it to fixed and it worked. Thanks again!!