Search results

Yes, Thanks a lot

Done. Here it is Private Sub Command30_Click() On Error GoTo Err_Command30_Click Dim stDocName As String stDocName = "YTD Totals" DoCmd.OpenReport stDocName, acNormal Exit_Command30_Click: Exit Sub Err_Command30_Click: MsgBox Err.Description Resume...

The Macro just has 3 statements, SetWarnings, OpenReport, SetWarnings. I was told to just a macro with SetWarnings to suppress any warning messages. I could have just used a Print Report command button

Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim stDocName As String stDocName = "Print YTD Totals" DoCmd.RunMacro stDocName Exit_Command27_Click: Exit Sub Err_Command27_Click: MsgBox Err.Description Resume Exit_Command27_Click End Sub

Sorry, can you give me a play by play, I am not too familiar with ACCESS

Yes, but when I get en empty set, there is nothing in the Text Box. Although, the result set is empty, I want to still have a Report Heading containing the selection criteria, "This Report is for the year "2007", if 2007 was the selection criteria chosen. It would also be good to create another...

I do not really know what you are asking. I am just geeting what was in the Combo Box in the Entry Form. =Forms!frmYTDTotalsandComparisions!CYear

I have to save the entries in the Combo Box, in order to use them in the reset set Form and Report. For example: I choose the year 2007 in the Combo Box, the Query will search all records for the year 2007. The Form and Report headers will read 'This are the records found for the year "2007"...

I have a Form with a Combo Box. I use the entry data from the Combo Box for the criteria in a Query. I also use the Entry fron the Combo Box as a Title Text Box in the result set Form and in a Report. Example: the Year 2007 is chosen in the Combo Box and I want to include the Year 2007 in my...

I get it. One question, after I created the unmatched query, I looked at the Design View and it puts IsNull for that one field I chose. If my key is five fields can I put them in the query and make the Criteria on those IsNull also?

append query I am running the unmatched query now, it will probably run awhile. After it finishes, how will I select those umatched records to append to the table?

append Yes, I do want to append the records from PROD to TEST, not in TEST. I have created an Append query, but how will it know to append the records not in TEST. :confused:

I have a Prod Table and a TEST Table, both are defined the same; same design, same key. They both have most of the same data records, except the Prod has more. I want to link both tables and update the TEST with the records in the Prod that are not in TEST.:confused:

ComboBox Yes, the example has 0";0.7875" in the Column Widths. I copied this to my combobox and now displays blanks. What does Column Widths do?

I have a form where I mimic the filter_combobox.mdb. I have created the comboboxes, rowsource queries and afterupdate event just like the filter_comboBox.mdb example. However, when I click on the comboboxes, the display the AutoNumbers instead of the Store or Managers. What am I doing wrong...

Thanks This really helped. :)

? Anyone ............Anyone ...................................

I am trying to Hide the Database Window by unchecking the Display DataBase Window in the Startup, but the first macro with a MoveSize fails with a Condition: True, Action Name: Movesize and Arguments: 14400, 14400, 7200, 14400. I have also used Code to Hide it and get the same error. "There was...

Do I split the mdb first then create the mde from the fe, or create the mde then split it?

Works Great, Thanks This is exactly what I needed. :)