Recent content by skeeter23

Unfortunately that is what I presumed but thought I would ask. I think I'll instead have to try to write it in a way that another instance can be run under a different profile until the issue is resolved by the first :( I'm tired of being the only person in the entire company that can admin...

Simply put, I have a front end that does a bunch of file moving and if it encounters an error and stops processing (which is intentional) I am the only that can login to the machine and fix it. Is there any way to run it that would allow others to login on their own user profile, solution the...

Thanks for the reply DJkarl... Since this system is largely passive I won't be able to use a shell command that requires user response. I actually use an unhandled error of "file already exists" to stop all the code until the issue is resolved. This in turn also alerts another system that...

Not sure why I never responded back to this but thank you all for the help. In the end the system ended up being split access only. I am now working on v2.0 which IS being built ground up on SQL :)

File staging/copying/moving system - better method? Hello all! It's been quite some time since I've been able to post here but I am in a bit of a quandry here redesigning a system I created a few years ago and hope someone can lend some help with a possible better solution for my code. I...

No I have not migrated a backend before. I was forced by management to begin development before I could prove my case to them that I felt we needed a SQL server for this. Now the server has finally been approved and built (well virtually configured anyway) but I still dont have create...

I am currently developing a system that will eventually handle large portions of job control, tracking, and billing data. This system may be accessed simultaneously by 25 or more users at any given time. So far the interface, subsequent code, and structure are built on a split access...

Yup that's it ;)

Simply go back to the one where you had added =[Amount]-[Discount] in the form for the total box and then delete the total feild from the table and query.

What we're referring to is that when you know that "total" is simply a calculation of other feilds it should not be stored, only displayed. You know that the total is always derived from the equation of amount-discount so total is redundant. Total should not be a field in your table. When the...

Yes that is a true statement. That is something to keep in mind phatus. That "total" really should not be stored but rather queried whenever you need it. That being said really the way you had it setup in the first place was fine. However that wasn't your question though so I answered it the...

Fixed. The main problem though is that you did not have a control source set to the table. Since the control source was = [Amount] - [Discount] it was only displaying the result and not actually doing anything with it. I switched the source to Total and added the VBA I suggested in the after...

I know this is a topic that has been searched and asked alot since this afternoon I did it myself and found lots of questions and no simple answers. Therefore I thought I would share the simple quick and dirty solution for displaying data from multiple sources on one form without recordset...

In the "After Update" event of both the amount and discount fields add this... Me.Total.Value = Me.Amount - Me.Discount DoCmd.RepaintObject

Good point. I like your solution. It probably also needs to be within the construct of an if else statement as well for supply outages :D