Search results for query: *

Sorry... havn't been looking at the forums lately... In Access Project you just create the stored procedures like you would a query. The triggers are created by right clicking on a table name, selecting triggers and then creating a new trigger. Remember that you are working in transact sql...

Oops.. i spoke too soon... that query did work! Sorry everyone

Hi everyone... Here is a problem i've been working over today to no avail... I have 2 tables - the first table "A" contains 1 field which I will call 'item' the second table "B" contains 2 fields 'item' and 'OnOrder'. I need a sql statement that will update the OnOrder Field from a user...

Could you copy and paste the sql from your query onto this forum so that I could take a look at it? I don't know if I am following you but I think you are saying that you are using a query with criteria 'like *(field)*' in all of the searchable fields... is that right?

I'm using QODBC to connect my access project to Quickbooks. I could use the Quickbooks skd, but it is so much easier to just use the ODBC driver.

Using the Access Project you can set up the stored procedures and triggers right from access. I have used both mdb files with an odbc connection to sql on the back end and adp files and find that both work very well. From what I have read thought it seems that Microsoft will not be making any...

Can you reference a dsn connection table in a SQL query? I would like to use a stored procedure to do an INSERT INTO query from an odbc dsn connection into my sql database and would like to know if this is possible.

Thanks, I will probally do that. Quick question for you though... since I am new to programming in adp..... What are triggers usually used for?

Try clicking on view in the menu and then select 'show panes' and 'sql'

Hi. I had been programming in using mdb files for a few years and just recently started using the adp file. Here is a little bit of what I have found out: In the future, Microsoft has made no plans to do any more work on Jet Sql... So like you said the adp file is going to be future of access...

I have a table called PurchaseOrder which contains the header information and a table called PurchaseOrderLine which contains the line information for purchase orders. I have set up an update/insert trigger on PurchaseOrderLine to update 4 different fields in PurchaseOrder - they are...