Hello can someone help me.
I would like to set up an excel spread sheet which when loaded only displays the first sheet.
i would then like to give a tick box to the person.
For example
Do you study maths (yes tick box)
Do you study French (yes tick box)
if yes is selected I would like it to...
I was wondering if there is a way to hide 1 record from a query
say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed
Iv got a user table with an admin record and head teacher record with the highest access level
I then have 2 teacher records with a lower access level
The admin and headmaster have access to the whole system this includes assigning user name and passwords. However I don't want the head master...
Can someone explain what the following code does.Thanks in advance
Set dbUser = DBEngine.Workspaces(0).Databases(0)
Set rsUser = dbUser.OpenRecordset("SELECT User.UserName FROM [User]WHERE (((User.UserName)='" + txtUserName + "'))")
Iv used wizard to to create a new record.
When I click on the new record button the form is suppose to come up with empty fields but instead class sub form come up blank.
Iv included the database for you to see the problem
I encountered another problem. I added a new button to the main form ,however when I click on new button the sub form come up blank.
I was wondering if you could help with this thanks again.
BTW what does me stand for in Me.AllowEdits