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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: cstuart79
  • Content: Threads
  • Order by date
  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

    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...
  3. 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?
  4. 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...
  5. 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"...
  6. cstuart79

    Title Page to call multiple DB

    I have 3 separate databases that I want to "integrate into 1" so that user has the ability to call up whichever DB they need. Thinking about utilizing a "title page" to select the appopriate DB but not sure how to do this....can i use visible/invisible? Not sure how to approach it....
  7. cstuart79

    Conditional Formatting to Make Visible?

    Stupid question, but is conditional formatting limited to all color/font changes or can it be used on a control to make textbox visible/invisible?
  8. cstuart79

    Dim strAddress As String?

    I am attempting to use checkboxes ("Me.CONTACTS.Group Email") to select specific email addresses ("Me.CONTACTS.Email_1") which will then all be added to a message upon clicking a button ("CommandEmail"). The following code gives me an error ('438' Object doesn't support this property or...
  9. cstuart79

    Remove control from tab order

    I am trying to remove a control from tab order so that it does not appear as a category when using the record selector to copy/paste into an email. I have tried setting Tab Stop to "No" which does seem to remove the control from the tab order but it still shows up when copying/pasting. Any way...
  10. cstuart79

    Error In Passing Default Values When New Record Is Created

    I have created a pop-up which is supposed to have default values passed on from its originating control. It seems to work properly when a record already exists, but does not pass values when a new record has been added. I know that I need to tweek my code to be more specific about where the...
  11. cstuart79

    Hide Tab Page Based Upon Subform Control

    My main form has 4 tabs. I would like to either hide or make visible tab4 based upon the value of a control located in a subform on tab3. I have attempted to use the following code in the main form "on current" event but it does not yield any results. tab3 subform = Master_Key tab3 subform...
  12. cstuart79

    List Box Error

    i have an unbound list box with a long list of clients that is on the main form composed of multiple tabs. when selecting one client from the list box, the client name in the list remains highlighted and the scroll in the proper position as i click each tab. however, when i click back to the...
  13. cstuart79

    Dirty Property to Undo Last Action

    Trying to use a button "Cmd_Undo" to undo the last action performed in multiple subforms. any suggestions on what i am doing wrong with the following code? It does not generate any errors but it does not remove last action performed in subform. Private Sub Command379_Click() If Me.Dirty...
  14. cstuart79

    Highlight Row in Continuous Form

    Is it possible to highlight (ie. change backcolor) of entire row in a continuous form upon clicking cmd button? I believe it would require conditional formatting, but this does not appear to be allowable for entire row.
  15. cstuart79

    Scroll Bar on List Box gets "stuck" in wrong position

    I have an unbound List Box that shows a long list of clients and therefore has vertical scroll bar to navigate. When using the arrows or scroll bar to scroll all the way through the list from top to bottom, the scroll bar stays in the proper position. However, when a client in the middle of...
  16. cstuart79

    Filter List based upon Keywords

    I am trying to utilize an unbound search text box to have users type in keywords which will filter a list box of clients to show only clients that meet the keyword criteria. However, the keywords will not reference the actual list box but rather the info in fields of various subforms. I know...
  17. cstuart79

    Close Button on Subform

    I am trying to put a "close" button on a subform using the following code: Private Sub Command11_Click() DoCmd.Close acForm, "SESSIONS_SOURCES", acSavePrompt End Sub However, this does not effectively close the subform, and when I tried to use the "Close Form" button in the wizard it closes...
  18. cstuart79

    Undo Last Action/Back Button

    is there a simple way to create an "undo last action/back button" in access which will simply restore to last state? i know there is a button called "undo record" but it doesn't seem to function as i want.
  19. cstuart79

    Conditional Formatting for Check Box

    So I have the following code added to a check box on a continuous form. Private Sub Check32_Click() If Me.Check32.Value = True Then Me.Sender_Comp_ID.BackColor = RGB(0, 255, 0) Me.Port.BackColor = RGB(0, 255, 0) Else Me.Sender_Comp_ID.BackColor = RGB(255, 255, 255) Me.Port.BackColor = RGB(255...
  20. cstuart79

    Code on Continuous Form to perform action on unique record

    So I have the following code added to a check box on a continuous form. The code is successful in changing the color of the field upon clicking the checkbox; however, all records change colors when 1 single checkbox is clicked. Please help me revise the code to make it so each checkbox for each...

Part and Inventory Search

Back
Top