Since the tech guy at work "upgraded" my computer to IE 7, I can only print
webpages as html. I've spent hours trying to figure out where to reset my
computer. I've been in Internet Options, checked all the settings on my
printer, and nothing is working. I'm sure it's an easy fix ...

I have a query and in one field I am looking for all of the codes, except 6.  
There are too many codes to say I only want to see these...In the criteria I
have entered it as <>AB, or <>CD, etc.  I have also tried going down the rows
for "or" but none of this has worked.  It will ...

Is it possible to force an access procedure to enter the debugger and break
when there is an error? I'm trapping errors using the standard errorhandler
methods, but I am stuck in a loop, and I would like to find out where the
problem is.

I am trying to create a Booking System for a client renting a number
of cottages.
I have three Tables:
1. Diary Dates.

I construucted a table that has many relationships from several junction
tables. After creating the first relationship, a view of the table showed the
relationship field with a column of plus signs in the left-most column
correctly. After clicking the + sign the underlying data ...

In access 2002, I add the access calendar to my switchboard and I like it to
display the date when it is opened, now it opens with the date it that it was
created only. I have try using the code below it doesn't work for some
reason.

How can I make a calendar appear on a form so that the user can select the
date and then store the date as a numeral in a table?

We have upgraded to A07 [not sure why] A03 was fine. I am feeling a bit
uneasy converting to 07.  Our A03 tables are split, we have 3 users, will
need 3 more for viewing read only reports.
Is there anyone out there that has converted from A03 with split tables to

I have a report that displays the data from a query I'm running. The
report is grouped as follows
Bin Number
  Skip Number

A little bit of help would be much appreciated. I'm an access novice and an SQL
newbi but I'd really like to know how to combine a couple of SQL routines
If I generate an SQL query called Test1 with the the following script, I can
join 2 access tables with identical structure and ...

I have a form that I use for data entry for audits.  On this form I have
fields for comments on 5 different areas.  I have limited it to five because
I need the form to be displayed on one screen without scrolling.  Is there
anyway to use a second form to enter data onto the same ...

I have an Excel spreadsheet I use for a database.  I am trying to make a
form in Access to make data entry easier.
When I open the spreadsheet in Access and make a columnar form and try to
input data, I cannot change any of the entries or input new data.  The add

I recently sent in a post asking about retrieving data from a listbox on a
search form and opening the main form showing only the records selected from
the listbox. Ken Sheridan was kind enough to send me this bit of code:
   Dim varItem As Variant

I have a need to track assigned IP addresses and I've chosen MS Access as my
tool.  One of the main reasons for tracking, is so I can issue the next
available address in a given segment.  
I have tried a few different variations for the fields, but the sorting is

I am using Access XP and trying to export queries to Excel XP with
memo fields that are getting truncated to 255. These fields have some
functions in them to get them to look right, so the only way I can
think to get them exported to Excel properly is to create a temporary