Create combo box in table properties
Tue, 09 Dec 2008 21:32:19 GMT
Brand new with Access. Just started making a table. I want a combo box. I
chose combo option in the properties but where do I enter in the info that I
want in my combo box?
Thanks
shannon
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
...
|
Recording old value after a change
Tue, 09 Dec 2008 21:03:12 GMT
Ok I can do this at any point but want to minimize the number of stored
records in the notes field.
I have a user driven db that uses logins to track a lot of what goes on. I
am trying to track if a user changes a record from one person's ownership to
anothers. Currently I have this code.
Private Sub Sale ...
|
Creating a command
Tue, 09 Dec 2008 20:50:17 GMT
Brand new with access-
How can I create a command in datasheet form to open another form? Is this
possible? I tried doing the command in datasheet view/form but it didn't work.
I'd like to create a command next to each person's name. So if I clicked on
their last name in datasheet view-it'd open to a new for ...
|
Very strange subquery field disappeared with a filter
Tue, 9 Dec 2008 11:32:16 -0800
Hi all,
So I have this search filter that functions with a text field and button on
a form. The code, which works, is as follows:
The issue, however, is that when the filter is on, the data in the two
fields that are actually subqueries in the recordsource query
[expClientMainName] and [expClientFirstName] ...
|
MsgBox replacement - procedure flow
Tue, 9 Dec 2008 19:22:52 -0000
Hi,
I have an Access 2003 app where I want to replace the standard Msgbox
function with the ability to show a message in a popup form which can be
customised. My question is: how do I suspend execution of the procedure at
the point that the MsgBox form is opened, and then return to that point once
the msg ...
|
Filter a listbox based on the value of a combobox
Tue, 9 Dec 2008 11:14:05 -0800
I have a form with a combobox (combo1) and a listbox (list1); the controls
are unbound and the row sources are two different tables with a common field
(system_id). I would like to use the value chosen in combo1 in a subquery to
make up the "where" clause of list1, but I am not sure quite how to
accomplish ...
|
Determining Whether a Specific String Exists in a Field
Tue, 9 Dec 2008 09:01:36 -0800
I want to determine whether a specific string of letters exists in a field
on the current field.
How is that done?
...
|
|
|
By Code, Is A record being Edited by another user
Tue, 9 Dec 2008 07:40:18 -0800
I have a multi user system "Shared" "Edited Record" are set and I do get the
message that says another user is updateing the record already. However, the
user does not like that. What they want is not to be able to enter any text
into a field if someone else is currently editing that record. Is there some
...
|
How to align a text in an email
Tue, 09 Dec 2008 15:04:49 GMT
Hi,
First of all thank you so much in advance.
I am doing a mass mailing using access 2003.
I have this code which works great. When the email is sent the .HTMLBody
appears in one line. I want the email body to appear like the following:
Center the first line "The Next......"
Leave a blank line
Cente ...
|
Button to backup
Tue, 9 Dec 2008 06:25:18 -0800
I need to backup the database, Candidates, five days a week. I would like to
have a button to press which will backup Candidates to "J:\bak\Backup (Tue)",
"J:\bak\Backup (Wed)", etc., so it needs to determine the current day and
execute the backup.
Thanks MUCH! ...
|
