Sorry I wasn't clear enough.
I want the query "GROWTH PRODUCT - 75" or relevant query in relation to drop down selection, to open in datasheet view when the button is pressed.
jolaunt
Last Activity: Aug 17 '10, 08:42 AM
Joined: Apr 16 '10
Location:
-
How to open a query based on option selected on a form
Hi
I have a form with a drop down field showing different 'series groups' eg
Series - 75
Series - 756
Series - 310
I have a button to run a query and want a different query to run dependant upon which series group is selected.
My drop down box is titled "product".
I have tried the following code which comes back with an error:
...Code:Private
-
How to use VBA to add Attachments to Emails
Hi
I have a database where visit reports are attached to individual records. Field Name: "KAM Visit Report"
I want to have a macro button that will send an email with the report as an attachment.
Can I do this using the DoCmd coding?
Thanks -
Thanks - I have managed to get it work now!!
You have been a great help.Leave a comment:
-
I am at a complete loss as to who to make this work. I think I need to start from scratch with this coding.
I have been able to get word to open the correct document but like you say it doesn't seem to know to look in the query to update the fields.
Any help at all on how to make this happen would be FANTASTIC!
As I have mentioned before I am quite new to vba coding and think I am being a bit ambious...Leave a comment:
-
Mail merge to letter in Word 2007
I would like to set up a button on an input form which will merge the contact information from the current record into a word document. I have set up the merge fields in the word document from a query. The word document is a letterhead and is saved in the following location:
X:\AVK UK\Global Reports - DCF's etc\Customer Complaints\Lett erhead DO NOT USE
I have set up a query which pull the data needed for the... -
I was over complicating it!
This has worked perfectly.
Thank youLeave a comment:
-
Auto updating form fields
Hi
I have two drop down boxes in a form both looking at the same table.
When I select info for the 1st box I want the second box to update with the same information. The code I currently have is:
Code:Private Sub Ctl1_Person_Responsible_AfterUpdate() If "Ctl1_Person_Responsible" = 0 Then Ctl2_Person_Responsible.Enabled = 0 End If End Sub
This isn't working.... -
I did try to set up straight from the query but it wouldn't let me.
The table is up to date and if I was to open the word document through explorer and not the button in access then the document updates fine.
I did consider using a report but I need to be able to amend and add text to it.Leave a comment:
-
I will try and give as much information as I think you'll need. Unfortunately like I said I am asking for help because I am new at this so please bear with me on this.
I have the following:
Query called "qryCustomerCon tact" with the following fields in:CC Number (set up to look at current form record only)...
Customer Name
Address1
Address2
Address3
Town
CountyLeave a comment:
-
What code do I need to do this? I have been searching all over the internet and have drawn a blank.
Any help at all would be appreciated.
Thank youLeave a comment:
-
Mail merge to MS Word from MS Access
I have a database with a query running a make table and linked to a mail merge letter.
I have a button with the following code:
...Code:Private Sub Command464_Click() Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc = "X:\AVKUK\Global Reports - DCF's etc\Customer Complaints\Letterhead DO NOT USE.doc" If Dir(LWordDoc) = "" Then MsgBox
-
Thank you this worked perfectly! :-)Leave a comment:
-
Exporting query to Microsoft Word
Hello
I have an Access database and want to export a query or report to microsoft word.
I have the following code which works fine:
Private Sub cmdLetterToCust omer_Click()
DoCmd.OutputTo acOutputQuery, "qryCustomerCon tact", acFormatRTF, "X:\AVKUK\Globa l Reports - DCF's etc\Customer Complaints\Mail Merge\Extracted Info\WordDocs\C ustomer Letter.doc", True
End Sub
... -
Sorry I am a newbie and a little confused by this.
How do I get around this? Should I change the format of my yes/no box?
Your help is appreciatedLeave a comment:
-
vba code to change a field based on another field
I am trying to create a vba code to tick a box after an update of another box.
I have a yes/no drop down box called 'ResolvedByTelC all'. When 'yes' is selected I want a tick to go in another box called 'Resolved'.
I have tried using the following code which does nothing:
...Code:Private Sub ResolvedByTelCall_AfterUpdate() If Me.ResolvedByTelCall = True Then Me.Resolved = True End If End S
No activity results to display
Leave a comment: