Search results

Validation Dim intSearch As Integer, varX As Variant intSearch = 1 varX = DLookup("[CompanyName]", "Shippers", _ "[ShipperID] = '" & Me.YourTextBox & "'") If varX > 2 Then MsgBox("Too many") Me.YourTextBox = "" End If Is CompanyName a field? I am assuming Shippers is the table name...

Validation What code do I put in the BeforeUpdate event and the Dlookup function. I want the option of assigning a person up to two serial number s but no more.

Is there a way to let the user know that the data already exists if they are entering data into text boxes?I want only one record of each person in the db.

Rich Got it fixed. If you put it in the correct field it usually works The field will have a dorm room if the student is here, but has clear when they leave.

I have a field titled Dorm_Plan. When a student leaves it says clear for them in the field. I am trying to display the students that are currently here. I have used Not"Clear" in the criteria for this field, no luck. Is there something better to put that would work. I want to display everything...

Control Name Jack: There is no control in the subform that performs a update query! The control is located on the main form. The control that performs the update query is named: cmdDeleteCadets Here is the code. Based on what I have said above can you tell me the location of the code...

Jack: The mainform name: XXXXX The subform name: TrialCadetAdd Mainform control commandbutton name:cmdDeleteCadets The command button is located in the main form and performs the update query on the subform. Here is the code I have for the command button: Private Sub cmdDeleteCadets_Click()...

I have a command button that performs an update query on a table in a subform. When you click the command button and check the table that is being deleted, it works just fine. The subform still shows the data in it that was deleted in the query. Is there a way to refresh the form to show that...

Text box Validation I have two forms that are subforms within a main form. In the subforms there are text boxes that can be filled out to add data. I wanted to make the fields that need info to let the user know if they were not filled completely out. This would be when the user moves from one...

Hide/Unhide Can I do this so if you click on the command button the form disappears and if you click on it again it appears? Private Sub CmdHide_Click() Forms!XXXXX!TrialCadetAdd.Visible = False Forms!XXXXX!TrialCadetAdd.Visible = True End Sub

Hide/Unhide Here is the code in the command button I used. Private Sub CmdHide_Click() Forms!XXXXX!TrialCadetAdd.Visible = False End Sub MainForm XXXXX SubForm TrialCadetAdd I get an error stating that It could not find the expression Trial Cadet Add I changed the subform name as a...

I would like to hide and unhide a subform with the click of a command button. Can I create command button thru a wizard and change the code to do this? me.hide.subform name me.unhide.subform name

Validation Code Do you start out with Private sub ??() Validation Code End Sub How do you start the private sub? As for queries It is listed un Lamb2087 in the query section.

Query question Faceman I have a query question, are you good with append queries?

I want to be able to type in a text box a serial number and have in another text box a slot number auto fill. Then I want to type in an id number that will auto fill a students name and housing. I want these to be added to each other in a table.So that a particular student_id and name wiil have...

I need to rethink my query R U pretty good with queries?

Validation Sean Thanks i'll give it a try

Subquery I tried the subquery with no luck as far as adding new records.

I get this error when I try to add a record.: Can not add record(s); Primary key for table_name not in recordset I put the primary key in the query but it did not solve the problem.

When you advance the record selector to a new record and only enter text in one text box rather than five is there a way to have a message bax come up and say you need to enter text in all text boxes?