What if [Charge] is a numeric field? Would the same apply

I have an application I migrated from Access to SQL Server 2005 and have a
report that lists all of my tables and each field name, size, type, default
value and comments. Now that its in SQL i cannot use my report anymore.
Can you please give me an idea from Access on how I could ...

Is there no other way to modify import specs except by going through the
import process?  Why isn't there a more direct route like a menu item?  Has
anyone ever added a menu item for this, can it be done?

I want to change the error message displayed in Access 2000 when the user
enters a value in a combo box that is not in the list.  I've tried the
following code but the system message still appears.
Private Sub SupplierName_NotInList(NewData As String, Response As Integer)

This is a query I have created that picks up the top 3 dates for this
data (for example) :
Tree Pos2 Date
1      15     23/08/2005

I have a little application that imports dbase IV files from two different
sources. One source is the database of student information system software
where the file names of each file consist of four alpha characters, which is
followed by one numerical character that denotes the ...

I build bespoke dbs for clients. I often get the problem of incorrect
references (for Word or Outlook) when I install the database.
I know that many of you will tell me to use late binding instead of early
binding (I only just realised I could do this), BUT, is there a way I can

Using a subform I do calculate the costs of a specific kind of expenses.
The kind of expenses are selected in the primary form using a combobox.
Withing the subform now I want to have a textfield with the grand total of
all expenses within the expense table.

I want to save a copy of a xml website by printing it as a file and then save
it as the date.prn

I have a split database, forms in frontend, data in back. From the
frontend
I am attempting to export some of the linked tables (linked to
backend) to

Hi, all!
I'm connecting to a A2K database which is secured with a UID of "Admin" and
a password of "abc".  On a form, I have the user input the UID and PWD to
use, then open the database as follows:

This code calls a subroutine in an external DB:
(code in a module in "ThisDB.mdb")
     Dim AppAccess As New Access.Application
     With AppAccess

Hello all,
Got a compatibility question for ya.
I developed an access application that has sends email using outlook. My
code is given below, can I still used this code after the IT dept. upgrade to

Need some assistance -
Below is my code -
There are recording dates and positionNo.  I need to do a calculation
such that it finds the number of dates between the latest recording

Hi to all,
I'm trying to write to the registry.  I already know how to read thanks to
some post but I can't see how to write to it.  I use some methods that I saw
on some post but with no luck.  Please can someone explain to me how to do