Search results

Yes the code works. I have the conenction string saved in the pass through query. I just pass new parameters here to get a new result set.

Thank you both. I did do something just like that. It just took me a little while to make sense of it. This is the first time I have had to work with this scenario. I have my pass through query that I pass a paramater to here to update that result set (I have the paramter hard coded while I am...

Thank you for the reply. I really would like to not use a local table for this if this is another work around. I have quite a few of them that need to be built. Basically the user opens the report prints it and they are done. It won't leave the connection open long. If anyone has any...

I have been trying to use a pass through query as the record source for a sub report, but apparently it is not allowed without some work around. I have been researching online and I came across this article where I can set the record source of the sub form in the main forms on load event...

I did put the Option Explicit in the top of my module :). Actually I ended up changing this again. I forgot that this form was bound to a recordset that was pulled by a stored procedure. I instead just had the pass through query execute again and reset the record set to the new qdf and it...

Okay so I realized the only thing I had left out that was in the example was the error handling code so I added that and it solved all my problems. Here is an example for anyone else in need: 'Save the new record that has been started so that it can be updated by a stored procedure with the...

I tried commenting out all of the code that runs the stored procedure and it still refreshing to the top record.

Thank you for the reply. I tried the code and I even opened the sample database and looked at it and I feel like I am doing the same thing, but mine doesn't refresh to the record I was working on. It may be some of the other stuff I have going on in the form. I need that stored procedure to...

Hello, I am trying to set the focus to a particular control for the current record after a form is updated. It always just goes back up to the top of the form to the first field no matter how I write the code. Can anyone see what I am doing wrong. I am using the me.currentrecord and I...

I instead just created an unbound text box on the form that I set the date equal to now so that the user can see it update. I already confirmed that the date gets updated in the actual underlying table when they push the button. The form just doesn't want to refresh form some reason. It is...

The text field is DateEmailed. I tried moving the refresh and requery up and it didn't help. I also do have the option explicit but it just is not part of this specific click event. Dim EncNbr As String EncNbr = Me.EncounterNbr With CodeContextObject DoCmd.SetWarnings False...

Hello, I have have this code in the click event of a form that updates the database table with the current date when the button is pressed and it used to always then update a text box on the form with the date, but suddenly it just stopped working. I haven't changed anything. Everything I...

I am having issues with getting anything in the ADODB collection to work. I think I have a missing reference and when I try to add it I get an error so I think I may need to reinstall Access. On another note I was able to use my pass through query that executes a stored procedure and set the...

Thank you for the example. I will look this all over and experiment :)

So in my sql procedure I should insert all rows into say TempEmailList and then link to it from my front end? That is where I feel like it will get overwritten. Should the temp table exist locally in the front end? If so how do I insert the records from the stored procedure into the local...

My concern with a temp table is that if multiple people run the report that the results will get overwritten. I am going to give everyone their own copy of the front end, but if the temp table is stored on the server it seems like they would all be using the same temp table. Am I wrong?

Hello, I have a pass through query that executes a stored procedure that will return results that I use on an MS access report. I have created the pass through query like I do for all of my forms and instead of putting it in the record source property I put code in the load event to populate...

This is how I ended up solving the problem. The actual stored procedure is referenced as a passed through query in my database and it seems to have to be there for it to work. This gets me the results I want. I am sure there are better ways to do it so that i don't have to store the pass...

Hello, I have been struggling with this for days. I finally just got the stored procedure to execute through vba and to populate a form in my database's record source property. I started first with just getting it to execute a stored procedure with no parameters because I was having trouble...

Thank you. I will look at removing the macro.