Search results

  1. E

    Counting Number of Days That Contain Records

    I've been searching the Queries Forum for help on this issue. I have a database that records loading records for a Taconite facility. Some days contain many records and on other days there are no records because of no loading activity. I create reports that group these loading records by each...
  2. E

    Report with SubReports

    Hello: I have a pretty complicated report. It has five subreports within it. I used Access's Report Wizard to begin building the Report and then Finished it in Design view. The main part of the report is in the Users.LastName.Header section. Employee Work Assignments are in the...
  3. E

    Setting Time Parameters

    I want to determine the time of day when a user to the database I am developing logs on. If the time is between 07:30 abd 15:30 the database will know that this is the "First" shift and make a note in the data record that is in view. But I am having trouble writing the correct conditional...
  4. E

    Transferring text from one field to a hyperlink field

    I have a database in which a query creates a text entry in a field which is used to show the path to a linked file. This path needs to be transferred to an adjacent field in the form in view which is a Hyperlink field. One can simply copy and paste this text and the link works. However, if I...
  5. E

    Sending automatic email notification using SendObject

    I have been able to write a line of code in a form that is called "SafetyLogF" that generates an email message in either Outlook or Eudora and attaches an HTLM document as the object. However, the user must manually enter the recipient's email address because I am not sophisticated enough to...
  6. E

    I need to get rid of leading empty spaces...

    I have an employees table that was imported from an excel file. It has FirstName, MI, LastName fields. Each of these fields has data entered in them with a blank space before the data entry. The last name Cross is entered like this: " Cross" instead of "Cross". Is there any kind of function...
  7. E

    SendObject command

    I am using the SendObject command to send an Access97 report in html format to various email addresses. These email addresses are stored in a field named [eMailAddress]. Is there a way for the SendObject command to take a specific eMailAddress value and put it into the SendObject statement so...
Top Bottom