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 any of these features, and you attempt to save it as an earlier version database, Access displays a message and does not convert the database. The following list describes factors that prevent conversion to an earlier file format:
Use of new data types, field property settings, and objects The following new data types, field property settings, and objects are not supported by earlier versions of Access:
Calculated fields in tables
Data macros
Multivalued lookup fields (lookup fields that have the Allow Multiple Values property set to Yes)
The Attachment data type
History-tracking Memo fields (Memo fields that have the Append Only property set to Yes)
You cannot convert the database unless you revise the database so that it no longer uses these features.
I know what the link contains before sending it to you and that section was meant for you to take action on. In the copy of your db, remove the fields with those 2007 settings or properties and Save it As an older file format.
Only send us the forms/reports you're having problems with and include the queries and/or tables they are bound to.
I know what the link contains before sending it to you and that section was meant for you to take action on. In the copy of your db, remove the fields with those 2007 settings or properties and Save it As an older file format.
Only send us the forms/reports you're having problems with and include the queries and/or tables they are bound to.
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, tables and reports in a poor version.
Then I put only 2 buttons to navigate within forms.
The problem still exist. (now it does not open the subform of the frmrecipe...but It will be a piece of cake for you to find the solution .)
I hope with this version you will take me out of the tunel!!!
thanks again!
To be honest, your explanations aren't very clear and it's even more difficult when the language of your db isn't in English.
I think what you're trying to do is to open the report based on the PatientID (present in the main report's record source) and the VisitID which is in the subreport. If this is the case there's no point in having a subreport.
Create a query to include the necessary fields from both tables and apply the filter in the WHERE clause of the OpenReport command:
To be honest, your explanations aren't very clear and it's even more difficult when the language of your db isn't in English.
I think what you're trying to do is to open the report based on the PatientID (present in the main report's record source) and the VisitID which is in the subreport. If this is the case there's no point in having a subreport.
Create a query to include the necessary fields from both tables and apply the filter in the WHERE clause of the OpenReport command:
To be honest, your explanations aren't very clear and it's even more difficult when the language of your db isn't in English.
I think what you're trying to do is to open the report based on the PatientID (present in the main report's record source) and the VisitID which is in the subreport. If this is the case there's no point in having a subreport.
Create a query to include the necessary fields from both tables and apply the filter in the WHERE clause of the OpenReport command:
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 solution if I need anything else.
Thanks again!!!!!!!!
