Continuous Form Programming Woes
Tue, 9 Dec 2008 14:35:00 -0800
I have a continuous form in which I have a bound cbo which I use to select
the Proj Number. After the Proj is selected I need a secondary texbox to
display the ProjName.
I have tried various method but when I update the txtbox it updates all the
entries and not just the one currently being edited? I can ge ...
|
Having a button to open up the file where a document sits
Tue, 9 Dec 2008 14:23:00 -0800
Hi there,
I have a database that we track projects with. On our server we have a
specific location for each project (by project code) Is there any way to have
a button on the form that when clicked would either show you the directory
(somewhat like the search function) or would open up a new windows explore ...
|
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
...
|
