Search results for query: *

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

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

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

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

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

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

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

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

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, " _ &...

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, " _ &...

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

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

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

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

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

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

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

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

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?

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?