Search results

thank you PNGBill. but i am still not getting what you are stating below. I have attached a DB that Access offers...If you open the DB and look at Client 1 that I have entered, in there you can add "common tasks" I have 2 common tasks and i want to add both to Client 1, which it does perfectly...

i'm not good at VBA so wouldnt have clue on User defined fields.. can anyone help with PNGBill's suggestion?

not sure what you mean? the field i am trying to concatenate are in the same field but different rows so in the form i have a table that is shown in datasheet view and has the following information chkbox, hour1, hour2, comment chkbox1 12 12 work on foood chkbox2 10 10 planting my...

Ok I found this helpful website (http://allenbrowne.com/func-concat.html) that had a concatenate function written by Allen Browne that i could use in a module.. and it works.. but the issue is i am totaling everything on a form in the footer field so i have 4 text boxes and each box here is what...

and how do i do that if the information is in the same column? so for example, i want to conct the assumptions when 2 different projects are picked (true in chkbox): witht he query below i get 2 rows, but i want one row with just the conct'ed assumptions, even if i get rid of the Proj Name i...

right not adding per say but putting them together??? so here is an example the sub form has the following info chkbox, hour1, hour2, comment chkbox1 12 12 work on foood chkbox2 10 10 planting chkbox3 8 10 paper work now if i check off chkbox1 and chkbox2 then what i want is total: 22 22...

Hello, i have a form with subform where user can see the hours allocated, if they want to add more hours they can then open up another form with different options that they can choose to add additional hours, in this form there is also one memo field (basically description of the hours). What...

this is going to sound so DUMB and it took me few days to figure this out... but i all i had to do was put that code in the AfterUpdate event of the combobox and not the unbound textbox... URGH..... but i am now :)

ok so maybe i am missing to tell u something, i have a combo box where i select a value depending on that, my unbound text box is populated with a value (using a query to pull down the value from a different table), then i want to take that value from the unbound text box and copy it to a bound...

can anyone please help?

thank you both! But i have a table where i am grabing the information i need (i/e hours) and basically need to update the master table to capture these hours so that htey are stored. So basically i am not calculating anything... why is it that i still cant copy it? I have an unbound text field-...

thanks! but what does "calculating the value on-the-fly" mean?

right but i am trying to do the same, i have a calculated value in an unbound text field and trying to copy that value to the bound text box that is bound to the master table... isnt that what fraser_lindsay trying to do? "Me.txtRisk = Me.Risk2.value That just copies the value form my...

ok i know this is an old post but i am trying to do the same and its not working.. does anyone have any ideas? thanks! Summer

nevermind i had some statements wrong... i apologize! ok so now it WORKS...which is great but I have changed it to select query as my code would not work on append query but it doesnt post the total in the text box... gives me #Name in the text box its in the SubFrm... i'll attach the DB.. in...

hello plog thank you for your reply. I still dont get the sum of hours appended, it appends 2 rows on the main table. And DBD and DBC are not related but the user can pick one of the 2 or both to get total hours. Hope that helps. thanks again. If anyone has any other suggestions please let me know.

Thank you Mr. B. Ok you're right i dont think thats what i want. If you look at my main form, the user has the ability to add records on there, so with each record the Hrs can change as well. So for example on my db i have 2 records on the main form, first is the ID "DEF" second is "ABC". What I...

Hi, Can someone please help on summing up 2 rows and posting the values in a table? So here i what i have ImpID P1Hrs P2Hrs P3Hrs P4Hrs DBD 34 60 56 16 DBC 21 20 38 6 I want to add so the result is DBD/DBC 55 80 94 22 then post the value above in a main table under P1Tothrs, P2Tothrs...

and how do i know store the calculated value in my main table? is there a way to take the value in the FrmScopeImp and store it in the TblMain as text meaning it cant change there? In TblMain, each ID can have different hrs..

thanks Mr. B! this is working fine but i want to understand the code... what does Me.Dirty?