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 Replies Reverse Sort Order Views
question for veteran Access users database plan by Zambi
My question is for you veteran Access users. I’ve never made an Access database—I was just given this assignment last week and I’ve been teaching...
(Multi-page thread 1 2)
June 4th, 2008 11:41 PM
by Evi Go to last post
13 269
Aliases or synonyms fields by Dennis
Hi I'm using Access in XP Office Pro w SP 3 on Xp Pro w SP3. On other db's I used I've been able to create alias or synonym fields for a given data field. ...
(Multi-page thread 1 2)
March 18th, 2009 10:03 PM
by Dennis Go to last post
13 330
Main form and subform by Beeyen
Good Day, Let me try this one again; I have a master form with several Tabs and Subforms. In the master form there is a field called Work Category (a combo...
(Multi-page thread 1 2)
April 20th, 2009 04:28 AM
by tina Go to last post
13 237
Lookup to show on form by Elizabeth
I have a table with zip code, state, city, and county. The ZipID is used as a lookup in another table. How do I get all four columns to show on the form? ...
(Multi-page thread 1 2)
June 26th, 2009 07:45 PM
by Steve[_72_] Go to last post
13 211
Normalization by lmcc007
I am trying to create a job tracking database. I have the company information in a separate table. And I created an event table to store all the...
(Multi-page thread 1 2)
July 5th, 2009 08:22 PM
by lmcc007 Go to last post
13 1,220
Defining 2 foreign keys out of the same Primary key by Mishanya
I have tblDestination (DestinationID and Destination fields) and tblRoot (From and To fields among the others). I set DestinationID as a foriegn key for both...
(Multi-page thread 1 2)
August 14th, 2009 03:31 PM
by Duane Hookom Go to last post
13 309
Second Thoughts on Normalizing by oldblindpew
I'm having second thoughts on normalizing my Insurance information. I thought I had a good theory this morning, but am having problems fleshing it out. ...
(Multi-page thread 1 2)
August 31st, 2009 10:50 AM
by Keith Wilby Go to last post
13 210
Table design help! by Hannah
I'm a bit of an access novice (training on basics, searching for help on the rest) building a database for a research project. I've tried having a wee look...
(Multi-page thread 1 2)
November 18th, 2009 02:10 PM
by Fred Go to last post
13 647
Avoiding Redundant Records by oldblindpew
It is my understanding that surrogate keys are generally recommended to ensure uniqueness of records. Is it not true that using surrogate keys implies...
(Multi-page thread 1 2)
January 28th, 2010 07:14 PM
by BruceM via AccessMonster.com Go to last post
13 676
Image ctl causes bloat when using text field to store path/filenam by Pete
I am using Access 2003 db (2000 format) to manage photos. I have a form/subform where the subform (Single Form) displays the photo for the current record...
(Multi-page thread 1 2)
March 9th, 2009 06:29 PM
by Gina Whipp Go to last post
13 290
Using Lookup fields by DumbWithData
Is it bad design to use the lookup field data value in tables? If so, why? Is it better to use these in forms?
(Multi-page thread 1 2)
January 30th, 2009 11:07 AM
by Keith Wilby Go to last post
13 292
LOOKUP Tables: How Do I Design and Join Them Properly? by T. Hulot[_2_]
This message is for John, but, of course, I'd like anyone to respond. John, I'm having trouble understanding the lookup tables concept that you described in...
(Multi-page thread 1 2)
April 2nd, 2008 05:49 PM
by John W. Vinson Go to last post
13 232
Database running over network runs extremely slow by Nicholas Scarpinato
Hello. I have an Access 2007 database that is currently used by three to five people. I have an unbound entry form that is used to enter data, and on this...
(Multi-page thread 1 2)
April 10th, 2008 03:33 AM
by David W. Fenton Go to last post
13 252
FE/BE question by Golfinray
I am ready to split a database. I know the general rule is for the FE to be loaded on each users computer. However, my question is, if all the users will be...
(Multi-page thread 1 2)
June 1st, 2008 01:35 AM
by Tony Toews [MVP] Go to last post
13 230
Generate account numbers with Auto number by Jacqueline
Access 2003 question: Does anyone know how to set up an automatic account number generation in Access? I suspect that it can be done with the Auto number, but...
(Multi-page thread 1 2)
August 11th, 2008 10:39 PM
by Graham Mandeno Go to last post
13 403
tables with lots of zeroes by buggirl
Hi everybody, I'm trying to design a table for my invertebrate data. I have many samples and over 70 taxa identified. However, most of these taxa are rare...
(Multi-page thread 1 2)
August 28th, 2008 11:39 PM
by Graham Mandeno Go to last post
13 235
Linking DataBases by Maurício Paiva
Hi! I have 4 spreadsheets that are filled by 4 different users. I am not an expert in Access but I created a Database and linked all of these 4 spreadsheets...
(Multi-page thread 1 2)
September 26th, 2008 06:52 PM
by Maurício Paiva Go to last post
13 315
Bulk Update To Db Tables by Hoop
Hi, up to now I have been using a single master table for my inventory, with all of the duplicate date. I have figured out how to split the table so that it...
(Multi-page thread 1 2)
November 14th, 2008 07:08 PM
by John W. Vinson Go to last post
13 313
setting up access to remote desktop features from within access by mike147z
I have created a nice little database that reflects a floor plan and has a button to provide info about each computer. I am want to further enhance this by...
(Multi-page thread 1 2)
January 14th, 2009 06:49 PM
by Clifford Bass[_2_] Go to last post
13 218
Order Entry type form to add to three tables by CuriousMark
I have been working on this database for several years, learning as I go. However I have been stuck on the problem of the best way to design a form for data...
(Multi-page thread 1 2)
February 12th, 2010 07:42 PM
by Jeff Boyce Go to last post
13 416
Post New Thread


Display Options
Showing threads 341 to 360 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 03:16 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.