cdmonroe
Last Activity: Aug 30 '07, 05:00 PM
Joined: Aug 9 '07
Location: Denton, TX
-
When I get these errors, compiling sometimes shows a problem, but it doesn't always highlight a specific line even before I import to the new file. I usually don't compile after import because I don't get the errors again.... -
Random VBA errors
I've been having trouble with several of my databases getting errors on VBA codes about missing references or invalid call procedures that I can't ever find and eliminate... but if I import the entire database (all tables, forms, macros, reports, modules) into a new file, the errors go away. Is this a known issue? Is there an update or patch I'm missing? or is this just some kind of file corruption issue? Any hints about this would be appreciated.... -
Should be easy... checking for an existing record
Hi all, I need help on something that seems like it should be easy to do.
When entering new data onto any form in my database the field [SubNo] has to exist in another table (tblPatients). If a SubNo is entered that isn't already on tblPatients, I want it to open the form frmNewPatient to add the patient to tblPatients; If the SubNo is already in tblPatients, I want it to do nothing. I can't figure out what the condition should... -
You are brilliant! I found the problem. I had copied and pasted repeated fields from the first form to the others.. so the name of the control was wrong! There was a difference in the "Type" on the two watches. THANK YOU THANK YOU THANK YOU! I'm a real novice at all this and haven't had to debug anything yet. I will make use of the watch lists more now.
Thanks again!!!...Leave a comment:
-
Here's the weird thing... this code actually works on one form in the database and not on another (I haven't checked more yet). On the broken one I currently get a Runtime error '13' type mismatch and it pops at the line.
Call AuditTrail(Me, RecordNo)
I think you're right about the control versus variable, but why is it treating it differently in one form versus the other? All tables in this database use [RecordNo]...Leave a comment:
-
audit trail issues
I'm implementing someone else's code for creating an audit trail for data edits. I REALLY need this or something similar to track changes made to my the data in my forms.
The first time I put it in, it worked great... I tried in another database and started getting ByRef argument type mismatch errors... I had to go back and modify the original database and now I'm getting "Compile Error: type mismatch" errors. I'm going...
No activity results to display
Leave a comment: