Hi All, I am getting an error when there is an apostrophe in the Comments
text box. I tried using double double quotes in place of the single quotes
but get a different error then. Here is the code I use, thanks for any help.
strSql = "INSERT INTO tblPmiHistory (PmiId,EquipId ...

what would be my datatype or any configuration if i want my database SQL not
accept duplicate records.
Regards,

I have an inquiry screen with multiple unbound selection criteria controls in
the form header section.  The usual stuff - nothing exotic.  Once the user
clicks on the Search button, the record source is set to a Exec the SP
passing the variables from the controls.  There is also ...

I have a report that I would like to print all exhibitors and their MAIN
address information.  I would also
like to print on the same report all Exhbitors that do not have a main or
branch address. (No address exists for the exhibitor)

I want Access 2000 installed on the same machine already running Access
2003.   How can I do this?
Many thanks in advance.

I have Access 2003 and SQL Server 2000.  Lately I noticed when I add a new
record, all of the bit (check box) feilds deault to True instead of False.  i
have made sure w/i Enterprise Manager the defualt is 0, I also did this with
in Access, property

I've inherited an Access 2003 MDB -> Access 2007 ADP conversion project. I'm
a SQL, VFP, and .NET developer, not an Access developer.
The main form on this project opens a table (not a filter/query/view - just
a simple SQL table) which has 9751 records on the SQL server. The form

need to add a 'select' & 'Group by' statement in excel query.
The Spreadsheet looks like this
KRE001    8/17/2007
KRE001    8/17/2007

Hi, I am leaving my current job and want to be able to take a copy of the SQL
tables,views, etc with me. I don't need all the data in the tables. I know
how to individualy script objects but is there a way to bulk script the
database so when I get to my next job I can recreate it. ...

Do you know were I can buy the last release of Vista ?
Ty
Sponsored search :
********************************************

Greetings eveyone.  I am using Access 2003 and SQL Server 2000.  I am trying
to make a procedure the record source of a new form, but in design view the
field list is empty.  The procedure has several variables, all of which may
be null, and the where clause is constructed ...

Hi, (I posted this in the query area earlier) I don't know how to link post
yet.
Anyway, I am having trouble creating the logic for a date case statement
(this is for

Here's a complete mystery...
I was using Access 2003 to open and manage an MDB located on a remote
server. In the datasheet view of tables and queries, I've adjusted the
width of the various columns to that which I am comfortable. All OK and

Want to query weather an image is null.  But IsNull() doesn't work with an
int.  How can I check via a query what records don't have an image? Help...pls

I'm trying out how I used to do things with Access, but now as the ADP
front to a SSE.
One such task was to search and replace for anything in a particular column
and replace it with NULL throughout the entire record set. I tried that