I know I read somewhere you can do this...
I have an ADO recordset built on a highly complex and slow query. I've
filtered it and I want to assign the filtered query as the ?Control Source
?RowSource? to a listbox which will display 3 or 4 of the 10 or so fields as

I'm afraid this is a bit of a wishy washy question:
I have lots of data stored in various XML files for which I have written
code (SAX) to interrogate the data and store it in class modules (as
scripting.dictionaries). I takes a bit too long to write all of this data

I have a problem with an Access 2007 form setting the control source of an
HTML control and displaying it in the form.  The Form is bound to a table
which contains the memo fields mem1HTML...mem8HTML which contain HTML. The
form contains a tab control (with 8 pages) and an HTML ...

Ive got another doosie for you guys. Ive got a pretty wide form, and i was
wondering, is there a way to lock the form header so it stays in place whilst
the body of the form is scrolled left or right? Pretty much I'd like to be
able to see the top left corner of the header when i am ...

I have a form with two listboxes, and I want to move items from one listbox
to the other. I have found some -perfect- code to move the items on
http://support.microsoft.com/kb/278378.
However, if I move an item from the left to the right listbox, the item is

I have a lot of item #'s to look up, like 50, so I put them in a
table, I also listed some key's so certain items could be lumped up
together easily. It looks like this
autonum    item         class        group

This is mainly a general inquiry as to how the group tracks the work being
done on an app.  This is either new or existing.  I have inherited a very
large development (10 yrs in the making) and there has not been any method of
keeping track of what was done.  By that I mean the ...

I use this code to count the # of things that happened on that day of the
week - xSun: Count(IIf(Format([ToDaysDate],'w')=1,1,Null)).  It works in
program A.  My boss saw it and wanted me to add it do something he does.  I
copied the code, created a new query using his table, ...

Good afternoon,
I am having a hard time with my form.  I need my form to allow me to input
data by year and hold that data.  I have my queries set up and they are
running correctly.  I just cannot get the form to allow for data entry.  I

I need receive 2 values from my function. I know that function only
returns one value.
I just wonder can function return array and calling function may
access the elements of array or pass by references than calling

I have copied the mousehook.dll into the same folder as the database, copied
the code onto the load section of my form, but I keep getting the following
error:
Compile Error:

I have a crosstab where the values are listed in months. It works fine
but the months reflect 1,2,3,4, etc I would like Jan, Fed, Mar, Apr,
etc. I read how to go into query properties and add column headers of
"JAN", "FEB", "MAR", "APR", etc, but when I run the query it says data

Hi everyone, I am looking for assistance in adding a line in my code.  
Currently i have a button on a form that upon the click runs and query and
saves it on my desktop.  I would like to add a line of code that would open
outlook and place the spreadsheet that was exported which ...

I have a main form with a text box in Form Header which AfterUpdate finds the
record and displays the main form with correct record and all its subforms
for editing and adding. When I first open the main form there is data showing
so I assume the form has pulled all records from ...

We send out surveys to clients and keep track of them in Access.  A form has
been set up to send out various surveys to email addresses in an Access
table.   The form works just fine, with two bugs:  (1) we have to change the
"From" field for each of several hundred emails (to ...