HI Remou!
Thanks again, I'm new at VB and trying many things out and of course without a programming background some things are not common sense to me. I will definately use the help you have given me thus far.
I think I understand how this code works now.
Thank you so much!
Shaz1
Good Morning,
I currently have working code which stores changed information into a table. This code uses an autonumber [EquipID] field that applies to an EQUIPMENT table. Now I would like to include the code for other forms with another autonumber field [DwgID]which updates the changes from...
Hi Shy216,
I have no programming experience but have worked with many forms that use continuous forms. What that is specifically is the Default View in your properies of the form. By selecting Continuous Forms is allows the rows to expand as new records are added to the record source. I'm...
Remou,
It working.....just didn't look at the table this time! Need coffee. Thanks so much! Too bad I can't buy you a beer or coffee.
Cheers!
Two thumbs up!
Remou,
I'll try working with the new code tomorrow. But back to this one. It's not updating the changes to the Audit Table. I have a dummy database I tried it on and it's fine. But the live one *shrugs shoulders*
8-)
Remou,
You sure were right on that one! Thank you so much for your efforts on that one. I was still trying to change focus. Trying anything actually.
I found that it's not updating the table though. I'm wondering if it know which record to write to the Audit table?
Remou,
Form Name = F-View All Equipment Tags
EquipID is "1242516" or "367"
Error: Run-time error '6': Overflow
Code used on BeforeUpdate:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim x As Integer
If Not IsNull(Me!EquipID) Then
x = WriteAudit(Me, Me!EquipID)
End...
Hi Remou,
I had actually pasted that code on the webpage only. I checked mine and it is okay.
After running Debug/Compile I get
Compile error:
Member already exists in an object module from which this object module drives.
I've looked for duplicates and can't seem to find any in that module.
Hello, I have no experience with VB or programming. I have copied some code from Candice Tripps link which is called Audit trail. I've added the modules as she shows in her example database and modified to suit. What I would like to do is on the form after a new record is inserted copy user...
Boxhead,
I forgot to mention that the Date field is set to now() so I had hoped to pull out the latest date where there is a duplicate record with another Revision.
Hi Boxhead,
Rev A,B and C is a value in the Field [Revision]. The report shall consist of all Rev A and only the next Revision ie; B. All the additional Revisions like the new Rev B changes are what I would like to have formatted in Bold.
Hi Boxhead,
Thanks for responding so quickly. Yes,this query was set up to show records with criteria >#4/10/2005# to check the formatting if it had changed.
Let's say I have 10 records with Rev A. A report is then issued. Then a user comes in and updates some of the records to Rev B...
Good Morning BoxHead,
I made the date field (MaxOfDate) the first column in my report and added the code. I cannot see any change in formatting on the report. Perhaps I am missing something.
I've attached the query for you to view.
SELECT Max(CABLES.REVDATE) AS MaxOfREVDATE, CABLES.[CONDUIT...
BoxHead,
If a new revision/record is added then we assume that their is some modification to either fields. I plan on using MaxOnDate to identify those changes.
Shaz1
Hi Boxhead,
I must explain that I am very new at VB and experimented with using "*" for all the textBoxes. But I seem to get a compile error with the wildcard. Do you know the best way to identify all of the textBox's?
Option Compare Database
Private Sub Detail_Format(Cancel As Integer...
Hi all,
Does anyone have any suggestions for a recent new user?
In Access 2000 I am designing a report to show revisions or changes. Example:
Multiple revisions of a record added to a table with different revisions (A, B, C ect;)
In the report I need to print the the latest revision...
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.