Recent content by jcmv007

If I do would't I need to recode the entire form?

Private Sub cmdPrvMenu_Click() Dim stFilter As String stFilter = "[ItemNumber] = 0 AND [Argument] = " & Me.txt2 Me.Filter = stFilter'On this one End Sub

Using Windows XP SP1 and ACCESS 2002; I have created two buttons on a switchboard, one takes the user to the main menu and the other to the Previous Menu, it is in this last one that i get the following error: Run-time error '2001': You canceled the previous operation. I'm open to other...

Thanks for all your help! Found in another post the answer to my problem! I had to set in the Stored Procedure 'SET NOCOUNTS ON' so the recordset could get populated.

cmmrfrds I get the error "Operation is no allowed when the object is closed" and the debug window points to the line of the code: If rstSource.EOF AND rstSource.BOF then

HEllo. I did search but the code was a bit confusing. Even thou I worked it out to the following code, but I get the error "Operation is no allowed when the object is closed" if the following line of the code: MsgBox "Cantidad registros " & rstSource.RecordCount Here is the code that I'm...

Do I need to refrase question or give more details?

Using Windows XP SP1, Access 2002 I need to run from an Access DB a Stored Procedure found on SQL SERVER and append the results in a table in that same Access DB. The stored procedure needs to be supplied with the following parameters User, BeginYear, EndYear; these are determined by the user...

Zhavic, Thank you very much! I finally got it to work. Now how can I optimize it since it's taking more the a minute to run, I have include the final working code. DROP PROCEDURE sp_DatosParaSistemaAPH GO CREATE PROCEDURE sp_DatosParaSistemaAPH ( @User int, @AnoDesde int, @AnoHasta int )...

Zhavic, Ok could you then please help me write the stored procedure using temp tables? What aditional information would you need? Thank you very much for your time and help!

Zhavic, I have placed 'SELECT * FROM #tp_Datos -- without INTO clause' at the end of the query before the return. I read that you can use table variables in a store procedure and that is what I have declared in Q2. I'm open to other options, like temp tables. 'tblGrupoDeCuentas' is not join...

Zhavic, Sorry for the mistakes I should of cuaght them, I checked the querys and here it is. The @User is a parameter I would like to use in my querys an it is an int data type. CREATE PROCEDURE sp_DatosParaSistemaAPH ( @User int, @AnoDesde int, @AnoHasta int ) as --TABLA VARIABLE PARA...

USING Windows XP SP1; SQL 8 I need to create a stored procedure which displays the results of a temp table which is populated by that stored procedure. It's complex form me to write becuase it's my first SP. to get my final results I need to run a couple of querys, lets start with Q1 and Q2...

mstrmage1768, It worked great Thanks!

USING: Windows XP SP1 Access 2002 SP1 What function or code can I use to find for example, 1 in the following string: 8,1,9,11,23 ?