Search results

No, he's trolling you.

Saying that Americans just accept gun violence is much like saying that Brits just want a hard exit from the EU.

In fact, here's what I'm talking about. Note that this is NOT design mode. Changes users make to the display here prompt a save dialog when they attempt to close the form (unless you take steps), and there's often no harm allowing them to save their changes if they're using a local copy.

I never said anything about opening it in design mode. If you open in DATASHEET mode, they can hide and unhide columns, sort, filter, and the rest, all of which are counted as design changes despite not being in design mode. If your user is running a persistent local copy, there's no real...

I've never had to do this, since my department's policy is to have users download a new copy of the front end every time they open the app, but I can think of one case where this would be acceptable: Let's say you have a main form/subform setup (or even just one form), where the bulk of the...

Absolutely. What will you do if a company changes its name? That DOES happen; as just one example, Federal Express became FedEx. If you use the name as a key, then when a company changes its name, you need to either create a new entry, effectively losing all your history, or else go through...

I'm afraid you lost me.

MajP, you absolutely should put that FuzzyFind database from post 13 into either the code repository or the sample database subforum.

Okay, next question - do you need ALL of the data in every table? All we really need is enough for the application to be functional. Things like invoice systems only needing a couple invoices, etc. Because, seriously, if just a handful of records results in a 2 MB database, you probably have...

Is it over 2 megs even if you zip it?

Also, note that spam posting just to reach 10 has been known to result in the spam posts getting deleted. Just post a stripped-down database (just enough to run the part you're stuck on, with fake data) inside a zip file. You can do that regardless of post count.

Colin, Colin. In the US, saying the slightest negative thing about Israel or any of its actions means you're an avowed anti-Semite. Hell, in many states, it's actually illegal to boycott any Israeli-owned business for any reason whatsoever, and there was recently talk about making it a federal...

Your initial point was that Democrats and liberals were destroying education and weaponizing children by turning them into mindless meme-spouting automatons unable to think for themselves. Now you're saying they aren't. Make up your mind!

California may rank toward the bottom, but research indicates that top six states (Massachusetts, New Hampshire, New Jersey, Vermont, Connecticut, and Maine) are ALSO under more or less complete Democrat control. https://www.usnews.com/news/best-states/rankings/education/prek-12 AB, please...

I have to admit, it's amusing watching him regurgitate the same tired arguments luddites and other reactionaries have been screaming about regarding the American education system for at least the last hundred years, since well before the Scopes Monkey Trial resulted in Scopes being found guilty...

Okay, two things: One thing that just jumped out at me is this: qdf.SQL = "EXEC dbo.sp_MRN_CleanUp =" & "" & DonorNum 'Simple runs a truncate table You normally don't do 'EXEC StoredProcedure = Value'. Try changing it to this: qdf.SQL = "EXEC dbo.sp_MRN_CleanUp " & DonorNum Alternately, add...

I know you are, I just wanted to confirm it worked fine on its own. My next step in your shoes would be to create a saved pass-through query, update it with the correct connection string, include the EXEC code, save it, and run the query. That will tell you if it's the form's vba or if it's...

ODBC call failed is a generic error that doesn't tell you what's going on. It could be a time-out, the stored procedure not existing, the procedure failing, anything. Have you confirmed that the stored proc works when run manually? I'd also suggest changing dbFailOnErrror to 'dbSeeChanges +...

Hours rolling over isn't generally allowed here because companies have a history of abusing the hell out of it. Basically, you need to pay overtime however states determine it. Some also allow comp time - extra PTO in lieu of pay - but I'd be surprised if ALL states do. (Personally I feel it...

I think he's looking for suggestions for a web interface for this database to replace Access.