Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ajolson1964

    File Dialog

    WOrking like a charm. THanks
  2. ajolson1964

    File Dialog

    ..."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...", _...
  3. ajolson1964

    Export Query to Excel code

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

    Mail Merge Formatting

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

    Mail Merge Formatting

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

    Mail Merge Command Button.Access 2007

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

    Mail Merge Command Button.Access 2007

    ...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"...
  8. ajolson1964

    Form Mail Merge Button

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

    Parameter Query in a Form

    WORKS PERFECT!!!! Thanks Thanks THanks!!!!!!!
  10. ajolson1964

    Parameter Query in a Form

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

    Filter a Form

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

    Filter a Form

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

    Updating Sub Forms

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

    Sending Report to email (outlook)

    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!!
  15. ajolson1964

    Sending Report to email (outlook)

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

    List box of a directory on C:drive

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

    Combo box showing contents of a Directory

    Sorry I though i posted it in the wrong thread.
  18. ajolson1964

    Combo box showing contents of a Directory

    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?
  19. ajolson1964

    List box of a directory on C:drive

    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?
  20. ajolson1964

    Delete a File

    Works like a champ. Thanks.

Part and Inventory Search

Back
Top