Search results

There are times in the series where Dany shows glimpses of the madness her House is famed for. Not in a 'gibbering and seeing dancing hippos wearing tutus' way, but rather in an 'everyone who opposes me will DIE' way.

lol Fair enough!

Except that it's a combination of reference manual and short story collection rather than a novel. Don't get me wrong - short story collections are nice, but they're like driving a go-kart while you wait for your Lamborghini to arrive. The Dresden Files, another series I read, is having...

LOL each new book? The last Song of Ice and Fire book to be published (A Dance With Dragons) came out three months into the first season of Game of Thrones. :p We've been waiting for The Winds of Winter for nearly 8 years now, and there's still no release date on the horizon.

Yeah, might be best to use VBA to set the location properties for your images when the form is loaded so that people can install it wherever they want. That won't noticeably slow down your form loads, so it should be fine.

Personally, I'd set the program up to be installed into its own directory somewhere, which would also allow you to install required image files. That, in turn, would allow you to link the images rather than embed them, which will go a long way toward minimizing the application's size. Never...

They shouldn't, but anything is possible with Microsoft. When I upgraded, all my document extensions got unassigned, and I had to go back and manually fix all of them. I asked because the behavior you're describing is what you'd get if you chose not to enable macros and told Access not to ask...

Were you asked to enable macros? Is the database or its folder listed on the Trusted Documents page?

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.

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 +...