Excel for Life: 25 new messages in 12 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: How to list existing variables ?
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/d7e35b8114b19a03?hl=en
==============================================================================

== 1 of 2 ==
Date: Mon, Nov 12 2007 2:28 am
From: Nicodemus

Hello,

I wish to list the already defined Public Variables from VBA, just like I
list my existing tables. Is there a kind of "VariableDefs", like "TableDefs"
I could use ?

Thank you already for any help.
Nicodemus

== 2 of 2 ==
Date: Mon, Nov 12 2007 2:50 am
From: Stefan Hoffmann

hi Nicodemus,

Nicodemus wrote:
> I wish to list the already defined Public Variables from VBA, just like I
> list my existing tables. Is there a kind of "VariableDefs", like "TableDefs"
> I could use ?
No, such a collection does not exists. Maybe there some tools which can
do that, but I don't know any.

mfG
--> stefan <--

==============================================================================
TOPIC: combo box data entry error
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/2a3f58cb100a5bee?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 3:12 am
From: "pubdude2003 via AccessMonster.com"

thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1

==============================================================================
TOPIC: Find what form opened another form
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/e134de7261a115e3?hl=en
==============================================================================

== 1 of 2 ==
Date: Mon, Nov 12 2007 3:26 am
From: Luis

Hello.
I'm trying to use a form on two different forms and return data into the
form that opened it.

How do i find what form opened another form?

Thanks.

Luis

== 2 of 2 ==
Date: Mon, Nov 12 2007 4:31 am
From: "Douglas J. Steele"

Access doesn't keep track of it. You'll have to pass that information to the
form (as its OpenArgs parameter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Luis" <Luis@discussions.microsoft.com> wrote in message
news:23D3374A-C52E-409E-B752-1D3054CCDFF0@microsoft.com...
> Hello.
> I'm trying to use a form on two different forms and return data into the
> form that opened it.
>
> How do i find what form opened another form?
>
> Thanks.
>
> Luis

==============================================================================
TOPIC: Array
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/9f6b37ad261d6c5c?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 4:17 am
From: Mike

Thanks John

"John Nurick" wrote:

> Hi Mike,
>
> I'm not sure what you mean by 'pass'. If you're trying to bind the
> column TENDSALE.REG_Z_COUNTER to an array, you can't do that sort of
> thing in VBA.
>
> Things you can do, depending on what you're trying to achieve:
>
> 1) Open a recordset, e.g.
> Dim R As DAO.Recordset
> Set R = CurrentDB.OpenRecordset( _
> "SELECT REG_Z_COUNTER FROM TENDSALE ORDER BY XXX;")
> and then pass the recordset.
>
> 2) Open a recordset, iterate through it appending each value to an
> array, e.g.
> Dim A As String()
> Dim R As DAO.Recordset
> Dim j As Long
>
> Set R = CurrentDB.OpenRecordset( _
> "SELECT REG_Z_COUNTER FROM TENDSALE ORDER BY XXX;")
> R.MoveLast
> R.MoveFirst
> Redim A(R.RecCount - 1)
> For j = 0 to UBound(A)
> A(j) = R.Fields(0).Value
> R.MoveNext
> Next
> R.Close
>
> and pass the array; later you can reverse the process and write values
> back from the array into the table.
>
> 3) As for (2), but concatenate the values into a delimited string.
>
>
>
>
> On Sun, 11 Nov 2007 17:59:00 -0800, Mike
> <Mike@discussions.microsoft.com> wrote:
>
> >I'm trying to pass the REG_Z_COUNTER in an Array Can some shed some light on
> >this for me
> >Thanks Mike
> >SQL1 = "SELECT TENDSALE.REG_Z_COUNTER " _
> > & "FROM TENDSALE " _
> > & "GROUP BY TENDSALE.REG_Z_COUNTER;"
> --
> John Nurick - Access MVP
>

