Search results

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

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") =...

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

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

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

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

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

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 have never done math on a report so I need some help at this. I have two date fields and I have another column that calculates the number of days between these two dates called DaysElapsed. Now I would like to calculate the average of this column and store it in the footer section. First of...

What expression would I use to calculate the number of days between two days. Say one date field says 12/20/01 and the other says 1/20/02 and I want another field to display how many days are between these two date.

There is a field on a form that I would like to carry over onto another form. Let's see if I can explain this. The user opens the form and fills in all the date. Then I have another form (based off of a different table than the first form, both tables have the same field for the primary key)...

I have a field called AcceptReject that is a drop down menu with the choices A or R. When A is chosen I would like the comments form to open and todays date and the A to automatically fill into the comments field. If it is R I want the date and R to fill in. The first problem I have is that I...

I have placed code on the Unload event of a form to check if certain fields have data in them (once the user has started entering in data), if not the form will not close. However, I have realized that ctrl alt del, allows them to close the form with only half the data in it. This is causing...

I am trying to place a button on a form to preview a report, I want the report to open and display the same record that is in the form. Here is the code I used in the On_Click event of the button Dim stDocName As String Dim stLinkCriteria As String stDocName = "VIR Info Report"...

I am having trouble setting up the relationships in my database correctly and looking for any help that anyone can provide. Here are my tables (some tables have many fields so I will only list the primary key which is the only similary field in the tables, if you need more info just ask) Table...

The way my form is set up now, it is bases off a query that prompts the user for a SO Num. If the number exists the form opens displays the first record with that SO Num and they can flip through all other records with that number. If the SO Num does not exist the form opens blank and they can...

I have a form that data is entered in, a button is then pressed to accept the data and take the users to another form where they receive a number. When the users either press the button on the first form to accept the data and go to the other form, or press the close button on the second form...

I have a form where data is entered. Once a record is started I would not like the users to be able to close the form until all the required fields have data entered ( I have figured this part out with lots of help). The problem is, a user may open the form and then without entering any data...

There is something I have been trying to figure out for quite sometime that could solve several problems I am having with my database. My question is, Is there anyway to prevent a form from closing when the 'X' button is pressed. I have code on the Before_Update() event of the form that 1...