Recent content by JasonPurdueEE

Hi vcpaint, Are we talking about a database password (password on the database file itself - the one you set by going to Tools->Security->Set Db Password) or a user level security password issue? Jason ______________________________ Sleep is a poor substitute for coffee.

Hello everyone. I am trying to come up with the best way to make backups of my database. How do you back up your databases? Is there something better than manually copying and pasting the db files? I suspose I could come up with a way to run a batch file from code (using a shell command)...

Hey AceMan1, Thanks for your reply, you must have been typing it as I was replying to PHV and I missed it last night. Your method looks pretty slick. I have another form with a similar checkbox validation situation and will give your method a shot. Thanks again. Jason...

Thanks for the quick reply PHV! It worked like a charm! Just for future reference for others who might stumble upon this in search of the same thing, I had to change PHV's sample a tad, here's what I did: '************************** oneChecked = False For i = 1 To 41 If...

Hello everybody. I have a form with 41 different check boxes on it and want to verify that at least one has been "checked" before allowing a user to exit the form. I am having difficulty getting my for loop to work, perhaps somebody could provide some assistance or reccomend a better way of...

Thank you for your help Zathras! Here's what I ended up with: For i = 1 To 41 If Not Controls(&quot;chk&quot; & i) <> -1 Then MsgBox (&quot;chk&quot; & i) & &quot; is checked&quot; End If Next i ______________________________ Sleep is a poor substitute for coffee.

To clarify: I need the if statement in the loop to end up evaluating Me.chk1, Me.chk2....Me.chk41 the line of code I need help with is: If Not Me.chk&Counter <> -1 Then as it is, this doesnt run. what would be the proper syntax for the bolded part? Thanks. ______________________________...

Access 2K ______________________________ Sleep is a poor substitute for coffee.

Hello everybody. I have 41 check boxes (named chk1, chk2, chk3...chk41). I'm trying to use a do while loop to go through them all. I have the counter count up from 1 to 41 and I want to append the counter number to the end of the &quot;Me.chk&quot; part. Whats the correct syntax for the...

thanks mikevh, you're post helped me too! ______________________________ Sleep is a poor substitute for coffee.

Thank you Fancy Prairie for the quck reply. I have used the naming convention chk1, chk2,chk3... is there a really good benefit to using the function in your first post to generate the check boxes? I just created the fields in my table and then on my form selected all the fields from the...

Hello hongbin81. Yes there is a way. In your database, click Tools->Macro->Visual Basic Editor. Once in the Visual Basic Editor, click Tools->YOUR_DB_NAME_HERE Properties and choose the Protection tab. Click Lock project for viewing and set your password. Easy as that! Hope this helps...

Thank you FancyPrairie for your reply. What you posted looks a little more complicated than I think I have time to do (I'm on a pretty tight timeline for this little project). I think I will just use 42 yes/no fields. Unless you think that method will be too slow. Thanks again for your help...

Check out Jeremy Wallace's method, used by many (including me) -- it's by far the simplest to set up and maintain: http://www.abcdataworks.com Yes, I also use this method and it works very well. If you have questions about the batch file, let us know and we can try to help you along...

Good morning everybody! I need some advice on efficiency. My new databse is going to require the user to input data from a printed form. On the printed form there are, among other things, 42 check boxes. I need to be able to select one, many, or all of the check boxes. Would it be...