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 derfloh 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: wshs
  • Order by date
  1. wshs

    DLookUp function only works when form is opened?

    i have a table "VRegister" which consist of budgetlines. (fund, revnumber, amount, etc.) bfsix = unique user will be using form "SelectBudget" to store all the transactions and all those will be captured to VRegister. Now when user wants to print a check from form "Checking", i was hoping i...
  2. wshs

    DLookUp function only works when form is opened?

    so is there no way to call a value from a table that is closed? by that i mean.. lets say i have 3 dynamic forms. a opens b and then b opens c. and c prints when going from form A to B some info are transferred and recorded to a table. when going from B to C.. same thing. is there no way then to...
  3. wshs

    DLookUp function only works when form is opened?

    it seems like dlookup only works when the form is opened or hid... is this true?
  4. wshs

    typemismatch.. possibly because its null??

    ty suryaf. it seems like that did the trick. can u explain what u mean about ur last post? it would be better to have them $0.. i have a query UPDATE tbl_Fsource SET tbl_Fsource.Totex = [cashd]+[voupa]+[payrl]+[contp], tbl_Fsource.Balan = [fcast]-[totex]; i think its when i run this query...
  5. wshs

    typemismatch.. possibly because its null??

    Private Sub List6_Click() Me!txtbal = Me!List6.Column(6) - Nz(Me!txtAmount, 0) end sub when i run my update query, it seems like it leaves $0 as null. by that i mean when i look at the table, if the calculation is $0, then field doesnt return $0 but blank. so i get an error message when...
  6. wshs

    updating multiple fields of a table from a listbox

    i will give that a try when i get the chance but for now.. i build and hid textboxes and bounded them. ie. me.txtbox = me.lstbud.column(o) txtbox (bound to VRegister.field) thx
  7. wshs

    updating multiple fields of a table from a listbox

    thx for ur input lars7 can you make sure im doing this right tho.. for some reason i can't get it to work. yourtable = table i would like to update(tbl_VRegister) yourfield = field from the table i would like to update(abID, buddesc, etc) list1 = name of the list box(lstbud) WHERE...
  8. wshs

    updating multiple fields of a table from a listbox

    well i didn't want to create a new table... just wanted to UPDATE tbl_Vregister...
  9. wshs

    updating multiple fields of a table from a listbox

    im getting variable not defined now.. Private Sub lstbud_AfterUpdate() strsql = "INSERT INTO tbl_VRegister " _ & "( abid, buddesc, revnum, revname, appro, " _ & "bfsix ) " _ & "SELECT tbl_fsource.abid, tbl_Fsource.buddesc, " _ & "tbl_Fsource.revnum, tbl_Fsource.revname, " _ &...
  10. wshs

    updating multiple fields of a table from a listbox

    thank you for clearing that up for me. list0 = name of the list box right? strSQL = "INSERT INTO tbl_VRegister " _ & "( abid, buddesc, revnum, revname, appro, " _ & "bfsix ) " _ & "SELECT tbl_fsource.abid, tbl_Fsource.buddesc, " _ & "tbl_Fsource.revnum, tbl_Fsource.revname, " _ &...
  11. wshs

    updating multiple fields of a table from a listbox

    yea.. that sql was the source property of the list box. strSQL="INSERT INTO tblToAppendTo " _ & "( abid, buddesc, revnum, revname, appro, " _ & "fcast, balan, bfsix ) " _ & "SELECT tbl_fsource.abid, tbl_Fsource.buddesc, " _ & "tbl_Fsource.revnum, tbl_Fsource.revname, " _ & "tbl_Fsource.appro...
  12. wshs

    updating multiple fields of a table from a listbox

    was i suppose to put that in the record source of the list box?
  13. wshs

    updating multiple fields of a table from a listbox

    i can't bound it to one column since listbox consists of multiple columns. and i also need to capture them as well ie.SELECT tbl_fsource.abid, tbl_Fsource.buddesc, tbl_Fsource.revnum, tbl_Fsource.revname, tbl_Fsource.appro, tbl_Fsource.fcast, tbl_Fsource.balan, tbl_Fsource.bfsix FROM...
  14. wshs

    updating multiple fields of a table from a listbox

    they can only select one item. im sorry but i can't follow your codes completely.. whats it doing?
  15. wshs

    updating multiple fields of a table from a listbox

    i have a listbox('lstBud') from form "SelectBudget" Record Source: tbl_VRegister quick description of what this form do. its opened from another form, and filters users id and provides a list of their budgets. User can select a budgetline from the list box and when they click ok, the budget is...
  16. wshs

    update multiple colums of the table from a listbox

    im sorry but can you explain little bit more about the column property you are recommending me to use?
  17. wshs

    Password Protect a Form

    sure. it would make it easier if you can list me your tables and its columns
  18. wshs

    update multiple colums of the table from a listbox

    would it be possible to make the listbox bound to a "unique" column and then use dlookup to find the rest of the info?
  19. wshs

    update multiple colums of the table from a listbox

    i have a listbox /w 8 columns. how would i update them to multiple fields in the table? ie. listbox has FIELD1, FIELD2, FIELD3, ETC if user were to select a line from the list box and click OK How can I have those information stored in the table? am i making sense?
  20. wshs

    filter report by control name and then by control content

    im not sure if im fully understanding what you want but why don't you create a search form which users can use to filter what they want?

Part and Inventory Search

Back
Top