Search results

Hello, I have a text box of a subform in datasheet view which contains an hyperlink to a file located on a shared folder. Is it possible to hide the hyperlink target? This is shown when you hover on the textbox an you step there a couple of seconds (see below). I would like to have no target...

thanks, but it really needs to be editable (on the non-calculated fields)

I would like to have a subform (in datasheetview) to appear as "upside down", i.e. with row headings being the field names and the columns the different records. I don't know if there is a way to do it. The reason is simply "aesthetic": the users of this would just store calculations which are...

Well, this solved the issue!

Hello, this definitely solved the issue! I didn't know about this property. With this I can cancel all the code in the resize event! thanks

Thanks but this statement doesn't look like doing anything on the apperance of the subform when looking at the main form. I tried to set the property from the immediate window but it doesn't change

Hello, thanks, but I think the error occurs because of a too big number is assigned to the Width property of the subform. If you assign a negative value to it you get the error 2100, not error 6 (overflow). For a some reason the InsideWidth property is Long datatype while Width property of...

Hello, I got an "Overflow error 6" when loading a form at some users of my application. I noticed that it comes out from a statement like this: me.subForm.width=me.InsideWidth - 100 I noticed that some users have very large monitors, hence the value in TWIPS to be assigned exceed the limit of...

Hello, in fact the application has two set of sources: one from SQL server and one from Oracle, the second one is mainly to read tables from our company production system. The query I mentioned actually involved the Oracle part. I will check if there was any change in the variable type in that...

Hello, I finally found a workaround for this, but it took some time. Instead of assigning the rstRead variable to a query I created a temporary table and then assigned the rstRead to that temp table. If in the temp table the numeric values are set as "Long Integer" then it works, if they are...

thanks for the suggestion but it crashes at that expression. Even if I try to debug step by step and simply hover above the rstRead!qtaresidua variable it will crash.

Hello, infact they show two different values: The first is 2 (which is correctly a Null), the second is 8 which means it's string but it shouldn't. I am trying some workaround but the main issue is that Access keeps on crushing whatever I do ...

Thanks, I tried this but the error remains. It is a "conversion" error 3421 during a statement to assign a value to a recordset. The line where it stops is the statement below. For some reason it doesn't read correctly the value on the "rstRead" recordset, while it did in the 2010 version...

Hello, I worked for many year with Access 2010 on an application we use in our company, this is distributed to about 60 users. I recently changed my pc from WIndows 7 to Win 10 and Access 2019 (32 bit). The previous accdb seems to open correctly except that I got frequent unexpected crashes...

Thanks ArnelGP, this solved the issue!

Hello, I have a form with a subform in datasheet view. The form (frmMainForm) is originally saved with the form property "Allowedits" set a as false. If I open the form from the navigation panel then the subform is not editable, as expected. If I open the form via VBA with the docmd.openform...

Isladogs: in fact I missed it and I think you hit the point: it will not work in the way I designed the thing. I think I have to go back and redesign the SubForm and the SubSub. Thank you!

sorry I just realized I posted the same thing twice! Anyway I will try to post the accdb file, but at the moment is very big and I should make a much cleaner version

Thanks. I have tried to use your syntax from the immediate window but I get to the same problem. It works till the SubForm level but it doesn't work to the SubSubForm level. See screenshot below (I have used the real names of the forms)

Micron: I just tried your syntax from the immediate Window and it gives exactly the same result, i.e. error 2455, when try to access data of controls on the SubSubfrm. But it work to access properties of a control on the SubForm. See the screenshot of the immediate Window.