Search results

VbaInet, I came across your post and it helped me return the value of the selected, any idea how to return multiple values. This is my code, I want it to return multiple addresses into my merged Excel template. XLSheet.Range("ServiceAdd") = Me!ServiceAddress.Value Thanks for any advise...

Using VBA you would create your form and add a button with an on-click event. Then you would enter your code into VBA. (at some point in this you have to make a template in office setting the bookmarks where the varible will change according to your database fields) It may help to buy a...

Yes, Congrats Bob I know you have helped me out tremendously in my quest! BRAVO! :D

Okay I figured out one reference that was wrong, it should have been .Email1DisplayName Now I just need to figure out how to get the File as to incorporate the Company Name also?

I would use code to merge to MSWord to accomplish it. Here's my code, start by building a template and storing it in the same file with your database. Private Sub MergeBttn_Click() 'Declare variables for storing strings. Dim AddyLineVar As String, SalutationVar As String Dim...

This may point you in the right direction. Although I am using Access2010. I have a navigation form that the first page is a datasheet which [JobNumber] is my primary key. The second sheet is a summary form, what ever record you are on in the datasheet when you click the second page it matches...

So in my access database I have created a contact form and it has an on-click event that creates a record in outlook. (by the way I removed linking because it was causing slow responses and not responding) My hang-up is referencing the Display as: and File As: fields (Which file as populates...

I am using Wrox Microsoft Access 2010 Programmer's Reference and I am attempting to recreate the audit trail example included. I have checked everything over and I don't see where I went wrong, but it does not create new records with the information. Opening the application log it state that The...

Oh, good that was one of the same books I was looking at. Thanks again!

Bob, is there a good book I should look for just in general for learning VBA . I have searched and found many to choose from. Well I figured out at least a temporary solution. I just inserted another subform with the field that I needed and then changed the visable property to NO. One more...

I suppose really I spoke to soon, the tab has to be active or "Clicked" before running the code. I attempted adding a line to the code to set the focus although it's not working using the same syntax it throws an error up saying it cannot find the field.

I've already bookmarked that page. That is wonderful reference for the future. Incase anyone else is wondering this is the proper way to reference it. [NavigationSubform].Form![ContractAmount] As always thanks for your time! ;)

This is the line that I inserted following your example. I am getting an error message that says it cannot find the field subBillingDetail although that is the name of the navigation control form and not a field itself? .Item("ContractAmount").Range.Text =...

I am looking for the proper way to refer to a navigation subform entering it the same as a regular subform is not working? [subBillingDetail].[Form]![ContractAmount] Thanks, Samantha

All the contacts have one or another as of now, although it is a possiblity in the future. So planning for the future, it would be nice to get a message box of the error and open a modal form to correct it before proceeding. I did figure out the text of my original question, this is how I...

Hi All, So I have a access database and I have delevolped a code (actually borrowed a code) to send all of the information to a MS Word template. My question is - not all of my contacts have an e-mail address so in the event that they do not the fax will be inserted instead. I have that part...

Bob, that is actually much better how you revamped it. Thank you so much for your time on this. Samantha

Okay it took a bit to get it down to size. The file is attached. I have labeled the main navigation frmNavigation, when it opens the first tab is my datasheet form then clicking the 2nd tab Detail it filters the subform from there but if I double click it the subform does not filter. Than you...

Bob, I have another little glitch with this. The form that I am opening also has a navigation subform with several tabs. Prior to changing this code it worked. The subforms are "JobComments" which relates to the base table by JobNumber then there are others like "Billing" which relates to the...

Hi all, I have created a modal form with a combo box that the user can select the ServiceAddress and the report will open. This does work how I intended. My question is how do I make it so if the report is open and the user wants to select another address from the combo box it will refresh...