Search results for query: *

Ladies and Gents! Please help. I have a form (Form Main)whose source is a table (Tbl Main). The data base is being established to track personnel info (including .jpg pictures) for HR. I have used the following code (from forums on this site) in the On Current property for the form: Private...

Ladies and Gents, I have a table with Employee Name, Class 1, Class, 2, ..., Class 24. Is there a way to combine different fields (column headers) on a table into the content of a single column on a separate table (Class Names)? Thank you in advance. FloydPepper

Ladies and Gents, I currently hav a chart that tracks the names of classes completed per employee name. I have a chart report that displays this in bar chart format, with class names along the x-axis and the count of these classes (data indicating employees have taken the class) along the...

Ladies and Gents, I have a query that pulls 5 fields from a table and feeds a report. When I open the report, I want a pop up form to allow the user to specify criteria for three of the fields. I followed the instructions from HELP and entered Forms![FormName]![Field] in the criteria. Once...

Ladies and Gentlemen, Please help. I have a report that pulls from a query and lists: a. Tasks (Text) b. Task Serial Numbers (Text) c. Notes (Text) d. Task Complete (Yes/No Checkbox) In the report, I have the text boxes (a-c) conditionally formatted so that their background goes to green if...

Ladies and Gents, Can I build a macro that will make a backup copy of my database (on my desktop) on close? Thank you in advance. Floyd P

Ladies and Gents, Is there a way to append data to a tbl with an autonumber assigned (destination tbl) that will reset when you delete the data and append new data? I need a table that I can append data to, then delete it while the table maintains autonembers 1-10. Thank you in advance. God...

Ladies and Gents, I have a qry that pulls between 1 and 10 records depending on the current work load. I need to enter these into a Word Doc for publishing. I've had some success with Mail Merge, but I have a table in the Word Doc that I need to list multiple entries in. For example, I have...

Ladies and Gents, I have a form memo that I put out a few times a week. Basically there is alot of text, a few points at which names involved in the action alternate (Bob might be responsible for an ation one week and Sheila the next week), and some excel-like tables that hold changing data. I...

Ladies and Gents, Is there an easy way to export a report to PowerPoint? Thanks. FloydP

Ladies and Gents, I have a line chart report that tracks the count of events that occur each day (3 separate reports for one week/month/and 6 months). Is there a way to have this report display a second "trend" line that would maintain the avg of these counts? Thanks in advance for your help...

Ladies and Gents, I have a dbase that records events based on date/time occurred, event type, etc. Right now I have a qry with criteria set to Between (Now()-1) and (Now()). How can I set the criteria to go from yesterday at 0430 (am) to Now() (time of qry)? Or set the criteria to 0430 to...

Ladies and Gents, Can you export a report to Power Point? Thanks for the help in advance. Floyd P

Ladies and Gents, I have a report with several subreports in it. I have a "total" from each of the subreports linked to its own individual text box in the "main report". The problem that I am having is that when a subreport has no data and thus does not appear, the text box that is linked to...

Ladies and Gents, I have a report that lists: Event, Outcome 1, Outcome 2 I have several different events that I log, such as "accept" and "return". Is there a way to have the total count of each event type (eg return = 7 total, accept = 8 total) in the footer of this report? I appreciate...

Ladies and Gents, I have a form that has three (3) OLE Object fields on ea record. I insert word docs into these fields. Is there a means by which I can have an email generate with these OLE(s) as the attachments? Thanks in advance. FloydP

Ladies and Gents, I am attempting to build a database that tracks tasks and their status over time. For each task entered, I have a task number assigned (for tracking purposes) and a hyperlink to pertinent Word documentation. Is it possible to build a macro (or code) that will allow the user...