Search results

  1. A

    Front end dimension

    Hello, thanks for all the comments received. Regarding front end dimension, it was actually the subject of the thread: The accde file I distribute is now about 80 Mb, with the following number of objects: Tables 318 (most of them linked, few local just as temporary tables) Queries 1027 Forms...
  2. A

    Front end dimension

    In fact one of the functions I have implemented is "feeding" the ERP with the forecast provided by the sales people. Before this there was one guy getting excel files from them and feeding ERP tables manually, really a crazy thing ...
  3. A

    Front end dimension

    Thanks, in fact IT are the ones that many years guided me to using an SQL express backend which made everything much more solid. You gave a good explanation about the pro's of Access as a RAD tool, I will certainly use this to redefine a new strategy of software development within our company. I...
  4. A

    Front end dimension

    Thanks for your comments, much appreciated. Maybe I was a little bit extreme: in fact the IT guys "maintain" the SQL server back end and the backups. Moreover there is one person in my team that can look in the Access front end if needed but he doesn't make any new development.
  5. A

    Front end dimension

    Hello, I am running an Access application since more than 10 years. It has become a very large one in our organization but I would say very successful: about 100-120 users in different locations across the globe. All front ends are linked to a main SQL backend (read/write) and some other back...
  6. A

    table not readbale

    Thank you very much, it must be this!
  7. A

    table not readbale

    Hello, since this morning one linked table (to a SQL server) is not accessible from my computer, and it show all records as belows. All other tables are ok. This system is used by many users (about 80) and no pc has this issue except mine. The table is fine in SQL. I have tried to delete the...
  8. A

    left join updatable query

    Thanks, you are right we take those things for granted but they are not at all! I tried to add the index in SQL back end on the "componente" field, but the query is still not updatable. Anyway I wanted to try your approach with subform and I think this is the best solution: I put the tblSmall...
  9. A

    left join updatable query

    I mean deleting a record
  10. A

    left join updatable query

    Hello, I have a simple LEFT JOIN query like below. The left table (tblSmall) is a from an SQL server (1000 records), the right table (tableLarge) is from a Oracle back end (200k records). I would like to use this query as the data source of a simple form in datasheet view where the user...
  11. A

    Hide Hyperlink target

    Thanks RanMan256, works well!
  12. A

    Hide Hyperlink target

    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...
  13. A

    Subform upside down

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

    Subform upside down

    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...
  15. A

    subform Width property - Integer

    Well, this solved the issue!
  16. A

    subform Width property - Integer

    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
  17. A

    subform Width property - Integer

    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
  18. A

    subform Width property - Integer

    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...
  19. A

    subform Width property - Integer

    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...
  20. A

    Solved Issues with Access 2019

    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...
Top Bottom