Search results

right, I think that's a good idea

the problem is that BeforeUpdate triggers before the AfterUpdate, hence the problem is always there

yes, that's the ultimate solution. But I wanted to avoid this because the typical users simply forget to hit the buttom.

it cannot work, because the user will enter several records on the subform. The notification should be sent only after entering records on the suborm and when the users either close the form or save the record on the main form.

Hello, I have a main form with a subform, which is placed on a tab page of a tab control belonging to the main form. The main form afterUpdate event should trigger an email notification. I am trying to include in the email notification some information which is placed in the records of the...

thanks but the main form is based on a aggregated query, so there is no primary key on it. It looks like below, so the only choice I had is to use the 3 fields I mentioned.

thanks, I didn't think about it, I will change the names

hello, the error was simply "-3004 - reserved error". I don't have a screenshot, but it's in italian language. Anyway I solved the issue by changing the linked fields from customerCode, Year, Month to customerName, Year, Month. Now it works.

Hello, I have a form based on a query that shows something like "open orders to be invoiced". I would like to add a subform to allow users to write comments, something like below. The subform is based on a table (on SQL server) and I set three fields to be linked to the top query: customer...

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!