Access 2007 VBA Programmers Reference Code

[RiceFarmer via AccessMonster.com]

I have the book Access 2007 VBA Programmers Reference, and have downloaded
the code from the website, trying to reuse the code, as the authors say to do
in the book. I don't see the functions in chapter 15 that I am trying to use.
Anybody know how to find them? one of them is the ReplaceWhereClause()
Function. I find others, but not that.

 

[Tom van Stiphout]

On Sat, 06 Feb 2010 21:24:01 GMT, "RiceFarmer via AccessMonster.com"

Did you check with the publisher's website? Sometimes they have errata
and additional downloads.

-Tom.
Microsoft Access MVP

 

[RiceFarmer via AccessMonster.com]

Yes. That's where I downloaded the files. There was no CD with the book. I
also found the errata, and it was not listed. I hate to key it in manually,
since my typing isn't wonderful. However, that may be the only solution.
Thanks.

 

[ryguy7272]

Or, just forget it and move on. When I was learning Access, I tried to
absorb as much as I could, and tried to experiment with every single example
I could find. Often, I would modify the code, and often I got the results I
was looking for, but sometimes, I got stuck on something, and it really
slowed me down because I couldn't figure out a technical detail or two. In
the grand scheme of things, this one example won't matter to you in a few
months. Continue learning as much as you can, and your collective knowledge
of things will improve, and soon you will have a good overall perspective on
how things work. This is the real value of learning Access (or any app).
One day you'll come across the example you are dealing with now, or something
very similar, and at that point, based on your cumulative knowledge, you will
probably be able to bring your experience to bear on the problem, and solve
it quite easily, by applying what you've learned while solving other
problems. Just keep at it. The day you stop learning is the day you die.

 

[RiceFarmer via AccessMonster.com]

Great Advice! Thanks. I have already experienced exactly what you are
describing. Access and VBA have a pretty steep learning curve, but I'm
gaining ground.

Or, just forget it and move on. When I was learning Access, I tried to
absorb as much as I could, and tried to experiment with every single example
I could find. Often, I would modify the code, and often I got the results I
was looking for, but sometimes, I got stuck on something, and it really
slowed me down because I couldn't figure out a technical detail or two. In
the grand scheme of things, this one example won't matter to you in a few
months. Continue learning as much as you can, and your collective knowledge
of things will improve, and soon you will have a good overall perspective on
how things work. This is the real value of learning Access (or any app).
One day you'll come across the example you are dealing with now, or something
very similar, and at that point, based on your cumulative knowledge, you will
probably be able to bring your experience to bear on the problem, and solve
it quite easily, by applying what you've learned while solving other
problems. Just keep at it. The day you stop learning is the day you die.

Yes. That's where I downloaded the files. There was no CD with the book. I
also found the errata, and it was not listed. I hate to key it in manually,

[quoted text clipped - 12 lines]

 

[Stuart McCall]

You may want to keep this in mind on your journey:

"Press on--nothing can take the place of persistence.
Talent will not; nothing is more common than unsuccessful men with talent.
Genius will not; unrewarded genius is almost a proverb.
Education will not; the world is full of educated derelicts.
Perseverance and determination alone are omnipotent."
-- Calvin Coolidge

Hope that's helpful

 

[Jeff Conrad [MSFT]]

One of the authors of that book works down the hall from me. I asked him your question and here was
Rob's response:
It looks like the code for chapter 15 is combined in a zip file with chapters 8 and 9:
http://media.wiley.com/product_ancillary/38/04700470/DOWNLOAD/047033ch08_09_15.zip

Looking through the sample, this function appears to be in Chamber Application.accdb in the module
named basSQLTools.
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[RiceFarmer via AccessMonster.com]

Thanks Jeff,
I have that file. I can run the application, but can't get to the code.
Design View is obviously disabled. Is there a way to get inside the
application? I know I'm gonna feel like a dummy when you tell me. Thanks.

 

[Jeff Conrad [MSFT]]

Did you try holding down the Shift key while opening the database to bypass all the startup code?
You should then have no problem opening any objects from the Navigation Pane.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[RiceFarmer via AccessMonster.com]

I told you I was gonna feel like a dummy. I had read that trick somewhere,
but couldn't remember where. You saved the day! Thanks a million.

Did you try holding down the Shift key while opening the database to bypass all the startup code?
You should then have no problem opening any objects from the Navigation Pane.

Thanks Jeff,
I have that file. I can run the application, but can't get to the code.

[quoted text clipped - 16 lines]

 

[Jeff Conrad [MSFT]]

No problem, glad to help.
Good luck with your studies.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

in message:

I told you I was gonna feel like a dummy. I had read that trick somewhere,
but couldn't remember where. You saved the day! Thanks a million.

Did you try holding down the Shift key while opening the database to bypass all the startup code?
You should then have no problem opening any objects from the Navigation Pane.

Thanks Jeff,
I have that file. I can run the application, but can't get to the code.

[quoted text clipped - 16 lines]

Anybody know how to find them? one of them is the ReplaceWhereClause()
Function. I find others, but not that.