Linq -
I added my code to the form's OnCurrent property and it does exactly what I want. Thanks for your help!
Shortstuff12345
Last Activity: Sep 16 '08, 07:38 PM
Joined: May 24 '07
Location:
-
Greying Out One Field Based On Another
I'm trying to use VBA code to disable a field based on the value of another field in a form. The code I have properly updates the enabled property of the field when it changes; however, it changes it for the form as a whole instead of a single record. My form is set as a single form.
For example on record 1, field1's value is "records" and field2's enabled property is set to false. When I go to the next record (record... -
Brad,
I was able to get the body section working properly with the extra & _. However I still can't seem to get the addresses to work properly. Here is the code I have:
It pulls in the first address just fine (and I've tried using the three different fields that I want to use - DCI_resp,...Code:Set ToContact = .Recipients.Add(Me.DCI_resp) Set ToContact = .Recipients.Add(Me.engr_resp) ToContact.Type = olCC
Leave a comment:
-
I've been able to add a single field from my form to the body of my email using the following code:
However, I also want to display the markup ID and the markup description as separate paragraphs. I've tried the following:Code:.body = "Purpose of Change: " & Me.purpose_change & vbNewLine
...Code:.body = "Purpose of Change: " & Me.purpose_change & vbNewLine & vbNewline
Leave a comment:
-
Brad,
Thanks for the links. The second one was very helpful. I do have a few questions about customizing it though.
First - when I use the code pretty much as-is, I get a message window from Outlook saying that a program is tyring to access email addresses stored in Outlook. I have to click Yes three times in order for the box to disappear and for the message to open. Is there any way to eliminate the warning?...Leave a comment:
-
Sending an Outlook Email Message from Access Database
I have a database that is tracking drawing markups from our manufacturing shop. The form I use captures the drawing number, the shop order, purpose of change, description of markup and who needs to make the change. I'd like to add a button so that I can send an email to the person responsible for the drawing and I want to include the drawing number, shop order, purpose of change and description in the body of the email.
For the responsible... -
Deleting Records in the Form View
This can be ignored... I did a bunch more searching and tried a few more things listed on different posts. I was able to get the delete query to work properly by adding a statement in the code (Me.Requery) to refresh the information on the form and the #deleted went away.
--------------------------------------------------------------------------------------------------------------
First of all, I want to say...Last edited by Shortstuff12345; Jun 18 '07, 03:51 PM. Reason: I did a bunch more searching since I posted this and found a few entries regarding this item. With a couple of tries, I was able to get the delete function to work. -
Scott -
I know this thread is a little old at this point, but it may be helpful to other users who run into this problem. I had the same issue with users leaving the database open all the time and I couldn't do updates to the database. To solve this, you can setup a timer to run when the database is opened by each user. After the set time, the database saves everything and closes.
To do this you can create a blank...Leave a comment:
-
Query Based on Selection Using a Checkbox
I have a database that tracks design changes made by different groups of people who work for different managers. I currently have a form setup such that the user can select a range of dates and when clicking a button to view the report, the report only shows the data within the selected date range.
I'd like to add the functionality that the user can check a box next to a single manager or multiple manager names and the report will... -
Do you mean using the subform as a continuous form and have it automatically link to the base information? I want to make sure the multiple root cause categories are all linked to one change request....Leave a comment:
-
Question about multiple instances of a subform
I have a database where I'm trying to do some root cause analysis on design changes. Each design change could have multiple root causes associated to the change. I'd like to try to setup the data entry form into a section that has the base information about the design change (ID, person responsible, date issued, etc.) and then have a linked subform for the root cause (type, error origination, etc).
I know how to setup the form...
No activity results to display
Leave a comment: