Combo box LimitToList help needed, please
Tue, 26 Aug 2008 11:27:01 -0700
I am using Select Case on the AfterUpdate event of cboLocType to then filter
cboLocName based on a query with a Where clause for several different cases.
For example: cboLocType = "Body Shop", cboLocName would then show a list of
Body Shops which works fine. I also have an "Other" case that would be a
on ...
|
Memo Field Limits???
Tue, 26 Aug 2008 10:56:00 -0700
I am running into a problem with memo fields on a form.
A Memo field can store up to 65,536 characters, right?
Yet in a memo field in one of my forms, limits the field to 2,046
characters. Can someone tell me what's up? My guess is that this is a
"feature" of Access. Is there a way to store above this l ...
|
Clear Data in Subform w/o deleting in table
Tue, 26 Aug 2008 10:33:01 -0700
I have a form with a subform in datasheet view. My form pulls up vendors, my
subform pulls up products from those vendors and order#'s. When a vendor
stops selling us a product I would like to be able to clear it from the
subform, but not delete the record so that I can go back and still be able to
refer t ...
|
Option Group
Tue, 26 Aug 2008 09:02:01 -0700
I set up an option group on a form. However, I am unable to select eithier
of the items in the option box. Any ideas why this is happening?
--
stacie ...
|
how do i set an autodate on access without it changing?
Tue, 26 Aug 2008 08:48:00 -0700
basically im creating a database/form at work and need a automatic date in on
field for the day the record is completed. however this date has to remain
the same. any ideas how ot do it? ...
|
DCount Error 2001
Tue, 26 Aug 2008 08:31:01 -0700
I have a query that finds duplicate records in a table based on StdNo and
ProjNo - 2 StdNo can be the same, and 2 ProjNo can be the same, but the query
returns records where both the StdNo and ProjNo match. I have a module which
determines if this query is populated - if not, the table is exported to
excel. ...
|
Address Book buttons
Tue, 26 Aug 2008 08:24:05 -0700
I have seen some databases, like an address database, where within a form,
there are a column of buttons from A to Z which, when pressed, filter the
records in that database. Does each button have to be setup individually or
is there an easier method to get this functionality? ...
|
|
|
Newly entered item in Table not showing in Field List of form
Tue, 26 Aug 2008 06:55:08 -0700 (PDT)
Hello all,
I have and existing form that I need to add a field to. I added the
item to the Table that the form pulls from, but when I go back into
the form, the new item does not appear in the Field list for me to add
it to the Form. When I try to add it manually, I get the ?Name# error
in the text box. I' ...
|
REPOST - Combo box selection to give Specific Information to Query
Tue, 26 Aug 2008 13:00:29 GMT
Hello all,
My deadline is Friday, and this is one of the last problems I have - please
help!!!
I have a parameter form called frmDocbyDept that filters for the report
Documents by Department. On frmDocbyDept there is a combo box called cboDept,
an invisible text box called txtDept (after the combo box i ...
|
I am giving up: My form never worked
Mon, 25 Aug 2008 21:14:01 -0700
Hi,
I'm still struggling to organize my tables and fields and I still confused
regarding the relationship between tables. I'm a newbie to Access. This is my
first database and I fluctuate between feeling hopeful I can do this one
minute and despairing that I can't the next because I've thought of yet
anothe ...
|
