Search results

is your first form bounded to a table ? is the second one an independent form? or is it a subform? are they both open at the same time? very littel information to work with. sam

Private Sub Form_BeforeInsert(Cancel As Integer) bolNewEntry = True ' this variable is global to the entire form End Sub

Here is my attempt to show the animals example. please see atttached database. sam

Here is my attempt to show the animals example. please see atttached database. sam

what you can do is on the Form_Current add this: me.txtMyCount = Dcount([ValueToBeCounted],[RelatedTable],"condition optional) and create a text box that is called: txtMyCount now you can change back the controlsource of the form. good luck, sam

exactly, this is what i meant. thanks a lot. i just couldn't remember if i can set it on the form itself. thanx for the snipet of code. sam

Hi I remember seeing it. i just don't remember if i need code for this or not. I would like to the combo box to open and show the full menu upon entry. thanks, sam

what you are looking at in this code is adding records to a table. the way you do this in VBA is open a recordset and then you may want to test for some conditions and then you start a record, add values to the desired fields of that record and you .update which means it records that record. a...

never seen this discussion. but i know this from excel that F2 will get you there. i just tried it on a query (manually) and it worked. i guess you would send keys or something like that? maybe you want to lookup the ascII code. good luck, sam

why in the form_open event, use it on the field that the user chooses afterupdate event. sam

listen bro, i think what you need is very simple. i think you don't need VBA at all. do this: start a form in design view, make it unbouned, meaning, don't attach a table or query to it. then put on it the few parameter text or combo boxes you are interested in. save it, keep it open, go to the...

can you disable the switchboard? sam

you most add a nz([Price]) the first time you multiply [items]*[Price] and that should help. try to use the Nz function as much as possible. sam

you need to automate. i don't think that this can be taught in one posting, but the basic concept is that you would be working in excel through your VBE. its not rocket science, its just hard to explain it all. i have some postings which has code that use automation with word. do a search for my...

form.requery is a common command, it can refresh your query of your form whenever you want it to happen. i noticed you use the asteric * in your queries. based on what i have read that slows down a query. i think i read that it is better to select every field than to use the *. maybe that will...

Just a suggestion: i used the calendar control 11.0 and it was just misery for me. i had problems with distributing to other computers with different versions of Office (e.g. with/wo sp1 or sp2). in addtion, i just couldn't get the right values not enough events etc.. just a lot of problems i...

Hi Rod, I guess that is a great solution and i think i will use it. so thanx a lot. :) :) :) :) :) :) However, i would like to share with you my frustration. i used selen's idea and i liked it a lot. i am just stuck with the continous form problem. i have some complicated solutions which...

its complicated. its like shading a particular row on a continous form. its way to complicated. i have some templates. i will see what i can do. thanks a lot for the quick replies. sam

one more followup. i can't believe i screwed this one up. but this is on a continues form. any way to get around the enormous mess??? i can't believe i didn't have any forsight on this one. thanx, sam

yup yup, thanks a bunch. this is the code: Private Sub txtDateWorked_Enter() Me.lblDateWorked.Visible = False End Sub Private Sub txtDateWorked_Exit(Cancel As Integer) If IsNull(Me.txtDateWorked) Then Me.lblDateWorked.Visible = True End If End Sub i guess if i would want...