Recent content by tad0075

Thanks, spikepl! I'm working on getting access to 2010 on a virtual desktop so I can use both simultaneously. I also found a good msdn article on the issue that outlines a long list of features with compatibility issues...

Hi All - Until recently, I was using Access 2010 but was downgraded to 2007 because of compatibility issues between the 2 versions. I now have a 2010 database that cannot be opened in my current version (2007), and it looks like I will have to recreate a ton of custom code if I can't recover...

Perfect! I used Rule #2 instead of Rule #3 to delimit my embedded string, and it works great now.

Hi all - My db contains an unlinked form that is used to append records to 1-3 separate tables (tests to see if master records exists, appends if needed, moves on to child records). One of the fields is a text field meant for notes. The VBA errors out whenever this text contains apostrophes or...

Any reason you couldn't copy this exact code to a button's OnClick event?

Good point. Thanks for your help!

Yes, but it never worked as expected on step 3. I can live with it as it is now, since it will work correctly for the users.

That's odd. It's still behaving a little strangely. I can open the form from the objects pane, and I can call it out from another form using VBA, but when I try to switch from Design view to Form view, it disappears like before. It won't be a problem for the end users, so I'll just learn to...

Success! That was quick, what did it take to fix it?

Sample attached.

Visible returns True

WindowTop returns 0 WindowLeft returns 1

I found it, but I've never used it before. Can you guide me through what to look for?

Tabbed form: https://plus.google.com/105344220430865949067/posts/Q8DkZQ48dDF

It appears as a tabbed form with no obvious problems.