Pop-Up Form for Contact Info/Address

[marisacoul]

Hi,

I'm creating a database for my company and would like to restrict the entries for the address fields. I want the user to click on any cell in the address column and have a dialog (see below) pop up prompting them to input very specific info, then I'd like that info to appear in the clicked cell in any one of the two formats:

Scott Brown
10 Mill St.
Cityville
ON
L6H 12J
Canada
555-222-3111
scott.brown@notrealemail.com

OR

Scott Brown, 10 Mill St., Cityville, ON, L6H 12J, Canada, 555-222-3111, scott.brown@notrealemail.com

I have already created the pop up form (see below). Please help! I am very inexperienced at this sort of stuff

Marisa

[ranman256]

If you are looking at a continuous list,the following code will open the pop form:
docmd.openForm "frmAddr",,,"[ClientID]=" & me.id

the form will have fields locked except the address.

[orange]

marisacoul,

Welcome to the forum.
Do you have a clear description of the business/processes your proposed database will support?
Just suggesting you get your analysis and design under control before jumping too quickly into physical database. You can make some sample prototype forms/tables etc to confirm your analysis and to get feedback from those requesting your project.

It appears you may have an Excel background, and I assure you that relational database is a different animal.

Good luck with your project.

[marisacoul]

If you are looking at a continuous list,the following code will open the pop form:
docmd.openForm "frmAddr",,,"[ClientID]=" & me.id

the form will have fields locked except the address.

Okay... where do I put this code? Keep in mind I'm veeeery new to this. And I don't really want all the fields locked... I'd like the user to be able to fill in all the boxes as shown in the image, and for them to be separated by commas, if possible.

Thanks for your help!

Marisa

[marisacoul]

marisacoul,

Welcome to the forum.
Do you have a clear description of the business/processes your proposed database will support?
Just suggesting you get your analysis and design under control before jumping too quickly into physical database. You can make some sample prototype forms/tables etc to confirm your analysis and to get feedback from those requesting your project.

It appears you may have an Excel background, and I assure you that relational database is a different animal.

Good luck with your project.

Hi, yes, it seems like a big undertaking but the database is actually very simple... just a few columns with attachments, dates, addresses and contact info, etc. It's almost finished except for these dialog boxes. The address boxes for our previous database (excel) were very messy so I'd like something standardized if possible.

Marisa

[orange]

Marisa,

the database is actually very simple

Can you show us your table(s) design?

[Micron]

Being new, one tends to use phrases that confuse the rest of us (OK, maybe just me) because Access doesn't have "cells". Does this I want the user to click on any cell in the address column mean you are allowing users to work directly in tables? This is not advised.
Does this I'd like that info to appear in the clicked cell mean that you want all this info

Scott Brown
10 Mill St.
Cityville
ON
L6H 12J
Canada
555-222-3111
scott.brown@notrealemail.com

in one "cell"? Again, definitely not advised if I understand the connotation of "cell".
Being entirely new, you are poised to cause more grief for yourself if you don't get some background in relational databases. I liken it to a 12 year old driving a car. He/she has enough information to embark on such an endeavour, but the outcome is not going to be pretty.
We can provide you with lots of links if you're open to doing some homework.

[marisacoul]

Marisa,



Can you show us your table(s) design?

Here you go!



Marisa

[orange]

Marisa,

I recommend you review some of the links here. Micron has offered good advice. Refresh some of the relational database concepts.

good luck.

[marisacoul]

Being new, one tends to use phrases that confuse the rest of us (OK, maybe just me) because Access doesn't have "cells". Does this I want the user to click on any cell in the address column mean you are allowing users to work directly in tables? This is not advised.
Does this I'd like that info to appear in the clicked cell mean that you want all this info
in one "cell"? Again, definitely not advised if I understand the connotation of "cell".
Being entirely new, you are poised to cause more grief for yourself if you don't get some background in relational databases. I liken it to a 12 year old driving a car. He/she has enough information to embark on such an endeavour, but the outcome is not going to be pretty.
We can provide you with lots of links if you're open to doing some homework.

Hi there,

My apologies for the confusion. I'm still thinking in terms of Excel. I don't think I'll have them working directly into the spreadsheet, maybe something like this...



But still I'd like inputting the addresses and contact info to be more standardized so that people don't, for example, forget to put in a phone number or something. I know I could put address 1, country, province, etc. into different columns but I was trying to simplify it/reduce scrolling... can we input the data into the form and have it show up as a string (separated by commas)? Would it require a lot of reading to figure this out?

Marisa

[Micron]

I don't think I'll have them working directly into the spreadsheet

I didn't say spreadsheet, I said "tables".

I know I could put address 1, country, province, etc. into different columns but I was trying to simplify it/reduce scrolling..

And so you should put things into separate fields - it is standard practice for several very good reasons. As for limiting what people can enter into tables, that is normal practice, but there are right ways to do this.

can we input the data into the form and have it show up as a string (separated by commas)?

You certainly can, but respectfully, I doubt you will be able to present a valid case for doing this. In all my years of dealing with Access, I have only encountered one case where this was necessary by design. I can't speak for anyone else, but I won't help you make things much more difficult for you than necessary. I say this because you seem bent on doing things that you will regret later on. Repeating: forget what you know about Excel - it will only lead you down the wrong path.

If you demonstrate a willingness to expand your rudimentary knowledge, then I'm sure we'll all be willing to help. But what may be worth noting is that many of us (me at least) won't teach you how to do bad things just because you want to do it and we know how - especially if it seems you aren't receptive to learning proper design fundamentals.

I have my own favourite link list which you can consider (or not) along with what Orange posted:
Normalization is paramount. Diagramming maybe not so much for some people.

Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/

Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.ca/...ng-part-i.html

How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/...cation-in.html

Important for success:
One source about how to name things - http://access.mvps.org/access/general/gen0012.htm
What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html

[orange]

Marisa,

As I read your posts, you are confusing data presentation with data storage. These are different concepts.
Get the storage structure/design under control, then work on the presentation/data entry mechanisms.

You have been provided with many well tested links.

Good luck with you project..