Search results

ok. your docmd works - but i can't find the right event. i just put a break in the code to see if it run, and even though the control is calculting correctly there is never an afterupdate event. any ideas on events for calculted controls? Jennifer

What event should I put the docmd on? and do I just use DoCmd.OpenQuery "qryPrepLastCost" and that's it? thanks for your help jennifer

i took the SQL from the update query and did docmd.runsql "sqlstatement" on the afterupdate of the calculated control. it does NOTHING!but if i go in and manually run the update query, it works fine. any ideas? [This message has been edited by JCross (edited 03-19-2002).]

i know you're not supposed to, but i need to store a calculation from my subform in a table. the subform is based on a query, and the main form is based on a table. the calculated field is =Sum(([Units]*[LastCost])/[Yield]) which adds up all of the lines in the subform. where do i put this...

Thank you! Worked perfectly. Jennifer

morning everyone. i have the following in a text box as a total.. =Sum([Units]*[LastCost]) which works just fine. but i need the sum to be (Units*LastCost) divided by Yield. I keep on getting error#, and i don't know why. the Yield is in the query for the form, though not displayed on the...

thank you alex! i'll try to stop apologizing for myself so much i still can't access the allowedits property of the subform from the click event of the button on the main form, though. I tried both of your solutions and got the same response. help! jennifer [This message has been...

so sorry - i searched old posts and couldn't find an answer! i want to click an 'edit' button on a main form and have it set the AllowEdits property to True on the form AND subform. works for the form.....but i can't seem to change the subform property. using Forms!mainform!subform.allowedit...

have to admit i have no idea why gotorecord would need the table open. makes no sense to me. hopefully someone else will have an answer for you! jen [This message has been edited by JCross (edited 03-14-2002).]

so something like 'IF no garage THEN (change the value of the query to exclude garages)' i don't know what your tables are named or what your query looks like, but i think that's what you would have to do. but i think it would be easier if you had a 'search' button on the form..so the choices...

i'm not really clear on what you're trying to do - but you can have the 'results' show up on the update or change of the control that was selected. for example - when you have a combo box with a list of names and you want to choose a name and have a record appear....the record appears...

I have absolutely no idea why you have the table open at all. It doesn't have to be 'open' to do anything with it. When you create a program to give to users, the whole purpose behind making forms is so that they don't have any access to the tables directly - and normally you would even hide the...

what do you mean that the table is still open behind it. and if you go into the properties for the button, on the events tab, the on click event....then open up the code builder through the button on the right on the box it takes you the right place in the code. jennifer

it would be easier to just go into the code for the button click and docmd.close, yes? if exiting the form on undo is what you want? [This message has been edited by JCross (edited 03-13-2002).]

why can't you get your button wizard on? here is the code from behind a button wizard Undo button. you can just make a new command button and then make this the click event. Private Sub cmdUndo_Click() On Error GoTo Err_cmdUndo_Click 'undoes any changes that have been made...

use me.undo to undo any changes to the form, or see the button wizard for an Undo button in record operations. jennifer

Morning Xena - ok - about the pics. You're going to have to find a form that works for you.....I don't know what yours currently look like. But if you have a data entry form where you are adding infoo for a property, and you include a Bound Object Frame from your toolbar on it (bound to the OLE...

I have a database of images set up where the user enters a date and a description for the image, then clicks a button which takes them to a linked page with the date and description they just entered and a bound object frame. when the frame is empty, you can right click on it and choose 'insert...

no no no!!!! i'm self effacing and bad at it. i'm so tentative about posting any ideas i come up with....not that i have many. and so many of you members are SO VERY HELPFUL. it's too bad i didn't hit the magic number and suddenly become better at all this stuff! did you know that they have...

Now I see what everone meant when they told me that the junior/member thing was a joke........and I thought i'd find myself suddenly enlightened. bah! heh. Jennifer