Search results

Can anyone help me out.

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...

No need to worry ,Iv sorted it out now

Is there a way to print a report for only the form you are on. Let say Iv got a list of customers on a form and I have a query for all the customers.

Thanks for the help it works with <>"admin"

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 done queries before but I have never been able to not show a record on the query. in this case a admin record

what would I need to write in the criteria box, I have never done anything like that before

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 + "'))")

I need to print out my VBA code , I was wondering if there is an easier way to do it without cutting and pasting it onto Microsoft word.

Thanks you for your help, you truly are a master

That does not seem to be the problem. When I try to add a new record from a different form it works correctly. only it doesnt work from the main form.

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

Thank you again for the help

Is there a way to keep the main form locked until I click on the edit button. So basically the button controls the main form and subform

Thank you for your help

Can someone help me out. If someone could get the buttons on the right to work with the sub form would help me a lot. I have included the part which Im finding difficult

So basically I have to code this on the main form for the edit button Private Sub cmdEdit_Click() AllowEdits = True Me.subfrmName.Form.AllowEdits = True End Sub but for some reason it does not work