Search results

Hi I need for my clients to short for month and year and 7 view per month = 84/year like in picture attached is there a function or a code that I receive the caption or the right,2 of the navigation name without insert all manually, the function where cause work great but I have to insert all...

now I understand what you need:D add event Form_BeforeUpdate on your subform If Forms!mainform.sumform.Form.Dirtyor Or Forms!mainform.sumform.Form.NewRecord Then Forms!mainform.sumform.Form.Undo this way it will discard all chanage you made but then your code cmd.save will cancel all the change...

You need to not save the record until you press the save button? Right?

here all information you need about save command you can also use the wizard for macro record operation - save record but I dont know if it save all dirty record on subform. vba code for button save is docmd.save acform, me.name to add it design mode design tab > insert button, cancel on wizard>...

If you need only a button for save add event on click docmd.save if you need exit and save docmd.close acform, me.name, acsaveyes but the cancel button for the subform after you insert more than one record on subform is little bit more complicated

OT:good to know, thanks

another way to make it is to add one code after update of the text box if int(me.textboxname.value) > 30 then me.textboxname.BackColor = vbred else me.textboxname.BackColor = vbwhite this way can be easier to control for me if there are not mathematical conditrion like on enter, on focus, on...

I think I found... I removed one sub form: Maps that contain 1 text box and one web browser.... how or why because that forum has not even a class module before I change from sub form to popup and put the close button lol?? or cry??

I think I found... I removed one subform: Maps that contain 1 text box and one webbrowser.... lol?? or cry??

I have a problem with one form that some field become not editable and I want to find what code are doing... I clear 1 of my code on current of one subform and all code on load but after 1 sec my mainform and my subform become non editable in intermediate window ?Forms!mainform.allowedits True...

you can also bound the form to a query that has filter based on the combo value and requery on combo change event

you can use a query to calculate the difference between the total of in and out to get the remaining qty. then the same code to look in the query and not in the table in query design select the product id and group by and the field in where are the qty you need and add sum to this field do the...

you can use function dlookup on exit event to check if qty out is < than qty out or can use openrecordset option to check and change qty in based on qty you are removing.

noway... I try to open access with shift to avoid startup and open only this form where on load event I have me.allowedits = true but after 1 sec it become blocked again and only 1 time because on button me.allowedits = true work permanently...

every 1000ms for time show in text field Me.Text26.Requery 'for time Static exittext As Integer Static intCount As Integer Static exittext2 As Integer If Nz(Me.textlogout.Value) = False Then Exit Sub Else Dim intexit As Integer intexit = Me.textlogout.Value intCount = intCount + 1 If intCount...

UPDATE: in immediate windows: me.allowedits = true after this code it works everything I put this code after the code to open this form ant it work for 1 sec then freeze again I have only one code on timer for automatic logout but there are nothing about this form

UCase(Format(Now(), "dd.MMMM.yyyy"))

I will try to put code on exit of the filed and try to check recordset

HI. I have a strange problem, I can't edit one bound field on my subfofm. I have a code that the guest user on load set this subform allowedits on false. but other user can edit all the others but not this field proprieties of the fild in subform is enabled yes locked no same as is in the source...

or another way is to conditioning iif before sum like