Search results for query: *

MichaelRed, How could I apply this to a report or query? How would I call/activate this function? I'm a beginner, so I appreciate your patience. FloydPepper

Roger that, AceMan. You are right on. How can I automate the assigning function (one picture per specific record)? Thanks again and again. FP

Sorry about that... Once the user takes the digital picture and saves it to the specified file, should they simply go to the form in the dbase, enter the individual's data and their picture name (.jpg) or is there a way for the form to prompt them (open a separate window displaying the contents...

Thanks AceMan! You've earned a combat star. Now,is there an easy way for the user to enter the picture name (prompt from specified file) or is typing it in the way to go? Thank you again. FP

AceMan! Thanks for the instruction. I moved my dbase to the same folder in which I store my pictures. Then, I eliminated my existing code and pasted in yours. Now, when I try to open the form I get an error message that reads: "Microsoft Access can't open the file'C:\Documents and...

Where could I insert this code and how would I use/call this function? Thanks PHV.

I have the Dbase on the desktop. What are the steps for designating a locatioon elsewhere for picture retrieval? Is there an easy way for the user to enter the path to the pic without typing it directly to the Dbase? Thanks. FP

Thanks for your patience. I'm an old grunt pushing through the electrons. When I enter the data for the picture link into the dbase, I only enter "Floyd Pepper.jpg". With this data it pulls the picture from the desktop (how it knows its there I do not know, but would like to). My first...

ZmrAbdulla, I'm all about flexibility with this dbase. If I move the image from the desktop into a folder I get the error message: "Microsoft Access can't open the file'C:\Documents and Settings\my user name\Desktop\my picture name.jpg'." whenever I open the form or report. Is there a way to...

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...

Thank you for your help. I wasn't clear enough in my posting. Here's what I'm trying to do: I need to pull the names of the columns/fields (eg Biking 101, Basket Weaving 301) into a single column in a table so that I can use the class names as a source for a listbox. I apologize for my vague...

Thanks GingerR. I added the Total column to my query by inserting Count([Tbl Main Training Schedule].Last Name) AS Last Name. This pulls up a final column in the report that towers over the others. My problem is that this column is still grouped with the other totals (for each class/column...

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...

Roystreet, I had this same issue a while ago. Are your users entering the docs into a table directly or a form? As far as renaming the doc, I can't help... But for ease of entry, I can. I created a form for my users from the base table. Then, I took the OLE field on the form and set the...

I ran into the same challenge a few months back. Here's what worked for me: For each criteria, place unbound text boxes in the report header. Set the Control Source for each text box to the appropriate crieria (e.g. = Forms![Criteria Form]![Criteria Text Box name]). This data will appear on...

Roger that. I created the form and the query. When I type [Forms]![MyFormName]![CriteriatxtBox] in the criteria section for the query and I run the query, a different form pops up (different from my design). How do I make it pull up my form? Thanks. FP

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...

Steve, Just build a new macro and select "Quit" from the options. This command will close your dbase. God Bless. FloydP

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...