==============================================================================
TOPIC: colours and bold in a query
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/beff7ec51b8b3076?hl=en
==============================================================================

== 1 of 2 ==
Date: Mon, Nov 12 2007 4:39 am
From: Patrick Stubbin

is it possible to retrieve records via aquery and change some of the
characters within a retrived field to a different color or format
setting.........

maybee using coding??? like a function ....

not sure how to do this

pat

== 2 of 2 ==
Date: Mon, Nov 12 2007 4:47 am
From: "John Spencer"

Not possible as far as I know in standard Access 2003 and earlier.

Access 2007 has the ability to use rich text fields, so it is probably
possible in that environment.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

"Patrick Stubbin" <PatrickStubbin@discussions.microsoft.com> wrote in
message news:40779EEB-8D9D-4BA4-AA94-0DB0056760F2@microsoft.com...
> is it possible to retrieve records via aquery and change some of the
> characters within a retrived field to a different color or format
> setting.........
>
>
>
> maybee using coding??? like a function ....
>
> not sure how to do this
>
> pat

==============================================================================
TOPIC: Automatically open a drop down list
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/3a9565f80db734bb?hl=en
==============================================================================

== 1 of 6 ==
Date: Mon, Nov 12 2007 4:50 am
From: LDMueller

I was wondering if there was VBA code I could write so that when the focus is
on a combo box which has a drop down list that the drop down list would
automatically open so the user wouldn't have to click on the drop down arrow
to see the list.

Any guidance would be greatly appreciated!

Thanks!

== 2 of 6 ==
Date: Mon, Nov 12 2007 4:58 am
From: "John Spencer"

In the GotFocus event, you should need one line of code.

Private Sub Combo6_GotFocus()
Me.Combo6.Dropdown

End Sub

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

"LDMueller" <LDMueller@discussions.microsoft.com> wrote in message
news:0C20349C-6D28-453A-B883-46C0AE9BF9D4@microsoft.com...
>I was wondering if there was VBA code I could write so that when the focus
>is
> on a combo box which has a drop down list that the drop down list would
> automatically open so the user wouldn't have to click on the drop down
> arrow
> to see the list.
>
> Any guidance would be greatly appreciated!
>
> Thanks!

== 3 of 6 ==
Date: Mon, Nov 12 2007 5:00 am
From: Stefan Hoffmann

hi,

LDMueller wrote:
> I was wondering if there was VBA code I could write so that when the focus is
> on a combo box which has a drop down list that the drop down list would
> automatically open so the user wouldn't have to click on the drop down arrow
> to see the list.
I personally don't like such a behavior.

> Any guidance would be greatly appreciated!

Private Sub yourComboBox_GotFocus()

yourComboBox.DropDdwn

End Sub

mfG
--> stefan <--

== 4 of 6 ==
Date: Mon, Nov 12 2007 5:13 am
From: LDMueller

Perfect, Thank you!

LDMueller

"John Spencer" wrote:

> In the GotFocus event, you should need one line of code.
>
> Private Sub Combo6_GotFocus()
> Me.Combo6.Dropdown
>
> End Sub
>
> --
> John Spencer
> Access MVP 2002-2005, 2007
> Center for Health Program Development and Management
> University of Maryland Baltimore County
> ..
>
> "LDMueller" <LDMueller@discussions.microsoft.com> wrote in message
> news:0C20349C-6D28-453A-B883-46C0AE9BF9D4@microsoft.com...
> >I was wondering if there was VBA code I could write so that when the focus
> >is
> > on a combo box which has a drop down list that the drop down list would
> > automatically open so the user wouldn't have to click on the drop down
> > arrow
> > to see the list.
> >
> > Any guidance would be greatly appreciated!
> >
> > Thanks!
>
>
>

== 5 of 6 ==
Date: Mon, Nov 12 2007 5:14 am
From: LDMueller

Also perfect, Thank you!

LDMueller

