Recent content by Philipc

Nearly there - found that I had typed Text12 (the label) instead of the control "Owner" Had to use the format [Forms]![Owner Form]![Owner] and that worked with the Query - and DID NOT add to the Table. One more little problem though - My OK button runs the Query and then opens the Report which...

No I have a form designed as a separate form with the textbox and a OK Button with macro for Set Value, OpenQuery and Open Report and also a Close Button

Soory to be a duffer but I am still having a problem Can you give me the reference to be used as the parameter in the Query form if the unbound text box on the Queryform is called Text12. I have tried various combinations and nothing works to bring up the name in the query. I really appreaciate...

Thanks for your quick response. Unfortunately if I use an unbound textbox my query which in one example has the parameter [Forms]![Owner Form]![Current Owner last name] does not work.

I am using Access 2010. How do I prevent the object typed into the textbox on a queryform being written to the table. The result from the name typed into the textbox on my query form correctly produces the result from the query, and my macros then produce the correct report, which I can either...

Thank you for your reply. Unfortunately I have got so confused with so many "Help" threads that I have not found any which just simply says how to use Follow Hyperlink and it is not in any of my Access "Bibles". I did try one code I found: Private Sub Text34_Click() Call...

I have a database form which has many hyperlinks (to save database space) but I want to be able to transfer this database and images (in another folder) to other computers. I have added two fields "Path" and "NameofFile". I added a text box based on "=[Path]+{NameofFile]". How can I convert the...

I use hyperlinks in my Databases with the links to subfolders in the main folder which contains the mdf file, in Office 7 version of Access. I have identified these folders (and sub folders) in the Trusted Locations for that database, yet when I click on the hyperlink in the form the "A...

I am living in the United States in the Shenandoah Valley, but was born in Nottingham, England. I have been using Access for several years - totally as an aid to my hobbies - research of buildings, maintaining records of items I own - books, CD's DVD's. etc. I started with the earlier versions...