Search results

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...

Thanks Doc Man for your help. Right now i'm trying to figure out in the appointments/meetings table with a start time and end time of the appointment on how to make it so that someone can't select a time anywhere between the start and end time. For example, let's say i made an appointment...

Hi, i am trying to figure out the best way to build a form based on doc man's suggestions. ANy ideas as to building the form/sub form with tblPerson and tblClients? the same goes for tblPerson and tblDoctors and business contacts. Thanks! Joso

Thanks doc for pointing that out, i originally had a person table, but a friend suggested the other way. luckily i still have a copy of the old one lying around. I just wanted to note so that we are the same pace here. The three types of roles are all like customers. A nutritionist is...

hi everyone, i sort of run into a dead end trying to figure how to structure this. I have three tables for the 3 roles, tblClients, tblDoctors, tblBusinessContacts, each with a Primary key and some unique information about each role. I'm not sure how i can track appointments to each of these...

thanks doc man for replying. Holy moly, that looks tough. I will do some research on this. What would you recommend me doing? The cascading combo boxes is easier to do, i've seen some samples. I should just change the concept about a refferal source, usually people have one main referral...