Search results

I finally figured this out. Or I should say it was something so trivial that it didn't really require any figuring thus the issues with finding it on Google. The table the data was being stored in had the "StartTime" and "EndTime" declared as "Long" instead of "Double".

Thank you jdraw for the detailed response. I don't quite understand the function that you made. I dynamically pass values into the "Start Time" and "End Time" whereas in the function you have coded those times in? Perhaps I am simply misunderstanding it? CazB would you be kind enough to...

Thank you CazB for the prompt response. Yes I would want 30 minutes to show as .50 and so on; however after trying the example you have given I am still not getting the desired result. For example I get the value "2.00" when I have a start time of 1:00 pm and an end time of 2:30 pm. The...

Calling on all Access gurus! I have been absolutely unable to figure this out and after 3 hours of "Googling" it seems what I am requesting is simply not out there - at least I have been unable to find anything similar. I want to be able to display the result of a difference between Date/Time...

Well let's assume I originally added a Word Document as an attachment but I later remembered that I should have put an Excel Document as an attachment instead. In this scenario the "tblAuditTrail" would have the original file (the Word Document) and the new file (Excel Document) whereas the...

Hi Alex, Thank you for the quick response. Yes I am tracking all changes in every table. I am tracking the old value, the new value, the type of entry (i.e. new, delete, or update). Ideally I would like to track the original file and the new file. Regards, Zohair Yousafi

I have been using Access for quite some time now and I am able to usually work around many of the issues that come with being a small timer, like me, taking his best shot at Access; however one issue I have had absolutely no luck with is auditing a new and/or change made to an "Attachment...

Thank you for the help pr2-eugin. I was able to fix my problem by fixing the tab order within the tab control and setting the form tab property to "Current Record". At the end of one tab when I pressed tab the data would vanish and once I fixed the tab order the issue resolved. I am not sure...

Thank you jdraw! That helped.

Thank you for the prompt response Paul. I was able to modify the code from Fonstuff and make it work as per my requirement. Allen Browne's work is awesome but perhaps it would be overkill for a small timer like me! :)

I am using the following code from the Fontstuff website to keep an audit trail in my application. I have been able to substitute the field names with my field names and the audit trail for new records is being maintained; however the audit trail for records I "edit" are not being maintained...

Hi pbaldy, I tried what you said and unfortunately my Combo Box is showing up empty. Can you please help me Regards, Zohair

Hi Paul, Well I have a field in my system, for example "First Name", and I have put live validations on that field. For example a user cannot enter a number in the field or any special characters except "-"; all of this was working perfectly fine until I incorporated the "Tab Control" in...

I am using the Tab Control feature in Access (.accdb) and for some reason the "After Update" code is not triggering through normal means. I removed the "After Update" code and tried again and now while the code is actually triggering the live validations I have put on this particular form the...