Tony's Microsoft Access Blog - All Comments

re: Two new versions of the Auto FE Updater are available.

PJ — Thu, 19 Nov 2009 15:41:22 GMT

Tony, version 1.82 did the job! Thank you

re: The expression On Click you entered ...

Tom — Thu, 19 Nov 2009 15:37:39 GMT

please can someone explain this to me for someone who is still stuck with this message PLEASE

re: Two new versions of the Auto FE Updater are available.

Tony — Thu, 19 Nov 2009 00:19:44 GMT

See autofeupdater.com/download.htm for version 1.82 that fixes this problem.

re: Two new versions of the Auto FE Updater are available.

Tony — Wed, 18 Nov 2009 17:23:53 GMT

PJ. Ahh, ooops. That was embarrassingly stupid of me. I will get a fix out shortly.

re: Two new versions of the Auto FE Updater are available.

PJ — Wed, 18 Nov 2009 11:33:23 GMT

Thanks Tony, works like a charm. Especially the the Access 2007 Security Warning enhancement is very handy!

The only thing is that I seem to need to manually change the "Last Date & Time Checked for updates" property in the AutoFEUpdater.INI file.

re: Windows Live Family Safety Filter is an enormous pain

Tony — Sun, 15 Nov 2009 19:42:37 GMT

Well, she wasn't that close of a friend. Indeed she recently died due to brain cancer. Very pleasant and cheerful person despite the years of enduring cancer treatments.

re: Windows Live Family Safety Filter is an enormous pain

southpeak — Sun, 15 Nov 2009 19:28:16 GMT

If she was a friend, you won't charge her $10. ;)

re: Compile error: Sub or Function not defined

Mohd Ajaz Ali — Sun, 15 Nov 2009 07:58:58 GMT

I ahve created a form andI need to assigne a Command Button to enter the data in ME Excel si for that I have given a VBA code in tha I am recieving a Comple Error as "Sub or Fnction or Not Defined"

the Gode is

Private Sub ExportToExcel_Click()

On Error GoTo Er_Handler

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel8

TabObervartionEachCompany , "C:\Documents and Settings\Administrator\Desktop\404CSWORiyadh12.accdb", True

Exit_Routine

Exit Sub

Err_Handler:

MsgBox (Err.Number & "-" & Err.Description & "-" & Err.Source)

Resum Exit_Routine

Resume

End Sub

re: Changing Allow Design Changes while at the Form View

BurtFaseman — Thu, 12 Nov 2009 15:27:48 GMT

Another thing you can do is uncheck the checkbox at Office-Button/Access-Options/Current-Database/Application-Options labeled "Enable design changes for tables in Datasheet view (for this database)". I unchecked this after setting AllowDesignChanges to false, so I don't know if it would have worked.

re: The expression On Click you entered ...

Phillip — Tue, 10 Nov 2009 13:38:49 GMT

I am running into this problem on a couple of computers running the same mdb (always via Access 2003)from a portable HD. On most computers it's not an issue. I'll try the Save As... fix forthrightly.

None

HansDietrich — Mon, 09 Nov 2009 06:51:52 GMT

Glückwunsch zum neuen Blog!

Access 2010 and Sharepoint discussion part 2

Tony's Microsoft Access Blog — Mon, 09 Nov 2009 03:56:31 GMT

In this blog entry Access 2010 and Sharepoint discussion I mentioned an interesting discussion

re: I hit the compile button every few lines of VBA code I enter

Srinivaa — Sun, 08 Nov 2009 17:47:02 GMT

Tony,

This is excellent article, i resolved my issue with in 5 min.

Thanks & Regards,

Srinivas

re: Windows Live Family Safety Filter is an enormous pain

Susanne — Sat, 31 Oct 2009 06:12:06 GMT

Thank you! Uninstalling Family Safety worked for me just now. Hopefully it's a permanent fix, this program has caused nothing but frustrations since I installed it last year, in the hopes of keeping my kids out of trouble. It never worked as advertized, and at the end blocked my access to the internet all together.

Good riddace.

Why doesn't Microsoft mention this in their website?

Next5Exits — Fri, 30 Oct 2009 22:46:09 GMT

This fix (SAVE AS..) addressed this same issue we had with our ADP file. Thank you so much.

Microsoft should have covered this in their support, KB or MSDN.

re: I can't download Google Earth

Doug — Fri, 30 Oct 2009 21:07:37 GMT

The link from the entry above by jluc finally worked for me. I have vista on my HP laptop and tried many links to get google to download and show up with an icon on my desktop, and this one worked:

earth.google.com/.../thanks.html

re: Share your Access 2007 templates

Sieng Leng — Thu, 29 Oct 2009 01:04:44 GMT

Need template of Ms. Access to study database

re: Getting a list of control names on a form

tharpa — Tue, 27 Oct 2009 16:07:02 GMT

It doesn't work for me in 2007.

re: Jackcess is a pure Java library for reading from and writing to MS Access databases.

Tony — Sun, 25 Oct 2009 01:41:23 GMT

I wasn't aware I had mentioned this project previously although I have mentioned MDBTools a few times.

I'm interested in anything that "gets under the hood" of the MDB format . (In a non NDA sense of course). So I figured someone might be interested and poke about a bit.

I was a bit puzzled myself as to why they figured there was a significant different between A2000 and A2002/2003 format files.

re: Jet Engine History

David W. Fenton — Sun, 25 Oct 2009 01:33:30 GMT

My bet is that the Jet history at the beginning in the 3.5 version is identical to that in the 3.0 version. If you sent me the 3.0 version, I'd send you the 3.5 (scanned to PDF, not typed).

Really, I'm not sure the 2nd edition is of sufficient use to be worth spending the money to acquire it. Certainly, I use it, but then, I've never fully reconciled to Jet 4.0!

It's really too bad they didn't put the effort into a Jet 4 edition. It wouldn't surprise me, though, if we someday got an ACE version which included a lot of the content that would have appeared in a Jet 4 edition.

David W. Fenton

http://dfenton.com/DFA/