Search results for query: *

Hi all, There is a fair amount of information on the site related to connections to Attachmate Extra Basic using VB code to establish the system object. At my new company we use Smarterm by Esker as our terminal emulation (3270) software. Does anyone have a code sample on how to make the...

Quick question. Is there a setting in Adobe Reader that will open a new document in the window and replace the current document? I want to open one document after another without having all of the documents layer one on top of another. Thanks for the help!

This is it.. "RunProcess" is a sub function that is started since the recset is = 1. However the recset is not correct and should be the 100+ records I get in the query and the fields I use from it are null. Public myDB As Database Public recset As Recordset Public qdef As QueryDef Public...

I am not sure if I understand what that code will do.. however if I put that in my code string and run it.. I doesn't fail, but I still get a blank recordset. Yet if I run the query from the DB it will pull the correct recset.

It is ugly so I apologize up front. This is the code in the module that sets the parameters. Set myDB = CurrentDb Set qdef = myDB.QueryDefs("MTMLCPMASTER") 'MsgBox (qdef.Parameters(1).NAME) qdef.Parameters(0) =...

I am still having problems with this.. So I am using the following to get and set the parameters. qdef.Parameters(0) = Forms![MainForm].[MLCPGroupList] qdef.Parameters(1) = Forms![MainForm].[MLCPGroupType] qdef.Parameters(2) = Forms![MainForm].[MLCPSelectList] I verify that it is pulling the...

That is a great link and I should have done the web search on this myself.. Excellent post on how/why this issue is happening and possible resolutions. Thanks again!!

I looked at the links and could not find any code specific to setting the parameter within the VB module. They describe linking the form control to a query or to another form. That I can do within Access without VB and it works fine. Looks like I will need to try your code or re-write the...

Thanks for the link. I will look into having the sql in the module to call the table directly. Any idea how I could simply include the sql in the module and assign the parameter to the same query? Here is a sample of part of the sql that has the parameter in it. if that helps anyone...

The code in the query is a page long since it has a ton of logic to pull the list of records based on the input of the user. Within access I run a form that calls this query and it makes the connection to pull the parameters from the form without a problem, but VB will not make this same...

Hello Everyone.. I have a form (mainform) where a user selects criteria and then runs a module that will make certain updates. In the code of the module a query is called (masterlist) that includes the list necessary for the module. Since the query is getting some of the parameters from...