Search results

Hi, I have a form with a subreport. The subreport consits entries with dates and a generated field of the week number. On the form, there are two buttons: Days and Weeks. There is also a listbox, which shows the dates/weeks depending on with button is pressed. What i would like to do is link...

Hi, I am looking for advise on how to turn off the highlighting of the row selection. thank you

Hi, I have a query with a calculated field that contains the latest date using a Dmax statement. It works fine. However when i want to order it by ASC or DESC it handles it not like date, but to me it seems like integer. Is there a work around? thanks

Hi, i am looking for something where i am not really sure about the wording. I would like to have a form in datasheet view listing records. While cliking on a record i would like to have a subform opened under the records (like in case of the tables with one-to-many relations). Is this...

Hi, Is there anyway to read out the content of an unbound textbox in runtime? What i mean is how to get the values while typing for example. Thank you

Hi, i have just experienced that if i open a report in acdialog than the set ribbon is not displayed. Is this the normal behavior of the program? thanks

Hi, I am looking for some on help on this. I have a report to be opened as pop-up in viewreport view. Because of filtering normally only one line showed up. However the window is much bigger and there is a big white empty place i want to avoid. Heights of details section is adjusted to fit...

Hi, I am trying to solve the following and asking for help I have a form frm1 with 2 unbound field txt1 and txt2. I want to compare the values of these fields in an if/end if condition. The first field txt1 gets its value from an other form via TempVars! on onLoad event. However it does not...

Hi, I am struggling with following which more a theoretical question, since some workaround i have found, but still would like to understand the "error". I have frm1 with pop-up=yes with a cmd button to open frm2 that has pop-up=yes. Frm2 has a subform with fields. After opening frm2 the focus...

Hi, I have a form frmMain with subform fsubMain. FrmMain is opened with different open arguments. I am trying to set the record source of fsubMain according to. So what i did is setting this up in the OnLoad event of the parent form frmMain like this and apply a filter but it does not work...

Hi, I have a report with OLEUnbound Image. When i change the scaling of the screen the the image changes its zoom so the fields that are positioned over change their location. I have found the SizeMode setting and i have played around with it, but i did not succeed. So my question is if there...

Hi, I have a form with public sub than contain an exit sub statement. I want to call that sub in some other events of the same form. however when i do so the called sub works except the exit sub statment. It is embedded in an if option. Why the exit sub does not work if it is in a called sub...

Hi, I have created a continous form with alternate row settings. It is a pop up form and i wanted to have better look of it, like having margins on both side. So in the form header i have added to box on both lateral end with white color. It is ok, look like having margins. I have added to two...

Hi, I have a button to bring up a report in a pop up mode (acDialog). However i need always need to click on the report itself to zoom in. Is there a way to do it via VBA i.e upon opening it zooms itself? thank you

Hi, I have a modul that creates a dynamic array which is made public. The array works, contains the appropriate values. However if i want to check ubound function it gives a result of 0. The array is not empty. Just curious why. thank you

Hi, I would like to know how to use this Dim ctlCurrentControl As Control Set ctlCurrentControl = Screen.ActiveControl If ctlCurrentControl.Name = "txtCustomerID" Then . . ' Do something here. . ElseIf ctlCurrentControl.Name = "btnCustomerDetails" Then . . ' Do something here. . End If...

Hi, I can not figure out how to loop through the controls in a form. The tutorials seems not working with MS Access 365. Dim ctr As Controls For Each ctr in me.controls if ctr.TypeName=acTextBox then msgbox ctr.name end if next ctr This is just the testing example...

Hi, I have a field in a form with conditional formatting (blue color with underline). It is not a hyperlink but i would like to have to behave like that (hand as cursor). Can not get it worked. Is there a solution for this? thank you

Hi, I want to delete a record in a subform by clicking a command button on the mainform. I made a public function in subform Public function DelRec() docmd.runcommand accmdDeleteRecords end function Then onClick of the button Public sub CMD1_Click() Forms!frmMain.fsub.form.DelRec end...

Hi, I am looking for some resources on the use of commandbar in ms access 365. Can some suggest one?