Search results

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

Alright, I've attached the DB in zip format. :p Call me toll free 1-800-367-9305 x51850 I'll be in the office till 4pm EST. If you can fix this for me, I'll send you a check for your troubles. - Malk

Thanks selena for your help. I don't want you to hurry on my account. The 1st checkbox linked to the textbox we've been talking about will only have a true value if 5 other check boxes are marked as true. That would be my fail safe for this feature and could not undone unless they unchecked one...

Nvm about the blank part... I figured I'll just stick with "__/__/____" lol... My next challenge is to now link the checkbox from above with 4 other check boxes. So if 4 specific boxes are marked, the above box's value will become true and then populate the date in the textbox. :p - Malk

Ack you beat me... hehe i was editing my previous post. I figured out that "Date" would resolve the long version problem and it did. But if my checkbox is uncheck, i would like the textbox to display nothing (blank) if possible. Otherwise using the if function i guess i could have it just...

Thanks Selena, that makes sense. So I put this in as follows: Private Sub filecompck_Click() If filecompck = True Then filecomptxt = Now(0) Else End If End Sub I get an error back because of the "(0)" at the end of the NOW. So i remove it and run it again. This time it works. The date it...