Search results for query: *

Hey Everyone: Below is a code I created (thanks to many Threads here on Tek-Tips) but get the Error Code 400 if I run this macro when I am in a different worksheet than "Master". I would like to create a button that is assigned to this macro but can't because of the Error Code. Not sure how to...

Thanks Skip Will try this and let you know.

Hey Skip, I've never used a UNION query. How do you go about creating one? Is there a site I can read about them? DMO

Hey Everyone: I need to create a pivot table that uses information from 3 different worksheets. The pivot table is a Year-to-date Financial report. I am using Excel 2002 and tried to use the Pivot Table Wizard's "Multiple Consolidation Range" function. A complete bust. The 3 worksheets all...

Rob and PHV: Success thanks to both of you. It works perfectly. Below is the code. Only thing I added was putting the report field name that the criteria was based on in the Select Case statement. Thanks again. DMO Select Case Me.Parameters Case "Range" strCriteria =...

Rob: thanks for the help. I took out the Where clause in my SQL statement (the only change in the code) and now am getting the message "A RunSQL requires an arguement consisting of an SQL statement." Can I still use my select case statement in the Filter area of the Report properties? And do...

Hey Everyone: I am trying to create a form where the person can choose the type of parameter (Equal To, Range, Less Than, etc.) to use for a report and thought VBA would be best. Here is my code to choose the parameter and then run the report: Dim stDocName As String, strCriteria As String...

kjv1611: Two of the subforms have Form_unload in their code to close a calendar form if it is still open. Private Sub Form_Unload(Cancel As Integer) 'this is required in case user Closes Form with the 'Calendar still open. It also handles when the 'user closes the application with the Calendar...

kjv1611: I have code in Form_Close but this was happening before I even put the below code in. I usually get a detail report of what happened, do you want me to post that report? thanks. DMO Private Sub Form_Close() Dim strappendClient strappendClient = "INSERT INTO tblGeneralList (...

kjv1611: Here is the code. Private Sub closeclientinfo_Click() On Error GoTo Err_closeclientinfo_Click DoCmd.Close Exit_closeclientinfo_Click: Exit Sub Err_closeclientinfo_Click: MsgBox Err.Description Resume Exit_closeclientinfo_Click End Sub DMO

Hey Everyone: I have a form that has 4 tabs with subforms on them. In my form header I have a command button to close out the main form(used the wizard). My problem is when I push the button to close the form the program crashes and Access shuts down. I believe it might be the subforms...

Skip: Thanks for the info and the help. Would i do this after selecting the rows? What does SELECT CASE do? DMO

Skip, This is for an offline financial spreadsheet to track items that were rebilled to customers who took unauthorized credits. We need to have the spreadsheet show the originally credit taken on one row and then any payments that apply against it on another row. The payment row has to have...

Hey everyone: I am trying to create a command button assigned to a macro. I would like the macro to copy the selected rows (range) and copy. Then within the selection change the content for specific columns. In one column I want to change the text from "Rebilled" to "Paid" and in another...

Hey Everyone: I have a form that has 4 tabs with subforms on them. In my form header I have a command button to close out the main form(used the wizard). My problem is when I push the button to close the form the program crashes and Access shuts down. I believe it might be the subforms...

Originally I created a form with multiple subforms that were connected by the client's social security number. The connection between the form/subforms worked well and the SSN number would flow to each subform when I inputted into the main form. (Example: When I created a new record and typed...

Randy: thanks for the idea, unfortunately I tried this and it didn't work. DMO

I am trying to run 2 append queries and concatenate two of the fields, (Last Name and First Name to create Full Name). The code runs fine except the space after the comma between the last name and first name does not show up even though it is in the code. Very confused since the comma shows up...

PH: That did it. Thanks. DMO

I have a form that is bound to a table (tblConcierge) and there are two combo boxes (both unbound). The second combo box (cboFull_Name) is based on what is selected in the first combo box (cboType). The lists of the two combo boxes are in two different tables. I've read a number of threads and...