Recent content by Philipc

  1. P

    Prevent writing to the table

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

    Prevent writing to the table

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

    Prevent writing to the table

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

    Prevent writing to the table

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

    Prevent writing to the table

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

    Converting to Hyperlink

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

    Converting to Hyperlink

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

    Question Potential Security Cocern when viewing hyperlinks

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

    Hello

    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...
Back
Top Bottom