Search results

I'm really just learning, although the navigation tabs are where they are turned off. So perhaps it would be good practice to turn them back on, it couldn't hurt.

Anyone still looking for a solution - I think I found it! This is what I have done and it seems to work. All of the on Load events of my forms I have set warnings to true DoCmd.SetWarnings True In addition I have set the filters on the datasheet form with VBA Private Sub Form_Load()...

Thanks Rookie, Perhaps it would help if I explain further AddyLineVar is another address block stringed together. It is the Property Manager involved in the project. Essentially we are in construction so an inital proposal would go to the property manager while an invoice would go to the...

I am trying to build an address string based off of my form. It has the following fields; ServiceAddress (FK), ID (PK), BillToCompany, BillCareOf, BillAttn, BillAddress, BillCity, BillingZip, BillBoxNumber. What I would like to happen is the BillToCompany go on First and if that is blank I...

Liam, If you figured this out could you post how you referenced it. I have been attempting this for weeks unsuccessfully :(. Thanks, Samantha

Just to update - I solved my own issue after spending half the day on it. Even though what I was attempting to add was "in my eyes not related" to the sub-form. The problem for me was in the filter on load property. Resetting the filter criteria solved it.

Error: "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblProposals." I have a form "frmProposalDetails" that has many sub-forms on it, the main source table is named tblProposals. Although, I have a query based on that table...

I have some code that takes the information on my form and transfers it to an Excel template. It does not link any information back into Access. I then save the template in a file location on my hard drive. It may be what you are looking for. Private Sub cmdMergeXLbttn_Click() On Error GoTo...

I am using the on click event to add my Access Contact to outlook and I am finding some odd behavior. It seems that if the contact is missing information like the Fax number then it throws this error message up (error number-2147352571 Outlook cannot translate) I have found that it is a result...

Bob, I am having the same issue, did you figure anything out? Samantha

I have a datasheet form that is based on a query. The query is based on three tables. Data entry worked fine with this configuration. There was extra duplicate lines that were identical cause by a multi-select box. It seems that once I entered Select DISTINCT that's when it would no long allow...

Oh, I got it, thanks for all your help Bob! Private Sub cmdCheckContact_Click() DoCmd.OpenForm "frmContactCheck", acNormal, , "[ContactID]=" & Me.Contact End Sub

Okay, I removed the On Load code, it had not been previously. Now there is no Error Message. It opens the form and navigates to a blank record 1 of 1. When I switch to Design View on the Property Sheet under Filter it states [ContactName]="16" which 16 is equal to the contact so there must be...

Thanks Bob, I changed the on click event to your code and entered as you suggested although It displays a message box stating Object Required. It does open the correct form and a filter is applied although it displays a blank record. Note: tblProposals.Contact is the control source of the...

Hi All, I seem to be having a difficult time getting my form to filter on opening. I have tired several variations and can seem to get it any help is greatly appreciated. :confused: I have one form entitled frmProposalDetails on this form there is a field named [Contact] then there is also a...

Follow the directions here it works. http://crissysmarteningup.blogspot.com/

DoCmd.Close acForm, "frmColorReports" This is a line from my code it closes a form named frmColorReports

It's the object type, then name of report, and an opitional save. Highlight DoCmd.Close and hit F1 for help it will tell you the agruments required.

I was wondering if anyone had some useful code for Outlook 2010 that would automatically reduce the images once they are attached. In Outlook 2007 once you attached an image it would give you another option to resize it in the same window. I do know that once it is attached you can select the...

Thanks for the response Bob, although I am lost. Just to clarify Me!ServiceAddress.Value returned only the first selection of the multi-list box. I set the varibles to build the string, and inserted portions of the code from the link. I get an error message at the red line? Private Sub...