A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Have I stumped the MVPs?



 
 
Thread Tools Display Modes
  #11  
Old September 28th, 2009, 02:54 AM posted to microsoft.public.access,microsoft.public.access.modulesdaovba,microsoft.public.access.tablesdbdesign,microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Have I stumped the MVPs?

Dale,

Even on their locals? This would also apply to other Office 2007
applications, so does everyone save to the Server?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Gina,

I had been putting the apps in a Trusted Location, right until my client
disabled Trusted Locations on all computers in the organization.

Thanks anyway.

"Gina Whipp" wrote in message
...
Dale,

Key is "...almost every post...". I would image a few slip thru the
cracks, no moving along...

I am willing to take a stab at question 1, which I did so now waiting in
you to reply. As for question 2, not sure I am knowledgeable enough
about Trusted Publishers and/or Digital Signatures BUT form what little I
know THOUGHT those applied to add-ons, macros, etc... Therefore the
actual databases must be placed in a Trusted Location. You really can't
compare Access 2003 and Access 2007 as they are two different animals
though they both have stripes.

Have a look at this and see if it can help you set up a Trusted Location
http://accessjunkie.com/faq_33.aspx

Perhaps, when/if someone has time they can direct you to a site that
explains it better then my meager attempt!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Over the years, I've been really impressed with the way that the Access
MVPs and others seem to answer almost every post, or at least the ones
where the OP is engaged, and answers the questions posed by the
newsgroup volunteers. I've visited a lot of the other MS newsgroups, and
would be willing to bet that the response rate in the Access groups is
among the highest.

However, lately, I've had a couple of posts which have not gotten a
single reply:

