Search results

I am generating a record number for each record with an expression as follows Dim numZero As Integer Dim strZero As String numZero = 6 - Len(CStr(Me![Autonumber].Value)) strZero = String(numZero, "00001") Me![Specimen Number].Value = str(Right(Year(DATE), 2)) + "-" +...

I am generating a record number for each record with an expression as follows Dim numZero As Integer Dim strZero As String numZero = 6 - Len(CStr(Me![Autonumber].Value)) strZero = String(numZero, "00001") Me![Specimen Number].Value = CStr(Right(Year(DATE), 2)) + "-" +...

I would like print a report AT SET TIME e.g.10:00, 12:00 and 16:30 Is there any suggestions to print a report Automatically? Thanks for help :)

Thanks in Advance for the solution! The database in question is for a medical laboratory, which has six different sections.The specimen entry is planned through this database. In the Data entry form, a specimen number is generated automatically. However, each section of the lab wants their...

Thanks in Advance for the solution! The database in question is for a medical laboratory. While main form is entered, a specimen number is generated automatically. However, each section of the lab wants their own serial number.I have tried this as follows Please note, I am not a Computer...

Hi! I am generating a work-sheet for samples to be tested on a particular date. The sample number and patient name is pulled from table. The technologist wants the work-sheet to be grouped in sections of five records each, starting as A1 through A5 , then B1 through B5 and so on. Any...

I would like to enter data as "Batch" e.g. for record number 102 to 148, enter "NO". Thanks for help.

I have added a Macro which will open a sub form, address 2 when ZIP code = 400062. However the Macro opens on all ZIP codes. Macro has following properties: Form Name: address 2 View: Form Filter name: Where Condition: [ZIP code]= "400062" Data Mode: Add Window Mode: Normal I will appreciate...