Updating data via email
Fri, 10 Oct 2008 13:06:01 -0700
I know how to send out the email to database contacts to have them update
their data but is there any way to further modify the form that is sent? Most
importantly, can you make it so that the responder can tab from one field to
the next? Thanks for any help! ...
|
Copy a record into the same table
Fri, 10 Oct 2008 12:12:05 -0700 (PDT)
Hi All,
i am trying to copy a record into the same table prior to updating the
original with a form. To achive this i am using the following code;
Dim fld As Field
With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.Recordset.AddNew
For Each fld In .Fields
...
|
Combo box Issue
Fri, 10 Oct 2008 11:46:22 -0700
I have a different problem. My Combobox shows the correct data and delivers the correct info to each field that gets filled after my selection. The issue is some of the fields are not visible. They are entered but invisible. ...
|
Sub totals on sub forms
Fri, 10 Oct 2008 10:21:02 -0700
Hi All:
How do I put totals on a subform. For example, I have an sales order form
with the order details on a subform. I would like the Quantity and Extended
Price of all the lines in the sub form to sub total for the order. Any ideas?
Ed ...
|
color codes
Fri, 10 Oct 2008 12:28:57 -0400
I've been give, by the client, a color to be ued as a form header background
(and a second for the menu form text). They aren't recognized by access...
The RGB numbers are standard stuff, the #___ is something that the website
guy uses(?)
Is there a way to translate them to something Access understands?
...
|
Alias or type of lookup question
Fri, 10 Oct 2008 15:00:49 GMT
I know this has probably been covered there but I wasn't really sure how to
phrase this so wasn't very lucky searching for an existing topic. And I'm not
really sure how to ask this to convey what I'm wanting to do.
I have values in a table, Field Name is Priority which contain L, M and H
(for Low Medium and H ...
|
Many-to-many on form
Fri, 10 Oct 2008 07:59:01 -0700
What is the best way to input data on a form in a many to many relationship
I have three tables:
Cell
CellID - PK, AutoNumber
Node
NodeID- PK, AutoNumber
Cell_Node
CellID - Number Long integer, PK
NodeID - Number Long Integer, PK
Cell and Node both have their own forms. Node will become a subform of C ...
|
|
|
Form to look for similar addresses
Fri, 10 Oct 2008 14:45:25 GMT
Im trying to create a form that will look for similar addresses to one
entered and allow the user to choose from those addresses or use the original
address that they entered. My database stores information on businesses, the
businesses are organized by address. I have a addresses table and a
businesses table, o ...
|
Dfirst and DLast function
Fri, 10 Oct 2008 14:29:43 GMT
Hi,
Can anyone tell me how to get the first and the last record on field 'date'
of my table 'table1'? I can't find it in help menu in my Access. Thank you
in advance.
KF
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200810/1
...
|
Form Control Default property problem
Fri, 10 Oct 2008 11:14:45 +0100
Access 2003 (SP3).
I have a Continuous form as a subform on a main form. The Continuous
form has several bound controls, i.e. Text, Currency and Date/Time.
The Default property of the date/time field is set to =Date() as I
want today's date inserted when the user starts a new record.
I have set the form's F ...
|