Search results for query: *

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

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

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

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

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

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

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

I’m making a coding database for a small doctor’s office and I want to print a report that prints only the records that the staff will be entering at one session. The data being kept is on multiple patients and multiple procedures so I want the data that we are working on that day to print I’m...

I’m making a coding database for a small doctor’s office and I want to print a report that prints only the records that the staff will be entering at one session. The data being kept is on multiple patients and multiple procedures so I want the data that we are working on that day to print I’m...

I'm trying to open a form from a combo box. I have a form with just a unbound combo box. in the after update event I have the code Private Sub cmbNEWPAT_AfterUpdate() Dim Criteria As String If Not IsNull(Me!cmbNEWPAT) Then Criteria = "RegistrationID = '" &...

I have a form with a job start date and a job end date, also I have a cmd button on the form which is made from a label thats prints a job report. When you click the button I want to check if the text box "job_end_date" if filled in and if not get a msgbox to put the date in. I cant...

I'm tring to open a form filtered by the selection of a combo box, this is the code used in the after update event Dim frm As Form Dim Criteria As String If Not IsNull(Me!cmbSelectEmp) Then DoCmd.OpenForm "frmEmployee" Set frm = Forms!frmEmployee...

I need help with adding titles. when i adding a title prtl file I can only see either the video or the title screen. how can i combine the two so i can see both?

I'm trying to come up with a time sheet for my database. What I have is a blank form with to sub-forms the blank form is called frmNewTime, the first form I put on this is a form I call frmTime this is just built from a query that gives the Employees name, it's a Continuous form with a command...

I've been running office 97 on my computer and wanted to install 2000 on the same computer. I did the install the right way, but now when I open any application in 2k it loads then when you try to do anything i.e.: type, click on anything the app. shuts down, my 97 still works fine. Thank you...

I've been running office 97 on my computer and wanted to install 2000 on the same computer. I did the install the right way, but now when I open any application in 2k it loads then when you try to do anything i.e.: type, click on anything the app. shuts down, my 97 still works fine. Thank you...

I'm having real trouble with this form… I have a form with a sub-form called "NewReservation" the form opens with patient information on the main form. The sub-form opens blank ready for data, this works fine. The problem comes in, with a command button on the main form the button is...

I have a small Doctor's office DataBase written on access 97 and I have two problems that are keeping me from finishing. The first is that I have form's opening from a form that I call "open" this is built from an unbound dropdown box that gets it's data from a query of patients names...