This may get complicated.  We've been playing around with it forever...
I have a form with a subform.  the user selects a couple of criteria and
then the subform is supposed to populate depending on that criteria.  There
is a results table, whose fields include resultID, OpID, ...

I'd like to send a text message to a Metrocall pager from within my Access
2003 database.  I'd appreciate any tip or help on how to code this interface
between Access and the pager.

I need some help in coding the interface between my Access 2003 database and
a Metrocall pager.  I'd like to send a text message (containing data from the
database) to the pager.  

I have a form that uses criteria from another form (fProspects) as part of
the SQL for it's record source.  I've added the following code to Cancel the
form from opening if fProspects isn't open, but it still prompts for the
fields in fProspects before closing the form.

I want to distribute my application commercially with as few hassles
(headaches) as possible. The db will be distributed as an MDE. I look to the
experts on whether going the runetime route is better or is it less of  a
headache to simply distribute as an Access file? Many ...

Are there form codes that allow me to delete a selected table colum
using the column name?
If is possible is there a code to add a column to a table.
I appreciate anyone can give me guidance on this. Thank

Greetings again,
I convinced the team to shy away from using a combonation of date /
incrementing number for the ID #.
Now we are going a different route for the sake of consistancy in ID numbers

I am using a macro to transfer Excel data into a table using the transfer
spreadsheet action.  The transfer spreadsheet action requires a name for the
table.  I am looking for a method that will prompt me (allow me) to rename
the table to anything I want instead.

how do i get data from a previous field

I would like to use a where clause in a query such that query would only
select Aug dates , but I'm not sure how the statement would be constructed.
Something like:
stSql= SELECT [table A] WHERE [DATE]=8/*/****

Is there a code to launch the "Users & Group Accounts" Interface Window
--
stevenzkPosted from - http://www.officehelp.i

I am using the following code in my form but it isn't producing a message box
when tabbing to a new record.  I think the problem might be with the "And"
but I'm not sure.  Any help would be appreciated.
Private Sub Form_BeforeUpdate(Cancel As Integer)

Thanks for your help so far. To remind you what we were talking about a week
or two ago, I have a listbox that I want to summarize "vectors" in my form.
For example, if a change is made in my form that causes a value to change in
an underlying *temporary* table, I want to see ...

I’ll try to keep this short and sweet.  I want to be able to track what I’m
spending on my employee’s Flight, Hotel, and Car (IE Travel Profile).  This
travel profile will also contain job codes and department codes which I’ll
use later on in reporting.  

When I run the following command to export data to Excel, I get the following
error message when I open the Excel spreadsheet.  "File Error. Some number
formats may have been lost."
The command is: