Search results for query: *

Hi, We need to print labels for customer that has a label number on it. I see how to use the on-print event of the detail section of the report (label) to get a number on the label that increments using the following code: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)...

We are using Citrix XenApp with Wyse Terminal using Program Neighborhood 10.00.52110. We have an Access database with reports that print to a label printer. These reports work fine for all users but one. For this one user, when she clicks the command button for the form to open, the screen...

Not sure if this is an Access problem; but hoped someone may have an insight. I have a report which is a label printing on a Zebra 140 XiIII Plus label printer. This report opens fine for all users but one. For her the screen just flashes like Access tried to open the report, but it does not...

The first If in this function works fine. The second If does not work. I know I'm doing something wrong. How does one correctly write W = LIKE " * "? Thanks !! Public Function rptWho() As String Dim w As String If Not IsNull(Forms!fNP_300a_REPORTS.Combo23) Then w =...

I have a dlookup that just is not right, I'm sure due to the quotes and single quotes not being just right. This is it: DLookup("LIST_NAME", "EMAIL_DIST_LIST", "RECEPIENTS Like " & fOSUserName & " & " * " ' AND LIST_NAME = 'ECN_ALL_OPERATION'") The List_Name and the RECEPIENTS fields are...

Hi Everyone, I have a table called EMAIL_DIST_LIST in which there are two fields, RECEPIENTS and LIST_NAME. I also have function FOSUSERNAME, that returns the logged on user. I want to write an If statement that tests if the name returned by the function FOSUSERNAME is in the RECEPIENTS field...

HI, I have an existing form with 5 tabs with 5 subforms. The form is related to the subforms in each case by a field called Prod_Id_No. This field is a key field in all the tables behind these forms and subforms. Tab 2 and 3 use the same table, NP_Part, as the record source. When I move off tab...

I have a form which has 4 tabs each with it's own subform. I change the value of a field on tab 3, then click on tab 4. On tab 4 there is a calculated field that is dependent on the value of the field on tab 3. But it order to see the updated value on the field in tab 4 I have to close the form...

I have a number of controls grouped together that I would like to control with vba; depending on username, I would like to control the grouped controls enabled and visible propery. But in Access 2002, the group does not appear to have a name to refer to it by. Is there a way to do what I want...

Hi Everyone, I have a form which has several text boxes where users can enter criteria for queries that are executed by clicking on command buttons. I would like to add some code that would clear out the entries made upon clicking the command button, so that they could start over with an empty...

The following code produces a type mismatch error when it calls the 5th line. The GET_RECIP function works fine in other forms, but in this form when it is followed by the "& AssignToEmail", a type mismatch occurs. If I comment out the "& AssignToEmail" it works fine. In a previous version of...

The first If line executes fine. The second, "ElseIf Me.AP1INITIALS Is Null Then" returns the error message. Any ideas why? Thanks!! Private Sub cmdApprove_1_Click() If Not Me.AP1Check Then MsgBox "Please check the Operations checkbox", vbSystemModal: Me.AP1Check.SetFocus: GoTo Incomplete...

Why does this "AP1Check.VALUE = -1" return a "type mismatch" error? It is part of an If statement. How do you test for the values of checkboxes? I've tried "on" and "yes" and "true" and get a variable undefined error. Thanks!!

Why does this work ok? ? DLookup("[LIST_NAME]", "[EMail_Dist_List]", "[RECEPIENTS]='" & fOSUserName & "'") But when this same line is in a function, it does not work: Public Function APGroup() APGroup = DLookup("[LIST_NAME]", "[EMail_Dist_List]", "[RECEPIENTS]='" & fOSUserName & "'") End...

Any ideas why this simple little procedure causes a run-time error 2465, Application-defined or object-defined error? I changed the name of the text box twice and recompiled. Private Sub txECN_NUMBER_Click() [Forms]![fNP_201a_LIST].txECN_NUMBER = Me.txECN_NUMBER End Sub Thanks !!

Does anyone know of a VBA routine that will loop through all the reports in a mdb and add an on open event? Thanks!!

Does anyone know of a VBA routine that will load on database open that will record the names of all reports as opened and increment a counter field in a table? I'm looking for code that does not need to be in each individual report. THANKS! PS: I apologize for posting this in the wrong forum...

Does anyone know of a VBA routine that will load on database open that will record the names of all reports opened and the number of times it was opened to a table? I'm looking for code that does not need to be in each individual report THANKS!

Is there a VBA routine which will count and store the number of times any report in the database is used? We have a slew of reports that were designed over the years and want to find out which ones we can ditch. Thanks!!

Hi All, I have a listbox, lstOP_History that is populated depending on which query is selected. I want to put a line of code that can detect if there are no records in the listbox as a result of the queries. I have tried " If me.lstOP_History.recordset Is Null, then" but I get a runtime...