Event coding for a pivot table
Mon, 22 Sep 2008 21:26:00 -0700
Hello all
I need to have pivot table form where the values of the table are drop down
list boxes and have event coding.
any ideas on how I can do this in access ?
...
|
Database Compacting Function
Mon, 22 Sep 2008 19:00:00 -0700
Hi,
Microsoft VBA help provides the following code suggestion for initiating the
compacting of a database.
Function RepairDatabase(strSource As String, _
strDestination As String) As Boolean
' Input values: the paths and file names of
' the source and destination files.
' Trap ...
|
Forms Change size and location
Mon, 22 Sep 2008 17:01:01 -0700
I've got a form with subforms placed on tabbed pages. How can I see to it
that when I move from page to page they remain centered on the LCD? Also,
the size of the pages seem to change unpredictably. ...
|
Incorrect values returned
Mon, 22 Sep 2008 15:12:07 -0700
Access 2003
I have not been able to figure why I get different results when I use a
variable name as opposed to the variable value. For example, the first
instance gives the following incorrect values:
Dim cal_width As Single
Dim cal_space As Single
Dim buffer As Single
cal_width = ((6.5 * 1440) - bu ...
|
How to control a webcam in Access
Mon, 22 Sep 2008 14:53:01 -0700
First of all, I know that using links instead of embedded is better. I know
how to link a picture to a frame. What I don't know and I can't find out, is
how to control a webcam from MS Access 2003 and also how to save that pic to
a folder where I can use my actual codes to retrieve the picture. If anyone
...
|
Dmax Function
Mon, 22 Sep 2008 13:17:01 -0700
I have this code:
If [TDocumento] = 1 Then
DocID = "VD" & Year(DataF)
varMax = DMax("DocID", "FacturaVenda", "DocID like """ & DocID & "*""")
varMax = Val(Nz(Mid(varMax, 7), 0)) + 1
my database arrived at DocID VD2008999. Then, with this code, it created
DocID VD20081000.
The problem is that, ...
|
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. ...
|
