Good Day
While using a sub form the code that is generated by
access displays this error message. "Object doesn't
support this property or method"

I'm no computer expert, so I'll just explain what's
happeing & maybe someone will be able to help!
I have a website & use Access 2000 to connect to the SQL
database in order to modify/add products etc. Normally I

Hi,
I just started a new job and need advice. Where can I
find information on the advantages and disadvantages of
Crystal Reports Vs. Microsoft Access Report Generator

Hi. I created a system dsn obdc data source but, when i
try to use link table manager in access, i can only see
some of the sql server database tables and views, not all
of them. any thoughts? thanks!!

I have two queries that I use in Access:
<qrySelect>
SELECT table2.column1, table2.column2, table2.column3, table1.column4 FROM
table1, table2 WHERE table1.column1 = table2.column1

hi group!
I have a problem that drives me cracy:
I have a view that looks like this:
Select * from tbl_test

I've inherited an Access 2000 ADP which I've been tasked to rewrite in VB.
It uses no security, (sa and blank password), and my first step is to secure
the SQL Server database.  Problem is, when I switch over to NT integrated
security, the reports based on stored procedures cease to ...

one of my forms is based on the results of stored procedure (that is
Form.RecordSource="exec MySP")
MySP has an output parameter as well. How can I get this parameter from this
stored procedure? I can't call it twice as output parameter can change...

Hi There,
I converted our Access database to adp front end and sql 2000 db as
back end. Every things is working fine except user permision. When i
distribute the adp file to our staff they could not able to open some

I am migrating my access database to SQL Server. I have a
crosstab query in Access which is
TRANSFORM Sum(qryDatafile2003.[Total Price]) AS
[SumOfTotal Price]

I am new to ADP and have trivial question:
How to pass a parameter to a stored procedure?
Here is my SP:
===================================

I have a patient database with MS Access project as front
end, and SQL Server 2000 as back end to hold tables etc.
I have a "Patient Information" Form that I want to add a
command button to.

   DoCmd.OutputTo acStoredProcedure, "dbo.ADP_ExportinventoryBysupplier
13", "MicrosoftExcel(*.xls)", "mytest.xls", False, ""
when i look at it in the profiler is send this:
SELECT * FROM "dbo"."ADP_ExportinventoryBysupplier 13"

I am writing a stored procedure in SQL Server,but it keeps
on giving me the same error everytime "Invalid column
name: FirstOfSub Product Code
Have tried to change it to FirstProductCode, but it still

I have just migrated from Access to SQL Server. In access
I had queries which used FIRST,but when I use the same in
SQL Server it says "first is not a recognized function
name". Can anyone please advise me an equivalent method in