Search results

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?

Hi, Until just recently, my access has had the "classical" white, red theme. Navigation pane and workplace white. However after a recent restart all of a sudden white background has changed to gray. Why? I played around the with Option/General/Office Backround and Office Theme but i can not...