Search results

Found A Solution using Dmax, went along the lines of: - Me.Card_Start = Nz(DMax("Card_End", "Card_List", "Facility_Id = Combo17.value"), 0) + 1 Thanks

Thanks for the pointer, do you happen to remember the demo for the range problem so I may have a look, I tried searching but to no avail.

Thanks for the quick reply, I kind of realized that I could not reference the previous row as in a spreadsheet this is as you say where I am getting stuck Lol. As to the recording of cards I only need to record or "calculate" the number range and not the individual card numbers. i.e the next...

Hi Folks I am in the process of starting to make a small database to record orders for door access cards. easy so far, however I need to record the number required as well as the number range start and end. i.e. 200 cards starting 1 - 200. Next batch would be 201 - + Quantity. I have tried...

I think we should have black and white radio. :D

Small database in access 2007 for tracking calibration data for test equipment, also used for verification logging thermometers. It may be of some use to someone either to use edit or laugh at.:)

Did you hear about the Dyslexic pimp, He bought a Warehouse.:confused:

Thanks that did the trick after I finally worked out how to use alias names.;)

I have used barcodes with our pat testing equipment and i found that it would not format correctly if there were spaces between words. also check that it has the control characters at start and end of barcode.

Forms And Reports Using data from a single table Hi Folks Dont really know where to put this, so please move if inappropriate. I have a small database I am building to log and record Calibration Details Of thermometers etc. I have several table that are related, no probs so far. However I...

Hi folks Quite new to Access, been trying to build a few small databases for recording and logging calibration etc. been stuck a few times so I dropped in here. I have already got a few pointers from here as I am new to VBA. Cheers :D