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!

  • Congratulations strongm 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: *

  • Users: kwor
  • Order by date
  1. kwor

    Email problem

    kjv1611. Thanks, I have been down that road. Even Microsoft can't get it right between Outlook and Outlook Express. I have tried all that and it doesn't work. I am thinking that perhaps an Access update has broken it but.. thefarg. The OutpuTo command is used to save a pdf copy to disk and had...
  2. kwor

    Email problem

    Sorry, you didn't list the thread....
  3. kwor

    Email problem

    That is the full message. to be specific: "<Database Name> can't send this email message" Not very helpfull. I have played around with the code and debugging trying to trap errors. I suspect that it may be runtime Error 2293 I have substituted CDO code as a workaround. This works but I have to...
  4. kwor

    Email problem

    I am running Windows 7 (64bit) and Office 2010 I have a database that creates a pdf document on disk and a button that calls my email program, attaches the docuemnt and leaves the new email open for edit. The code is: stEmail = Me.Parent!Email stFileName = "D:\documents\abc_" &...
  5. kwor

    Open any file from a form

    I used the Application.FollowHyperlink method on various file types, including pdf, and have not had a problem with warnings. Thanks for the comment anyway.
  6. kwor

    Open any file from a form

    Thanks for the replies everyone. PHV, exactly what I was looking for. Opening the folder/file dialogue was the easy part - launching the associated application of the selected file had me stumped.
  7. kwor

    Open any file from a form

    I have a form that performs a function. There are times when users need to select and open other documents relating to the database. At the moment they must go to explorer, navigate to the directory and double click the appropriate file. The file could be a Word, Excel or other document. To make...
  8. kwor

    Send Report In Body Of Email

    I have a parameter query to generate a report. Up to four parameters may be passed from the form to the query. Click a button on a form and the report works perfectly. I also have another button to email the report via Outlook. This works perfectly as an attachment, however, I need to place the...
  9. kwor

    DoCmd.RunSQL problem

    Thanks everyone, the DLookup worked. I shall remember not to use DoCmd.RunSQL in this situation again.
  10. kwor

    DoCmd.RunSQL problem

    I have two tables - tblAssets and tblAssetNo tblAssets is the main db table tblAssetNo has only one record that keeps track of the latest asset number. I have a form to add a new asset with a bound control called AssetNo. I am trying to use the following code to get the next asset number from...
  11. kwor

    current week from start and end date

    Thanks for the replies. I had actually worked it out by a different method but PHV's method is far more elegant than mine. Thanks. My method was to calculate the start of week and end of week in unbound controls on the form that called the query SOW = Date - Weekday(Date) + 1 EOW = Date -...
  12. kwor

    current week from start and end date

    I have a table with records that include a startdate and enddate field. The stardate and enddate for a record could be the same or differ by days, weeks or months. I have a query that will retrieve all records where the current day is on or between the startdate and enddate i.e...
  13. kwor

    No data from crosstab query

    I changed the select query as per your recommendations. No change. The "Report wizard" still has no data fields but they are available via "Report Design". My original report still returns the same error. "Like" or "=" makes no difference. "add all possible values of Area into the Column...
  14. kwor

    No data from crosstab query

    The form stays open. There is no code in the report. "Null value in the column heading" Hmmm.. I will check that for the original report because some "fixed" data may have changed. However, I would still like to understand why the report wizard would not display any data fields when trying to...
  15. kwor

    No data from crosstab query

    I have a couple of related tables. I have a form based on those tables that provides parameter input to a select query. I have a crosstab query based on the select query. This all works. I can select the required parameter on the form and view the results in the crosstab query. I used to have a...
  16. kwor

    Continuous forms record color

    Thanks MajP There is enough information there for me to design what I need. Not what I envisaged at first but one must be adaptable.
  17. kwor

    Continuous forms record color

    Thanks. It's not exactly what I was looking for but it's a good fallback solution.
  18. kwor

    Continuous forms record color

    I have a table with two fields: category and color. The color field stores a user selected number according to a color, e.g. 39423, 52479, 16763904, etc. I wish to create a form/report as a legend to a graph. The legend will display the category text and a control next to it showing the...
  19. kwor

    Annual Calendar Report

    Hmmm....I did look at your site early on. I missed the Gantt Chart. Thanks for sending me back again. I will work from that.
  20. kwor

    Annual Calendar Report

    I have a table recording people and projects. The table has people's names, start date and end date of each project. Each person may have several projects throughout the year. I need to generate a report that will display an entire year (each month?) across the page. Each person's name would be...

Part and Inventory Search

Back
Top