|
|
|
Query Of Totals
Tue, 16 Dec 2008 11:36:25 -0800
I have a table that has some fields, â??typeMeetingâ?, (11 types of meetings),
â??NumberOfBooksâ?, NumberOfItemsâ?, â??NumberOfPagesâ?. I would like to create a
TotalQuery that gives me a break down for the totals numberofpages, books,
items for each type of meeting. Can this be done using 1 query?? Ca ...
|
Access, Outlook, and Word - Email Form Fill-In and db Update
Tue, 16 Dec 2008 10:27:01 -0800
REQUIREMENTS FOR EMAIL FORM FILL-IN AND UPDATE OF ACCESS DATABASE
1. Need individual recipients to review/update their â??contactâ? information.
Some, without email will respond to a mailed form. For those with email, an
on-line form fill-in with a reply that updates an Access database is
preferred.
2. Th ...
|
problem opening form
Tue, 16 Dec 2008 09:40:01 -0800
I have a main form that has a command button to open a form in data entry
mode. The form I am opening has entry fields at the top of the form and 4
subforms - set up as pages in the middle.
My tables are tblclient, with clientid as primary key and autonumbered. and
tbltxplanmh with txplanMHID as primar ...
|
Unhandled runtime errors kill form timer events
Tue, 16 Dec 2008 09:28:23 -0800
Does anyone have a decent way to deal with unhandled errors, which kill
globla vars and stop form timer events from taking place? I use unbound
forms (and temp tables) to keep alive some data points for reference, so
the global vars part is not so much of a problem. But I'm having a hard
time coming up with ...
|
use append in a form
Tue, 16 Dec 2008 08:06:20 -0800 (PST)
INSERT INTO tabl1 ( [TAG], [Date Received], DPS, [P/N], DESCRIPTION,
CITY )
SELECT parts.[TAG], parts.DATE, parts.DPS, parts.[PART NUMBER],
parts.DESCRIPTION, parts.CITY
FROM parts
WHERE (((parts.[TAG])=[enter the tag number]));
this is the sql for an append query that i have. i created a form that
would us ...
|
resizing msoFileDialogFilePicker
Tue, 16 Dec 2008 08:03:02 -0800
I have an app where I use the msoFileDialogFilePicker. I must have clicked a
maximize button in the corner, because suddenly it is full-screen, and there
is no resize button. When I close the app and reopen it, then try to use the
file dialog picker it opens full-screen.
Is there any way to get it back to ...
|
highlight the cursor position
Tue, 16 Dec 2008 07:25:00 -0800
is there a way to highlight the position of the cursor....for example if the
cursor is in a textbox, the textbox background would change to a certain
color. Now, if there are, say, 30 controls on the form, is there a way in
program to highlight where the cursor is. If the button has the focus it is
blue, i ...
|
|
|
Command Button to execute a Function
Tue, 16 Dec 2008 07:23:01 -0800
I have the following function that I want to execute onclidk using a command
button.
What code will run this (or any function) on click within a command button
Public Function AutoCompact()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and ...
|
Error 2105
Tue, 16 Dec 2008 07:13:01 -0800
This error is returning on occasion. I believe it's due to my code being
faulty:
Private Sub Form_Load()
If Me.OpenArgs = "New" Then
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End If
End Sub
Does anybody see what's wrong?
Thanks!
--
www.Marzetti.com ...
|
From 2003 to2007
Tue, 16 Dec 2008 13:55:53 +0100
Hi,
I converted my code from my previous 2003 version to the new access2007
version.
I get following error:
(I have to translate so could be a bit different)
error 13 during executing:
Types are not matching
The code:
Dim db As Database
Dim tb As Recordset
Dim kl As String, afd As ...
|
|
|