Trusted publisher / Digital Signature
(http://www.microsoft.com/office/comm...-05856f1d2845).
With this one, I even reposted, and then sent an email to the Access
Team from their Blog site. Still no response.

and

A2007 Report not evaluation Where Condition
(http://www.microsoft.com/office/comm...-934229e00e46).
I thought this might have to do with using SharePoint lists as my data
store, but I pulled all of the pertinent tables reports and forms into a
stand-alone application, and it still has this problem. Would be
willing to send a copy to anyone interested in taking a look.

So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next?
Do you have to pay for technical assistance to get someone from
Microsoft to get an answer? Pay to join "Experts-Exchange" or one of
the other web sites that are basically fee-for-service? Or is there
another option?

Dale







  #12  
Old September 28th, 2009, 03:58 AM posted to microsoft.public.access,microsoft.public.access.modulesdaovba,microsoft.public.access.tablesdbdesign,microsoft.public.access.reports
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Have I stumped the MVPs?

"Dale Fye" wrote:

Over the years, I've been really impressed with the way that the Access MVPs
and others seem to answer almost every post, or at least the ones where the
OP is engaged, and answers the questions posed by the newsgroup volunteers.
I've visited a lot of the other MS newsgroups, and would be willing to bet
that the response rate in the Access groups is among the highest.


Thanks for the kind words.

However, lately, I've had a couple of posts which have not gotten a single
reply:


So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next? Do
you have to pay for technical assistance to get someone from Microsoft to
get an answer?


There are some good online forums that have been suggested.

One alternative is that MVPs do get a few free support calls a year
for which they can use on behalf of a newsgroup requester. Or maybe
give the newsgroup requester.

So if you like email me and I'll see about getting one of those for
you.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
  #13  
Old September 28th, 2009, 01:11 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Dale Fye
external usenet poster
 
Posts: 2,651
Default Have I stumped the MVPs?

Jeanette,

Thanks for the offer, but AccessVandal pointed me to Allen Browne's site
regarding filtering bugs. Apparently this is not new. I was able to resolve
the problem by setting the reports FilterOnLoad property to Yes.

Thanks again.

----
Dale



"Jeanette Cunningham" wrote:

Dale, would you send a copy of the db with the report issue to
jjcc14 at gmail dot com


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Dale Fye" wrote in message
...
Over the years, I've been really impressed with the way that the Access
MVPs and others seem to answer almost every post, or at least the ones
where the OP is engaged, and answers the questions posed by the newsgroup
volunteers. I've visited a lot of the other MS newsgroups, and would be
willing to bet that the response rate in the Access groups is among the
highest.

However, lately, I've had a couple of posts which have not gotten a single
reply:

Trusted publisher / Digital Signature
(http://www.microsoft.com/office/comm...-05856f1d2845).
With this one, I even reposted, and then sent an email to the Access Team
from their Blog site. Still no response.

and

A2007 Report not evaluation Where Condition
(http://www.microsoft.com/office/comm...-934229e00e46).
I thought this might have to do with using SharePoint lists as my data
store, but I pulled all of the pertinent tables reports and forms into a
stand-alone application, and it still has this problem. Would be willing
to send a copy to anyone interested in taking a look.

So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next?
Do you have to pay for technical assistance to get someone from Microsoft
to get an answer? Pay to join "Experts-Exchange" or one of the other web
sites that are basically fee-for-service? Or is there another option?

Dale




  #14  
Old September 28th, 2009, 01:17 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Dale Fye
external usenet poster
 
Posts: 2,651
Default Have I stumped the MVPs?


My client has locked down Trusted Locations on all network and local
computers. They are aware of the implications, but the Information Assurance
folks seem to rule the day around here at the moment.

Since we all have digital signatures, we are generally able to sign our
Word, Excel or Powerpoint files that contain macros, and then add ourselves
to the trusted publishers list. However, this doesn't work with Access 2007.
Hopefully, I'm just missing something, but the lack of responses implies
that very few people have been using this functionality.

----
Dale



"Gina Whipp" wrote:

Dale,

Even on their locals? This would also apply to other Office 2007
applications, so does everyone save to the Server?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Gina,

I had been putting the apps in a Trusted Location, right until my client
disabled Trusted Locations on all computers in the organization.

Thanks anyway.

"Gina Whipp" wrote in message
...
Dale,

Key is "...almost every post...". I would image a few slip thru the
cracks, no moving along...

I am willing to take a stab at question 1, which I did so now waiting in
you to reply. As for question 2, not sure I am knowledgeable enough
about Trusted Publishers and/or Digital Signatures BUT form what little I
know THOUGHT those applied to add-ons, macros, etc... Therefore the
actual databases must be placed in a Trusted Location. You really can't
compare Access 2003 and Access 2007 as they are two different animals
though they both have stripes.

Have a look at this and see if it can help you set up a Trusted Location
http://accessjunkie.com/faq_33.aspx

Perhaps, when/if someone has time they can direct you to a site that
explains it better then my meager attempt!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Over the years, I've been really impressed with the way that the Access
MVPs and others seem to answer almost every post, or at least the ones
where the OP is engaged, and answers the questions posed by the
newsgroup volunteers. I've visited a lot of the other MS newsgroups, and
would be willing to bet that the response rate in the Access groups is
among the highest.

However, lately, I've had a couple of posts which have not gotten a
single reply:

Trusted publisher / Digital Signature
(http://www.microsoft.com/office/comm...-05856f1d2845).
With this one, I even reposted, and then sent an email to the Access
Team from their Blog site. Still no response.

and

A2007 Report not evaluation Where Condition
(http://www.microsoft.com/office/comm...-934229e00e46).
I thought this might have to do with using SharePoint lists as my data
store, but I pulled all of the pertinent tables reports and forms into a
stand-alone application, and it still has this problem. Would be
willing to send a copy to anyone interested in taking a look.

So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next?
Do you have to pay for technical assistance to get someone from
Microsoft to get an answer? Pay to join "Experts-Exchange" or one of
the other web sites that are basically fee-for-service? Or is there
another option?

Dale








  #15  
Old September 28th, 2009, 01:22 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Dale Fye
external usenet poster
 
Posts: 2,651
Default Have I stumped the MVPs?

Tony,

Thanks for the offer.

I got the report problem resolved (bug in Access that Allen Browne has
documented).

Let me check a couple of the other resources that have been mentioned. If I
still don't get an answer on the trusted publisher/digital signature thing I
may give you a holler.

----
Dale



"Tony Toews [MVP]" wrote:

"Dale Fye" wrote:

Over the years, I've been really impressed with the way that the Access MVPs
and others seem to answer almost every post, or at least the ones where the
OP is engaged, and answers the questions posed by the newsgroup volunteers.
I've visited a lot of the other MS newsgroups, and would be willing to bet
that the response rate in the Access groups is among the highest.


Thanks for the kind words.

However, lately, I've had a couple of posts which have not gotten a single
reply:


So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next? Do
you have to pay for technical assistance to get someone from Microsoft to
get an answer?


There are some good online forums that have been suggested.

One alternative is that MVPs do get a few free support calls a year
for which they can use on behalf of a newsgroup requester. Or maybe
give the newsgroup requester.

So if you like email me and I'll see about getting one of those for
you.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

  #16  
Old September 28th, 2009, 03:10 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Have I stumped the MVPs?

Dale,

You might be right there... well, hopefully one of the others can figure
out a solution. Please post back with the answer as you may be the first to
have this issue but you won't be the last!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...

My client has locked down Trusted Locations on all network and local
computers. They are aware of the implications, but the Information
Assurance
folks seem to rule the day around here at the moment.

Since we all have digital signatures, we are generally able to sign our
Word, Excel or Powerpoint files that contain macros, and then add
ourselves
to the trusted publishers list. However, this doesn't work with Access
2007.
Hopefully, I'm just missing something, but the lack of responses implies
that very few people have been using this functionality.

----
Dale



"Gina Whipp" wrote:

Dale,

Even on their locals? This would also apply to other Office 2007
applications, so does everyone save to the Server?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Gina,

I had been putting the apps in a Trusted Location, right until my
client
disabled Trusted Locations on all computers in the organization.

Thanks anyway.

"Gina Whipp" wrote in message
...
Dale,

Key is "...almost every post...". I would image a few slip thru the
cracks, no moving along...

I am willing to take a stab at question 1, which I did so now waiting
in
you to reply. As for question 2, not sure I am knowledgeable enough
about Trusted Publishers and/or Digital Signatures BUT form what
little I
know THOUGHT those applied to add-ons, macros, etc... Therefore the
actual databases must be placed in a Trusted Location. You really
can't
compare Access 2003 and Access 2007 as they are two different animals
though they both have stripes.

Have a look at this and see if it can help you set up a Trusted
Location
http://accessjunkie.com/faq_33.aspx

Perhaps, when/if someone has time they can direct you to a site that
explains it better then my meager attempt!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Dale Fye" wrote in message
...
Over the years, I've been really impressed with the way that the
Access
MVPs and others seem to answer almost every post, or at least the
ones
where the OP is engaged, and answers the questions posed by the
newsgroup volunteers. I've visited a lot of the other MS newsgroups,
and
would be willing to bet that the response rate in the Access groups
is
among the highest.

However, lately, I've had a couple of posts which have not gotten a
single reply:

Trusted publisher / Digital Signature
(http://www.microsoft.com/office/comm...-05856f1d2845).
With this one, I even reposted, and then sent an email to the Access
Team from their Blog site. Still no response.

and

A2007 Report not evaluation Where Condition
(http://www.microsoft.com/office/comm...-934229e00e46).
I thought this might have to do with using SharePoint lists as my
data
store, but I pulled all of the pertinent tables reports and forms
into a
stand-alone application, and it still has this problem. Would be
willing to send a copy to anyone interested in taking a look.

So, the question of the day is: When you cannot get an answer, even
from
some of the best Access developers in the world, where do you turn
next?
Do you have to pay for technical assistance to get someone from
Microsoft to get an answer? Pay to join "Experts-Exchange" or one of
the other web sites that are basically fee-for-service? Or is there
another option?

Dale










  #17  
Old October 13th, 2009, 04:31 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Dale Fye
external usenet poster
 
Posts: 2,651
Default Have I stumped the MVPs?

Tony,

Never was able to get an answer or even a nibble about my issues with not
being able to create a digitally signed accde file. Any chance your free
support call offer is still available?

----
Dale



"Tony Toews [MVP]" wrote:

"Dale Fye" wrote:

Over the years, I've been really impressed with the way that the Access MVPs
and others seem to answer almost every post, or at least the ones where the
OP is engaged, and answers the questions posed by the newsgroup volunteers.
I've visited a lot of the other MS newsgroups, and would be willing to bet
that the response rate in the Access groups is among the highest.


Thanks for the kind words.

However, lately, I've had a couple of posts which have not gotten a single
reply:


So, the question of the day is: When you cannot get an answer, even from
some of the best Access developers in the world, where do you turn next? Do
you have to pay for technical assistance to get someone from Microsoft to
get an answer?


There are some good online forums that have been suggested.

One alternative is that MVPs do get a few free support calls a year
for which they can use on behalf of a newsgroup requester. Or maybe
give the newsgroup requester.

So if you like email me and I'll see about getting one of those for
you.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

  #18  
Old October 13th, 2009, 08:45 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Have I stumped the MVPs?

Dale Fye wrote:

Never was able to get an answer or even a nibble about my issues with not
being able to create a digitally signed accde file. Any chance your free
support call offer is still available?


Yup. Send me an email and I'll do some research on this topic.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
  #19  
Old October 16th, 2009, 06:13 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Dale Fye
external usenet poster
 
Posts: 2,651
Default Have I stumped the MVPs?

Sorry, Tony.

I've been out of town for a couple of days. Will try to send you the email
this evening. Is your email address that is visible in user profiles correct?

----
HTH
Dale



"Tony Toews [MVP]" wrote:

Dale Fye wrote:

Never was able to get an answer or even a nibble about my issues with not
being able to create a digitally signed accde file. Any chance your free
support call offer is still available?


Yup. Send me an email and I'll do some research on this topic.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

  #20  
Old October 17th, 2009, 12:34 AM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Have I stumped the MVPs?

Dale Fye wrote:

I've been out of town for a couple of days. Will try to send you the email
this evening. Is your email address that is visible in user profiles correct?


Or on my web sites. Whichever works.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.