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
Can a field name start with a number? by Don Wiss
I have a table. My column field names are like 50xs50, 100xs100, etc. By when I issue a sql query like: Select Year,'100xs100' from RLLagMatrix; It give me...
(Multi-page thread 1 2)
February 2nd, 2005 01:36 AM
by Don Wiss Go to last post
12 292
Upload New Data Structure by Erica
Is there a way I can upload a new access database structure without overwriting all of the data inside the current database?
February 1st, 2005 11:18 PM
by John Vinson Go to last post
3 152
auto forcast 6 months on, from a completed task (access or excel!. by Steve Wilson (1780)
creating a vehicle servicing database (300 vehicles) vehicles have annual MOT and 6 monthly servicing intervals. Am trying to set up a database/spreadsheet...
February 1st, 2005 09:21 PM
by Steve Wilson (1780) Go to last post
0 225
February 1st, 2005 05:46 PM
by BB Go to last post
3 163
Access updates all files with the same name in diffrent folders by macindia
When I update an access file it also updates the same file name in other folders that I have to use as a test copy - why - what am I doing wrong - I cannot...
February 1st, 2005 05:27 PM
by Rick B Go to last post
1 135
Suppress Warning Message - DAO Insert by dave h
Hi, When using - DoCmd.RunSQL mySQL with an INSERT INTO............ How can I surpress the dialog box that asks to confirm the append? Thanks, Dave...
February 1st, 2005 04:17 PM
by Roger Carlson Go to last post
5 175
Not understanding M:M relationship by MCB
I have tblCategories, which was related 1:M to tblSubcategories. So, for example: - Category 1 had Subcategories A, B, and C - Category 2 had Subcategories D,...
February 1st, 2005 02:39 PM
by MCB Go to last post
4 208
February 1st, 2005 01:54 PM
by Jeff Boyce Go to last post
2 160
Time formatting question by Wylie C
I have a time field that I want to store hh:mm:ss. I can set the custom format to 99:00:00 and the user can input the time but no matter what I do the table...
February 1st, 2005 12:13 AM
by Rick B Go to last post
7 176
Group Permissions by Sam
I have a DataBase and a Replica. What impact will giving group permissions have? I want to allow two groups access to enter/modify data on a form and read a...
January 31st, 2005 05:33 PM
by Sam Go to last post
0 129
how to create a table automatically after a data is inserted? by Andre Bazin
Dear all, I have two tables, tbl_Student and tbl_DSSR. Each student needs to have their own DSSR table, which means, a student John may have a...
January 31st, 2005 12:28 AM
by Chris2 Go to last post
4 152
HOW DO I FIND NUMBER OF OCCURENCES FOR DIFFERENT LETTERS IN A FIEL by [email protected]
WHILE I AM CREATING A DATABASE IN ACCESS, I NEED TO COUNT THE NUMBER OF REPEATED LETTERS FOR EACH ROW. THE LETTER COUNT SHOULD BE PRINT IN SEPERATE FIELDS FOR...
January 30th, 2005 11:38 PM
by Graham R Seach Go to last post
9 281
table design by [email protected]
I am having problem with a table design. The table is for Quality measures. A couple of the attributes for the Quality measures table are the Company name and...
January 30th, 2005 07:56 PM
by Tim Ferguson Go to last post
3 151
In Access 2003 , how can I delete entries that I custom defined i. by dianecl1
I defined an Input Mask entry as !LL0-00 to achieve entries in a text field with a length of 6 to appear as EN1-80, etc. When I test the Input Mask in the...
January 30th, 2005 02:33 PM
by Jeff Boyce Go to last post
1 216
Difference between primary key and index by Amir
What is the difference between primary key and index in Access? If I define an Index field which is Unique and Not allowed Null, is it a the same as a PK?
January 30th, 2005 05:05 AM
by Chris2 Go to last post
3 150
Add Index Property To Temp Table by Larry R Harrison Jr
I have Access 97. I have a "tmp" table that is created in code via a query (or SQL statements), I then need to modify 2 of the fields to be index (dups okay)....
January 29th, 2005 06:42 PM
by Brendan Reynolds Go to last post
3 138
Auto Numbering by Craig B.
I am creating a data base and want to add a formula to my table so that when a form is filled out an automatic number is assigned to each new document. The...
January 29th, 2005 06:07 PM
by John Nurick Go to last post
6 230
problem with subform by Nuno Camarinhas
I have a database on Projects. I have PROJECTS that can have many participants, and PERSONS that participate in many PROJECTS. Therefor, I created: - a...
January 29th, 2005 03:42 PM
by Chris2 Go to last post
1 313
Linking an excel spreadsheet to a networked database by Joan
Can someone please tell me if there is a way to have more than one user working in a database when one of the tables comes from a linked...
January 29th, 2005 06:05 AM
by Joan Go to last post
0 108
Name database with up to six phone numbers per person by Dan
I'm looking to create a DB with a person's first, mi and last name and each person could have from two to six or more locations, phone numbers...
January 28th, 2005 10:27 PM
by Dan Go to last post
3 499
Post New Thread


Display Options
Showing threads 10061 to 10080 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 02:41 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.