Search results

I have an unbound form whitch is compiled mynually because the querry result are not updatable... evrything worked well for month... now I change a code on a bottons(not the textbox problem) to not open double record but chech first if it exist and opend the record on a new form... now on a...

In query criteria

need to filter a subform based of 2 checkbox on main form, all work but not for both checked in this calculated field: placeno: IIf(Nz([iznos])=False;0;-1) this is the criteria: IIf([forms]![Putninalogmjesec]![Check49]=-1; IIf([forms]![Putninalogmjesec]![Check51]=-1;0 or -1;-1)...

Thank you for the help. For now I have that code working and don't have time for that to much. But it goes funny if on main form on load have me.recordset.gotolast The code select 2016 and 09 :) but not 2015 and 11

Private Sub Form_Current() Dim mavcontrol As NavigationControl Dim i As Integer, n As Integer i = Month(Date) Set mavcontrol = Me.Frmorderrviewonly.Form.Controls("NavigationControlmonth") Me.Frmorderrviewonly.SetFocus mavcontrol.SetFocus For n = 1 To i SendKeys "{TAB}", True Next n SendKeys...

No, never found nothing similar after a lot of googling

On my database i have from 1 to 7 and a total. Because 3/4 users need to read all "orders" of that client and only 1 need the other form for enter the data. And in our work never happened that we had more than 5/month because we have weekly orders...

with insert into I think you have to remove the # from the constant like format(cdate(F1),"dd/mm/yyyy")

if your is in F1 as string and not as date try replace format(F1, JetDateFmt ) with format(cdate(F1), JetDateFmt )

I normally put all constant in module so they can be used in all class module. did you try your system cdate("8/17/2015 16:39:52") if it get the correct date? because on my it get 17.08.2015. 16:39:52 and format(cdate("8/17/2015 16:39:52"),JetDateFmt ) I get #08/17/2015#

I had this issue because my country, my sistem and vba have diffenrent format date :D I solved this way you can try too in module: Global Const JetDateFmt = "\#mm\/dd\/yyyy\#;;;\N\u\l\l" and then every date use format(yourdate, JetDateFmt ) my system cdate(date) = 02.11.2015. =...

thanks for your help. it's a lot simple that you are looking for. you was right: no class module and no macro... if you open Frmorderrviewonly in design view and select 10 then 01 on 3rd row under proprieties data tab you can find the first row to select the form to show and where cause that is...

Thanks and sorry. English is my 2nd foreign language and I use almost only for programming... I did a small database to be more clear as suggested it work only for 10 and 11 month because I entered record in orders only for this months. As you can see when you change record on main form the...

On access 2013 I have 3 level on navigationcontrol 1st for the year. name: navigationcontrolyear 2015 2016 2017 2nd for the month. name: navigationcontrolmonth 01 02 03 04 05 06 07 08 09 10 11 12 3rd for the file with the same subform. name...

Life is to short to match your socks

Im interested to, I managed this with creating an account extra in my business account and make a rule in gmail toforward that specified mail to my outlook account. Then I can connect access to outlook folder and check for new mail because I get every week a new one, but I need to manualy...

solved: I renamed the first navigation control for easy find, the 2nd and the 3rd and get the value with this code: year= Forms!mainform.subform.Form.NavigationControlyear.SelectedTab.Caption month= Val(Forms!mainform.subform.Form.NavigationControlmonth.SelectedTab.Caption) line=...

No. In the navigation where cause I have [ID] = mufunction(2015, 1, 1, forms!mainform.form.custormercodeID). I only need if it's possible to change the 2015, 1, 1 with some function for not insert 84*5 year and 84 every year

Yes anywhere I know. Even in itemediate window :)

depend where you are, in main form, module or subform... forms!mainform.subform.form.fieldtohide.visible = false is the long version