Search results

  1. S

    Tracking Trends Over Time

    I am trying to figure out some productivity stuff and I am stuck. I have developed an application for our security department to keep track of the various tasks they do. One of those things is standing by with combative/violent patients. Sometimes this lasts for fifteen minutes, other times it...
  2. S

    Exporting Data to Word and Formatting Tables

    I am trying to export data to Word and convert it into tables. Using code from an example by Pat Hartman, I put the following together. This works great except I would like each individual record to be its own table instead of one giant table, but I am stuck on exactly how to get that. Can...
  3. S

    Exporting to Word and Remote Server Unavailable Error

    I looked at a couple of threads here on this topic and tried some suggestions, but was unable to fix my problem. I am exporting some data to a Word template so that users can then write an incident report (its for our security dept). Everything seems to work fine except that I keep getting the...
  4. S

    SQL Help

    Can someone give me a hand with a SQL expression. I've been staring at this thing for hours and can't figure out why I keep getting a syntax error. strSQL = "INSERT INTO tblIncidentReport(OfficerID,IncidentReportNumber,IncidentReportLocation) " & _ "SELECT " & [cboOfficer] & ", " &...
  5. S

    Opening a report from a list box

    I have a list box that displays the names of reports that can be printed. The list box is populated from a table with three columns - an autonumber, the name of the report, and a description. I hide the first two, displaying the third. I want the user to be able to double-click the report they...
  6. S

    Trouble with record source

    I'm having trouble with a form. I have a query pulling together info from a few table to display on my form. The problem is that when I look at it in Form View, the detail section is completely empty. I don't just have blank fields; none of the fields and controls are visible. If I change the...
  7. S

    Tab control formatting

    I searched the forum, but I couldn't find an answer for my question. I have a tab control with three tabs on a form. How do I eliminate the grey bar to the right of my tabs where additional tabs would normally go?
  8. S

    Need some help tracking hours

    I'm hoping that somebody can help me out. I'm fairly new to Access and I have a big work project I'm trying to get through. I need to keep track of all of the vendors and contractors that come to my facility and their orientation status. I've got a db set up now for that - tables for companies...
Back
Top Bottom