what _I_ am really curious about is why you feel compelled to recreate the TrasnferText functionality by "manually" looping through the records and outputting them.
Have you thought of adding a "Record_Change_Log" table to your database instead of writing to a text file?
Of course the issue becomes, how do you write diverse data records to the Record_Change_Log table. Perhaps the easiest method would be to have the following:
Record_Change_Log Table...
Think about this one for a minute in a more generic form.
If you had ONLY Access tables that you were working with, would you be able to accomplish your task?
If so, then ignore the origin of the linked tables and do what you would do if this were a pure Access issue.
If not, then THAT is...
Re: " Even if there is no return date, it gives me the membership number, with a video id of 0 and a blank return date."
You might want to add a constraint to the query so that it counts the "no return date records" by member and if the "no return date records" count is 0, it doesn't return a...
Although it was intended for hospital equipment maintenance, I designed a system a while back that was very similar to what yours sounds like.
My approach was to defined the following:
PM_Master:
PM_ID AutoIncrement
PM_Name Text (Char(50) of Human conumable name)...
As a slight variation on the recommendation by RoyVidar, why not create two (2) new databases, one for the data and one for everything else.
1) Import the "Good" data into the Whatever_Data.mdb;
2) Import everything else into the Whatever.mdb.
3) Finally, _link_ the Whatever.mdb to the...
The problem is that, under certain circumstances (e.g. partial processing of the file) the user needs to open the same form and manually initiate a failed portion of the process. The form is currently bound to the table which is used to indicate whether each stage of the processing has been...
Let me see if I understand what you are trying to do with regard to an "I 2 of 5 number":
Let's assume that you have created an "I 2 of 5 number such that it consists of the following:
1 ea product 1
2 ea product 2
2 ea product 3
1 ea product 4
You do not want to allow the creation of ANOTHER...
I have a form that is bound to a table. The table contains some information that lets me know if either or both of two processes have been executed for a given filename. I have progressively added more and more automation to this project but now I've drawn a blank on what I am trying to to add...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.