okay..well if that works, how do i connect the textfield from the toolbar to this access? maybe in other words, where and how do i add some codes to the toolbar files?
From: "Shawn K. Hall" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: RE: [DQSD-Devel] adding options
Date: Sat, 15 Nov 2003 18:30:31 -0500
Hi Phoebe,
> I was wondering how to code if let's say I want to
> enter a text into the toolbar, and have it
> automatically open up a specific file in access
> database and use this text for the first text field
> of the application that is being opened up.
In Access create a Macro named "AutoExec" - this function will run
everytime your application starts. Add an event to it using "RunCode"
and set it to a vba function that does something like this:
'// ========================================================
' WARNING: Vaporcode
' This code was NEVER tested in the IDE.
' It was written directly into this email.
'// ========================================================
function StartupAndDoStuff()
sStartupParam = Command() & ""
If sStartupParam = "" Then
' do nothing
Else
' open the table/form and set the value for that field
' forms are easier to work with case you can do
' something like:
DoCmd.OpenForm "form1", acNormal
Forms!form1.field1.value = sStartupParam
End If
End Function
'// ========================================================
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
'// ========================================================
"There's nothing to explain. You're trying to kidnap
what I have rightfully stolen."
-- 'Vizzini', The Princess Bride
-------------------------------------------------------
This SF. Net email is sponsored by: GoToMyPC
GoToMyPC is the fast, easy and secure way to access your computer from
any Web browser or wireless device. Click here to Try it Free!
https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
_______________________________________________
DQSD-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/dqsd-devel
smart spam protection and 2 months FREE*
-------------------------------------------------------
This SF. Net email is sponsored by: GoToMyPC
GoToMyPC is the fast, easy and secure way to access your computer from
any Web browser or wireless device. Click here to Try it Free!
https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
_______________________________________________
DQSD-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/dqsd-devel
