Recent content by sdimaggio

Thanks

I'm sorry I do not know what a modal form is. Any help here is appreciated.

InputBox" is a built in access function. It is not a form I built. That's where my problem lies. Any thoughts?

I have a command button, that when clicked on a message box will pop up to enter a password. The problem is that you can see the password when you type it in front of someone. Is there a way to make the password display all asterisk rather than the password. Example: "ron" vs. " *** " Here...

exit sub Worked like a charm! Many Many thanks.

Yes, Me![BillingStatus] is the name of the control on the form.

I know the answer to this is easy, but I need a little help. I’m trying to get a form to close if a customer is on COD basis or they have an approval# that is inactive. My code is as follows embedded in an AfterUpdate event. Private Sub If Me![Approval#] = "Inactive" Then MsgBox "This...

still stumped?

I'm sorry! I did what you said. The help feature came up but I did not see anything of value to solve the problem.

Here is my printbutton code. I don't quite understand what you are asking. Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName As String stDocName = "rpt_PlantProfiles" DoCmd.Close acReport, stDocName stDocName = "rpt_PlantProfiles"...

there is a button on the form that opens a report which is based off of the query.

This works but my user may only want a certain number like 2000. If I place ">" before the where clause it will always be greater than and not an exact number. Any other thoughts. thanks steve

I have a query running off of a form. In the criteria section of my query I have the following code: [forms]![frm_PlantProfiles].[employees] I am trying to do a query of employees "greater than" 2000. When I place 2000 in the form field the query displays all the plants with 2000 employees...

I have a query running off of a form. In the criteria section of my query I have the following code: [forms]![frm_PlantProfiles].[employees] I am trying to do a query of employees "greater than" 2000. When I place 2000 in the form field the query displays all the plants with 2000 employees...

It worked. Thanks