Search results for query: *

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

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

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

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

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

I have a print dialog form named "frm_print" it produces a report when I click a button. I am trying to get the form "frm_print" to minimize after the report opens since it stays on top of the report when it opens and gets in the way. What is the code that I need to put...

How can I delete all the tables in a database at one time? thanks in advance.

I created a database and used the built in security. I have a front end database which is application file (it is unprotected) I also created a backend file which contains the data only. (it is NOT protected) Access created a "Secured.mdw" file. And an access exe file to open the...

I have a form with an underlying query with many fields, I am trying to figure out a way to either requery or filter across all the fields as a search tool. I built a text box to enter the text and have it fire on an after update event. I am using the following code. Set qdf =...

I found some coding in another version of Access. I coverted it to ms2000. when I imported the files and try to run the code, I get an error message which is: compiled error: user defined type not defined. in the following code "dbs As Database" is highlighted. Private Sub...

I have a front end (application) and back end (data) data base which is secured. The back end is not password protected. the front end is protected with the built in security. I have the secured Microsoft Access Information file which was created when I initially passworded the application...

I have a button on a print dialog form which previews or prints reports. The code on the "printbutton" is OnClick event. Private Sub printbutton_Click() Dim ReportName, DateFieldName Select Case Me.PickReport Case 1 ReportName =...

I need a little help here. I put the following code on my main switchboard under the "on timer" event, "timer interval" = 60000. This part works fine. However notice the last part of the code. what i am trying to do is that if a user has not been active for 1 minute...

I have major problems. I have a split database. The data is in "CompanyData.mdb" The application files are in "Applications.mdb" with the data linked into it. The data base is secured. When I go to open the "Applications.mdb", I get the following error...

I have major problems. I have a split database. The data is in "CompanyData.mdb" The application files are in "Applications.mdb" with the data linked into it. The data base is secured. When I go to open the "Applications.mdb", I get the following error...

This message is occuring when I try to send an excel file as an email attachment when I am viewing a report. I created a group call &quot;SalesRep&quot; and gave it certain permissions. When I create a &quot;Delivery Report&quot; and then click my right mouse button and choose < send to > then...

This message is occuring when I try to send an excel file as an email attachment when I am viewing a report. I created a group call &quot;SalesRep&quot; and gave it certain permissions. When I create a &quot;Delivery Report&quot; and then click my right mouse button and choose < send to > then...

I want to filter a query which is the record source of a form when it opens. I want to filter the data based on sales rep so the salesman can only see their data when the form comes up. here is my code. it does not work. Private Sub Form_Open(Cancel As Integer) Me.AllowFilters = True...