|
|
Location of Validation Text by
lkb
I am working with Access 2000 and need to add a NULL value to a validation rule to allow a specific field to be left blank in a table. I know I need to add...
|
June 30th, 2004 10:45 PM
by lkb
|
8 |
538 |
|
|
|
|
2 |
152 |
|
|
Group Sequence by
Marty
I have created several groups in my mdb as I was
developing it. Now that development in nearly done, I
would like to resequence the groups so that they are...
|
|
3 |
114 |
|
|
Select statement includes "AS xyz_ID_xyz" by
Eva at Work
I used the table analyzer on imported data. good.
Noticed that a SELECT statement on the imported data includes the term as noted in the subject line, as xyz...
|
|
1 |
983 |
|
|
My tables lost their AutoNumber fields by
Bill Nicholson
I ran an corrupted mdb through a third-party recovery utility and it
recovered the tables but it changed the AutoNumber fields to Longs, all 200
of them. Since...
|
|
2 |
312 |
|
|
Access 2002 import wizard issue by
Cato
Access 2002 SP3
When attempting to import from either an Excel spreadsheet or a CSV file the
wizard fails to function properly. Everything works fine except...
|
July 2nd, 2004 03:28 PM
by McKlee
|
3 |
580 |
|
|
Table Security by
David Tunstall
Is there any way that I can disallow users from importing
tables from my database into their own database. I have
it split into Data and Application databases,...
|
|
2 |
113 |
|
|
Hidden Table by
SN
I have 2 tables in my Access 2000 database which I gave
a "Hidden" attribute so taht users would not tample with
them. Now, I want to edit these tables, but I...
|
July 5th, 2004 06:13 AM
by Ernie
|
3 |
159 |
|
|
|
|
1 |
114 |
|
|
combining fields by
cutthroatjess
I'm trying to group a number of fields from one table into one separate field.
Basically, the table lists address information: state, zip, city, street. I...
|
|
6 |
127 |
|
|
|
|
5 |
105 |
|
|
Printing the relationships by
Shel
When I try to print the relationships in my Access
database, I end up with extra lines and box symbols in
the upper left corner of the print that don't show on...
|
|
1 |
74 |
|
|
Table row limitaiton by
Dean
I remember from Access 97 that there was a 200,000 row
limitation for a Access table. Does any know what the
row limitation is for Access XP (2002), or...
|
|
4 |
103 |
|
|
Validation Rule by
Lonz
I created a bankruptcy data, using Case Number as the Primary Key. I now need to know how to disallow duplicate Case Numbers. The Case Numbers are 8 digits...
|
July 6th, 2004 07:49 PM
by Lonz
|
6 |
125 |
|
|
|
|
1 |
370 |
|
|
Combo box accepting new entry by
Sharon
I am new to Access programming. My problem is I have a combo box that adds a new record to the underlying bound table. When I enter a new record I get "The...
|
|
1 |
147 |
|
|
Forms and subforms by
Randall
I have what a believe to be a fairly obvious use for
access. i.e a company contact list where the user can add
some data to each user and company.
Basically,...
|
July 7th, 2004 02:31 PM
by Chris
|
1 |
486 |
|
|
Want to eliminate Duplicate Values <> Null by
Ben
I know how to make a column prevent duplicate values with
an index; however, I have a column where many values are
null which is OK, but I can't use an index...
|
|
1 |
388 |
|
|
Autonumbers... by
Joe
I have a table with an autonumber field. I routinely delete records from this table and add new ones using code. Is there a way to reset the autonumber to...
|
|
3 |
206 |
|
|
Access File System by
gperson
Hey Guys, I'm trying to set up a data base for an office file system. We have alot of paper stuff here and we're trying to use access to help us file...
|
|
1 |
193 |