Search results for query: *

WOrking like a charm. THanks

I am having a heck of a time getting fileDiolog box to open so a user can select a file to import into an access tbl. I am using the following code but get a compile error stating that ahtAddfilterItem "Sub or Function Not defined" Dim strFilter As String Dim strInputFileName As String...

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

I have a command button that, updates data in a table then starts the mail merge wizard. The user then selects the directory and the name of the file to merge a presto works great. Here is that code Dim StrName As String ' This deletes the content of a table and replaces it with new...

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

I have a form that when is opened executes a parameter query. What happens is the form opens and the first thing asked is to enter a date, so the user Types in a date (fat fingers) and poof the record set selected and only returns the desired date. Once the parameter query has been...

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.