Search results

Fixed the code and the actual parameters for the query aren't getting passed and I don't know why. Linked tables is very new to me and I don't understand it all. As far as the Public Sub, how does your code know what "qPT_Generic" is?

The recordsouce is now set to the Query_Tracking. When we run the report, it execute and brings up data, but not the parameters we passed. So now it looks like the parameters being provided aren't actually getting passed and what ever was stored in earlier executions, is what runs. What would...

I commented out the On Error Resume Next and received no error and report still doesn't work. It opens, but there is no data.

We no longer have a Q1. We rewrote the code and it compiles with no errors. That, when the report is opened, there is not data, which tells me that it is not executing the stored procedure. I don't know why the code isn't executing the stored procedure, which I provided in my previous...

Thanks for you response. We are using linked tables to SQL Server. We upgraded from ACCESS 2010.adp to ACCES 2013 accdb. Q1 is the continuation of the select statement based on the user. When it's necessary to use a Sql Server Stored procedure for you source code, then you would have an...

Greetings all - I have a form that is based on a SP that was originally coded in ACCESS 2010 and now we are "using" ACCESS 2013. The form runs fine and behaves like it is updating the record (messages displayed), but never actually updates the table. Tried a lot of different approaches, but...

Ended up requiring the Main form after the selection in the combo box was made. That worked Thanks you! Still have to base the sub form on the table because when the query is used, the sub form doesn't show up.

Hi everyone - We recently upgraded and access 2010 adp database to and access 2013 accdb and not everything is working properly. We have a Form with a related Subform and they both have combo boxes on them. After a selection is made in the main form combo box, that value is saved in the table...

Yes, I have, but have no clue as to how to make that happen. It would certainly be the best way to go. I have a hard deadline of July 31st for up and running for everyone. There is a tremendous amount of vba code throughout the DB and I didn't write it. Dissection is very challenging.

That stopped the error. i must have missed that one. Thank you! I compiled the database and now, once again, it's asking for my DSN. I don't understand why it it keeps asking for the DSN.

Yes, I agree. I listed all of the References that I am using. Does anything jump out? I tried adding and removing different oneds but I continued to get the error.

Attached is copy of the actual error message.

'Callback for Form OnButtonPress Public Function FrmButtonPress(ctl As IRibbonControl) End Function On Error GoTo FrmButtonPress_Err DoCmd.OpenForm ctl.Tag FrmButtonPress_Exit: Exit Function FrmButtonPress_Err: MsgBox "Error:" & Err.Number & vbCrLf & Err.description, vbCritical, "Warning"...

I finally have my toolbar loading. Unfortunately nothing works. The Public Function FrmButtonPress and RptButtonPress keep getting User-Defined type not defined error. I have been trying to research this issue, but nothing has worked. There is a lot of information out there! My references...

Thanks for your help. Do linked tables have to use dao?

Well, I put into my original db and my message is back. I have the correct references and I have compiled the database. No joy.

I didn't see any errors running the code you provided. I will attempt to try it in the original db. I still don't understand how the toolbar showed up with not code behidn it.

Okay, it worked! What now?

I didn't see any real code in the module. How did the toolbar load? Very curious. I will let you know if the code works on the 2013 machine shortly.

It worked! We were supposed to migrate to 2016, but there is a lot of code changes that I can't do on my own before our August deadline. I am too green.