Recent content by Claven

  1. C

    Bookmarks in word

    yes, I think that might work. However, I have found that the bookmark allergy will always show at the bottom of the text from the bookmark start. I will give this a try. Do you know of a good reference for working with word and VBA for reports? Thanks, Dennis
  2. C

    Bookmarks in word

    I am trying to use bookmarks in word to make a report. I have it set up to make the report the way I like, except.... I have text on the left side from top to bottom that start with the bookmark start. The thing is I need a column on the right margin that I will place lab work, so I will...
  3. C

    Need to print the last 24 hours of records

    namliam, With this database the datecalled is set, while we enter the time called as this is the time we are paged or called for an event. We then go to the medical emergency and deal with the event. When we get to charting the event we place the time paged and arrival time. We can't just...
  4. C

    Need to print the last 24 hours of records

    BTW, I used Date() -1 That only gave me records for the previous date, and not the current date. I will try your suggestion when I get back to work to look. Den
  5. C

    Need to print the last 24 hours of records

    Well, in the db the timecalled and datecalled are two separate fields. However, the datecalled is automatically set on open so it would contain the complete date and time. I don't use all the data for the forms and reports. Den
  6. C

    Need to print the last 24 hours of records

    Will that give me all of the current date and the previous date of records? If so, that is the ticket. Thanks, Den
  7. C

    Need to print the last 24 hours of records

    Well, I must have spent hours looking in the Access Help in the application. Where is VBA help located? remember that a date is stored as a number, so to take 1 day off (24h) it is just date_-1. Look at this: dummy_=#02/01/2008 10:00:00# ? Format((dummy_),"dd/mm/yyyy hh:mm:ss") 02/01/2008...
  8. C

    Need to print the last 24 hours of records

    I am using Access 2000. I am trying to print a report of the last 24 hours of reports. This will be printed twice a day and needs to include the last 24 hours of reports. There could be one or several. I created a report that included the information, then I decided that a query would be...
Back
Top Bottom