Transferring list items between combo/list boxes
Mon, 22 Sep 2008 12:59:01 -0700
I have a multi-select combo populated by a multi field query. I want to
transfer 2 fields (key and name) from selected items to a list box. I can
transfer the key but cannot figure out have to copy the other field. I
looked at QueryDefs but didn't find anything on how to accomplish this. Any
ideas?
Th ...
|
Access 2003 VBA Code
Mon, 22 Sep 2008 11:59:00 -0700
How do you write records from a temporary table to a permanent table.
I have a one to many form where I am trying to have the user select which
task code they want for a given task. These are in a subform. The subform has
63 DSR codes that will display on the screen. The user has 5 check boxes to
select task ...
|
using lib files?
Mon, 22 Sep 2008 09:59:02 -0700
In order to provide certain functionality to my projects, I've been directed
to the Internet and come across code that has following format for function
and sub definitions declarations:
Private Declare Function myFunction Lib "xxx.yyy" Alias "myFunctionA"
(ByVal...) as ...
What does this do? I haven't b ...
|
Yes - I want duplicate records
Mon, 22 Sep 2008 09:07:01 -0700
do to space limitations, I had to create a popup which enters additional data
into the main table one of my forms references. However, when I use the
Duplicate command, it only duplicates the data visible on the main screen -
and does not duplicate the added information which has been saved to the
record. ...
|
EXTEND mode??
Mon, 22 Sep 2008 07:21:01 -0700
I have a user complaint that if they press F8 while in Access, it goes into
EXTEND mode, and will not accept entered data until you hit the ESC key. I
have a couple of questions:
1) What the heck IS Extend Mode?
2) Can that F8 key be "turned off" (ignored)?
Thanks!! ...
|
vba help
Mon, 22 Sep 2008 03:04:02 -0700 (PDT)
i need to sort each individual value in the first column (employee
name), take the total salary from another column, and perform certain
calculations on this data. i need to do this automatically for each
unique employee in the employee column. is this possible? ...
|
using a hyperlink in outlook to open a specific record in ms acces
Mon, 22 Sep 2008 02:29:01 -0700
Does anybody has any sample on how to open an access db and open a specific
record that is specified in the line argument of the cmd function? I have
created a routine in access that send an-email using outlook automation but
the only thing that remains is the hyperlink that needs to open a form with a
speci ...
|
|
|
OpenForm ignores query
Sun, 21 Sep 2008 22:54:00 -0700
Hi:
I have a button (btnAddServices) on a form which opens a linked form
("SERVICES") using 'OpenForm':
Private Sub btnAddServices_Click()
DoCmd.OpenForm "SERVICES", , qryGetServices
End Sub
The qryGetServices has 2 parameters which the user is supposed to enter (if
I open the query on its own, it ...
|
using msg box to advance to new record
Sun, 21 Sep 2008 07:11:01 -0700
wow, i'm back for more advice. the problem I have is that after completing a
search for a specific record and not finding it, how do I get the code to
advance to a new record instead of staying on the last record in the record
set. I'm using the following code to look for a record:
' Find the record t ...
|
Calculate an amount for a group of records based on number of reco
Sat, 20 Sep 2008 22:11:01 -0700
I have an invoice form and the amount of the invoice is to be shared between
a number of employees. THe employees to receive a portion of the invoice are
listed on a subform on the invoice form. I am getting a count of the number
of employees on a particular invoice. When I calculate the invoice I can
calcul ...
|
