Search results for query: *

Hi! I've got a Patient_INFO table that has information about patients. The key is PatientID. I have a lastname, firstname, SSN, ect.... How can I design my table & forms so that the user can do a lookup on lastname? I'm not quite sure how to do that...but I think you have to build the table...

Here's my query: SELECT scheduledSurgery.anesthesia, scheduledSurgery.LOS, scheduledSurgery.suite, patientInfo.firstname, patientInfo.lastname, patientInfo.surgeon, patientInfo.coverdbyins, patientInfo.surgeon, scheduledSurgery.DOS, scheduledSurgery.TOS FROM patientInfo INNER JOIN...

Hi! I'm not sure if I can do this. I've got a main form, and I'd like to created a calculated field that sums some values in one of my subforms. Can that be done??

I have a form with TimeIN (short time) TimeOUT (short time) Elapsed Time ---> calculated field that is giving me trouble!! I thought I could use the DateDiff function: DateDiff ('h', [TimeIN], [TimeOUT]) But it's not working... For example if somebody entered the following TimeIN: 1:15...

Hi! I am trying to setup a Yes/No field as a control on a form. I have 2 tables patientInfo and scheduledSurgeries. On the patientInfo table, I have a YES/NO field called "coveredByInsurance". How can I create a lookup field on the scheduledSurgeries form that would take the patientID from...

Hi! I'm new to Publisher, and I've got the Office XP version. How is the easiest way to convert a catalog that was made with Publisher (a .pub file) to an HTML file? I would like all the text in the .pub file to be HTML text, and not a graphic. Is this hard to do??

Hi! I'm trying to do a report, and I added a combo box to pull in data from another table. Then when I ran the report and printed it, these combobox fields where in black boxes!! What's up with that?? Am I doing this right?

Can you hook a parameter query to a report? Ya know a popup box that you enter values in, and it does a lookup on those specific records, then spits out a report?? I think you can do this, but my Access books don't cover that...

My forms seem to be working correctly, but I am amazed, and I don't know how they work!! Where could I look at the SQL? I'd like to see what the SELECT statement is to pull the records (from a subform), I'd also like to see what the UPDATE or ADD statements look like. Just to be sure everything...

HELP!! Access is doing so much for me, I don't know where to look to see what I'm actually doing!! I'm using the Forms wizard I've got a form called surgeryProcedure It displays Surgeries & all the Procedures associated with it. There is a one to many relationship with the surgery and...

Hi! I'm wondering how to make this work... I've got a 1 to many relationship between two tables, and I'm trying to setup a subform. I've got a SURGERY table. There can be many PROCEDURES for each surgery. I've got a foriegn key into the procedures table. HOW do you setup a subform that only...