Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: McWhorter
  • Content: Threads
  • Order by date
  1. McWhorter

    Printing Hyperlinks in Excel

    We have an Excel sheet that has 100s of hyperlinks that (when clicked) open up in IE6. I have a checkbox next to each one. I want the users to be able to check several hyperlinks they want to print, then click a command button to print them all (preferably without opening them all up in IE)...
  2. McWhorter

    I have a table that has 3 check box

    I have a table that has 3 check boxes(A, B, C) along with a few other fields. The records could have any combination of A,B, or C checked or none at all. I have created a form that has 3 unbound check boxes labeled (A, B, C). Here is what I want to do. A command box needs to be created that...
  3. McWhorter

    Append data to password protected database

    I have a command box on a form that when clicked, does several tasks, one of which runs an append query to copy records to another database. It WORKS great. Well, now we have to put a database password on the other database so the append query wont work. Anyone have some code that I can use...
  4. McWhorter

    Link Table ? (from Excel)

    When I link an Excel worksheet into access97 the data types are automatically set. How can change them to what I want since it says you cant edit the link table? Lets say to change it from a "Number" to "Text"
  5. McWhorter

    Link Table ? (from Excel)

    When I link an Excel worksheet into access97 the data types are automatically set. How can change them to what I want since it says you cant edit the link table? Lets say to change it from a "Number" to "Text"
  6. McWhorter

    How 2 run Action Query without being prompted!

    I have a database that needs to run a few action queries. On my PC, I have "Unchecked" box in the Tools/Options/Edit menu for Action queries (Access97). That way it doesnt ask for comfirmation that running an action query is OK. The problem is that all the users PC's have the...
  7. McWhorter

    CFR 21 Part 11

    Has anyone created an access database that is completely Part 11 compliant? electronic signatures electronic records audit trails data security Just curious.
  8. McWhorter

    get Default value on a Form from Query

    I have a form set up for data entry. I want one of the numeric fields to have a default value of a field in another query. I've tried to set it in the "properties" box of that field with no luck. I then tried to set it in the "On Load" event of the form. I used the following...
  9. McWhorter

    How to set: If no data is entered on form, you can't continue?

    I have a form that allows for data entry. At the bottom is a control box that, when clicked, closes the form and opens a report. Currently you can click the box without entering any data and it will close the form and open the report. How can I stop this? I want it to only open that report IF...

Part and Inventory Search

Back
Top