Search results for query: *

yup..so i have setup a module (never have before so first for everything), then dropped in this piece of code Option Compare Database Dim listbox As String listbox = [Forms]![Assigned test list]![List0] (ill need to have it selected somewhere but not sure where to incorporate this)... then...

yup i need to close down the form (test case list) when i move to form (test case).Syntax/coding was never a point of strength of mine. [Case number]=[Forms]![Assigned test list]![List0] is the query details which brings up form (test case)...so i need to arrive back at [Forms]![Assigned test...

Hi, I make a selection in a listbox (test case list) and press a command button which brings me to another form (test case).But when i save the changes on the the (test case) form then i return to the (test case list)form.I was hoping to have the item previously selected to remain selected in...

thanks a mill guys.I have decided to use a setvalue macro in the afterupdate function of a textbox. Works a treat and actually makes better sense to have the user working this way. Cheers

i thought i did in my earlier post.Sorry. I did run Private Sub Form_Deactivate() DoCmd.Requery End Sub but it never worked. It is strange.The form is not updating even though i am opening it afresh.but then when i go back into it, the save has been registered.Very annoying.

ssatech, there doesn't seem to be any code behind it. I thought the macro's i build would build the code in the background. Sure what my macro does is Save the form that i made changes on, OpenForm (where changes should be reflected), and then Close(the form where i have made the changes)....i...

sorry ssatech. You are dead right i did post this same problem before. The below piece of code didn't work for me. Where i am at the moment is that i hit the save button returning me to the form where the info should be updated, but the data isn't updated.But then when i click out of the form...

Guys, I am really stuck on this one. I am editing field data on FormA, saving it and returning to another form where I should see the data updated. One field in particular. However, no matter what i try it won't update the field until i re-enter again.I have tried requery, form onOpen, refresh...

sorry i should have mentioned that i did that already but it is not working for a bound textbox.It will work for the unbound.I have tried a few workarounds like onEnter or onOpen etc but not happening for me.Cheers

Hey guys, thanks for all your help the last few days.I am wondering would you know a way of setting the value of a form text box can default to be the current date when they enter a form. I have tried to use onOpen (for the Form) set value be Date() but tells me this is not allowed to be set...

Hey guys, i am clicking a command button which opens a form up. Problem is this form was setup based on a query and therefore it is looking for query details. The user of the system will select some details on a listbox and click this button. I have this statement in the onClick property,[Case...

ace man i have placed this piece of code inside but it is just saving it, which is fine, but i need the new form to refresh with the saved details. I have tried many different things (even though i know it is probably really simple) like runSQL (the query statement, turns out too long a...

thanks guys for the quick response. I can't find the OnOpen property of the form.I have also added the code Forms!Assigned test list!List0 in the requery item of the macro. List0 is the name of the listbox, Assigned test list is the name of the form.

hi, i hit a "save" command button which saves data on form1, closes it down, then opens up form2.However, the changes i make on the form1 should be reflected on form2. This data in the list box is not getting updated until i reopen form2 on its own.I tried appending to the macro which runs when...

i read the document and took a look at the db i have inherited. There are no primary keys at all. Would you believe it.Bleeding great.Can i force primary keys without recreating the whole table again. Cheers

hey..thanks a mill for your help. i just changed the code around a small bit.Synntax error is gone now. Thanks Dim stDocName As String Dim stWhere As String Dim stFilter As String stWhere = "[Tester]=" stFilter = "[Forms]![Assigned test list]![Text29]"...

hey... stDocName = "John" DoCmd.OpenReport "John",acViewPreview,,"[Tester]=" &[Forms]![Assigned test list]![Text29] causes a syntax error (operator missing)...it picks up the value in text 29 but the syntax is wrong.Looks ok to me.

thanks for that..it is greyed out.So it is not gonna work. Any suggestions of how to go about it.Cheers

when i put [tester] =1 in the where condition of the openReport macro it still appeared with the [tester] prompt. This in my opinion was because i was using a query for the report i was using.But now that i have changed the report to use the table fields it doesn't prompt me for a tester. But...

i created a new report to try and get around this. I am using a table as the control source rather than the query which was giving me a proplem. I need to create a filter to use Tester.Would you know what piece of code i could drop in. effectively i want to add where condition = tester chosen...