A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Database Design Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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 Go to last post
8 530
A Dropdown List that lists the queries in the database by Danny B
Hi, I've been searching the help directory but to no avail... Is there a way I can easily create a dropdown list in a form that shows the queries I've made in...
July 1st, 2004 08:25 PM
by Danny B Go to last post
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...
July 1st, 2004 10:12 PM
by Tim Ferguson Go to last post
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...
July 1st, 2004 10:26 PM
by Tim Ferguson Go to last post
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...
July 2nd, 2004 02:20 AM
by Rick Brandt Go to last post
2 305
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 Go to last post
3 547
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,...
July 4th, 2004 10:34 PM
by Eric Butts [MSFT] Go to last post
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 Go to last post
3 159
Access 97 forms crash when trying to add fields, labels, buttons etc. by Steve C.
I've been running and modifying 2 Access 97 databases for some years now. The application consists of a forms database and a data database. Current size of...
July 5th, 2004 09:43 AM
by Steve Schapel Go to last post
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...
July 5th, 2004 06:11 PM
by Jeff Boyce Go to last post
6 127
merging tables to remove duplicate functions by steven
Please excuse my poor explanation in advance, I am a self taught Access user with no programming background. I am re-designing tables within my company's...
July 6th, 2004 12:25 AM
by Steve Schapel Go to last post
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...
July 6th, 2004 03:42 PM
by Jackie L Go to last post
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...
July 6th, 2004 07:30 PM
by John Vinson Go to last post
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 Go to last post
6 125
setting relative path for linked tables? by [email protected]
I have a database that has linked tables to another database. I have an absolute path set right now, but will be distrubuting to customers. Can the linked...
July 6th, 2004 09:57 PM
by Joan Wild Go to last post
1 361
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...
July 7th, 2004 04:05 AM
by Ken Snell Go to last post
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 Go to last post
1 467
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...
July 8th, 2004 01:01 AM
by John Vinson Go to last post
1 371
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...
July 8th, 2004 09:09 AM
by Steve Schapel Go to last post
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...
July 8th, 2004 05:48 PM
by Tim Ferguson Go to last post
1 193
Post New Thread


Display Options
Showing threads 361 to 380 of 11610
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.