Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cstuart79

    Import AEP files into Adobe Premiere to stitch together

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

    Invalid Reference to property Form/Report Error

    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.?????
  3. cstuart79

    VBA Email Method: BCC Only

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

    Invalid Reference to property Form/Report Error

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

    Invalid Reference to property Form/Report Error

    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"...
  6. cstuart79

    Invalid Reference to property Form/Report Error

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

    Invalid Reference to property Form/Report Error

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

    VBA Email Method: BCC Only

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

    VBA Email Method: BCC Only

    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 & ?
  10. cstuart79

    Invalid Reference to property Form/Report Error

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

    VBA Email Method: BCC Only

    perfect...thanks so much!
  12. cstuart79

    VBA Email Method: BCC Only

    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 =...
  13. cstuart79

    Invalid Reference to property Form/Report Error

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

    On Click Open Hyperlink and Close Current DB

    worked like a charm....thanx!
  15. cstuart79

    On Click Open Hyperlink and Close Current DB

    great stuff, but i'm using 2007 access
  16. cstuart79

    On Click Open Hyperlink and Close Current DB

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

    Image as Hyperlink

    ah, transparent instead of invisible! many thanks!
  18. cstuart79

    Image as Hyperlink

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

    VBA Email Method: BCC Only

    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"...
  20. cstuart79

    Title Page to call multiple DB

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

Part and Inventory Search

Back
Top