Search results

Its really that first text box that is troubling for me. I have both of these websites that say start with a combo box and hide the ID field. I cannot figure out where or what to do without an ID. What am I missing form these steps that I can apply to having a text box instead of a combo box...

Start a new blank form, not based on any table. Add a text input on it to enter a zip code. <<---Doesn't this need a control source? Which I believe should be the actual ZipCode field in table zips? Add 3 text inputs for City/County/State. These will not have any control source.

Ok, I have combo boxes the if its not in the system they get asked if they want to ass and it takes them to an "Add A Whatever" form. I won't let them add anything directly in the form. But right now I am beyond confused where to even start. Am I putting a Dlookup or a Dcount? Do I put...

Would the zip code need to be a combo box that hides the pkZip and shows that zip code number only?

It has to be a button click? It can't just be an after update event from zip code filed? Such as, they type in the zip code then tab or click out of the text box?

"You change them to text inputs. Disable them (because they are for display purposes not for user input)." I live the Zip Code enabled because it is going to be where the type that to populate the other fields. Is that correct?

I'm sorry that was a typo of the zip code from above table. 14830 has an alternate city. So yes, I guess I am going to take those alternates and make them their own record in table Zips instead of trying to incorporate a Zip "Type". I do want the user to select if there is multiple choices...

Lol...I was asking you. Should I keep those columns? I was thinking I'd eliminate that column and just make those one of the options. So fo 1483 there would be two combinations in the zip code table. Then the Dlookup of greater than one would kick in. Is that the easiest?

This is how USPS classifies them..

I’ve got the fkZipCode into the table address. Yay me and double yay you for telling me how to do it. Tomorrow I will try writing the D lookup. I see in the Zip Code resource I’m using, they call cities that share a zip code either “standard” or “acceptable”. Would any of my coding or...

So I just went ahead and removed outnumbering from pkZipCodeID. it made the temp table fine. And I think I will be able to complete the other query from your instructions. Thank you for all that. BUT I have a different problem. When I make my New Zip Code table, I used Select distinct, so...

I did that and still get the autonumber error. both pkAddressID and PkZipID are autonumbers. Do I need to temporarily change one of these from autonumber? Wouldn't the temp table make its own autonumber field? Also, pkAddressID is not linked to pkZipID and it shouldn't be. Do I need other...

I don't mean to be dense, but queries are really hard for me. Am I typing: p_aid: pkAddressID and p_zid: pkZipCodeID into the "field" where it says pkAddressID in the query column?

"pkAddressID and pkZipCodeID" I tried just using these without rename to make table and I received a message saying resultant table cannot have more than one autonumber field. How do I resolve that issue?

" in the query bring down pkAddressID and pkZipCodeID and rename them 'p_aid' and 'p_zid'." Is renaming done in the query fields or is it done when I do Make Table?

I managed to get the query to build the zip code table. I had to use SELECT DISTINCT. My problem now is that I have to get that new field in table address to populate based on the new table zips. I tried following your instructions but just can't get it correct. Can you help me build the...

"Build a query with your existing tables, linked apporpriately. In the query designer bring down the appropriate field for each field in tblZips (ZipCode from tblAddress, City from tblCity, etc). Make it a Totals query (click the Sigma/Summation symbol in the ribbon) and GROUP BY every field and...

I am going to try this exactly as you have it written a few hours. I cannot thank you enough for getting me in the right direction. I am sure I will be back with more questions later. :):)

I'd always have the zip code entered first. I do like your suggestion that we could build on our existing zip-city-state-county option without having to dump a bunch of useless zip codes in there. As far as building tblZips, how do I populate it with every existing combination? I have Only...

Also....what about my table address? It will still need to show city state county zip? Or would it just show the fk to the zip code field? Wouldn’t that be confusing? Right now my address table shoes the fk to each city, state, zip so if I need to see names in this table, I can.