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

Help: Access2k



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2005, 08:17 AM
Dungeon Raider
external usenet poster
 
Posts: n/a
Default Help: Access2k

I'm trying to set up a contact database for a salesperson who is
canvassing businesses in certain areas. I have three tables.... Main,
Suburbs, Streets

Streets is basically just a list of relevant street names and an
autonumber ID as the primary key.

Suburbs is a list of suburbs with a autonumber ID as the primary key
and two columns of postcodes (the first being for street addresses and
the second being for postal boxes)

Main is where most of the contact information is stored... company
name, fax number etc. I have drop-down combo boxes for street name and
suburb which work perfectly well. However, I want the postcode to be
automatically looked up and entered into the main table when I select
the suburb. I've tried searching and found several sites offering help
but they all seem to skim over things and I find myself lost in no
time at all.

I also have a form to ease entry of data into the fields in the Main
table.

I'm using Access 2000 and if anyone could possibly explain just what I
need to do in clear, precise instructions it'd be appreciated.
Alternatively, I could zip the file and email it if anyone could
possibly fix it and email it back - preferably with explanation of
what you've done so I can follow the changes.
 




Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tooltips unvisible (Access2K / WinXP) Laban Twissel General Discussion 0 January 11th, 2005 06:27 PM
Converting Access2k forms to VB6 forms Jeff Using Forms 1 September 10th, 2004 01:21 AM


All times are GMT +1. The time now is 07:21 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.