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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 13 of 13
Search took 0.06 seconds.
Search: Posts made by: TGC
Forum: Database Design January 28th, 2010, 07:20 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Here is the catch with that...

Sometimes when we are looking up prospective clients, we have all the info
for the company and the contact, but no info for the property. So if that is
the case, we...
Forum: Database Design January 28th, 2010, 05:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Hello again! Did you get a chance to review the questions from my 1/26 post
from this string?

Thanks again!

Ellen

"Gina Whipp" wrote:

Ellen,
Forum: Database Design January 27th, 2010, 12:18 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Haha....no problem. :) I am only in the office on Tuesdays and Thursdays
anyways so that is the only time I will be working on this.

Thanks again!

"Gina Whipp" wrote:

Ellen,

There will...
Forum: Database Design January 27th, 2010, 12:17 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

That is helpful. After reading Gina's response on that question I thought
about having some kind of autofill option where when the user starts typing
in the city name, the field starts filling it...
Forum: Database Design January 26th, 2010, 11:01 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Awesome! Thanks! I responded to a few things below. Put my answers in CAPS
so you could see them. Sorry, I hate CAPS, but probably best way to
differentiate on this string...

Thanks again...
Forum: Database Design January 26th, 2010, 08:26 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Hi Gina -

I had a chance to digest all your helpful info...

I have rewritten all the tables I think I need based on the info you
provided me. I have included a few questions next to a few fields...
Forum: Database Design January 22nd, 2010, 12:34 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Lots of info to process....my brain hurts! :)

Won't be back at work until next Tuesday. Will review info and respond
then.

Thank you again! The help is invaluable.

"Gina Whipp" wrote:

...
Forum: Database Design January 21st, 2010, 10:31 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Wow, thank you so much for your help! And I apologize for creating a problem
with other discussion group responders.

I responded to your questions.

tblProperty
pPropertyID (PK)
pCompanyID...
Forum: Database Design January 21st, 2010, 06:55 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Hi Gina -

I responded awhile ago, but it looks like my response never posted. I
apologize if this is a repeat.

It looks like you might understand what I am trying to accomplish with this...
Forum: Database Design January 21st, 2010, 06:05 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Hi Gina -

It sounds like you might be understanding what I am trying to do...

I have a bunch of prospective companies. And there are really 2 main models
I am looking at. One company with one...
Forum: Database Design January 20th, 2010, 01:49 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

Thank you for the feedback John. That all makes sense!

"John W. Vinson" wrote:

On Tue, 19 Jan 2010 12:21:01 -0800, TGC wrote:

I am new to Access 2007 and...
Forum: Database Design January 20th, 2010, 01:25 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

That makes sense!

Here is what I have so far based on what you started...

TblCompany
CompanyID
CompanyName
Street
City
Zip
Forum: Database Design January 19th, 2010, 09:21 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 51
Views: 1,283
Posted By TGC
Prospective Client Tracking Database

I am new to Access 2007 and recently reviewed all the online tutorials on the
Microsoft website and reviewed the provided templates (none of which fit my
needs). I understand the general concept...
Showing results 1 to 13 of 13

 
Forum Jump

All times are GMT +1. The time now is 12:46 AM.


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