Can't filter a recordset
Thu, 2 Oct 2008 08:06:19 -0700 (PDT)
Dim stString As String
Dim rs As DAO.Recordset
'lintLastRecord is a public variable where the key record number
to be found is located
If lintLastRecord = 0 Then 'do nothing
Else
Set rs = DBEngine(0)
(0).OpenRecordset("qryModifListaAssociacoes")
rs.Filter = "lintAssoci ...
|
Trapping negative values error in subform
Thu, 02 Oct 2008 15:01:42 GMT
I have a subform pulled from the table tblSub and a main form pulled from
tblMain. Both tables are linked by child and master relationship (using the
field items). My main table consists of items and type of wares. While my
subform (in datasheet view )consists items, date, purchased qty and consumed
qty and a u ...
|
Trapping negative values error in subform
Thu, 02 Oct 2008 14:58:30 GMT
I have a subform pulled from the table tblSub and a main form pulled from
tblMain. Both tables are linked by child and master relationship (using the
field items). My main table consists of items and type of wares. While my
subform (in datasheet view )consists items, date, purchased qty and consumed
qty and a u ...
|
Movement within a List Box
Thu, 2 Oct 2008 06:38:02 -0700
I have a List Box on a form. I want to go to the record "Black". I type a
"B" and it goes to the first record beginning with "B" (not Black). I type a
"L" and it moves to the first "L" record. Is there a way using code that
will take me closer to "Black" when I type "BL". Any help appreciated. ...
|
Quick Key
Thu, 2 Oct 2008 03:27:01 -0700
Hi
I would like to create a "quick key" to allow my user to navigate quickly to
the field "NewNotes" in my form "FrmContacts"
How do I do this?
TIA
--
Sue Compelling ...
|
Automating form
Thu, 2 Oct 2008 02:52:00 -0700
I have a access database which is being used for data collection. The problem
i am having is on one of the forms that is being used for the data collection
thier is a section that only has to be done every tenth unit. I have tried to
write code so that the form has that section with a line thought it if it is ...
|
ComboBox List Limitation 65526
Thu, 2 Oct 2008 00:00:05 -0700
Good Day to one and all.....
I have a delema. The traditional type as you go search has been a wonderful
control, but now I have over 100,000 parts to look at and have tried to write
a new search which would work the same as the original box but search the
whole list(show a range of parts in the drop portion). ...
|
|
|
How to use the "What is this?" feature in custom help?
Thu, 02 Oct 2008 03:25:32 GMT
I´m building a professional looking Access 2003 application to distribute,
and I´m using my own custom-built help file (built by HelpNDoc - which is
free and excellent!!). I trap the F1 key and instead make an API call using
the following code.
Declare Function HtmlHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" _
...
|
Form Not Closing with Code
Wed, 1 Oct 2008 16:00:13 -0700
I am new to Access 2007. I have build a form that allows a user to view
projects that are either open or closed. The OnClick event for open projects
I have this code:
DoCmd.OpenForm "fProjects", acNormal, , "lngStatus = " & 0
and this for closed:
DoCmd.OpenForm "fProjects", acNormal, , "lngStatus = " & -1 ...
|
Avoid nulls in Combo box
Wed, 1 Oct 2008 12:22:02 -0700
I have a form that displays Customer information with subform that displays
receipts for each of those customers. I have 2 combos on the form, one of
which displays Business name, the other which displays Contact name. This
way, users can look up records based on either of those names. The problem
is that ...
|
