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

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

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

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

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

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?

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

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

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

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

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

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

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.

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

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

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

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.

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

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