Search results

thats works great thanks

Private Sub Useful_Websites_Click() On Error GoTo Err_Useful_Websites_Click Dim stDocName As String DoCmd.Close stDocName = "Websites" DoCmd.RunMacro stDocName Exit_Useful_Websites_Click: Exit Sub Err_Useful_Websites_Click: MsgBox Err.Description Resume...

hi i have a button opening forms however when they open they appear in window mode and not full screen. is there an option or a line of code of code i am over looking to make it open in full screen mode? thanks michael ps. i am using access 2010

that worked great thanks for the help

hi thanks for the help guys im now using a different form with the password imput mask and its working great. however is there anyway i can make the password case sensitive? the code i am using is Private Sub Submit_Click() On Error GoTo Err_Submit_Click If Password = "open" Then...

where is that?

hi all, i am currently using Private Sub Form_Open(Cancel As Integer) Const cstrPassWord As String = "open" Dim strPassWord As String strPassWord = InputBox("Password:") If Not strPassWord = cstrPassWord Then Cancel = True End If End Sub to password protect a...

that works great thanks. it didnt have to be that secure as the database is already password protected. it just needed a simple method to keep it slightly more secure.

hi all, i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up. if it is possible how would i go about doing...

no i didnt think it was possible just wanted to double check thanks for the help tho

this is just for my testing however the user will be running it from a form

hi all, i have created a query with the parameter for the Domain field. however on the form the user enters this information via a drop down menu. i was just wondering could the parameter box be set to a drop down box as well to save the user entering in the full Domain field name? thanks for...

ok glad u figured away around it :)

could u upload the spreadsheet you are trying to create the database from, or at least a screenshot. also could u explain what the database has to search for as it is unclear in the previous post

them tabs was a brilliant idea. they are working great :)

thanks once again. i appreciate your time and patients with me :)

how do you insert/merge a subform into the tabs?

thanks for all your help

yeah sorry that was a typo. how would i go about creating the tabs? as that would be really useful. thanks

what do you mean seperate tags?