Re: Vb code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I knew that.... :)

Too much time reading about SQL Express. Maybe its starting to sink in.....

Thanks John

--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"Douglas J. Steele" wrote:

If the MDB approaches 4 Gb, you've got major problems, since the limit is 2
Gb!

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


"Steve Sanford" <limbim53 at yahoo dot com> wrote in message
news:A086C2D6-DD0A-49CC-B8DE-21B010C87424@xxxxxxxxxxxxxxxx
There shouldn't be a problem with the*number* of procedures, unless the
MDB
approaches 4GB.

It sounds more like you have a problem with a specific procedure. If you
would post the procedure, it would be easier to help with the problem.

HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"Nandini" wrote:

I have created user interface to retrieve data using combination of more
than
three fields from two tables. For this I used three types of combo boxes
on
the form. Two boxes for boolean operators (And or, not), three for
selecting
searching criteria of 8 fields and three for putting keywords are used
here.
One command button is to execute the queries. The necessary parameter
queries
are designed. The code of If--Then--ElseIf is written. But after certain
number of procedures, I got the compile error message: 'Too large
procedure'.
I used Access 2003. What should I do? Anyone can help me?
With best regards,
--
nandini



.

Relevant Pages