"Stefan Hoffmann" wrote:

> hi,
>
> LDMueller wrote:
> > I was wondering if there was VBA code I could write so that when the focus is
> > on a combo box which has a drop down list that the drop down list would
> > automatically open so the user wouldn't have to click on the drop down arrow
> > to see the list.
> I personally don't like such a behavior.
>
> > Any guidance would be greatly appreciated!
>
> Private Sub yourComboBox_GotFocus()
>
> yourComboBox.DropDdwn
>
> End Sub
>
>
>
> mfG
> --> stefan <--
>

== 6 of 6 ==
Date: Mon, Nov 12 2007 5:16 am
From: "Gary Walter"

"LDMueller" wrote:
>I was wondering if there was VBA code I could write so that when the focus
>is
> on a combo box which has a drop down list that the drop down list would
> automatically open so the user wouldn't have to click on the drop down
> arrow
> to see the list.
>
Hi LD,

In addition to John's sage advice,
in certain, particular situations I have
used below code to simulate "mouse-over"
, i.e., when user runs mouse over the
combobox, it automatically drops down,
and then dropdown disappears when cursor
goes ouside boundary of combobox.

for example, in the MouseMove event
of a combobox named "cmboLink"

Private Sub cmboLink_MouseMove(Button As Integer, Shift As Integer, x As
Single, y As Single)
Me!cmboLink.SetFocus
Me!cmboLink.Dropdown
End Sub

Used in the wrong situation I could imagine it would really *annoy*
your users though...

good luck,

gary

==============================================================================
TOPIC: Code does not 'see' the required related record.
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/5bfc2cc84ab94cc1?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 5:57 am
From: "Dirk Goldgar"

In news:E037288E-C7DA-467F-94F5-E37BD21B41BC@microsoft.com,
ThomasAJ <ThomasAJ@discussions.microsoft.com> wrote:
> Sorry the open recordset should have been:
> Set rsCUSTPRODUCT = myDB.OpenRecordSet("CUSTPRODUCT").

That makes more sense, and is what I would have expected. And what line
of code is setting myDB?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

==============================================================================
TOPIC: ^^^^^^ Genuine Way To Permanently Enlarge Your Penis At Home ^^^^^^
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/2437974e0565812d?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 6:58 am
From: ashley9911@gmail.com

Natural Penis enlargement IS NOW POSSIBLE AND 100% SAFE

New clinically proven device for Bigger penis, Harder Erections and
Sexual Stamina?

Know More: http://xadvice2men.blogspot.com/

==============================================================================
TOPIC: My VB scrip doesn't work in Access 2007
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/6bc68072a2e4525f?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 7:48 am
From: "KimTong via AccessMonster.com"

Dear all,

I just upgraded my MS Office 2000 to Office 2007 recently. When I ran my
Access application that I developed in Access 2000 using VB script, it didn't
work. On click property, here is my Vb script:

Docmd.OpenForm "MembershipFee", acFormDs

When I click that button that has VB script, the screen stay on the current
form. It didn't go to Form 'MemberhsipFee'. Is anyone can tell me why?? Thank
you in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1

==============================================================================
TOPIC: Populate dropdown box with information from other fields
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/02634369e516d5cd?hl=en
==============================================================================

== 1 of 5 ==
Date: Mon, Nov 12 2007 8:39 am
From: BZeyger

I currently have a Access VBA database projetc. I have a form which uses
information from a current record. There are fields that populate perfectly.
I would like to add a dropdown box that will display the information from the
various fields.

Example:

The form conatins 3 non-visible fields : Writer1, Writer2, Writer3

I would like the drop-down to display Writer1, Writer2, and Writer3 of the
current record.

Is there a way to have it displayed directly from the object's property
window (Row Source) ?

== 2 of 5 ==
Date: Mon, Nov 12 2007 8:51 am
From: "John Spencer"

You could use the Current Event to set the comboboxes value list.

