Search results

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

just a counter for the current session, it's not bound. and i want to to increment only when it's being populated for the first time

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

Everything works fine. I've just missed an apostrophe in the line when I define criteria:)

Well, i did change it but know i'm getting different problem. A message is saying: Run-time error '3077': Syntax erros in string in expression and the same line of code is being highlighted

I'm getting a message saying Run-time Error '424' Object recquired and in the code editor line .FindFirst Criteria gets highligted in yellow

Ok, in real life situation looks like that. During final inspection of a product I'm scanning in the serial number, and ticking check boxes confirming visual, functional and printout inspection. That's my database. Now, the production has their own database that monitors every single product...

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

I've found something like this on the net, might work: When the Microsoft Visual Basic window appears, you can create a new function to retrieve the value from the table. In our example, we're going to create a function called GetGST that retrieves the GST field from a table called GST...

Could I hope for some kind of example code for that. I'm reeeeeallllly crap when it comes to "code writing" programming (shame on me:()

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

Problem solved ;)

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

Were talking quality control:). To check if the monkeys on the production line didn't put the wrong thing in the wrong box. Problem is that the numbers are quite long and have small font. Thats why I'm looking for double checking using barcode scanners. And database is to keep track what...

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