Search results for query: *

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

To open a report using a button on a form i use the following code: Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName As String stDocName = "rpt_PlantProfiles" DoCmd.OpenReport stDocName, acPreview Exit_Command47_Click: Exit Sub...

That did it! thanks

I have a report that has a date column. I want to pick the last date out of the column and subtract it by a different date to figure out the number of days. example: Arrival Date: 9/25/04 Delivery Date 10/1/04 10/15/04 10/30/04 What I want is as follows: 10/30/04 - 9/25/04 = 36 days I'm...

here's my problem. I've created a query that displays all the results I want. When I run the query, it displays the name of the "carrier" on the screen. However, when I create a pivot table linked to excel and my query, instead of the name of the "carrier" I get the...

thanks I'll give it a try