Search results

Thanks a lot for detailed and clear explanation. Lets say that the "time" is not a problem, I'm planning to do such verification one time per day and i will provide feedback based on this period of time. Also, i want "only" focus on the "change" of one field for "existing" Projects, i know could...

Any idea why all button in Data Macro are disabled in the Table Label ? I open a local table just for test the Data Macro functionality but I can't use any button (Before/After Events, Named Macro, etc.) are all disabled. I just did a test creating new db with one table and there it work. It may...

Thank you, it is exactly my Idea i tried to explained (step by step) in my previous messages. The only thing to understand was refer to the "tblCheck" which I need to create everyday by copy of the linked table in order to have something to compare with (as you well explained). In any case i...

Ok this is clear but, in order to have something to compare as you said, at the first run I should add in the log table the actual value (RFSU_PLANNED_DATE) for all Projects, . Now my question is: what if user add some new project in the Linked table (which i don't have control, i have only a...

Ok, clear, but this is only to understand if I need to do the verification process or not but my main issue is how I can understand if the value of one field is change in the same linked table ? Data Macro can be used only in local table (that's why i though to create a copy), any other...

As I said, this table is not under my control, is linked to my database trough ODBC hence, unless I do local copy, I cannot add any field.

The benefit is to use it everyday to compare with the live table (linked) in order to verify the differences. This is what i though otherwise, how i can control the modification in the same "live" linked table ? Because it is not clear to me in your explanation. Where i should add that code ...

Yes, exactly the above process i described. Cheers

My work around it was exactly partially described: the idea, assuming i'm not familiar with Data Macro (but i will read some documentation about), is : - Assuming i want to do the control one time per day (at the first logon of the frontend, any user); - Assuming i will create a daily local copy...

The problem is that i don't have the form where the modification it may be done by the user so how I can control something i don't have in my db? Sorry maybe I don't have enough experience but as far i know i can control the event only if i can manage the form (so the event), if not please...

What if I decide (at the first logon for example) to create a local table by copy of the linked one and apply the DataMacro on that local table which is owned by Access in this case ? But, as I said, I need support on how it works DataMacro (how and what to do). Cheers

Thanks first of all. The external application is another database, not sure which one but most probably SQL. So, am i wrong to say that I should find some work around ? or, if it is possible to use Data Macro, someone can be so kind to explain how to work with that ? I check some documents in...

Good morning everyone. Actually I have a need to send an automatic e-mail to users whenever a field of a specific table is change. The table is part of an external application and is linked to my access database trough ODBC connection and users may change that field trough that application. I...

Well, implementing that function it work very good (it seems even more quick). What i did : If rst!Nr_Records > 0 Then 'Create a new worksheet with name of query Dim ws As Worksheet Set ws =...

Thank you for the answers. So, the form is always open because this function is called from that form trough a button and [Forms]![frm_project_selection_for_edw_de_qc]![PRJ] is never Null . I tried to use Eval but not work, I remove Like and not work, i use '=' and not work, the only way it...

Good morning everyone. Time to time I face with the Error 3061 Too Few Parameters Expected 1. I tried to check around some solution but it seems i'm not able to solve. Below is my code. Mainly I have a table with a list of queries name (previous build based) and for each query i need: 1. Create...

Hello everyone, I'm Leonardo, working in an Oil and Gas Company in Oman. My role is to deal with the Computerized Maintenance Management System (SAP) and mainly in the data verification, QAQC, etc. To do this, very often, using my MSACCESS (and VBA) knowledge, i develop small tool which allow...