Recent content by stelioshania

You were right!!!! I made a simple report, a query and I used the last command you sent me ( patient ...AND....visitID .. was the crucial detail I needed) Now It works perfect!!!!!!! Thanks and sorry for being tiring. (this happens if you are a rookie!!!) Now I know where to find the...

This is exactly what I want. I will try and let you know. Thanks!

I found a way. I made a new blank .mdb database and then I imported external data from my new access 2010 .acddb. Any object that did not work in .mdb version was not imported, Removing buttons, unusual fields ( web adressess, links, pjoto links, dropdown menus) I managed to insert all forms...

When I use Save as it has no options for save at earlier versions. Read this: Factors that prevent conversion to the .mdb file format Certain new data types and features can be used only in the .accdb file format and are not supported by earlier versions of Access. If your database contains...

Sorry, It does not allow me to save to an erlier version :mad:. Anyone else willing and able to help me?

I am sending the database. I did not remove the tables- names and visit details are not real. Open a patient, go to his visit- navigate to the second, third or last visit, and down at the form there is the command button to open the recipe form or report. All I want is to open this form using...

I found some errors. All the forms/subforms had their fields on Header not on Detail section I made the database almost from scratch. I named the new forms frmVisitMain, frmPatients, frmRecipe ( I did not use number (3) any more). Everythink else is the same. The button for the recipe is in the...

I make tries with both report and form Recipe. The result is the same. The field VisitID is in both subformVisitMain3 (where the button to open the report is) and report(or form) recipe. In fact when I add this field it appears as tblVisitMain.VisitID Control source. I continue seeing Enter...

I tried this code according to the example you showed to me but rhe result is that 'enter parameter value-=--visitID'' Now the code is: Private Sub Command163_Click() On Error GoTo Err_Command163_Click DoCmd.OpenForm "FrmRecipe", acViewPreview, , "[VisitID]='" & Me.VisitID & "'"...

Thanks again! The form part (Which in fact is a small part of the 'main' FrmPatients where I edit patient details and then navigate to form/subform VisitMain3 ) of the form/subform ''frmVisitMain3 has these fields from tblPatients: PatientID (Primary key) First Surname FathName Gender and...

I did it and the result is exactly the same as before. The code now is: Private Sub Command163_Click() On Error GoTo Err_Command163_Click Dim theRecord theRecord = VisitID.Value Dim theFIlter theFIlter = "VisitID = " & theRecord Dim stDocName As String stDocName =...

Thanks for your reply According to your example I used this code Private Sub Command163_Click() On Error GoTo Err_Command163_Click Dim theRecord theRecord = VisitID.Value Dim theFIlter theFIlter = "VisitID = " & theRecord Dim stDocName As String...

Hello everybody! I try to make a database for my surgery. I have 2 tables: tblPatients (key; Patient ID) and tblVisitMain (key: VisitID) (one-to-many relationship) I made a form that has my patients details (frmPatientsMain3 ) and a second form for patients’ visits (frmVisitMain3). The...