Search results

Here is what I have, This is for our HR dept. to enter in employee health insurance information. I don't know what I'm doing wrong, I'm still kind of new at this. Ignore every other query except for main query.

Okay I have a question, I'm not sure if this is possible or not, but if it is how can i accomplish this? I have multiple tables (6) in a database that have one common field in all of them which is Employee_Name. What i have is, all of the tables combined with a query. Without having to enter...

well i think i got it. i went into the design view and changed the criteria to is null or is not null and it seemed to work. just have to wait and see if this is what they want for sure. thanks everyone for all of your help :D

SELECT Appointments.[Date of Service], Appointments.Patient, Appointments.ID, Appointments.Physician, Appointments.Phone, Appointments.Chart_Id, Immunizations.Patient, Immunizations.Sex, Immunizations.DOB, Immunizations.Chart_Id, Immunizations.Preferred_Provider...

Okay i don't know if this is possible or not. and if it is how it can be done i need to create a query that basically combines the two tables. if they have an appointment but no immunization, it still needs to show in the report (query). is this possible? thanks in advance!

well the information in the appointments table is from the scheduling system and the immunization information is from the electronic health records system so there could be multiple appointments for one patient. if that makes any sense. thank you for your help though! If there wasn't 13,000...

I'm not quite sure on how to go about this query.:confused: What I need to know is if a certain patient has had an immunization or not. I need one query to show the patients who have had an immunization and another to show the ones who have not had the immunization. I have two tables...

yes, i know, if i would've set up this database to begin with i would've used a form, BUT i just created a form for them to use instead. sorry for the stupid question post, that was my stupid moment for the day :p

What if the users do not use a form to enter data? and they enter it straight into a table?

Well since it wasn't the webpage, i knew it had to be the database. I fixed it though, i did the backup of the database and it works, so i need to go in and set it to compact and repair automatically. I didn't initally set up this database or i would have set it to do so already ;) it's just my...

Is there a limit on the number of records you can have in an access database? I've got one with 8500 records and it's been a PITA! I have a webpage on our intranet so users can go and enter their information to it, and they get a nasty error whenever they try to enter information. I'm trying...

Thank you :) I greatly appreciate everyones help with this!! :D

Okay so just to clarify, when say two or three people are in the database at the same time with the fe/be set up, if they're in the same table and editing or adding information, the information won't be lost will it? :confused: It is very imparitive that information from this database not to...

Thanks !! :) I'll check out that link. Thanks so much :D

Okay so i think i've figured out how to do the fe/be. Is it just a split on the database? If so, how "safe" is it?

Okay, so how can I go about setting up FE / BE ? :confused: I've tried looking up how to do it and haven't had much luck. Thanks in advance.

well is there a way to just change a setting or add some code somewhere to allow multiple users to do the above things?

Okay, i need to know if there is a way so that more than one person can be in an access database at one time. Both need to be able to edit, add, delete, etc. within the database. Is this possible? :confused: