Is it possible to call a web service that returns a dataset, from access?
Could I please have an example of how to call such a service from access?
Thanks
Regards

Hi Gurus
I noticed that when you have a class module without error handling, you can
not actually debug it.  That is to say, you will get an error when calling
the class, but it does not tell you where the error takes place.  This is

How could I make a text field sort in the following way?
2CBE00001            2CBE00001
2CBE00002            2CBE01001
2CBE00003            2CBE02001

I've created a stocktaking database using Access XP. This is indexed by two
fields - part number and shelf location.
I am currently inputting all the data via a form. When I have entered a
record such as:

I have created a button on my form which when pressed does the
following :
1) Run a pre-defined Macro, which is picking up a query and running my
data to excel.

I'm still in the process of rewriting my Parts Inventory application, and
still using good old Access97 to do it.
I'm attempting to modify Allen Browne's code from:
http://members.iinet.net.au/~allenbrowne/AppInventory.html

I have a continuous form with  3 comboxes, combo1, combo2 combo3.  The
choices in combo2  are dtermined the what is selected in  combo1  by using a
where =  combo1 statement. The combo is refreshed with code, i.e. . The
combo are freshed with code on after update of previous combo. ...

I have a problem making changes to a query. The query is extracting
data from three different tables, but when I run the query in a form
or datasheet view I can't make any changes to the data. I can view the
data but not make changes.

I have this code in my button click event.  this runs with no error.
However, the stored procedure doesnt execute from the  sql server.
any idea?
TIA

wondered if anyone might lend a hand? I'm having a little difficulty
updating the backend SQL Server tables. Normally I just use Access'
update but I'd really like to try something new.
I'd like to be able to override Access' update, capture the updated

Hello to All,
I'm trying to retrieve records from AS/400 in an VBA application.
So, I've made an RPG program, then a stored procedure wchich calls that RPG
program, and finally some VBA code to call the stored procedure and retrieve

I need to know the key strokes to insert fields into a select query.
I know how to use the mouse but I want to know the key stroke.  Can
anyone help?

I have developed an Access database and wish to e-mail a form to a
central address advising of changes etc.
Have the form and command button the form with a macro behind using
SendObject command.

Obviously im new with ms access..so my basic question is how do i run
crystal reports in my ADP.  I also pass parameters to cyrstal reports.
Please help!
thanks in advance

Does anyone know how to print a report to a specific printer, and even using
a specific tray. Using VB or even a macro.
Jeff