Recent content by Andy74

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

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

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

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.

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

Thank you very much, it must be this!

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

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

I mean deleting a record

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

Thanks RanMan256, works well!

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!