Search results for query: *

WOrking like a charm. THanks

..."Sub or Function Not defined" Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _ DialogTitle:="Please select an input file...", _...

I am exporting a query to excel using the following code: DoCmd.OutputTo acOutputQuery, "AllOut", acFormatXLS, , True It creates a new excel file called AllOut and places the information in a worksheet that it names AllOut. Where that works I would like to take this to the next level and just...

Where do I type that in? A new query or in "OnClick" of the command button that mergeges the table with the word document?

I am having a problem keeping formatting after a mail merge has completed. Here is the issue. I have formatted in access a field as a percent. In access I see 50%. But when I mail merge it, to a word document reads .50 does anyone know how to make word read as 50%? Thanks’ Andy

Now here is a code I have been trying to get to work. It should do the trick but I get a 'Compile error: Saying: User-Defiened Type not defined. It refers to the Dim MyWord as Word.Applicaion. Private Sub Enveloppe_Click() Dim MyWord As Word.Application Dim PathDocu As String If Me.NomPers...

...DoCmd.SetWarnings False DoCmd.OpenQuery ("DeleteGasRockWeeklyReport") DoCmd.OpenQuery ("AllWeeklyReportinfoToDocument") DoCmd.SetWarnings True ' *********** Code Start ************ ' 'This example starts the Word Mail Merge wizard using the query passed to it. StrName = "AllWeeklyReport"...

I need help in setting up a command button to mail merge a query with a Microsoft word Document. The word .doc already has the fields set up in it so only need to have the user hit the button within a form and it opens the doc with the merged fields. I did try using a hyperlink to the...

WORKS PERFECT!!!! Thanks Thanks THanks!!!!!!!

...is first thing the parameter query wants, before running any code is a “Fat-Fingered” date. It just wont execute any code. Here is my code FYI ***[StartDate] is the parameter that controls the[DayofProduction] field within the query. Private Sub Command2_Click() Dim stDocName As String...

I am sorry what I ment is I want this to work on a Report not a Form. Sorry.

I am having a difficult time applying a filter to a form. What I have is a form that’s control source is a Query with several fields on the form. One of the fields is named JobFunction and that is the field I want to apply the filter too. What I would like is for the user to open a form then...

I have a form that has 2 sub forms within. I also am using a Combo box to select data then have that data updated to field located within the form that the combo box is located.. What I would like to do is have the combo box update (with the same data) a field in the sub form. Is that...

Thanks a little tinkering and it works great for my applications. Gonna see if I can call it up as a function but if not coded in a command button will be fine. Again Thanks exaclty what I needed!!

Is there a way to have a command button output a Report to outlook email as a snapshot or excel file?

Like I said I thought i posted it in the wrong thread,

Sorry I though i posted it in the wrong thread.

What I would like to do is have the user be able to select a file located in a directory using a combo or list box. So when the user clicks on the combo box a drop down list appears that lists all the files in a specified directory. Can that be done and if so how would I set it up?

Is there a way to have a combo box, or a list box, list the files on a Directory? If so how would I set it up?

Works like a champ. Thanks.