On our aging accounts reports for sales reps, I would like to calculate the
median aging field values on each rep's list. I tried placing Median([Aging])
in the Rep footer, alongside Sum([Open Balance]).
Opening the report, Access asks for the Median parameter but calculates Sum() ...

I have a form with a combobox with EmployeeLastName,EmployeeFirstName which
are 2 fields from table
Employee. My code is
Private Sub Combo31_Click()

I had this working when I only coded it to insert 2 fields from my list
boxes.  I simply added the other 4 fields that are in my list box and now I
am getting a message:
"Too few paramaters. Expected 1"

I need to be able to send SMSs from my Access app using SOAP.
Can someone point me to a 'how to' article please.
My VOIP uses SOAP web services. (whatever that means)

I have a form with a combobox with EmployeeLastName,EmployeeFirstName which
are 2 fields from table
Employee. My code is
Private Sub Combo31_Click()

Hi, does this need programming? I want a field to be populated after updating
it with a Date. For example, FieldInitialDate and FieldEndDate. This 2 dates
should be the same, but sometimes will be different. Also, have a check on
the FieldEndDate to make sure that date is not ...

I am so confused in my procedure where  I am trying to take 2 text fields
from a multi-list box and insert them into a table as text.  I keep getting a
data type conversion error.  Does this error mean something is wrong with me
having a text versus numeric quoting in my INSERT ...

I have an insert into statement that takes a value from a listbox and puts it
in a new table where more fields will be manually typed in on another form.
The field "Oracle" represents two fields in one, hence the hypen.
But the insert into puts it in the new table as a subtraction ...

I currently have VBA written to export query results into an Excel
file.  That file is then formatted using the code below.  The problem
I'm having is that it keeps throwing Error 91 (Object variable or With
block variable not set) at this part of the code:

I have a database that has around 300,000 records. Any query to run is taking
a long time run.
Is there a efficient way to handle huge volumes of records and make it run
faster.

How would I programatically run a query after another closes.  
Basically I want to run a series of queries.  But I don"t want them all to
run at the same time.  I want one to run and after the user closes it the
next runs and so on.

I have a macro to run a form called Main Switchboard.  I would like to put
this file out on the network and have it automatically open to the Main
Switchboard.  Please advise how to do this.

Good morning,
I have a table (Table A) for which I created to keep track of who has been
logging in and out of the database.  In the table, I have 3 fields: LogInBy,
LogInTime and LogOutTime.  

I am working with Access 2003 and am in desperate need of help.
I am unsure of how to go about this, but I have recently created a database
that allows me to enter data into 3 different ways (by cluster, group and
store).  I have select queries for each to break down the groupings ...

I have a form called "frm_Credits".  I have an option group called
"Frame_Credit".  Within this group are 4 options.  They populate the "Credit"
field.  I also have a field called "Units".  What I need to do is go through
a series of scenarios that could occur and perform an ...