Search results

I tried but i get a message for each. how do I get it to not return a message if the query was not called? If (Forms![2ndfrm_AddEditView]![CbCATracker1] = True) And DCount("*", "SearchCaTrackerCLUpdatedOn_Bt_qry") > 0 Then DoCmd.OpenQuery "SearchCaTrackerCLUpdatedOn_Bt_qry" Else...

I've seen multiple post of closing a query if it is blank. But my code checks to see if a check box is clicked then moves to the next box. If a check box has been clicked it opens a query. I'm trying to get it to close the query then return a msgbox if the query is blank. I get the first...

Thank you!!! I used a combination of both. Private Sub Edit_Click() If IsNull(Me.SearchVariance) Then MsgBox "Select something in the Combo Box" Me.SearchVariance.SetFocus Me.SearchVariance.Dropdown Exit Sub End If DoCmd.OpenForm "3rdfrm_AddEdit", acNormal...

I've updated the code to my form and combo box names but when I open the 2nd form it does not open on the correct record. Private Sub Edit_Click() If IsNull(Me.SearchVariance) Then MsgBox "Select something in the Combo Box" Me.SearchVariance.SetFocus...

Okay, how do I filter it base on the combo box? The text box on the other form is called, VarianceNumber. I tried: Private Sub Edit_Click() DoCmd.OpenForm "3rdfrm_AddEdit",acNormal,,,where "VarianceNumber" = me.SearchVariance,, DoCmd.Close acForm, "2ndfrm_AddEditView" End Sub But I got an...

On the second form there is another combo box that is used to filter records. So I would like to have the value of the combo box on form 1 passed the the combo box on form 2 when I click the button.

I have a combo box and a button on a form. I would like the go to the record selected in combo box on another form when the button is clicked. Also, the first form is closed when I click the button too. Private Sub Edit_Click() DoCmd.OpenForm "3rdfrm_AddEdit" DoCmd.GoToRecord , acNormal...

arnelgp's code works. When the user un-checks the checkbox the date is removed. Which is what I wanted. Thank you for your help!

I'm new access and I don't know what you mean by bound. The date and checkbox are from the same table but I don't want to have the date field on the form.

I'm trying to make a form checkbox update a the date in another table. Private Sub Delivered_AfterUpdate() If Delivered = -1 Then [tool implentation].[date] = Now() End Sub This is code I have but it does not work. What should I do? Thanks

I'm getting an error at the If Nz line

I have textbox on a form and after it has been updated I would like a check box on a subform to be clicked. I would like to do this in VBA but I can't get it to work. My code is below. Private Sub VarianceNumber_AfterUpdate() If (Me.VarianceNumber) = Not Null Then Forms![Drawing...

I'm building a database that contains error codes and the starting part number and the ending part numbers effected. The part numbers are continues, they go from 0 to 120. The number of parts is too large to include all of them in one table. So, I have a made a form that has a text box where...

each unique number has more than one vehicle assigned to it.

The first and last vehicle number given on the first table, but the numbers in between can be on either the first or on a 2nd table.

I have a table where the user enters a unique number/letter then they give vehicle numbers (in column b they write the smallest number. in column c they write the largest number). The vehicle numbers go from 1 to 300. So instead of user entering all the vehicles, they write the smallest and...

I'll have a button on a form which will run an update query and have them added to another table.

Micron, that is correct. I'm trying to "generate all the whole numbers between any 2 values that are provided. These missing numbers don't actually exist in any table."

Thank you. Maybe I'm missing something but the output only show the the first and second numbers not all the one in between. Below is my code: SELECT [abc Tracker def].VarianceNumber, [abc Tracker def].[SPH Start], [abc Tracker def].[SPH End] INTO AnotherTable FROM [abc Tracker def] WHERE...

I have an access form where the user enters two set of numbers, for example 63 and 120. On another table I need to have all the numbers >=63 and <=120 listed. How would I do this?