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

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

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

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

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

I have a form that I compose an email to a contact then a command button sends the info to Outlook. Also on that form is a command button to save the record to the contact notes table. The problem I have found is that if I send to outlook prior to saving, then try to save the record, it does...

I have found this rather old code to search my Outlook folder and add the name of the folder to an unbound text box on a form. What I need to be able to accomplish is to actually store the link in the field to the folder, preferably using the folder name as the link name as opposed to the full...

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

I have a select query that is based on two crosstab queries. One of the crosstabs uses the * to pull in all fields to the query. This is needed because the table data is not constant (i.e new products can be added, removed, etc.) The select query gives me the data I need. However, the field...

Any suggestions on how to dynamically render report column headings based on a field value? For example, I may have a machine with Items A,B,C. A daily sales ledger reports on item sales and volumes. The info for the report comes from a query based on a couple of crosstabs. The products can...

I have an unbound text field that displays the day of the week once the date is selected/entered into the SalesDate field on my form. Until the date is entered, the field displays #Error. Any ideas on how to suppress this?

Any guidance on syntax? What I am trying to do is to lookup the last value in a related table based on a field(DateChange)and then use another value(s)to perfom misc. calcs on a form, report, and query. I do not want to affect any values older than the ChangeDate

I have fairly simple database. 2 tables: PriceTBL SalesTBL PriceTBL is used to store pricing and volume data for 5 products. PriceID used as key. SalesID default value set from command button call from SalesFRM. SalesTBL is used to enter total daily sales for each product type. Other fields...

Using a bit of code to browse and open Outlook folders from a form in Access (2007). Code works fine. If I press the Cancel button in the "browse for Outlook folder" window, get a runtime 91 error. See code below: Private Sub Command187_Click() Dim mOutlookApp As Outlook.Application Dim...

I have a large database with both contacts and projects. No problem emailing from Access (via Outlook) and attaching emails to contacts and projects. However,I also need to attach received emails in Outlook to individual contacts or projects in Access. The most desireable method would be to have...