Search results

I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?

Error: Run-Time Error 2450 Microsoft office access cant find the form ACAudio referred to in a macro expression or visual basic code

I am not sure but this how it should work in VB, I am trying to disable a button that exists on a different form: ACAudio!Command89.Enabled = False Where ACAudio is the name of the form and Command89 is the name of the button but I keep getting an error saying object required.

Enable/Disable table or form? After setting both accounts if user is accessing the database then I want to disable him from editing or adding a new record sth like this Form(name).enable = false and if the user is admin then he can edit and add records Form(name).enable = true, is that...

Got it fixed thanks Bat17.

this is what I got: invalid operation rs.MoveFirst

The strSql string should find the record that I have already saved in my admin table and then compare it with combusername, where is my mistake. Private Sub Command7_Click() 'Dim db As Database Dim strSql As String 'Set db = CurrentDb() strSql = "Select adminpass From admin" If...

yeah that works, What I have done is adding this sub on my form load: Private Sub Form_Load() combusername = "" txtpassword = "" combusername.SetFocus End Sub Is this a good method to implement or not? Thanks.

Update if I click on my clear button combusername = "" txtpassword = "" combusername.SetFocus Then click on my Enter button then the msg comes out!! Having an empty box is not equal to ""?

Thanks Uncle Gizmo but what I meant by the path is that lets say the file (split) is located in folder1 then after the splitting both files (split and split_be) will be in folder1, if I move both files into a subfolder folder2 and if I open the file (split) it wont work it will still remember...

Can anyone tell me whats wrong with this code, its not working for me!! If ((txtpassword = "") Or (combusername = "")) Then MsgBox "Please Enter A Valid Access", vbOKOnly, "Error" End If

I have read the pros and cons of splitting the database, after splitting the database, what happens If I have to move the folder that both files are located in, I have tried moving both files and I get and error saying that ....file cannot be found, what If we decide to move the folder location...

no I havent done that, do I have to do it?

I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access: 1. 3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my...

Thanks Len Boorman i will make my search and I'll be back soon if you get anything please post it here. Regards.

Thanks Len Boorman, I think number 3 is more suited for me, I will be uploading the main database on the server and I will link 3 computers through mapping the file. Can you tell me where I can find more information on that part so I can get it done?

When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit. I would appreciate your comments and...

Thanks WayneRyan. I have used the below function to enter data and it works fine, however I am trying to make it more user friendly, what I want is that the user will type the new data in the comb Box and he will have to click on button to add it if the new data not is the list a msg will popup...

Lets say that I have four combo Boxes on my form ’A’ I need to create another form ’B’ that will give the admin the permission to add or remove from these combo Boxes their values, do I need to create another form and simply add 4 combo Boxes and connect them to their source? What about the add...

Thanks Jon its Fixed now.