Recent content by Craig0201

One thing you could think about is whether you can always get to a consistent state. If you trap Form1's Unload event, you can set it to never close using Cancel = True and always set it to hide unless certain conditions are met. From that, you may be able to work a solution.

To do a proper search function, the most effective ways is to create an inverted index of the items you wish to search on and use the results of the search on this to link back to the items. It's pretty standard stuff which you should be able to find on Google.

.Ticks

You don't need to run the script from the executable. Centos can be set up to watch the path in natively using Gamin and Inotify. Craig

Is this not an Observer style idea? C

Re: "Because we are a 24/7 operation and the information in the database is CRITICAL" I'd stop worrying about a 55 second time delay and worry about moving the data to an enterprise quality database. SQL Server Express has these qualities and is free. C

Why would you do this at all? The Engagement presumably has a date. Sort the Engagements by school and by date. The 'Number' is then calculable.

As long as the convention is understood, there's no reason to need to use restrictive access modifiers on the concrete types." But humans are involved......

Re: Plan, Do, Check, Learn. More commonly Plan Do Check Act, the classic Deming quality cycle. Re: 1. First, you have to understand the problem. 2. After understanding, then make a plan. 3. Carry out the plan and test. 4. Look back on your work. How could it be better...

You're using the wrong wildcard character. Access uses * not %

What line of code is throwing the error? A quick Google search indicates plenty of people with similar problems when using the [Forms]![frm...] syntax, many of which are resolved using the Me. syntax C

Of course the user should not interfere with the technical solution. But what should be reasons to follow or NOT follow the technical solution the user suggests?? " I think that summarises your problem nicely. You're doing things that you believe are right but have no rationale for doing so...

Roll your own serialisation. C

I'll ask the simple question..... Why the recordset? Can you not achieve the insert by a (series of) query(ies)? I'm guessing yes. C

Google is your friend. http://www.codeproject.com/KB/shell/clipboard01.aspx