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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. GymRatPA

    Database Password

    Why exclusive?
  2. GymRatPA

    Access 2003 and Access 2000 Issues

    might need repair, and some 2003 funcs might need tweeking for 2000
  3. GymRatPA

    Can you link tables via "autonumber" or "lookup"

    Yes you can lookup (i.e. SQL select) to determine the correct row, but your dependant table will need the autonumber. An example is CUST and ORDER, ORDER_LINE from northwinds. ORDER will need the autonumber of CUST to link to that data, and ORDER_LINE will need the autonumber of ORDER to link...
  4. GymRatPA

    Transfering combo box values from one form to another

    gaijin, on page one of the zip files is an access mdb titled 25comb7. download it, when launched it will sgow a dropdown box of 25 examples of combo box controls. one is single and multiple tranfers from box A to box B.
  5. GymRatPA

    Progress Bars

    CHeck out the syscmd options. strMsg = "Deleting data from <application> for " & Trim(GetAcctMUName(cboDist)) & " Year " & cboYEar & " Month " & cboMonth varReturn = SysCmd(acSysCmdInitMeter, strMsg, 0) varReturn = SysCmd(acSysCmdUpdateMeter, 0) DB1.Execute SQLTEXT, dbSQLPassThrough...
  6. GymRatPA

    Hiding buttons based on Login

    Bob I could not have said it better. We also use similar under Oracle OBDC. The Securty tables can be very complex, but must be thought out by a good planner. When done right, like yours, an application and restrict down to add/chg/del in any app or form.
  7. GymRatPA

    Hiding buttons based on Login

    'Reset the Email notification/DELETE fuction visable FALSE when JOE/462 or BECKY/066 Me!btnEMail.Visible = True Me!btnDelete.Visible = True If ((GetUserID() = "KOP00462") Or (GetUserID() = "KOP00066")) Then ' Me!btnEMail.Visible = False Me!btnDelete.Visible = False End If The default is...
  8. GymRatPA

    Transfering combo box values from one form to another

    trry this site. while in German, the combo box example is rather nice. http://hjem.get2net.dk/accessnet/download1.html 25combo7, is in ACC97, but can be converted. scroll to bottom of list and there is one which allows single/multiple copy to 2nd combo box. gymratpa@ziplip.com
  9. GymRatPA

    b]Is Append Query the only way to append data to a table???

    you can also code the .newadd but for quickness the append qry from tbl1 to tbl2 is easiest.

Part and Inventory Search

Back
Top