Recent content by Carol

Its the way you have your report set up. Your company name should be positioned within a "Company" Group Header line. Your payment details, such as date and amount should be reflected within the detail section of the report. You can assign a "Company" Group Footer line, which will enable you...

This is what I got and I'm behind a firewall: d00d Also got the same health pop-up that Rich got.

Another solution would be to open up the Print Dialog Box through your print command button and manually select the printer. Of course, you would have to run this command twice, but it would save you from having 2 copies of the same report.

Just another thought....sometimes when I want to try some new code, I can crash my database. Unfortunately, erasing the code does not fix the database, because an internal record has been corrupted. The only solution I have found is to import all tables, queries, forms, reports, etc into a new...

Is there something unique about this query, a table, a field, a join. You state that it is okay running from the zipped file, but when you install, it crashes the program? Install the program and open up the query and run it while in design mode - does it still crash? If so, then rebuild the...

Open up the query in design view and open up the properties. Make sure that Run Permissions states "Users" and that Record Locks states "No Locks"

The above code should go on the report in the "On No Data" properties line. The code behind your button on your form should be something like this: Private Sub Report_Click() On Error GoTo Err_Report_Click Dim stDocName As String stDocName = "AbsenceInformationLog"...

Sorry, access does not allow for different orientations on the same report, nor does it allows for different orientations within a main/subreport. The only way around this is to use rotating text (addin), or the simplest method use a graphic program to make your front and back as a template...

Use the following and modify it to suit your report: Private Sub Report_NoData(Cancel As Integer) On Error GoTo Err_Report_NoData MsgBox "There are no absences for this employee for the year selected. Personnel Manager will cancel printing", vbInformation, "PRINTING" Cancel = True...

After entering in information in the main form and before moving to the subform, make sure that you save the data and requery before continuing on to a subform.

Open your subform in design datasheet view. Highlight the column that you want hidden. Go to the main toolbar and click on "Format" and then on "Hide Columns"

You need to set your references to Microsoft DAO 3.6 Object Library and use the Password format for an imput mask on your field txtpassword. Also removed an extra End If at the end of your code, no required. Here is a fixed zip file.

The best and easiest way to achieve this is to have a main form with 2 subforms in continuous view. Each subform, would have its query set to only select records 1 through 5 for the 1st subform, and then records 6 through 10 for the 2nd subform. Within each subforms footer, create an unbound...

Check the margins on your form and adjust accordingly (usually your right hand margin). The problem here is that your forms actual size, together with the margins are set to a size larger than the actual paper size, which causes a runoff after each record printed. [This message has been...

This message is correct, you are not appending data, but making a complete new table with the selected data. Each time you run this query, it will delete the table that it made previously and set up a new table with the name selected. If you don't want your users to see this message, then you...