Recent content by psuplat

That will be problematic due to the size of the file. It is a massive one with over 80MB. Any other way of doing it?

Here is the code launch by the onClick event of a button: Private Sub Command196_Click() Dim x As Integer Dim rpt As Report ' Colour constants. Amend as required Const PINK_COLOUR = 16751103 Const GREEN_COLOUR = 65280 Const YELLOW_COLOUR = 65535 Const GREY_COLOUR =...

rpt.Print didn't work. When I use DoCmd.PrintOut the printer spits out 4 copies alright but all of them are of pink color version. It seems like the switching doesn't work

I'm getting compile error "Argument not optional" and .Print gets highlighted

The code is as below DoCmd.SelectObject acReport, "NewReport", True DoCmd.PrintOut acPrintAll, , , , 4 is is set to a button onClick event. but all this does is prints 4 copies without any alterations

Yes it is, but I could just as well change it to a text box with color background. I have a piece of VB code somewhere that will spit out 4 copies of report.

Hi all, Not sure if this is possible to do but.. I have an access db from which I print a report, but I am using a dot matrix printer that print on special paper giving me 4 copies on pink, green, yellow and white paper. I need to move this report from dot matrix printer to normal printer...

Hi everyone, not sure if what I want can actually be achieved but here goes, i have a db system used on a fast production line, that works of linked tables located somewhere on the network. What I was thinking to do is something that keeps the system working even if the network goes down. Let...

Hi everyone:) I have a simple form conencted to table that displays the suppliers. The records are being sorted alphabeticaly by the company's name. What I would like to achieve is create an A to Z "letter bar" on top of the form. When user click i.e. "S" it takes him to first record where...

Tried it, but still doesn't work. But I managet to find a solution. It was actually simpler than i though it would be. I just add the following code in the reports detail OnFormat event: If Me.checkNIU= False Then Me.lblNIU.Visible = False End If Anyway thanks, willingness to help always...

I'm using access 2003, and looks like i cannot apply conditional formating to labels. If i select label and go to menu format, that function is disabled :(

Hi. On the report i have a checkbox bounded to table field named "disc", the checkbox is hidden. Also I have a label called "lblDisc", also hidden by default. What I want is when the box is ticked, I want the lblDisc visibility value set to true. Or, other way of doing it, lblDisc is visible...

I've been trying that one. but still got few problems. on it's own in a simple form this works, but my form is a bit complicated. the whole thing includes to tables: substances and pictures table pictures has fields "picID" and "path" table substance includes, among other fields, hazard1...

Hi everyone. I'm having a problem with a database design, and don't know how to bite it:mad:. I need to design a COSHH database. Everything goes nice and smooth until the point of pictures. Every substance that is on db will have to assigned pictures representing symbols of hazard or ppe...

Hi. I've got a textbox on form with input mask \T\M\CL0\C\H000000LAA0000 which access is automatically redoing to "TMC"L0"CH"000000LAA0000 i've got 2 problems with this. when i scan the number from a barcode: 1. the 4th characted should be any letter required - but it always puts in K...