Search results

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...

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...

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...

Hi. I've got a little problem with the unbound controls on continuous form. In form header user inputs his name, temperature, humidity, and number of tools used (drum, belt). Then on forms main "body" he only inputs the serial number to the first field and the rest is field automatically. The...

Hi. I've got a table "table1" with field Serial_no and model (among others). the serial number of the product has a following format: A9BC1234567 - Month,Year,Factory,Model and 6 digits. when i input the serial number on the form (field "Serial_no") i want access to recognize the string...

hi. how can i increment a value (number) in a text box placed in a form header every time i input a value into a field on form detail section? in form header is text box "count" in form detail is tex box "SN" after i input value into "SN" i want to value in "count" to go up by 1 i guessing...

Hi. I'm trying to display result of a query in a textbox on a form and I'm hitting a wall. I've got 2 tables - Test & Tracker joined 1-to-1 on SerialNo and SN. table Test already has values inputed for field SerialNo and Tracker. On the form (working on Tracker table) after inputing the serial...

Here's a nice one for ya ;) My database has a main table and a linked table from a different database. My table, among others has the fields Serial_No and Tracker_No, linked table has the fields Serial_Is and Tracker_Is (among others of course but those are the ones that interest me). Table are...

I've got the following problem. In table I got the hyperlink type field which values are pointing to images on hard drive. When creating data access page i want for that image to open on the page or at least show a working hyperlink because for now even that the table field is a hyperlink access...

So here's the problem. On the form I'm scanning in a product serial number from the box. The same serial number is on the product itself. What I need is when I scan the first number, for some pop up box to appear where I'm scanning the number form product. If they don't match I get a message...