This is odd, and only occurs for one user, no matter what machine he's using...
I have a query that populates a listbox contained in a "Tab Control" on the
main form.  In order for this listbox to show the most current information, I
have the form perform a Me.Refresh in the ...

I have a form that displays contact details from a table.  When I do a search
on any field using the standard search button & want to scroll thru the
records, it sorts by  the RecordID field which is the primary key field.  In
the form properties I have defined the Sort Order by:

How do you capture a combo box selection to use in a query?
Thanks!
Opal

Sorry to post this here, but I can't figure out exacty where to put
this and nothing has any traffic :)
I have a bunch of linked tables which work fine.  The problem is that
when I go to linked table manager it doesn't show any of them.

How can I format cells individually in a pivot table. Depending of the value,
I need to set color for detail or subtotals in a pivot table with two fields
in rows. I used:
Me.PivotTable.ActiveData.Cells(RM,CM).DetailCells(0,0)

I have a combo box on a form displaying Months. I have them sorted from Jan
to Dec based on numeric value of the month. I'd like to add option "All", but
then I have to use "*" in my numeric column and it converts to text. And then
my sort is messed up. How do I add option for ...

I have a list box in which information gets listed from a field (of course).
However, every time I add a new record successfully, a blank line gets added
to the list box. How can I prevent that from happening?
Below is the code I am using behind the form and behind the listbox on ...

I have been using these groups for assistance (and offering some at times)
for the last few months.  I have a suggestion for all those that respond to
the various questions--At least have the courtesy to answer the original
question or provide some guidance to help the person ...

Is it possible to populate multiple fields with OpenArgs?  Say I have 3
fields populated in form1, and I want those 3 fields to be populated in
form2.  Can I use the OpenArgs to do this?

I have a small table and associated form with just 1 field that contains the
8 bank (public) holidays throughout the year (each as a separate record) and
I want to compare all these records against another field in a form where
people enter their holiday (vacation) dates.

I'm struggling with an if, then statement.  I have a combo box [status] on a
form.  When the user selects "complete" a message box reminds the user to go
to another combo box [savings] and select the appropriate answer.  That
second box is not required (and thus is null) until ...

I've just discovered this rather useful technique, but I have a few questions
that do not seem to be covered in Microsoft's documentation.  I'll be
performing some experiments, but I'll take whatever comments or links people
would like to provide.

I have an Access application that launches overnight and basically takes
data several different sources and outputs a new combined tables.
My code is very easy and there is code present in only the Form_Open event
and I have startup options set to open my form:

I'm trying to sort the following data....
1,2,3,4,5,6,7,8,9,10,11,12,13,14...etc and A1,A2,B1,B2,B3,B4,C1 etc...
This is the code I'm using...
With Me.ListTransfer

I've copied some code from an Access website, and it's basically a plate of
spaghetti, even though it does the job.  I find myself scrolling up and down
between function calls and the function, only to find that by the time I
locate the function I forgot what I was looking for.  ...