Search results

Thanks DBguy that was it. learning so much, is easy to overlook a step. Next time I should remember it.

I have a combobox in a form, the table has all 50 states, but for now I would like to limit this list to just a few states. I have added a column called active. I have un checked all but a few states but in the combo box all the states still show up. I'm sure I have just missed a step. Can...

Redoing the (tblAthleticDirector) renaming to create as Contact table. Have created a table of the Titles (AD, Asst. AD, Head Coach ect.) when I add this to Contacts would I use the ID or the shortend title or long title (AD-1, AD, Athletic Director) ? Also from above "CID to link the contact...

Learned a long time ago from an old timer cut it big then sneak up on it. not the same as un-cutting but same idea.

Already have a form for the (tblSchools) or at least 95% anyway. I am bringing in data from a spreadsheet and find it easier to do this in the table. Once I have everything setup will use form to edit or add new.

Reply to both Crystal and zeroaccess. At least for now I will be the only one using this, may change but not likely. I find it easier to add data in the table, at least for now. However I am trying to develop sound procedures from the start. I find it better especially when this project starts...

Thank you, but that is still within the form not the table. I have just found out that I shouldn't be using a drop down within the table but to add it to the form. That is the problem I'm running into, I know just enough to be a danger. Jim

Some how I had a feeling that is what the answer was going to be. is there a good way to remove the drop down from the table? or will I need to re-enter the information? if I simply change the properties from lookup wizard to short text or would that just empty the contents?

Is it possible to add or edit information in a drop down list within a table. Example I have a table for cities, while entering information in a table I need to add a new city. do I need to open the city table and add, or can I add it to the table I am entering data in? I have found what change...

I have found both of these on your site, haven't started reading yet. Am working on another problem. This happened while I was still working, and would be deep inside the Pattern Systems database. I am not able to turn off my thoughts and am not able to get a really good nights sleep. It does...

Thank you so much for your reply. I have been looking it over for a while, and as you said there is a lot of information. If I understand correctly All AD's as well as Coaches should be in a Contact's Table. I could expand my current AD Table include Coaches and re-name it. However I will need...

Just starting to create a database, will include information about High School Sports. So far I have created a table with the school information, such as address, phone, fax, link to google map, website ect. Second table is for Athletic Directors. Including School, Name, E-mail, Cell Phone...

Hello my name is Jim Smith, and yes that is my real name. I am retired from years in the woodworking industry. many of those I spent as a Project Engineer and or Production Engineer. Used a program called Pattern Systems, it was basically a very large and complex database. I didn't create it but...