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)) + "-" +...

The time event did work! Thanks every one for help. Paul.. We are still om win 95 and hope to get update on your suggestion! I can try it only after update is complete! But thanks for a very practical soln. :)

Now it works!Can I print a report ONCE in 24 HRS? I tried to set time interval, but it prints more often than necessary! Thanks for your suggestions!

Thanks a lot I tried "On timer" but did not work as desired. The event is as follows If Time > TimeSerial(10, 0, 0) Then Print GCLog Me.Timer = 10000 End If Thanks

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 :)

Fizzio I have tried that earlier. The problem(s) : 1) the specimen no in Specimen table is a text field and 2) H or P number as you suggested are Autonumbers hence referential/Cascade can not be established and hence the sectional fields are not automatically updated. This is how I am selecting...

Fizzio Thanks You are right!Each section has it's own table and I have 1:1 relationship between two tables on Specimen number, which is copied through referential integrity and cascade update related records.

Fizzio Thanks for your reply. The "specimen number" is an autonumber field, which indicates any sample in rcd in the lab. the format is e.g.01-000001. Each section needs additonal serial number representing sample number in that section. Hence sample no. 01-000030 could be H-0001 in Hepatitis...

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

Sorry for being late...Does not work on computers every day! A1 A2 are NOT in the table.These are the location of sample on the instrument. Only names will be in the table. Thanks

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

Thanks for your suggestion and it worked very well. Sorry for late reply,was away from desk for few days.

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

I tried as you have suggested, however the forms open for any ZIP code.Any suggestion? Thanks for your time and suggestion.

Thank you very much. I will post the progress.

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