Is it a common occurrence for A97 VBA to 'RACE' on past
a debug.print statement?
I have been trying to debug a problem (which turned out to
be an attempt to assign Null to a Date Type variable) and had

I generate XML from an MS-Access 2002 database and find that I can
format and display the data no problem with a XSL/HTML template.  Perfect!
However, then I found that I needed to replace my automatic MS-Access
output with a customised dump of the XML and find that I am now ...

Can someone please tell me whats wrong with the last line of the query
below. The first three lines work fine but when i add the fourth line i get
an error message (see  text at ERROR MESSAGE)
       sql_HTTermijnRecords = "select * from Orders where FaktuurGeprint =

Does anyone know the difference between Navigational and Lookup
features of combo boxes? I wondered if there were difference between
these two if we selecte "remember the value for later use" when we save
setup in lookup of combo. Thanks.

I automated printing of my report...so I am able to print n-number of
versions of it. If I send it to the printer everything is
fine...however if I send it to a free pdf printer I will get n windows
asking me for the save as file name. I was wondering if through access

1. Can you do a parameter query on a Memo field?
2. Can I set up a query to find all records that do not have a date in
the field.
As you can probably tell, I have tried but have not been successfull

I have a form w/ 11 identical text boxes in each of which user can
enter a number between 1 and 11. Each defaults to 0, which I use to
flag empty. Each has the 1 to 11 restriction as its validation rule,
but I also need to enforce no duplicates among them. I haven't been

I am trying to create a crosstab type of report without using crosstab
query. The report captures several survey questions and for each survey
questions there are multiple choices that users responded to. Basically
I am trying to create a report that will look some thing like this

Access 2003.
A client has asked me "Can you publish multiple Access reports to the
Web and allow them to be selected individually using a filter, for
example?"

Hi, has anyone experienced a spontaneous loss of a subform bookmark
(i.e. resetting to the first record), when the computer is idle.
I used to have a problem in NT4 when doing a couple of specific things
outside of access (launching internet explorer or adobe) that would

Good head-banging stuff!  :-)
http://video.google.com/videoplay?docid=2362050448778905490&q=%22steve+ballmer%22

I am trying to exclude zeros from my report by setting a report filter

[SumOfDebt]-[SumOfCredit] <> 0
This excludes most of the  Zeros, but not all.

Is it possible to select the number of copies of a report from a variable
input in a form ?

I am using the following code to save the changes to a form's data in the
form's Before Update event;
For Each ctl In Me.Controls
   If ctl.ControlType = acTextBox Then

After viewing OFF307 from
http://blogs.msdn.com/access/rss.aspx
I have a few comments.
Although I was very impressed with the user interface and overall