Browse by Tags

All Tags » Access (RSS)

Queries On Steroids ... Part IV

I was reminded of this article in a discussion in a newsgroup/forum.   As I’m always interested in the hard core details of anything computer related but especially anything to do with Access or Jet I thought I’d share this with you. Queries...
Posted by Tony | with no comments
Filed under: , ,

Updated a few pages on PDF printing

I answered a question recently and realized that several of my pages were woefully out of date.  Well, more than a few but I’ve updated the following. Creating PDF files from within Microsoft Access Emailing reports as attachments from Microsoft...

You *CAN* install Access versions in whatever order you want

I see another posting stating that you MUST install multiple Access versions in chronological order.  That is Access 97, then 2000, 2003 and finally 2007.  This is WRONG< WRONG, WRONG.  I have very deliberately installed Access versions...
Posted by Tony | with no comments
Filed under:

Time stamping a code signed Access file

The following was asked: *Hi, I have a digital certificate and is able to sign my code. Back in XP I have to specify a timestamp server in the registry for my code to be timestamped. Now in Win 7 and Office 2010:* *1. Where do I specify the timestamp...
Posted by Tony | 2 comment(s)
Filed under: ,

Finally got going with the Microsoft Answers forums in my NNTP news reader

I answered a few questions using the online Answers webs site but I sure wasn’t happy with Microsoft or other forums given the limitations that are common to many/most/all? web forums.  Such as sluggishness compared to using client software which...
Posted by Tony | 2 comment(s)
Filed under:

VBA Hover ToolTip Trick

Try ctrl+hover over a longish string variable when in debug mode.  Cool! VBA Hover ToolTip Trick I learn something new about Access every once in a while.
Posted by Tony | 1 comment(s)
Filed under: ,

Never, ever again will I use the letter i as a counter in a loop

Ok, so I recently read an article, maybe by Joel Spolsky, about not using i, j and k as counters.  Those familiar constructs of For i = 1 to Ubound(SomeArray()) …. next i should be using a full variable name of some sort.   The code I’m working...
Posted by Tony | 1 comment(s)
Filed under: ,

Working with an unbound grid of controls

Now this isn’t a technique that you’d use very often but it can come in handy sometimes.  This particular poster want to create a set of 9 x 9 data entry controls which looked like the paper form and the sample tray.  So yes it’s unnormalized...
Posted by Tony | 5 comment(s)
Filed under: ,

VBA Unit testing for Office

No idea how useful this is but a posting on Stack Overflow mentioned VBAUnit   VBAUnit is an extension of Beck and Gamma's JUnit unit-testing framework designed to work in Microsoft's Office2000 using Visual Basic For Applications.
Posted by Tony | with no comments
Filed under: , ,

What screen resolution is the smallest Access developers use these days?

I’m working on some Access forms as part of the soon to be released Enterprise Edition of the Auto FE Updater.  (After all Access is far better than Visual Basic 6 to display or update data in the tables.)   So what screen resolution do...
Posted by Tony | 5 comment(s)
Filed under: ,

I've never quite trusted ADO because …

I've never quite trusted ADO because I've never understood how their versioning system works. I just couldn’t see the various versions DLLs on my system and yet the Access references window showed five or six different versions..   Jet...
Posted by Tony | 7 comment(s)
Filed under: , , ,

Microsoft Office Diagnostics fixed “SendObject stopped responding”

A posting titled SendObject stopped responding caught my attention.  in it Rick stated “I finally ran the microsoft office diagnostics and it found one error and repaired it. “  You can find Microsoft Office Diagnostics on your Windows XP Programs...
Posted by Tony | with no comments
Filed under: ,

Kicking out users after inactivity

I just received an email thanking me for the Auto FE Updater and expressing a certain amount of annoyance at users who don’t exit Access at the end of the day. I use the following to kick users out so I can make changes to the back end after hours. HOW...
Posted by Tony | 2 comment(s)
Filed under: , ,

Bug with Access and SQL Server: Erroneous #Deleted bug on Insert with null values

When a new row is inserted into a view that uses identity but contains null values for at least one field and Access' subsequent attempts to locate the new row uses "a_field = NULL" and thus will always fail to find that row and return #Deleted...
Posted by Tony | with no comments
Filed under: , ,

How do you create a mdb database file in Python?

An interesting question was asked on StackOverlow. The answer was surprisingly easy (assuming the answer was accurate of course. <smile>)  See How do you create a mdb database file in Python? I should add that I have no idea what Python is...
Posted by Tony | 1 comment(s)
Filed under: , ,

Puzzling problem with Access’s built in Shell function

I was testing some code, which will be available in a few days as part of a new release of the Auto FE Updater, which uses the Access shell function to start the Auto FE Updater. I could hear the beep sound but I couldn’t see the customized form to display...
Posted by Tony | 8 comment(s)

Misleading error message when creating relationship between two tables with lengthy names

If you attempt to create a relationship between two tables with a combined table name length greater than 64 characters you will get the following confusing error message. "<combined table names> is not a valid name.  Make sure that it...
Posted by Tony | 1 comment(s)
Filed under:

An amusing bug – Report with 36505 pages has negative page numbers

A most amusing thread ms access negative page numbers “I have an access report that generates 36505 pages ( un filtered, and about half of each page is taken up by group headers and page headers) , though the footer at the bottom of the report page says...
Posted by Tony | 1 comment(s)
Filed under: ,

Accessing external data using the IN clause in SQL

I happened to come across this article Accessing external data using the IN clause by the Access product group recently again.  I thought I’d do a blog posting describing how I use the IN clause to update tables in the Granite Fleet Manager when...

vbMAPI - Outlook Security Evader for Office / VBA and classic VB6

vbMAPI - Outlook Security Evader for Office / VBA and classic VB6   Another interesting product by Wayne Phillips. Thanks to fellow MVP Alex Dybenko for noticing this .
Posted by Tony | 1 comment(s)
Filed under: , ,
More Posts « Previous page - Next page »