Search results

For anybody who may have the same problem I achieved the update to the data base by recreating an MDE file - splitting the new data base and then exporting the data from the old data base into Excel and re-importing into the new data base. Only fieods from the old db were loaded - don't know...

I have searched the forum but have failed to find the answer to my problem. I have a front end ms access 2000 solution that I distribute to user PC's with an MDE back end data base on a server. I now need to release a new version that includes changes to forms, queries and tables. However there...

A way to repositon on subform I had the same problem an I also prefer the control on the main form. I found a way to reposition to the last record by doing the following: In the command button code give focus to subform - Me.subObjectives.SetFocus subObjectives is my subform name In the...

You are quite right! Thanks...

Sorry Rich you misunderstood, probably because my description was a little ambiguous. I am calling a report from a form by using a command button and this is printing a report based on data associated with that form. I had hoped to preview the data before the report was printed and then print...

Thanks for the ctrl-P tip. The situation with the report is that it is printing a form. The user may wish to view the printout as the form spans more than the viewable area of the form window - the print preview gives him a full view of the data without scrolling. He may also then wish to go...

I am trying to use a print command button on a form to offer the user the capability to preview a report, to preview a report and then print it or print the report immediately without preview. I have use acPreview option of OpenReport using DoCMD to show the preview dialogue but I have not...