Search results for query: *

i'm trying to import clips into adobe premiere that i edited in adobe after effects. however, it appears that i cannot drag and drop unless i use dynamic link which requires adobe production premiere (which i do not have, only regular AP CS5). i have also tried file-->import but the file seems...

Setting Focus didn't work since it seems to be complaining specifically about Me.Service_Key.Form.chkROTO_Weehawken..... Setting subFrm didn't work either since it complains that form is "ambiguous"..... I am really at a loss here since there is absolutely no problem when opened manually.?????

thanks a mil guys! works perfectly...that missing " was what was throwing me off!

tried setting focus on Me.Services_Key.SetFocus to no avail. tried adding control SubFormControl on Services_Key and setting focus Me.Services_Key.Form.SubFormControl.SetFocus to no avail. wasn't sure where doEvents should go or what it is supposed to specify....

yes, i am able to open any of the 3 DB's even while another one is already open, if i manually select..... however, when using the code below to "switch" between DB's i get the error: Private Sub Command510_Click() Application.FollowHyperlink "Z:\GES\Client Database\Asia_DATABASE.accdb"...

i have 3 differnet DB's all linked together via application.followhyperlink .....: GES_CLIENT_DATABASE.accdb (MAIN) US_DATABASE.accdb EU_DATABASE.accdb Asia_DATABASE.accdb 3 of the DB's (US, EU, Asia) have identical names for the following: CLIENTS: current Form List367: list on Form CLIENTS...

this error is only generated when i utilize followhyperlink to open up DB from another DB. when i open it manually there is no complaint.

i am using the following: Application.FollowHyperlink "mailto: support@getcollc.com?bcc=" & "" & strHighAddress1 & "" & "" & strHighAddress2 & "" where should "replace" clause go?

only 1 bug encountered....if email address has "&" in it (ie. P&S@abc.com) then the string breaks. any ideas on how to escape & ?

AceMan, tried your suggestion but it is still complaining....

perfect...thanks so much!

can't i just adjust the above code to add Bcc similar to below? or is there no way to use application.followhyperlink for bcc:? Private Sub Command432_Click() Dim strHighAddress As String Dim strResetnow As String strHighAddress1 = Concatenate("SELECT Email1 FROM CONTACTS WHERE GroupEmail =...

Help! Whenever I try to open my database I get the following error: Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report. The following line is highlighted: Me.TabCtl88.Pages...

worked like a charm....thanx!

great stuff, but i'm using 2007 access

Anyone have VBA code for opening another Access database (via hyperlink) and closing current Access database?

ah, transparent instead of invisible! many thanks!

Need help figuring out how to turn an image into a hyperlink. i have tried using vba in on click event of image to no avail. i have placed hidden button over image to no avail. i have tried using hyperlinkaddress property on image which only works if you right-click first and then left-click...

Need some help figuring out how to adapt the following code to keep To: blank and add email addresses to Bcc: instead.... Private Sub Command432_Click() Dim strHighAddress As String Dim strResetnow As String strHighAddress1 = Concatenate("SELECT Email1 FROM CONTACTS WHERE GroupEmail = True"...

thanks randy..i'll give it a shot.