Thank you All!!!

Just wanted to write a short note to thank everyone that helped me within
the last few months. I had been working on re-working my business app in
Access 2007, and I had help from everything from ribbons, to
application.printer commands, referential integrity, tree view's, late
binding's, import strategies, you name it.

This group helped a great deal, and I'm not sure I could have completed
certain things without all of you!

Thanks so much,

Andy

BTW, if anyone wants to have a look at a first release 2007 app, I'll post a
link in this thread if you want, and if no one objects. I think, all in all,
I must have spent 100 of my estimated 1,000 hours of development work on the
ribbon interface alone. Fun to work with, but a crazy amount of hours to
learn. One of the hardest parts was the Import Utility. When you're
importing from a 97 db, with no referential integrity, to a 2007 db with
full RE, it's a bit of a bear! Many thanks again, All!

Re: Thank you All!!!

On Wed, 17 Oct 2007 23:55:24 GMT, "ARC"
wrote:

Good luck with your launch. It's great to lend an occasional helping
hand to someone who is really trying to do the right thing.

-Tom.


>Just wanted to write a short note to thank everyone that helped me within
>the last few months. I had been working on re-working my business app in
>Access 2007, and I had help from everything from ribbons, to
>application.printer commands, referential integrity, tree view's, late
>binding's, import strategies, you name it.
>
>This group helped a great deal, and I'm not sure I could have completed
>certain things without all of you!
>
>Thanks so much,
>
>Andy
>
>BTW, if anyone wants to have a look at a first release 2007 app, I'll post a
>link in this thread if you want, and if no one objects. I think, all in all,
>I must have spent 100 of my estimated 1,000 hours of development work on the
>ribbon interface alone. Fun to work with, but a crazy amount of hours to
>learn. One of the hardest parts was the Import Utility. When you're
>importing from a 97 db, with no referential integrity, to a 2007 db with
>full RE, it's a bit of a bear! Many thanks again, All!

Re: Thank you All!!!

Many thanks, Tom. I appreciate that...

I think it was you who suggested on doing a compact/repair on the source
import database at the very least (for the import utility I was working
on)... Unfortunately, I couldn't. Access 2007 wouldn't compact a 97 db via
code. :( It's bit me twice already, where the import works fine, but the
source had some corrupted notes fields, etc.

On an interesting note. If you ever have to write an import utility into a
2007 db, make sure to compact the resulting 2007 database after the import!
One customer had trouble with RE and adding a new record on the resulting
db. Doing the compact refreshed all id's / indexes, etc. So when you're
importing to a clean db, you really need a compact at the very end of the
process.

Thanks again,

Andy
"Tom van Stiphout" wrote in message
news:arcdh39f8da21r6fdl25ph9bf5ab2sijpo@4ax.com...
> On Wed, 17 Oct 2007 23:55:24 GMT, "ARC"
> wrote:
>
> Good luck with your launch. It's great to lend an occasional helping
> hand to someone who is really trying to do the right thing.
>
> -Tom.
>
>
>>Just wanted to write a short note to thank everyone that helped me within
>>the last few months. I had been working on re-working my business app in
>>Access 2007, and I had help from everything from ribbons, to
>>application.printer commands, referential integrity, tree view's, late
>>binding's, import strategies, you name it.
>>
>>This group helped a great deal, and I'm not sure I could have completed
>>certain things without all of you!
>>
>>Thanks so much,
>>
>>Andy
>>
>>BTW, if anyone wants to have a look at a first release 2007 app, I'll post
>>a
>>link in this thread if you want, and if no one objects. I think, all in
>>all,
>>I must have spent 100 of my estimated 1,000 hours of development work on
>>the
>>ribbon interface alone. Fun to work with, but a crazy amount of hours to
>>learn. One of the hardest parts was the Import Utility. When you're
>>importing from a 97 db, with no referential integrity, to a 2007 db with
>>full RE, it's a bit of a bear! Many thanks again, All!