Set the Row Source Type of your combobox:
Row Source Type: Value List

Private Sub Form_Current()
Dim strList as string
strList = Me.Writer1 & ";" & Me.Writer2 & ":" & Me.Writer3
Me.YourCombobox.RowSource = strList
End Sub
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

"BZeyger" <BZeyger@discussions.microsoft.com> wrote in message
news:15DACAE6-C691-40E8-9F0A-0DB2FF6AE148@microsoft.com...
>I currently have a Access VBA database projetc. I have a form which uses
> information from a current record. There are fields that populate
> perfectly.
> I would like to add a dropdown box that will display the information from
> the
> various fields.
>
> Example:
>
> The form conatins 3 non-visible fields : Writer1, Writer2, Writer3
>
> I would like the drop-down to display Writer1, Writer2, and Writer3 of the
> current record.
>
> Is there a way to have it displayed directly from the object's property
> window (Row Source) ?
>

== 3 of 5 ==
Date: Mon, Nov 12 2007 9:44 am
From: "Douglas J. Steele"

Slight typo. It should be semi-colons in both places:

strList = Me.Writer1 & ";" & Me.Writer2 & ";" & Me.Writer3

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"John Spencer" <spencer@chpdm.edu> wrote in message
news:O7bLFxUJIHA.748@TK2MSFTNGP04.phx.gbl...
> You could use the Current Event to set the comboboxes value list.
>
> Set the Row Source Type of your combobox:
> Row Source Type: Value List
>
> Private Sub Form_Current()
> Dim strList as string
> strList = Me.Writer1 & ";" & Me.Writer2 & ":" & Me.Writer3
> Me.YourCombobox.RowSource = strList
> End Sub
> --
> John Spencer
> Access MVP 2002-2005, 2007
> Center for Health Program Development and Management
> University of Maryland Baltimore County
> .
>
> "BZeyger" <BZeyger@discussions.microsoft.com> wrote in message
> news:15DACAE6-C691-40E8-9F0A-0DB2FF6AE148@microsoft.com...
>>I currently have a Access VBA database projetc. I have a form which uses
>> information from a current record. There are fields that populate
>> perfectly.
>> I would like to add a dropdown box that will display the information from
>> the
>> various fields.
>>
>> Example:
>>
>> The form conatins 3 non-visible fields : Writer1, Writer2, Writer3
>>
>> I would like the drop-down to display Writer1, Writer2, and Writer3 of
>> the
>> current record.
>>
>> Is there a way to have it displayed directly from the object's property
>> window (Row Source) ?
>>
>
>

== 4 of 5 ==
Date: Mon, Nov 12 2007 9:48 am
From: BZeyger

This code works however it does not show the desired results. Writer1,
Writer2, and Writer3 fields contain comma's in them. For example: Smith, John

The code provided does put the desired information into the drop-down box
but it does not place the full name on the same line.
What happens is: Smith
John
Doe
Jane

I would like it to show as : John, Smith
Jane Doe

"John Spencer" wrote:

> You could use the Current Event to set the comboboxes value list.
>
> Set the Row Source Type of your combobox:
> Row Source Type: Value List
>
> Private Sub Form_Current()
> Dim strList as string
> strList = Me.Writer1 & ";" & Me.Writer2 & ":" & Me.Writer3
> Me.YourCombobox.RowSource = strList
> End Sub
> --
> John Spencer
> Access MVP 2002-2005, 2007
> Center for Health Program Development and Management
> University of Maryland Baltimore County
> ..
>
> "BZeyger" <BZeyger@discussions.microsoft.com> wrote in message
> news:15DACAE6-C691-40E8-9F0A-0DB2FF6AE148@microsoft.com...
> >I currently have a Access VBA database projetc. I have a form which uses
> > information from a current record. There are fields that populate
> > perfectly.
> > I would like to add a dropdown box that will display the information from
> > the
> > various fields.
> >
> > Example:
> >
> > The form conatins 3 non-visible fields : Writer1, Writer2, Writer3
> >
> > I would like the drop-down to display Writer1, Writer2, and Writer3 of the
> > current record.
> >
> > Is there a way to have it displayed directly from the object's property
> > window (Row Source) ?
> >
>
>
>

