I'm trying to fill a 2-dimensional array with ca. 2.000.000 records and I'm
getting a 'out of memory' error. Is that due to limitations on my machine or
in VBA or something else?
Jesper

Happy new year!!!!!!
I want to know if is possible to agrup Word and access tables? Been more
expecifically, i want to do a template in word, that have a table with 3
columns. 1st - Code; 2nd - product; 3rd - quantity; and each line of this put

I want to get the total sum up of annual approved budget relating to 3 fields
from Budget entry form to budget analysis field (txtannlapprvbudg). I have
used following codes.
Private Sub txtapprvbudg_GotFocus()

I have a combo box that I want to clear. I tried combo.clear, but it doesn't
work.
How can I clear the combo through code?
Thanks.

I want to create custom menus in an Access XP database using VBA.  One of
the menus I need to create will open selected forms, queries, and reports
directly off of the menu.  Using the Customize command (not using VBA) I
have added forms and reports to menus but I can not figure ...

I need to prevent users from being able to enter in future dates into a date
field.  Has anyone found syntax that performs this function.
So, the logic should be that <=todaysdate
Any ideas?

I am passing a date entered by the user ( from an input box) to the TSQL
statement for a pass-through query. What is the correct syntax in the WHERE
clause for the user's entry? Here is what I have, I know the # is wrong:
AND ((t.ApptDate)> #1/1/2005#)

I have an Access program that makes several tables and then runs queries from
them to create the final report.  The database is fairly big (a couple of
tables with about 1 million rows each, and several others with a few hundred
thousand rows) and the program runs about 50 ...

I have AC2002 app I have been developing and supporting for over a year.
I have added new features over time.   The app is split with a front and
back -end.
Over time the front end mdb has bloated to 15 megs.  There is no data here

I need to import an Excel spreadsheet (that is a download report from another
system) into my database.  There is one TEXT field in the Excel database that
contains some blank spaces in front of the field.  The field may contain a
mixture of numbers and letters and sometimes has ...

Recently our facility Migrated to another Domain.  I have to use a different
username to get the same access to the Network that I had before.  We have an
access program that generates Help Desk Request, and when ever I try to go to
the privileged area for Network Admins, I get a ...

I've wrote this function to loop through a table of Holiday dates in
order to calculate a business day three days in the future that was not
a weekend nor a holiday.
When I tested it as a function in a query, it worked fine.

We have a database which keeps track of staff training.  We have three
tables staff, course and training.  The course tabvle stores details of the
individual courses and their compliancy periods.
Course

I created a custom toolbar in Access 2003.  I want the users to see the built
in print setup dialog box so that they can choose No of copies, range etc;
but the print button just sends the  report straight to the printer.   Why is
this?  I have even tried coding in Sendkeys (ctrl ...

I have this code on several option buttons.  When one is chosen the
corresponding combo box appears.  The combo box is linked to a query for data
to pick from.  My problem is that the code will work for the current record
only and changes all the others at the same time.  I tried ...