User Profile

trevor glover · Mar 25 '08, 12:29 PM

Hi Martin,

On the Toolbox toolbar (in the form you are using), use the Command button wizard, as you navigate through it you have an option to go to a specific record, which you can use both ID criterias to apply a filter.

Hope this helps you.

Trevor

trevor glover · Mar 25 '08, 12:26 PM

Jim,

What you can do is create a new database and then import all the objects via the Table and New Option, select Import and the wizard will ask you to select the database (Passworded one) and then import all the objects from there.

Hope it works for you.

Trevor

trevor glover · Mar 1 '08, 02:23 PM

Matt it sounds as though you need the Database in a Shared Folder, someone having Administration rights and others just shared permissions. If this doesn't help then within the form you can set commands on the On Open Events to do something like this:

cmdButton1.Enab led=True
cmdButton2.Enab led=True

etc

This can be done on the form itself as it opens.

Enjoy...

trevor glover · Mar 1 '08, 02:16 PM

You want to set a password behind a button on a form and set it to the Event on Click. Something like this:

Code:

dim strPassword as string
strPassword = "Password Goes here"
if inputbox("Enter the Password","Access Password")=strPassword then
docmd.openform"Form name here"
Else
Msgbox"The Password is incorrect please try again"
Exit Sub
End If

...

trevor glover · Feb 24 '08, 10:11 AM

Hi what you need to do in your dim statement is specify the sheet name as follows:

Code:

dim wkbk as excel.application
set wkbk = createobject("excel.application")
with wkbk
.visible=true
.workbook.open ("The path and name of the workbook")
.sheets("The name of the sheet to activate").select

end with

Enjoy

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Image Update on Multiple Access Reports Via a command button on a From