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 ...
|
Auto name input
Tue, 16 Dec 2008 04:25:01 -0800
I would like to add a field in my form that will display a list of the user's
as the letters of the last name are typed i.e. auto find.
Is this feature available in access or must it be coded?
thx in advance for the feedback. ...
|
Conditional Formating or Continuous Form Record Formatting
Tue, 16 Dec 2008 03:10:06 -0800
Hi
I have another question.
I have a continuous form that I need to highlight certain records based on 2
or 3 criteria. If the criteria is met then all fields within the record (or
even the back colour of that record) must be changed to red.
I have the following fields on the form
fldStartBy
fldDea ...
|
