Could use some help. I don't know if I can even do whatI'm trying to
do. I have a text box in a report under the details section. It will
return a value for each line on a sepcific record set. There may be 1
line or 10 lines. What I want to do is sum the totals in that text box.

Say I have a list box. I also created a control on a form bound to that
list box. When I click different rows in the listbox the control
changes the ID of the row depending on what I click.
One thing I'm doing is setting the .selected(i) property of the list

I'm trying to export a reference table from MS Access to a table via
ODBC.  Is there a way I can use a DAO.Recordset and use the
value(field) to populate my ODBC table?
Dim rs as DAO.Recordset

   I want to use check boxes on a form in datasheet form that has a query
for a controlsource. Here is the basics of it:
   I created a query that will return all the fields in one table then in
the next cell I am returning a value of -1 or 1 depending if one field in

hello i have a front end access application that has mixed linked
tables from 2 different sources.
some tables are linked to a MYODBC Driver and the other tables are
linked to an access database.

Hi - I'm stuck on a simple problem I am trying to display a true/false field
in a report, and instead of the default value of a checkbox, I want to print
"Yes" or "No"
I have tried various permutations of :  iif( [DBFld]=True,"Yes","No")   .

I have some code in our database which opens Windows Explorer in a
server folder related to a loaded form. The code is:
Shell("explorer /e,/root, G:\Surveyor\Parsonages\" & strHouseNumber,
vbMaximizedFocus)

I arrived at the holy grail of Access 2000 programming about a year
ago, when I found out how to READ AND WRITE to and from the Microsoft
Outlook Inbox <smug>
Now the pesky endusers are saying they want to be able to use the

I have a text file that needs to be imported into a table on a daily
basis.
The data is replaced each day except for one field.
This field has an account balance in it and needs to be added to each

I'm trying to enter data from a form into two different tables.  The
field names are identical in both tables.  I only want to enter the
data once from the form.  In each table a new record will be created.
Is this possible?  Can someone tell me how to do this?

Can we find another way of dealing with PCDatasheet?
Can we find positive things about Steve and emphasize them?
I can think of two
    1. He can explain things very clearly;

Hi Guys:  I was stuck.  I needed to send a report to a file.  My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.
I described my situation to the guy I'm doing work for and he did some

Hey everyone,
I am having a hell of a time trying to set this menu system up. Here's
what I'm trying to do.
Combo Box One; is populated by names under properties "row source"

Dear reader,
With DatePart() you can subtract the year or the week from a date field
with:
           DatePart("yyyy";[DateField])      for the year

I have some code which uses the now unsupported "ChrB" function.  The code
worked in A97 but does not with A2k3.  Can anyone tell me what the following
arguments equate to?  Many thanks.
ChrB(19)