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
DB Structure Question by wallymeister
I have 3 tables (Models, Check Items & Parts) Models Table has fields; , , (e.g. 120 records) Check Items table has; , , (e.g 40 records) Parts Table has;...
(Multi-page thread 1 2)
April 3rd, 2009 08:29 PM
by Guy Go to last post
11 240
After splitting the performance is 10 slower.... by Lara
I got a new job, where one quite simple Access DB was placed onto the server with shortcuts of the whole! DB being placed onto app 5 PCs. Of course one of...
April 3rd, 2009 08:02 PM
by Ken Snell MVP Go to last post
3 169
Managing a glossary with multiple sources that apply to one term by mikahm1
Hi - I manage a glossary that is stored in Access. Each term can appear in multiple publications. Currently, all of the sources are stored in one field,...
April 3rd, 2009 07:45 PM
by John W. Vinson Go to last post
2 96
Populating Fields Automatically by dsmit13
Table field values. I would like to populate table2 fields with table1 field values when a chosen field is entered. e.g. I enter a serial number in table...
April 3rd, 2009 07:43 PM
by John W. Vinson Go to last post
2 97
Best Data Type for up to 12-digit Accuracy (up to 9 after dec poin by SH2008
Hi there-- I need to store numeric data that should be able to handle up to 12 digits with up to 9 digits behind the decimal point. Thus, Currency is out and...
April 3rd, 2009 07:31 AM
by Allen Browne Go to last post
4 107
many to many relationships by bpauley
Hello All, quick question that may lead to other questions. Can you have more than one many-to-many relationships in one database? If so, is there any...
April 3rd, 2009 02:06 AM
by John W. Vinson Go to last post
3 122
No "Attachment" option in dialog box scroll down Data Type by jarhead382
I want to add an attachment (JPG photo) field to a table, but there is no "Attachment" option in scroll down of Datasheet/Data Type.
April 2nd, 2009 08:57 PM
by Jeff Conrad [MSFT] Go to last post
2 123
Table Fields: conditional values based on another field in same ta by Jodi P
I have a table which includes the following fields: Course (text) Attended (Yes/No) Exempt (Yes/No) Exempt Reason (3 values in value list: Already Done,...
April 2nd, 2009 10:37 AM
by Jodi P Go to last post
1 95
Lookup Question by Brad
I'm relatively new to access, so bear with me as I try to explain my issue. I have 2 tables of interest. One table, I'm using as a lookup table and I have...
April 2nd, 2009 04:01 AM
by John W. Vinson Go to last post
1 139
Relationship setup - CAFM by vbcraft
Hi, Maybe someone can help me with a relationship setup for the following senario: I have the following tables, furniture, Building, Floor, and RoomCode. I...
April 2nd, 2009 01:07 AM
by vbcraft Go to last post
3 93
Access 2007 parent-[PARTIAL] child table by MikeF
Trying this again, please advise if clarification is necessary. Have one master called tblCompanies. This contains name/address/phone and other general info ...
April 1st, 2009 10:35 PM
by MikeF Go to last post
8 173
Here's a tricky one by Bill Neilsen
I currently have 2 identical databases running at different company branches. The data bases have multiple related tables, and because they are at different...
April 1st, 2009 08:49 PM
by Barry A&P[_2_] Go to last post
4 165
Why Index? by Andy
I am using a table with almost a million records and redesigning a database to run a series of queries which currently are very lengthily. Could someone...
April 1st, 2009 07:04 PM
by Jerry Whittle Go to last post
3 419
Duplicate Key Record Index Violation by news.microsoft.com[_37_]
I have a table with several thousand records where Access is informing me every time I attempt to save it or any data that there is a duplicate record in the...
April 1st, 2009 03:24 AM
by Allen Browne Go to last post
1 90
template-access2003 maken ? by paul[_10_]
1) Tabel-opmaak elders... ----------------------------------- Ik werk in dreamweaver met tabellen in dwt-extensie(templates) . Templatetabellen (later sjabonen...
March 31st, 2009 10:11 PM
by paul[_10_] Go to last post
0 71
Input Mask Wizard by paul
After creating a new entry in the Input Mask Wizard, how is it possible to delete an entry you no longer wish to use? An example would be an entry entered...
March 31st, 2009 03:44 PM
by Duane Hookom Go to last post
1 98
how do i extract the first occurance of duplicate fields by blackcat
I have fields set up as 'Title' and 'PubDate' there can be many pubdates for the same title, i would like to be able to pull off/quiery and report showing...
March 31st, 2009 02:44 PM
by Allen Browne Go to last post
3 105
What data type should I use to store latitude and longitude? by Nigel
I want to create a table storing the latitude and longitude of airports. What data type should I use to store a latitude or longitude ... such as 34° 3'...
(Multi-page thread 1 2)
March 31st, 2009 12:46 PM
by Fred Go to last post
10 181
data is repeating itself by tboyce
I have set up a DB for our Transport Managment Dept. Containing a main table holding our trucks details (Vehicle Details). I have created a Servicing,...
(Multi-page thread 1 2 3)
March 30th, 2009 09:03 PM
by tboyce Go to last post
25 355
switchboard design by Jblues5000
I have added pictures to my main switchboard. I need them to disappear form the other switchboards. What can I do?
March 30th, 2009 02:18 PM
by Fred Go to last post
1 99
Post New Thread


Display Options
Showing threads 1341 to 1360 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 11:57 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.