Search results

That's pretty much what we mean by 'phoning home' - validate against an external authority that keeps track of licences and permissions, etc. It works, but as discussed above, for the small-time developer, it commits you to supporting the application into the indefinite future and it puts your...

I wonder if there's some kind of execution stack that's getting filled up here. Try putting DoEvents inside the loop, immediately after your DoCmd line(s) - i.e.: For i = 2 To iMax sText1(i) = "Fld" & i DoCmd.RunSQL "ALTER TABLE TestTab ADD COLUMN [" & sText1(i) & "] TEXT(10);" DoEvents Next i

If that's not already the right term for it, it ought to be. I like it.

If either one of the two queries could potentially be empty, then you may need to create a third one that just selects the base fields (or you might be able to use the underlying table), then Left join both of the other two out from it.

I agree - because it's considerably easier to implement a time bomb to keep your support customers paying their subscriptions, than it is to implement a limitation on the installation process. Furthermore, if you are unable, or unwilling to continue developing/supporting the application, it...

Really?! I always search for stuff I know will be useless. You're a spammer, of course, but something went wrong, didn't it?

In practical terms, there's usually little difference - that is, data presented in a .txt file to be imported into a database is often comma-separated inside the file. (not always - it may be fixed width or something else, but CSV is common) - And conversely, a .csv file is just a text file...

I'd agree, with certain exceptions - local tables can be useful for: -Storing local configuration settings specific to the client machine (can't think of a brilliant example, but there are probably valid ones - maybe if your application has to interact with something that is in different...

First off, what you have there is a couple of functions - all by themselves, they have no idea what they're meant to do - they need to be called, with parameters specifying what objects they are meant to act on. If you want to call them repeatedly throughout the whole time your database is...

What calculated fields have you in the query? You mentioned a percentage field - could there be a division by zero problem here?

There might be an MS Visio activex object available in your version of Access, but I'm afraid I have no idea how to use it - I've only seen other people use Visio - which it why the report looked familiar.

I think that's a Visio chart.

Putting the Google Adsense stuff (including custom search) centrally at the top of the main content typically generates the biggest ad revenues - as described here: https://www.google.com/adsense/support/bin/answer.py?answer=17954 As a webmaster, it's not a choice I would make myself, but then...

Thanks for that - so would you recommend calling that from a dedicated single-purpose startup form that runs this code, launches the login form, then closes itself?

How is he trying to export them? Through the menu options in the Access Window, or is it some VBA code built into an Access application that's trying to perform the export?

I've got an application that uses pop up forms that open on top of the desktop (with the Access window minimised) - except that when a user launches the application, the startup form (a login form) drops behind other application windows. How do I force it to the front?

Just download and install a free 3of9 barcode font and format the cell in that font. As Bulrush said, you might need to enclose the value in delimiter characters such as *

I don't smoke

The big problem with phoning home to activate is that it requires the vendor to support the application into the indefinite future. That's OK when it's a big corporation like MS or Adobe, who can reasonably be expected to still be trading (and interested in the product) next year, but for a...

I think there are some OEM builds of XP that do not require online activation - in fact, I'm pretty sure my old Acer desktop has one. They only work this way when installed on the appropriate hardware though, I think.