Search results for query: *

I think i'm going to try that thanks alot.

I have a small doctor’s office database, and on it I have a form called frmCHART that opens with the patient name and info, in the detail of that form I have a tab control with 4 tabs with other forms on them. I would like to change it a little and get rid of the tabs for command buttons that...

Thanks that was it I was looking at this too long.

I have a form with a subform and I have a commanf button that is used to open another form called "frmORDERS". This form opens from records from a query called qryORDERS, and I want the query to show the record that I was Working on. So I want to pass the Criteria from the form and subform. The...

Thanks for the replies I'll give it a try, let you know what happens, Thanks again. Tom

I know this is a pro forum but my trouble is in xp home. I do some work for a small co. that is running xp home on two computers and the owner of the co. thinks he knows about computers. I had the users set up as limited with an owner account as the administrator. He tried to install a program...

Thanks I thought a function would be the best way to handle this

Actually the form is a form with 3 sub forms attached to it; the form works like a POS transaction form and returns allot data from the database. I can’t make the form from a query because of the data entry needed on the form. I just wanted to add the results from the query sort of like an...

I have a doctor’s database and part of it is a patient close out form. On the form I want to have a field that shows the patient’s opening balance. I created a query that calculates by patient the sum of the procedure charges and the sum of the patient payments, and an expression field that...

Thanks AceMan!!!

No I can't do that because I want to be able to add one record that goes with the registration record. What I don't want it to do is go to a new record after you put in the info for the insurance that goes with that patient. The form opens for data entry. Tom

On my database I have a form with a sub form and I'm Trying to stop the sub form from adding a new record After entering the last field. Because of the settings on my tables you can not have two records with the same patient id number. So I was trying on the after update event on the co pay...

I have a database that I have been running for a couple of years with not much trouble. But a couple of days ago I've been getting an error message just on two of the forms with command buttons that print reports from the form were working on. The message that come up if The instruction at...

I’m working on a doctor’s data base and what I’m trying to do is. I have a form named frmVISIT this form has a tab control on it and there are 4 tabs and the four sub forms are forms built from queries with the PROCEDURE_ID as the criteria. These forms are continuous Forms so a visit can have...

What I did was make a table that keeps my data for my appointments this keeps stuff like patient data, and date of appointment, which is the field that I want to query the info by. Then I created a unbound form and added the calendar control to it and I also added a text box just to keep track...

I’m reposting this thread because I’m not sure if I asked the right question before, I’ve been away and hadn’t had time to work on this database I appreciate the response I received but it was not really what I was looking for. I want to make this schedule form with a calendar on it and keep...

I have a small doctor’s office database and I want to add a scheduling program to the database using a calendar control. Never using this control before I’m not really sure how it works, but what I was thinking is that I want the control to be on a main form with a sub form attached to it...

Thanks for the quick responces I will try everything you said and let you know what heppens. And thats what I think I did i know not to do this anymore Thanks again

I have a coding database that I’m building for a small doctor’s office; I was just about done with it when something strange happened. I was working on the design of the forms when any form with an Event Procedure associated with it produces an error. The error comes up and reads “Error...

Thank you that's the way i'm going to handle it. thanks again Tom