Recent content by Pizarro

Hi Guys.. I ran into the same error and I found the cause to be an empty toolbar that I had setup in the prior version of MS Access. The toolbar was named Custom1 and was set up in the Tools\Startup as as a Menu Bar:Custom1, but not in the opening form; I did this so that the form would open up...

I have an unbound form in an Access project that sets it's RecordSource to an ADO recordset in the OnLoad event. On the form's Dirty event, I start a new transaction on the connection object (if one hasn't already been started). When the user exits the form, I can prompt them to save or...

Thank you very much for the valuable information. You have jump started my projects! God Bless! Regards - Pizarro

Here what finally worked: Many thanks to all and a specials thanks to cmmfrds! On Error GoTo ErrHandler Dim oConn As ADODB.Connection Dim oComm As ADODB.Command Set oConn = New ADODB.Connection Set oComm = New ADODB.Command '==== oConn.ConnectionString =...

Thanks for your reply and here is what worked: On Error GoTo ErrHandler Dim oConn As ADODB.Connection Dim oComm As ADODB.Command Set oConn = New ADODB.Connection Set oComm = New ADODB.Command '==== oConn.ConnectionString = "Provider=Microsoft.Access.OLEDB.10.0;;Data...

Thanks for your reply and yes I have added your code and I did not get anything - I'll check back later - Thanks again for all your help!

Thanks for lookin in Jay!

Here is what I came up with but I am getting a time out error and the stored procedure is not executing..... What could be wrong??? Any help as always very much appreciated! regards - Pizarro Private Sub Command0_Click() Dim oConn As ADODB.Connection Dim oComm As ADODB.Command Set oConn =...

Thanks for the reply. I have gotten so far with what I have down below. 1.) I am getting a time out erro message and 2.) Stored Procedure2 is not executing. If you have any ideas they would very welcomed! Thanks again and Regards Private Sub Command0_Click() Dim oConn As ADODB.Connection...

Thank you so much for help. And I hope you understand that it is a bit hard just diving into this, all I need is some valuable direction, just like the one you gave me. I have developed great apps with Access but now my data has overgrown. I am not scheduled to start training until next month...

Thank you for looking into my question/problem! Here is my senario: I have the full SQL 200 on my desktop. Server name is BLK00FINA00129. From my ADP named Cumes.adp I am connected to SQL database named Cume2SQL. the following is what I am trying to do which is run a stored procedure from a form...

Thank you very much for your reply ... I tried it in a stored procedure (I am new at this but with mucho experience in DAO) tried to run it and nothing ....what am I doing wrong or a step I'm missing? Thanks for your tremendous help!

I am simply trying to append all records from table ORDERS to table ORDERS CUME and this is as simple as it gets but it does not work, I am greatful for any light! Regards Julio ALTER PROCEDURE StoredProcedure1 /* (INSERT INTO dbo.Orders Cume OrderNo AS Expr5, Sponsor AS Expr6, SponNo AS...

Heres what I came up with ...And all thanks to you! SELECT [Orders Cume].FeedDate, [Orders Cume].OrderNo, [Orders Cume].Sponsor, [Orders Cume].OrderDpt, 0.001*Sum(case [Units Cume].Flight when 'FLT2' then [Units Cume].TotAlloc else 0 end) AS GrossFlt2...

This is what it looks like in the query pane: I have tried your suggestion and put it in above the FROM statement but and error messages comes back, could it be because the query is grouping? SELECT dbo.[Orders Cume].FeedDate, dbo.[Orders Cume].OrderNo, dbo.[Orders Cume].Sponsor...