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: *

  • Users: kwor
  • Content: Threads
  • Order by date
  1. 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_" &...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. kwor

    Supress error on unbound control

    I have a form with two bound controls - StarDate and EndDate. Using code as per faq181-261, I use a third unbound control to display the number of working days between the dates. This works well. However, if there are no dates in the two bound controls, the unbound, calculated control displays...
  10. kwor

    Email via Thunderbird (or other email client)

    I have a couple of different databases on different networks with facilities to send email from within the Access databases. Network A. This database was written in Access 2007, runs under Vista Business and uses Outlook 2007. Network B. The database was written in Access 2003 and runs on the...
  11. kwor

    Cancel = True error

    I have a form that requires some mandatory information. The following code checks the form before updating. Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Surname) Or IsNull(Me.Address) Or IsNull(Me.Suburb) Then MsgBox ("Surname, Address and Suburb are mandatory")...
  12. kwor

    Apostrophe problem in query

    I have a form that displays contacts. Name, address, etc. On the form is a combo box that is used to find a contact. The following code is used on the after update event on the combo box: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Surname] = '" & Me![Find_Surname] &...

Part and Inventory Search

Back
Top