Excel for Life: 19 new messages in 15 topics

microsoft.public.access.modulesdaovba
http://groups.google.com/group/microsoft.public.access.modulesdaovba?hl=en

microsoft.public.access.modulesdaovba@googlegroups.com

Today's topics:

==============================================================================
TOPIC: MI5 Persecution: Ravenscourt Park 20/3/99 (4994)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/453ed3af38413354?hl=en
==============================================================================

== 1 of 1 ==
Date: Fri, Nov 16 2007 9:10 pm
From: MI5Victim@mi5.gov.uk

Ravenscourt Park 20/3/99

Certainty level: 70%

On Saturday I went to Hammersmith, specifically Ravenscourt Park. There
had recently been a resurgence of persecution activity, following the
Capital spams. I went to the cafe in the park and had a cup of coffee
outside, with my mother. As I went inside the cafe to return the cups,
a woman shouted a sexual obscenity (not present on this audio file -
don't ask), and she said loudly "something's wrong with him". You can just
about hear it in the audio file; listen very carefully, several times; it
is distinguishable.

Much less subtle is the male voice shouting "take care he's a nutter"
immediately after the woman's voice. As on the other recordings there's
a lot of noise, but what the people say can be clearly heard.

Given that I take medication and look and behave quite sanely, and that
there had been increased abuse over the last couple of weeks, it seems
pretty unlikely that this incident was just spontaneous.... of course,
you couldn't prove otherwise, but then that's the way MI5 mean their
abuse to look.

4994

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: Visible = True and Visible = False
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/6b1da785c92f7cd8?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 2:24 am
From: "Wolfgang Kais"

False

--
Regards,
Wolfgang

==============================================================================
TOPIC: MI5 Persecution: Battersea Library 29/3/99 (7169)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/b94dede5dfa80725?hl=en
==============================================================================

== 1 of 1 ==
Date: Fri, Nov 16 2007 10:56 pm
From: MI5Victim@mi5.gov.uk

Battersea Library 29/3/99

Certainty level: 60%

This one is quite dull. During the month of March 1999, MI5 made another
determined attempt to "get" me, substantially through radio programmes,
through Jon Snow on Channel Four News, and through abuse in public, of
which this is one example.

Recorded on my minidisc-walkman on Monday 29 March 1999, this audio file
consists of two girls talking. One says to the other, "he's got something
wrong with him." The usual words. How many millions a year do the Security
Service waste on this? But they've denied it - how silly of me to forget.
And they're not liars either, are they?

7169

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: ADO Connection
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/7189f0bec8d7fe75?hl=en
==============================================================================

== 1 of 2 ==
Date: Sat, Nov 17 2007 4:50 am
From: Rio

Yes, my tables are linked. Are there any performance
advantages/disadvantages of using one method vs. the other? Thanks.

"boblarson" wrote:

> If your tables are linked then use the CurrentProject.Connection one. If
> they are not, you will need to use the other.
> --
> Bob Larson
> Access World Forums Super Moderator
> Utter Access VIP
> Tutorials at http://www.btabdevelopment.com
> __________________________________
> If my post was helpful to you, please rate the post.
>
>
> "Rio" wrote:
>
> > When establishing an ADO connection when should I use
> >
> > Set cn = CurrentProject.Connection
> >
> > vs
> >
> > cnn.Open "Provider=sqloledb;" & _
> > "Data Source=yourServerName;" & _
> > "Initial Catalog=yourDatabaseName;" & _
> > "Integrated Security=SSPI"
> >
> > My app is Access (front-end) and SQL Server (back-end)
> >
> > Thanks!

== 2 of 2 ==
Date: Sat, Nov 17 2007 9:56 am
From: boblarson

I cannot answer with absolute assuredness but I do believe that the linked
tables will work better for you since a connection is already open and JET
can help in the management of things.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

"Rio" wrote:

> Yes, my tables are linked. Are there any performance
> advantages/disadvantages of using one method vs. the other? Thanks.
>
> "boblarson" wrote:
>
> > If your tables are linked then use the CurrentProject.Connection one. If
> > they are not, you will need to use the other.
> > --
> > Bob Larson
> > Access World Forums Super Moderator
> > Utter Access VIP
> > Tutorials at http://www.btabdevelopment.com
> > __________________________________
> > If my post was helpful to you, please rate the post.
> >
> >
> > "Rio" wrote:
> >
> > > When establishing an ADO connection when should I use
> > >
> > > Set cn = CurrentProject.Connection
> > >
> > > vs
> > >
> > > cnn.Open "Provider=sqloledb;" & _
> > > "Data Source=yourServerName;" & _
> > > "Initial Catalog=yourDatabaseName;" & _
> > > "Integrated Security=SSPI"
> > >
> > > My app is Access (front-end) and SQL Server (back-end)
> > >
> > > Thanks!

==============================================================================
TOPIC: MI5 Persecution: Royal Festival Hall 15/4/99 (9344)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/92339076773a0c90?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 1:12 am
From: MI5Victim@mi5.gov.uk

Royal Festival Hall 15/4/99

Certainty level: 100%

Another "day in the life of", this one. January and February were quiet;
in March it all started again; by the middle of April the resurgence of
abuse had been going on for over a month. And this, with 100% certainty,
is one manifestation of the abuse.

On Thursday 15 April 1999, 1pm lunchtime, I was at the booking office at
the Royal Festival Hall near Waterloo Station in London, buying a ticket
for a friend. A woman was at the counter next to me. She said;

"it would kill it, you know, it would just be overkill...
.. they can't stop can they"

It was obvious to everyone, the ticket agents included, that her comments
were directed at me, and that "they" (ie. MI5) were "killing" me.

I've heard similar things said at various other times, but rarely have their
intentions been expressed as clearly as this. The woman also expressed the
obsessive nature of MI5's preoccupation with me, by saying, "they can't
stop can they".

9344

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: MI5 Persecution: Balham Bus 8/7/99 (11519)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/b44e3dcc91f9de01?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 2:43 am
From: MI5Victim@mi5.gov.uk

Balham - LT bus (8/July/1999)

Certainty level: 90%

I am very sure about this one. I got back from holidays on Wednesday.
There were two incidents, both on the tube, on the way back from the
airport. There was a further incident the following day, Thursday, on
the bus (the 155 I think) in Balham, where two girls started spouting
abuse about "crazy", etc. Naturally I had my minidisc with me and was
able to record their words.

The cynical reader might think my demeanour or behaviour had given rise
to the taunts of "crazy" recorded above. But I assure you my behaviour
on the bus would not have made anyone think I was ill; and the taunts
the previous day were the same sexual words as previously; so I'm quite
sure that these incidents are either deliberately staged, or indicative
of an overall high level of awareness among the London public,
particularly in the part of London where I live.

11519

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: MI5 Persecution: Clapham South 17/2/00 (13694)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/fa9c2a53c99db6d3?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 4:06 am
From: MI5Victim@mi5.gov.uk

Clapham South (17/Feb/2000)

Certainty level: 100%

In February 2000, MI5's hate campaign against me was in full swing. They
sent people into the road where I live in south London, to swear at me
and abuse me as I was leaving or returning home. One such instance is
recorded on the above audio file.

On Thursday 17 February 2000, I had just left my home, en route for Croydon,
when two youths approached, going in the other direction. One of them said
with a smile on his face something which I didn't recognize, and still
don't understand despite it being on this audio clip. His demeanour made it
clear his statement was directed at me. I coughed, and in response to that,
he continued his insult, calling me a "wanker", which is very clearly
recorded on this audio clip.

Two days later, in the very early morning of Sunday 20 February 2000,
MI5 inflicted another insult against me just outside my house, when,
returning from Croydon, two youths approached (MI5 agents always go in
packs of at least two - they're too cowardly to go anywhere on their own)
and one of them said quietly and bitterly to the other that "he's shitty,
very shitty".

It is still comparatively rare for MI5 to send people to my house, or to
my road, to harass me. Usually they know where I'm going to, since they have
bugs on my phone and in each room of my house; and they send people to
that location, or on the train or tube getting there.

13694

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: Importing text files into length specify parameters
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/b9e78415dc6e9557?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 8:36 am
From: Marshall Barton

If you can use File - Import (probably using the Advanced
features) to get the part of the text file containing the
characters you want into a field in some table, then we can
go from there.

If you can not use File - Import, then you will have to use
a sophisticated code procedure that intelligently parses the
text file to locate and extract the desired characters.
There's a class module that can be a big help at
http://www.mvps.org/access/modules/mdl0057.htm
but you will need to have expert coding skills if you can
not use File Import.
--
Marsh
MVP [MS Access]

N.Ordiers wrote:
>Thanks, but the file is outside of MS Access. I need to copy expecific number
>of characters from each lines into defined fields in a MS Access table. I
>have try using a schema.in but iti does not work for me. If you have any
>idea of how I can accomplish the task, I will welcome it
>
>
>> N.Ordiers wrote:
>> >I have forgotten how to import a string and tell how many character to
>> >insert from the begging of the line into a specify column.
>> >
>> >I think the code looks like this "INSERT INTO TableName (Field1(char 5),
>> >Field 2(char 10))
>> >"FROM TextFile"
>>
>>
>"Marshall Barton" wrote:
>> Check the Mid function in Help to see if that's what you
>> want.

==============================================================================
TOPIC: Visible = True Vs Visble = False
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/ab35e58d40612388?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 8:40 am
From: Marshall Barton

I already understood that. Try my suggestion and see how
close it comes.
--
Marsh
MVP [MS Access]

dsc2bjn wrote:
>Customer doesn't like using the Single Header lines. They want it to look
>similiar to an Excel spreadsheet, but only to display the FunctionOrder,
>Function, ActivityOrder, and Activity when the value changes.
>
>F-1 Function1Text A-1 Activity1Text Risk
> Risk
> Risk
> A-2 Activity2Text Risk
> Risk
>F-2 Function2Text A-1 Activity1Text Risk
> Risk
> A-2 Activity2Text Risk
>F-3 Function3Text A-1 Activity3Text Risk
>
>
>"Marshall Barton" wrote:
>> You might want to try a completely different approach that I
>> think(?) does what you want without any complicated logic.
>>
>> Create a group with header for each of the fields you want
>> to hide. Add a text box for the field to the group header
>> and make sure the group header sections are the same height
>> as the detail section. The code for the group header
>> sections' Format event would simply be:
>> Me.MoveLayout = False
>>
>> The only controls in the detail section would be the ones
>> you want to display on every line. The only(?) code needed
>> for the detail section would be the line drawing code.
>>
>>
>> dsc2bjn wrote:
>> >I have a report which returns a series of records for which I wish to
>> >suppress the duplicate values for a few fields. The "Hide Duplicate"
>> >attribute will only hide the duplicates on a single page of the report. I
>> >which to hide all duplicates for like values throughout the report.

==============================================================================
TOPIC: MI5 Persecution: Clapham Junction 6/5/00 (15869)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/49079d388b46b142?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 5:44 am
From: MI5Victim@mi5.gov.uk

Clapham Junction (6/May/2000)

Certainty level: 60%

On Saturday 6 May 2000, I was in Clapham Junction, shopping and visiting
the library. At precisely 12:29pm, the above audio clip was recorded,
in front of Arding and Hobbs department store. One girl was saying to
her friend,

"He's a homosexual, they can say whatever they want."

There are several reasons why I think this comment might be about me.
Firstly, temporal proximity to other such incidents. The persecution
had restarted about two to three days before this clip was recorded.
Cause of restart unknown. Personally I think it's because I was going
on holiday to France the following Monday - MI5 do like to take holidays
abroad at the taxpayer's expense, and inventing reasons to resurrect their
hate campaign just before I go on holiday is something they've done
before.

Secondly, although I am not gay, they have used such references against
me before. At Oxford Computer Group in 1994, manager Steve Mitchell
simultaneously abused me and another employee but saying we were "of a
similar bent". Such insults show latent or quite overt homosexuality
on the part of the abuser.

Thirdly, the sort of people who abuse on the basis of mental illness
are the same people who abuse others on the basis of sexuality, race,
religion, etc. If they can abuse a disabled man, then they will surely
do so based on the other criteria mentioned.

There is still some room for doubt, though, which is why I have assigned
this recording a certainty level of only slightly above evens. But "they
can say whatever they want" is what gives the game away; they just choose
a differentiating feature on which to base their abuse; and if one such
feature gets too boring ("we've called him a nutter for the last ten years
so now we'll call him something else") then they invent a different lie
to throw at me.

15869

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================
TOPIC: Table
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/2b49c1437ef660b4?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 10:08 am
From: mustangric2001

I have a table and a form. When one person has the form opened, another
person can not use it. It gives a message saying, The database has been
placed in a state by user 'Admin' on machine ' DISPATCH' that prevents it
from being opened or locked. Is there a way to make it where more then one
person can access the database at a time.

==============================================================================
TOPIC: Replace text using recordset
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/dc3430825cd995f0?hl=en
==============================================================================

== 1 of 4 ==
Date: Sat, Nov 17 2007 10:14 am
From: Billy B

I am trying to loop through a table (tblPlants) using a recordset and update
part of the text fields text value. The variables strOld and strNew
represent the root paths that I am trying to find and replace in the PicPath
field of the table. I am getting an error message at the replace line of the
loop. Thank you.

Within the procedure...

With rsFnd
Do While Not rstfnd.EOF
If rsfnd!PicPath <> "" Then
replace(rsFnd!PicPath, strOld, strNew, 1, 3, vbTextCompare)
As String
rsFnd.MoveNext
Loop
End With

rsFnd.Close

== 2 of 4 ==
Date: Sat, Nov 17 2007 10:30 am
From: "dhauck"

is your recordset readonly?
the "As String" syntax seems wrong, out of place
what is the error msg?

Billy B wrote:
>I am trying to loop through a table (tblPlants) using a recordset and update
>part of the text fields text value. The variables strOld and strNew
>represent the root paths that I am trying to find and replace in the PicPath
>field of the table. I am getting an error message at the replace line of the
>loop. Thank you.
>
>Within the procedure...
>
> With rsFnd
> Do While Not rstfnd.EOF
> If rsfnd!PicPath <> "" Then
> replace(rsFnd!PicPath, strOld, strNew, 1, 3, vbTextCompare)
>As String
> rsFnd.MoveNext
> Loop
> End With
>
> rsFnd.Close

== 3 of 4 ==
Date: Sat, Nov 17 2007 11:23 am
From: Marshall Barton

Billy B wrote:

>I am trying to loop through a table (tblPlants) using a recordset and update
>part of the text fields text value. The variables strOld and strNew
>represent the root paths that I am trying to find and replace in the PicPath
>field of the table. I am getting an error message at the replace line of the
>loop. Thank you.
>
>Within the procedure...
>
> With rsFnd
> Do While Not rstfnd.EOF
> If rsfnd!PicPath <> "" Then
> replace(rsFnd!PicPath, strOld, strNew, 1, 3, vbTextCompare)
>As String
> rsFnd.MoveNext
> Loop
> End With
>
> rsFnd.Close

You need to set the field to the modified value and save it
back to the table.

You are using two recordset variables, Since you only
mentioned one recordset, I assume that one of the recordset
variable names is a typo. With that caveat, the code would
look more like:

With rsFnd
Do While Not .EOF
If !PicPath <> "" Then
!PicPath = Replace(!PicPath, strOld, strNew, _
1, 3, vbTextCompare)
End If
rsFnd.MoveNext
Loop
.Close : Set rsFnd = Nothing
End With

Note that using a record set to do this job is the slow,
inefficient way. Better to use an UPDATE query:

UPDATE thetable
SET
PicPath=Replace(PicPath,strOld,strNew,1,3,vbTextCompare)
WHERE PicPath Is Not Null

--
Marsh
MVP [MS Access]

== 4 of 4 ==
Date: Sat, Nov 17 2007 11:22 am
From: Billy B

Here is my recordset statement:
rsFnd.Open strSQLFnd, conn, adOpenForwardOnly, adLockPessimistic

The error for the code I posted is:
Statement invalid outside type block

If I remove the 'As String' I get the error message:
Expected =

"dhauck" wrote:

> is your recordset readonly?
> the "As String" syntax seems wrong, out of place
> what is the error msg?
>
> Billy B wrote:
> >I am trying to loop through a table (tblPlants) using a recordset and update
> >part of the text fields text value. The variables strOld and strNew
> >represent the root paths that I am trying to find and replace in the PicPath
> >field of the table. I am getting an error message at the replace line of the
> >loop. Thank you.
> >
> >Within the procedure...
> >
> > With rsFnd
> > Do While Not rstfnd.EOF
> > If rsfnd!PicPath <> "" Then
> > replace(rsFnd!PicPath, strOld, strNew, 1, 3, vbTextCompare)
> >As String
> > rsFnd.MoveNext
> > Loop
> > End With
> >
> > rsFnd.Close
>
>

==============================================================================
TOPIC: Reference
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/832a5cec2bc1fd10?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 10:23 am
From: "dhauck"

I'd like to indirectly reference a function...

if docmd.runcode functionVariable was allowed, I would be set....

Public Function Do_This(My_Thing As String, My_Type As String)
Select Case UCase(My_Type)

Case "FORM"
DoCmd.OpenForm My_Thing, acNormal, , , acFormEdit, acWindowNormal
...

Case "REPORT"
DoCmd.OpenReport My_Thing, acViewPreview

Case "CODE"
docmd.runcode My_Thing
..

Here is the rub. Docmd.runcode is not allowed...

==============================================================================
TOPIC: Accessing a table
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/d97f6eb47c977e24?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 11:04 am
From: mustangric2001

Is there a way to access a table when it is opened on another computer. Right
now when I try to do it, it says the database has been placed in a state by
user 'Admin' on machine 'Dispatch' that prevents from being opened or locked.
The Dispatch computer only has one Administrator user account that everyone
uses. All of the other cumputers have user accounts set up on them.

==============================================================================
TOPIC: MI5 Persecution: he's an idiot you know 3/11/00 (18044)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/9597a50b213f03f8?hl=en
==============================================================================

== 1 of 1 ==
Date: Sat, Nov 17 2007 7:23 am
From: MI5Victim@mi5.gov.uk

Balham High Road (3/Nov/2000)

Certainty level: 60%

On 3 November 2000, I had just got off the bus in Balham High Road,
when I heard a group of schoolgirls shouting and laughing. One of them yelled;

"He's an idiot you know."

You can hear this on the above clip; it is followed by laughter. I am
not quite sure this is about me, which is why I have only given it
a two in three probability. I have been attacked many times with the
word "idiot", which seems to be a favourite with intellectual lightweights
who want to bring down bigger game. (Back in 1992 I was so worried by the
attacks on my intelligence that I took the test and joined Mensa......
does that make me a *clever* idiot? Never mind.)

18044

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

==============================================================================

You received this message because you are subscribed to the Google Groups "microsoft.public.access.modulesdaovba"
group.

To post to this group, visit http://groups.google.com/group/microsoft.public.access.modulesdaovba?hl=en

To unsubscribe from this group, send email to microsoft.public.access.modulesdaovba-unsubscribe@googlegroups.com

To change the way you get mail from this group, visit:
http://groups.google.com/group/microsoft.public.access.modulesdaovba/subscribe?hl=en

To report abuse, send email explaining the problem to abuse@googlegroups.com

==============================================================================
Google Groups: http://groups.google.com?hl=en

Excel for Life

Sabtu, 17 November 2007

19 new messages in 15 topics - digest

Tidak ada komentar:

Arsip Blog

Blogeroll

Mengenai Saya