Prev: Auto-Fill a Form
Next: Relationships and lookup tables.
From: Ken Snell (MVP) on 3 Jul 2008 20:05
Yes. Be sure that your macro view is showing you the Condition column so
that you can enter the information for it. Also, the "..." that I typed for
the second step's Condition column is exactly what you type. The ellipsis
means that the step is using the same condition as the previous step.

--

Ken Snell
<MS ACCESS MVP>


"jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
news:786BEA34-FF5F-421F-93AA-05294F0E915F(a)microsoft.com...
> Just a quick question -
> When I click - "On Load" he VB screen appears. I click on Tools, then
> Macros and it is allowing me to create a macro. Do I write the macro as
> you
> wrote it below? Dumb question, I know! :-(
>


From: jerseygirl54 on 3 Jul 2008 20:33
All I get is another VB code window where I have to enter code. I don't see
the "Condiion" column you are referring.

"Ken Snell (MVP)" wrote:

> Yes. Be sure that your macro view is showing you the Condition column so
> that you can enter the information for it. Also, the "..." that I typed for
> the second step's Condition column is exactly what you type. The ellipsis
> means that the step is using the same condition as the previous step.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
> news:786BEA34-FF5F-421F-93AA-05294F0E915F(a)microsoft.com...
> > Just a quick question -
> > When I click - "On Load" he VB screen appears. I click on Tools, then
> > Macros and it is allowing me to create a macro. Do I write the macro as
> > you
> > wrote it below? Dumb question, I know! :-(
> >
>
>
>
From: jerseygirl54 on 3 Jul 2008 20:41
I place this code onto the "LastNameSearch" Macro and I get this error when
run:

"Access failed to eveluate one or more expressions because 'Recordset' was
referenced in an expression. Only functions and properties that are
considered to be safe are allowed in expressions when Access runs in sandbox
mode."

???


"Ken Snell (MVP)" wrote:

> Yes. Be sure that your macro view is showing you the Condition column so
> that you can enter the information for it. Also, the "..." that I typed for
> the second step's Condition column is exactly what you type. The ellipsis
> means that the step is using the same condition as the previous step.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
> news:786BEA34-FF5F-421F-93AA-05294F0E915F(a)microsoft.com...
> > Just a quick question -
> > When I click - "On Load" he VB screen appears. I click on Tools, then
> > Macros and it is allowing me to create a macro. Do I write the macro as
> > you
> > wrote it below? Dumb question, I know! :-(
> >
>
>
>
From: Ken Snell (MVP) on 4 Jul 2008 07:31
What version of ACCESS are you using?

I assume that you did find the Condition column?

--

Ken Snell
<MS ACCESS MVP>


"jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
news:D5252D34-08C8-41FA-B964-56B5A7E12F3D(a)microsoft.com...
>I place this code onto the "LastNameSearch" Macro and I get this error
>when
> run:
>
> "Access failed to eveluate one or more expressions because 'Recordset' was
> referenced in an expression. Only functions and properties that are
> considered to be safe are allowed in expressions when Access runs in
> sandbox
> mode."
>
> ???
>
>
> "Ken Snell (MVP)" wrote:
>
>> Yes. Be sure that your macro view is showing you the Condition column so
>> that you can enter the information for it. Also, the "..." that I typed
>> for
>> the second step's Condition column is exactly what you type. The ellipsis
>> means that the step is using the same condition as the previous step.
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>> "jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
>> news:786BEA34-FF5F-421F-93AA-05294F0E915F(a)microsoft.com...
>> > Just a quick question -
>> > When I click - "On Load" he VB screen appears. I click on Tools, then
>> > Macros and it is allowing me to create a macro. Do I write the macro
>> > as
>> > you
>> > wrote it below? Dumb question, I know! :-(
>> >
>>
>>
>>


From: jerseygirl54 on 4 Jul 2008 10:25
i'm using Access 2007. I actually could not find the macro in the form, it
was all vb even when I found Tools - Macro. I didn't know what to do, so I
tried to add to my "LastNameSearch" macro. As soon as I entered the last
line to close and not save, a little yellow triangle with an exclamation
point appeared on the left. When I tested it, I received the error message
below.

"Ken Snell (MVP)" wrote:

> What version of ACCESS are you using?
>
> I assume that you did find the Condition column?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
> news:D5252D34-08C8-41FA-B964-56B5A7E12F3D(a)microsoft.com...
> >I place this code onto the "LastNameSearch" Macro and I get this error
> >when
> > run:
> >
> > "Access failed to eveluate one or more expressions because 'Recordset' was
> > referenced in an expression. Only functions and properties that are
> > considered to be safe are allowed in expressions when Access runs in
> > sandbox
> > mode."
> >
> > ???
> >
> >
> > "Ken Snell (MVP)" wrote:
> >
> >> Yes. Be sure that your macro view is showing you the Condition column so
> >> that you can enter the information for it. Also, the "..." that I typed
> >> for
> >> the second step's Condition column is exactly what you type. The ellipsis
> >> means that the step is using the same condition as the previous step.
> >>
> >> --
> >>
> >> Ken Snell
> >> <MS ACCESS MVP>
> >>
> >>
> >> "jerseygirl54" <jerseygirl54(a)discussions.microsoft.com> wrote in message
> >> news:786BEA34-FF5F-421F-93AA-05294F0E915F(a)microsoft.com...
> >> > Just a quick question -
> >> > When I click - "On Load" he VB screen appears. I click on Tools, then
> >> > Macros and it is allowing me to create a macro. Do I write the macro
> >> > as
> >> > you
> >> > wrote it below? Dumb question, I know! :-(
> >> >
> >>
> >>
> >>
>
>
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: Auto-Fill a Form
Next: Relationships and lookup tables.