Private Sub cmdOk_Click()
Dim count As Integer
If txtUsername = "businessmanager" Then
If txtpswd = "vddgna" Then
strUserName = txtUsername
Form_Startup.Visible = False
Form_Switchboard.Visible = True
Else...
ok i have it to where a form starts and the user enters a password which works fine however depending on the user i want to make certain forms read only and others dataentry.
i figured if i coded the first form to store the users name in a global variable and then do an if statement on the form...
ok i did the security wizard for ms access and it works on my computer however when it is on the network folder i can still access it but the other computer can not. Any ideas? and i'm trying to package the security workgroup file with the database and deploy it will this work on another computer?
i was wondering if there was anyway that i can make a database in access read only to one user when they enter in a user name programmatically. The reason being is that the database is not on a server but is emailed out to 3 people thus very small.
Ok i plan on developing a security workgroupfile for my project that i have created.....I was wondering if i would need to incorporate this file with the database when i zip it and send it to maybe 3 other people via email this way no other person can access thie file.
the table involved would be simple address info with a primary key which was generated from the old database that i converted from paradox.....the numbers run from 10004 to 13261 and i just need it to so that when the click add new record it increments the primary key by one ie the next record...
ok i need a way to to calculate a primary key value everytime you add a record starting from 13261. The reason being is that that is the last number in the database for primary keys and it was originally not an autonumber field. So far i think i have to do it on form level in the add record...
Ok i have 6 columns to where people can enter data for judges ie judge1 is jane doe judge2 is jim doe judge 3 is drew smith etc etc. I need a way to count the number of people in the record. I figured what i could do is do a loop and counter for the report open event but no such luck. Anyone...
see the thing is that would work but it throws in alot of unecessary information that i dont need to copy to the clipboard. which all i need is mailing information
I was wondering if anyone had any ideas on copying multiple items such as first name ,last name, state, address that were in a text box on the form level to the clipboard.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.