Recent content by scalextric59

Thank you @arnelgp . The report subreport width was a little bit off and that was the cause of my issue. Still bothers me that it worked with the other column layout, but now it is working fine.

I have a simple report that I have been using for some time. The report has 4 columns and was printing properly (16 records per page, 4 x 4) with the 'Down, then Across' column layout option. Now, I want to switch to 'Across, then Down' but the report prints only 1 column per page. Besides...

Try the OnFormat event. Add code to set the lower group top margin to zero and then make it invisible. I dont think the section will shrink. You will need to add logic to resize it.

I am confused. I have reports that produce charts in color. If I use a B&W printer the colors come out as a grayscale. If it is a color printer, it prints in color.

Try fixed-width fonts. If that does not work, I would print the old-fashioned way, something along this lines... this is just air code... intFreeFile = FreeFile() intPageCount=1 Open LPT1: For Output As #intFreeFile Do Until <recordsetname>.EOF Print #intFreeFile...

I don't have a dot-matrix either. However, you are grouping by 'invoice_no' but you are not forcing a page break. Setup the page length to the proper size (A4, letter...). On the Sorting anf Grouping set 'Group Footer' to Yes so it displays on the report design. Then click on the footer and set...

I have had issues with certain printers when the line Border Width property is set to Hairline. If that is the case, try increasing to 1pt

That is a different statement. The one provided by Freshman is if Environ("username") <> "administrator" or Environ("username") <> "manager" then and it will not work. In your statement you are using "=" so the OR operator works fine

The statement is still wrong. You need to use AND. The OR operator will only evaluate the first condition. If I log in as "manager" the form will close because it is different than "administrator", thus returning True.

Not too long ago, I had a similar issue. I inherited a form that needed to be updated. Everytime I tried to save my changes, I got an Access message stating that the changes could not be saved, Access froze, and had to kill the process. After doing things like recreating the form, convertint to...

This code will add a blank record. I guess you can code around to set the billing amounts SubFormControlName.SetFocus SubFormControlName.Form!FieldInSubform.SetFocus DoCmd.GoToRecord , , A_NEWREC

Thank you. I will check.

Is there any way of controlling a web cam from a MS-Access form? What I am trying to accomplish is to take a picture and save it (preferably as .TIF) outside the database. The form would have a control to view the feed from the camera, and a command button that would be the trigger. I have...

Cwittmaack, I don't know if you already figured it out. You are being asked for the dealer number because the subreport is not set properly. Go to the main report, click the border of the subreport and bring the properties window. Setup the Link Child and Link Master fields (dlrnum).

Okay, I am reposting yor DB since I made a mistake on the subreport and that was the reason it was not printing. The subreport calculates the total to date (any date before or on the date entered) and it is linked to the main report by "dlrnum". The subreport has two fields that are not visible...