== 5 of 5 ==
Date: Mon, Nov 12 2007 10:05 am
From: BZeyger

I have changed the typo to semicolons and the issue is still happening. It is
putting the first and last name on two seperate line.

"Douglas J. Steele" wrote:

> Slight typo. It should be semi-colons in both places:
>
> strList = Me.Writer1 & ";" & Me.Writer2 & ";" & Me.Writer3
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "John Spencer" <spencer@chpdm.edu> wrote in message
> news:O7bLFxUJIHA.748@TK2MSFTNGP04.phx.gbl...
> > You could use the Current Event to set the comboboxes value list.
> >
> > Set the Row Source Type of your combobox:
> > Row Source Type: Value List
> >
> > Private Sub Form_Current()
> > Dim strList as string
> > strList = Me.Writer1 & ";" & Me.Writer2 & ":" & Me.Writer3
> > Me.YourCombobox.RowSource = strList
> > End Sub
> > --
> > John Spencer
> > Access MVP 2002-2005, 2007
> > Center for Health Program Development and Management
> > University of Maryland Baltimore County
> > .
> >
> > "BZeyger" <BZeyger@discussions.microsoft.com> wrote in message
> > news:15DACAE6-C691-40E8-9F0A-0DB2FF6AE148@microsoft.com...
> >>I currently have a Access VBA database projetc. I have a form which uses
> >> information from a current record. There are fields that populate
> >> perfectly.
> >> I would like to add a dropdown box that will display the information from
> >> the
> >> various fields.
> >>
> >> Example:
> >>
> >> The form conatins 3 non-visible fields : Writer1, Writer2, Writer3
> >>
> >> I would like the drop-down to display Writer1, Writer2, and Writer3 of
> >> the
> >> current record.
> >>
> >> Is there a way to have it displayed directly from the object's property
> >> window (Row Source) ?
> >>
> >
> >
>
>
>

==============================================================================
TOPIC: Run-time access
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/a1ed64b038865c70?hl=en
==============================================================================

== 1 of 2 ==
Date: Mon, Nov 12 2007 9:23 am
From: dougsnyder

I have created a program and with the office developers extensions packaged
the access run-time version. Will a mac user be able to use my program?

== 2 of 2 ==
Date: Mon, Nov 12 2007 9:43 am
From: "Douglas J. Steele"

Perhaps if you're running a Windows emulator on the mac. Otherwise, no.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"dougsnyder" <dougsnyder@discussions.microsoft.com> wrote in message
news:576B1C86-E225-4B68-9610-5C26A8512DC2@microsoft.com...
>I have created a program and with the office developers extensions packaged
> the access run-time version. Will a mac user be able to use my program?

==============================================================================
TOPIC: What Code Do I Write ?
http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/758e465168699795?hl=en
==============================================================================

== 1 of 1 ==
Date: Mon, Nov 12 2007 9:57 am
From: Jone

"Allen Browne" wrote:

> If Dir("C:\Windows\Sample.txt") <> vbNullString Then
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jone" <Jone@discussions.microsoft.com> wrote in message
> news:2616FFC4-4240-4862-84B9-0620A650EBF7@microsoft.com...
> > What code do I write when I want my main menu form to check for a file
> > before
> > it opens if it cannot find the file it should not open ? for Ex. check if
> > I
> > have the file C:\Windows\Sample.txt if it cannot find if it should not
> > open
>
> Sorry it dose not work

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

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

Senin, 12 November 2007

25 new messages in 12 topics - digest

Tidak ada komentar:

Arsip Blog

Blogeroll

Mengenai Saya