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 dencom 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: shy216
  • Content: Threads
  • Order by date
  1. shy216

    updating a form using time interval?

    is it possible to make a form update after certain time? lets say... requery every 60 seconds?
  2. shy216

    double click(or any) event within subform?

    i have a subform which lists of data. is it possible to create an event from that list? like if user double click a "name" from a subform? each row contains different info so... how would i approach this>?
  3. shy216

    requery subform after an update

    i want my subform to requery after updating data in another form. right now, i have a subform which requeries when i click the command button but i was wondering if there is a way to do it in a time frame or such. so that user don't have to close and open everytime to see if there was an...
  4. shy216

    report based form (continuous form?)

    i needed to find a way to refresh/update report after an update but i guess that's not possible in access. so someone recommended continuous form. what exactly is continuous form? and how can i approach to create a form which works as a report? is it possible to list them by itself after an update?
  5. shy216

    Immediate report updating? (stored procedure)

    i know in sql they have stored procedure which updates immediately after a new data is entered. Does access have this kind of feature? Able to update a opened report when a new data is entered? i have a database that's on a shared folder. i would like to have the one on the main computer to...
  6. shy216

    trigger update?

    isnt it possible to have your report opened and have it refresh on it's own every 10min or so? or do i have to close and reopen everytime to check for an update??
  7. shy216

    html within combo box?

    is it possible to make a selection from a combo box and link a distinct html depending on the selection?
  8. shy216

    show different columns in cbo box in different forms

    i've linked 2 cbo boxes from different forms. so from form 1 if user selects OK, it opens form 2 and that record shows up on form 2 as well. problem is i need to show different column on the form 2. i.e. if first combo box contains 2 colums, "Name", and "Number". (but only shows "name" from...
  9. shy216

    Linking combo box and filter

    i've linked 2 cbo boxes from different forms. so from form 1 if user selects OK, it opens form 2 and that record shows up on form 2 as well. problem is i need to show different column on the form 2. i.e. if first combo box contains 2 colums, "Name", and "Number". (but only shows "name" from...
  10. shy216

    option grouping

    how would i create a list with "option" then record to the table. like lists of description /w empty check boxes. so when user clicks one of the check box, that description is then recorded to the table. ?
  11. shy216

    dlookup funcion

    Private Sub password_AfterUpdate() =DLookUp("[password]","tblpasswordMonitor","[password]=forms!frm_pwMonitor![password]") End Sub trying to set up a quick pw filter and open if it's true.. what am i missing?
  12. shy216

    password filter from command button

    Im not sure if this is possible in Access but... From FormA, if user clicks command button, a pop up will show up and ask for password. if true, then open FormB, if false, retry or close. is that possible?
  13. shy216

    record data after cbo update

    i have dynamic cbo boxes which are all unbound. (requery after update) is there a way to actually Keep the record on a data table after selection?
  14. shy216

    access budget database

    does anyone know where i can maybe download a sample of a budget database? im new to access and vba and im trying to learn different types of databases. i've downloaded most of the samples available from microsoft but didnt see any that's related to budget or financial database. any suggestions?
  15. shy216

    selecting from listbox (setfocus) and sub/adding to/from a table

    i have a dynamic forms. how do i make it so that when user select from a list box, type amount, and click cmdbutton. and then select another from another listbox on new form. and click cmd button, it'll subtract amount from first row selected from the list box and then add an amount to the row...
  16. shy216

    access .mdb won't open!!!

    i just updgraded to access 2003 and now my file won't open. it says it's missing MSACCESS.EXE i searched it manually and now it says the dynamic link library mso9.dll could not be located what is going on? i hope i didnt lose my database...
  17. shy216

    password(field box) filter

    i have a form which filters stDocName = "frmFsource" stLinkCriteria = "[StaffID] = '" & Me![cboStaffID] & "' And [AbID] = '" & Me![cboBud] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria and im trying to add another field. this one's little bit different since im not linking them...
  18. shy216

    selecting(highlight) from a listbox!

    if i have a listbox. is there a way user can select from that listbox and click a command button which will update other field from another form? ie. lstTransFrom (if user highlights from the list) from frmTF cmdUpdate (then user clicks this command button) Balance (from...
  19. shy216

    void, cancel, strikeout... a Record on a form

    is there a way to create a cmd button which can show a big X or a void so that user know it's been voided or canceled?
  20. shy216

    i need my menus back!!!

    from the startup.. option, i disabled all the menus and such. which is fine... but i just realized that i can't even right click now... how can i change these settings back to normal?

Part and Inventory Search

Back
Top