Search results for query: *

Storing image paths in table projectphotos. Multiple images for each project. No problem displaying via subform on main project form. Each image path has auto number id and is linked to project number. Need to be able to display 2 of x pictures on a report based on the main project table. As...

I have a table (PROJECT_TBL) that gets most of its data from drop downs from another query (CRITERIA_QRY). Column 1 is bound from the CRITERIA_QRY and is stored in the field CRITERIA_1, Criteria_2, etc. in the PROJECT_TBL. What I need to do with a query on PROJECT_TBL is to be able to reference...

PHV, Worked like a charm. The last piece of my project puzzle.

Maze, I came up with a work around that calls a custom help form when the user clicks on a help button.This is consistent with other forms in the application. The help window then opens off to the side of the main form so the user can see the data entry fields and still view the help. Thanks...

I have a form with an unbound field that is calculated by the entries to 20+ bound fields. When the value of the unbound field goes below a preset parameter, a message box pops up to warn the user. The user can then close the message box and continuing entering/editing data on the main form...

MazeWorx, How exactly would I create a bound control on a popup form that is essentially unrelated to the main form? Tried setting the control source of the check box to a yes/no field I added to the table, but when I try to check the box, will not allow me to select the checkbox.

Maze, My apologies for the continuation thing. Ace, this will not be on a network so I will give Maze's suggestion a go. Thanks to both.

Yes, Ace Is correct. He has helped me out too many times to count. maze, thanks for the reply. Will give it a go tomorrow. Rigging the boat for a sailfish trip at 0430 in the AM. Ace, you are the man!

I have an unbound form that pops up after loading the bound form with instructions on filling out the fields in the form. What I would like the user to be able to do is cancel the pop up (unbund form) by checking a check box (just like the Start Up screen on most software programs where you...

Ace, You are tha Man! I knew it was an easy fix but I am a self taught programmer, though not a very good student! Another one for ya! I need the user to be able to click a check box on the unbound 2nd form that will prevent it from opening again. Kind of like the info screen when you first...

I have a form (PROJECT_FRM)that is a popup called from a command button from the switchboard and is bound to a table for data entry. What I would like to accomplish is to have a 2nd popup form PROJECTHELP_FRM (which is an unbound form) open after the PROJECT_FRM opens. PROJECTHELP_FRM has a...

ProjectPhotoTBL linked to ProjectDetailTBL via ProjectID which is the primary for ProjectDetailTBL. ProjectPhotoTBL has 3 fields: ProjectPhotoID (autonumber) ProjectID (pick up from parent form) PhotoLink (which is a hyperlink field) The ProjectphotoID is updated by a search button on the...

I store the path to photos for individual records in my database. Each record can have unlimited photos. All works well in displaying the photos on the form using a subform. When printing a report, I would like to be able to use multiple photos. However, the link is stored in an unbound text...

MW, Thanks. I knew it was not that complicated. Works perfectly.

...Private Sub Command7_Click() Dim email, ref, destination, notes As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem '**gathers information from your form. this sets the string variable to your fields email = Me!email_address ref = Me!subject notes = Me!message...

Yep. We maintain separate Outlook folders for each project we work on so linking the tables would be a bit problematic. It would also require creating additional forms to view the emails. Once a project is complete, we save the emails to a PDF and delete the folder, hence the reason for just...

...using the folder name as the link name as opposed to the full path to the Outlook folder. Here is the code (I plan on cleaning this up): *********************** Private Sub Command3_Click() Call SelectFolder End Sub Function SelectFolder() 'Created by Helen Feddema 8-25-2000...

I have a query that derives its records from two xtab queries. I need a report that will dynamically display the column headings and fields based on the query contents. This has to be dynamic as the records will change in the xtabs. I am working on the premise of the unbound text boxes for...

Duane, How do you alias a column using the "*" in the query. I need to include all of the fields from both xtabs. Thanks again for the help.

dhookum, I guess my understanding is a bit off. In order to link the two xtabs, I need a common field, correct? All of the data is coming from the same table, but I am using one xtab to genrate sales for each product type and then volume for each product type. The common link between the two...