Prev: how to draw circle,
Next: Access 2007 Analyze with Excel
From: Gina Whipp on 27 Sep 2009 21:54
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" <dale.fye(a)nospam.com> wrote in message
news:Ochl9S9PKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> 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" <NotInterested(a)InViruses.com> wrote in message
> news:uVgmjz6PKHA.1236(a)TK2MSFTNGP05.phx.gbl...
>> 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" <dale.fye(a)nospam.com> wrote in message
>> news:%231TBE55PKHA.5108(a)TK2MSFTNGP02.phx.gbl...
>>> 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/community/en-us/default.mspx?&query=fye+publisher&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.modulesdaovba&p=1&tid=3c263a94-5463-48b8-b68f-05856f1d2845&mid=3c263a94-5463-48b8-b68f-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/community/en-us/default.mspx?&query=fye+&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.reports&p=1&tid=72645444-424a-4376-bf7b-934229e00e46&mid=72645444-424a-4376-bf7b-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
>>>
>>
>>
>
>


From: Tony Toews [MVP] on 27 Sep 2009 22:58
"Dale Fye" <dale.fye(a)nospam.com> 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/
From: Dale Fye on 28 Sep 2009 08:11
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" <dale.fye(a)nospam.com> wrote in message
> news:%231TBE55PKHA.5108(a)TK2MSFTNGP02.phx.gbl...
> > 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/community/en-us/default.mspx?&query=fye+publisher&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.modulesdaovba&p=1&tid=3c263a94-5463-48b8-b68f-05856f1d2845&mid=3c263a94-5463-48b8-b68f-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/community/en-us/default.mspx?&query=fye+&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.reports&p=1&tid=72645444-424a-4376-bf7b-934229e00e46&mid=72645444-424a-4376-bf7b-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
> >
>
>
>
From: Dale Fye on 28 Sep 2009 08:17

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" <dale.fye(a)nospam.com> wrote in message
> news:Ochl9S9PKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> > 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" <NotInterested(a)InViruses.com> wrote in message
> > news:uVgmjz6PKHA.1236(a)TK2MSFTNGP05.phx.gbl...
> >> 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" <dale.fye(a)nospam.com> wrote in message
> >> news:%231TBE55PKHA.5108(a)TK2MSFTNGP02.phx.gbl...
> >>> 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/community/en-us/default.mspx?&query=fye+publisher&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.modulesdaovba&p=1&tid=3c263a94-5463-48b8-b68f-05856f1d2845&mid=3c263a94-5463-48b8-b68f-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/community/en-us/default.mspx?&query=fye+&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access.reports&p=1&tid=72645444-424a-4376-bf7b-934229e00e46&mid=72645444-424a-4376-bf7b-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
> >>>
> >>
> >>
> >
> >
>
>
>
From: Dale Fye on 28 Sep 2009 08:22
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" <dale.fye(a)nospam.com> 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/
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: how to draw circle,
Next: Access 2007 Analyze with Excel