Recent content by Malkavian

Some people do not have the freedom to surf forums like others. I'm forced to use 97' without any patches or upgrades and as a result, I've learned my problem has no solution. Thanks Len for your help unlike some. - Malk

I'm stuck with using 97' and yes it is a number with the value of 0009500. - Malk

Is it possible for access to recognise "0009500" as a value? If so, how can this be done. - Malk

Private Sub Serialtxt_BeforeUpdate(Cancel As Integer) Dim i As Long Randomize ' Initialize random-number generator. i = Int((900000 + 1) * Rnd + 100000) Do While DCount("ID", "Check Requests", "ID = " & i) ' "Check Requests" is the table name. i = Int((900000) * Rnd + 100000) Loop SERIAL...

Thanks Len, I've sent it. Anyone else have any input on how to resolve this problem? - Malk

I've created a database on put it on a shared network drive. I have several people who will need to use this database but I dont want some of them to be able to edit the database in anyway. Ive tried creating individual user accounts for the database but I don't think I'm grasping how the...

Random because its a check number and im dealing with 30,000+ individual cases. How do I "seed" or format the field to a positive 6 digit number? And can the randomisation be done? - Malk

If I use an autogenerated field option... it creates numbers in excess of 6 digits and sometimes the value is negative. Id like to generate unique six digit numbers of a positive value. - Malk

I would like to create a form that generates a random 6 digit number when creating a new record and then use this number field as the primary key. Only thing is I'm not too good at the coding. Can anyone help me? - Malk

Actually it's weird but it accepted your original forumla for the date now... Thanks again. - Malk

Ok, I figure out why the date wasn't populating aswell.... Again i missed the name. All is well except it doesn't like "" as a result of a false reponse. It needs something. So I've "__/__/____" for now. Thank you sooo much Selena! If you figure out how to leave a blank entry for the date let...

Ok... i discovered one of the 5 boxes was labeled incorrectly which prevented the final box from checking. After correcting that, the final box now checks if in any sequence all 5 boxes are checked. However, it does not populate the date when all 5 boxes are checked and the final box is...

Ok I set it up but still whilst checking all 5 boxes, the final box does not check. I've attached the db so you can see. Change the ext to .ace to decompress. - Malk

What sub do I place this under? When under general declarations nothing happens. - Malk

If notecompck & mortcompck & asscompck & tpcompck & inscompck = true then filecompck = true. else filecompck = false. if filecompck = true then filecompdate = date else filecompdate = __/__/____ - Malk