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
Re-Seed in SQL Server by J E Jensen
Hello NG A continue from othe post. In an access database i have problems with the seed in a autonumber field. The autonumber field is used as a Primary /...
(Multi-page thread 1 2)
September 15th, 2009 10:24 PM
by J E Jensen Go to last post
12 250
Design question - one or many tables? by tc2004
I am building a DB for a medical study that collects data approximately every 6 months (lab values and imaging results). In addition to recording the...
September 15th, 2009 09:49 PM
by Klatuu Go to last post
2 150
Access 2007 Database Issues - Very Complicated by Novalith
Sorry I could not enter a more descriptive title, I am not sure if what I want to do is even possible but I know this is probably the best place to come for...
September 15th, 2009 09:28 PM
by Dale Fye Go to last post
6 294
Cross Reference two lookup columns by krumlov
I am working on a 2007 database of service providers in different cities. I have separate tables for services, cities and providers. In the provider table I...
September 15th, 2009 06:54 PM
by Fred Go to last post
4 206
Hyperlink field formating question by tstew
Hello, I have a field that I think would work well as a Hyperlink field but don't know how to format it correctly. Currently the field is TEXT with entries...
September 15th, 2009 06:48 PM
by tstew Go to last post
5 199
Attachment Field in Access 2007 by AngelShadow
Hi! I'm fairly new to Access (I'm on my seventh database) so forgive a fairly basic design question. I'm designing a database that will be responsible for...
September 14th, 2009 11:25 PM
by Bernard Peek[_3_] Go to last post
4 201
time management calculations when there are constant interruptions by bird lover
I'm a solo law practitioner, having used access 2003 and its predecessors on xp for many years. I don't know vdb. I created a basic todo-done form which...
September 14th, 2009 10:46 PM
by Fred Go to last post
3 179
Two tables, one link of date, multiple entries in one table per da by Harriet
I am trying to create a query to run two tables; sinle relationship of transaction date but one table may have multiple entries of a transaction while the...
(Multi-page thread 1 2)
September 14th, 2009 08:32 PM
by Harriet Go to last post
11 231
Subfields by PieterLinden via AccessMonster.com
Basic design is a table with (Phrase, Category) as the compound primary key (unique and required). What are you really working on? I spent seven...
September 14th, 2009 05:37 PM
by PieterLinden via AccessMonster.com Go to last post
0 144
Practice Management with Scheduling by JenniferM
I am creating a physician's practice management solution and I'd like to add "calendar" scheduling to it. Can anyone offer suggestions on how best to do...
September 14th, 2009 01:43 AM
by Duane Hookom Go to last post
2 193
Allow Duplicates by acss
i have a table for invoices and at times i receive a duplicate invoice number from another country. How do i set up a primary key (InvoiceID) and a secondary...
(Multi-page thread 1 2)
September 14th, 2009 12:25 AM
by Graham Mandeno Go to last post
19 307
Cross Reference two lookup columns by Ken Snell MVP
I'd suggest a table with these data fields: ProviderID (foreign key to Providers table) CityID (foreign key to Cities table) ServiceID (foreign key to...
September 13th, 2009 01:48 PM
by Ken Snell MVP Go to last post
0 105
Do I need a sequential primary key? by Webtechie
Hello, I am designing a guest database. Guests leads will be entered into the Guest Table each day. There should be about 300 leads entered into the guest...
September 11th, 2009 10:00 PM
by Fred Go to last post
7 184
Access 2007 "attachment" "Data Type" not an option by Shane
I'm attempting to add a field to my A2007 database that would allow for attachments (primarily word). But when i attempt to add the field, i do not get...
September 11th, 2009 07:43 PM
by Shane Go to last post
2 116
teste by Alexnadre Roca Billy Programa Crazy Shake
September 11th, 2009 04:01 PM
by Alexnadre Roca Billy Programa Crazy Shake Go to last post
0 72
My message keeps disappearing! by Clarendon
Hi I had a terrible time yesterday trying to post my question in Access forum. They just ket disappearing after appearing for a short time I posted dozens...
September 11th, 2009 03:25 PM
by Ken Snell [MVP] Go to last post
1 168
Problem with Query, Relationships and Reports in Access 97 by FMO902
I know.. I know... I am way behind the curve on versions of Access, however, my state government is holding me back. I am trying to create a simple report...
September 10th, 2009 08:44 PM
by John W. Vinson Go to last post
2 140
30 Questions & 300 Students by NFL
I'm sure I asked this same question in the past. Sorry for bringing it up again.... I did make some progress (thank you for your input!) I was able to...
September 10th, 2009 07:14 PM
by John W. Vinson Go to last post
5 142
Do I need a sequential primary key? by Webtechie
Hello, I am designing a guest database. Guests leads will be entered into the Guest Table each day. There should be about 300 leads entered into the guest...
September 10th, 2009 04:45 PM
by Webtechie Go to last post
0 124
Avoiding One to One Tables by oldblindpew
I cannot ignore warnings given elsewhere in this forum against tables with many fields and the temptation to break them apart into a series of one-to-one...
September 10th, 2009 03:36 PM
by oldblindpew Go to last post
0 94
Post New Thread


Display Options
Showing threads 741 to 760 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 12:00 AM.


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