Recent content by Joso

Hi everyone, i am creating a database by importing data from excel than normalizing it. In the excel spreadsheet thre is a full name field and want to import it into access by splitting it up into first and last name. Some of the data in the spreadsheet have middle initials. ANy idea on how...

i actually got what i needed to do. I used a query for the record source using a left join bringing all the records from tblperson to the other tables whether they are a client/doctor/business client or not. Created one form instead of using a subform, since it's a 1 to 1 relationship it...

If you take a look at my db, you will see that i can't disable close features. The way i have it setup is a left join bringing all info from tblperson into tblclient, this allows me to add people (like doctors and business contacts names) from tblperson to become a client without adding the...

I am wondering what would be my best bet. i validated everything i could possibly do as i used the mous trap sample on here with the save feature. This close or moving to a new record without subform information is the only problem. Myabe i should change my design a little? joso

the way my tables and forms are setup, is i have 3 forms, 1 for each person type, client, doctor and business contact, each haveing a seperate table linked to one parent table called tblPerson. Let's say i go into frmClient, everyones tblPerson info is there regardless of whta type of person...

If anyone has a solution for this, that would be great. I need some serious help on this. Joso

hi everyone. I am stuck in a dilemma. I have 2 tables: tblPerson PersonId LastName FirstName Title Gender tblClient PersonID Address City Email etc... 1 to 1 relationship On the main form i have a tab control with 2 tabs. On the first tab i have the tblPerson info which is part of the...

Pat, what about using a cascade combo box in the header? In the first combo box wil be a filter that has "CLIENT', "DOCTOR" and "BUSINESS CONTACT". Then in the second combo box will have the selection based on a UNION query. Will a union query work? In that union query i can bring the unique...

Hi, this is what my design looks like. I had to change doc man's suggestion a little bit. tblPerson fldPersID, autonumber, PK fldFirstN, text fldMidN, text fldLastN, text fldGender tblDoctors fldPersID, Long, FK ClinicID, FK Specialty Email etc tblClients fldPersID, Long, FK DOB...

I figured tblperson should hold the names instead of putting it in each role table. the fields in tblPerson are the only similar fields between the client, doctor and business contact. but all the othe rinformation in the role tables are unique. i didn't want to repeat the names if i where to...

I am trying to find some identifyer for the combo box along with the first and last name. Right now, i have the tblPerson info on the main form then a subform for each of the 3 tabs for the role tables, with each the tabs named "client info", "doctor info" and "business info". For the combo...

thanks Pat, i knew i can count on you. Thank you for guiding me in the right direction, i completely overlooked that option. So, on the main form i should have the tblPerson info? Then for the 3 role tables, have tabs? Would you recommend queries to bring the tables together or the wizard...

I thought it would be better to place a new thread since this is a form issue not a design issue.

Hi there, i recieved this design from doc man in the table design forum and thought since this is a form question i should post here: tblPerson fldPersID, autonumber, PK fldFirstN, text fldMidN, text fldLastN, text fldAddrLine1, text fldAddrLine2, text etc. tblDoctors fldPersID, Long, FK info...

I created a meetings table with the 2 fields starttime and endtime, both of them to a look up table too enforce rules of time. In the lookup i have a list of times 8:00am, 8:15am, 8:30am....evry 15 minutes so they can't enter an odd time like 8:23am. or even accidentaly type it in. Now, i am...