Search results

So, your choices are basically: 1) FTP a file to the mainframe to drive a batch process and/or receive a file FTPed from the mainframe to complete your process. 2) Transmit data via MQ Series and have a scheduled batch job run to pick off the data from MQ and write results back to MQ for you...

Is this just a matter of specifying DAO 3.6 instead of 3.0?

Please explain. How can an Access table be either? Isn't ADO or DAO just the means and properties used to access it?

I changed the code and checked DAO reference in tools/reference. Now I get "Run Time error 13 type mismatch" on the set command: Public Sub FixData1() Dim VistaDB As DAO.database Dim CrapData As DAO.Recordset Set VistaDB = CurrentDb

That could explain some of my current problems.

I'm not a great VB coder, but many of the things that worked in VBA 2000 don't work in 2007. I think most are related to changes in DAO and variable declaration.

Hummingbird provides FTP and 3270 terminal emulation access to the mainframe. What are you trying to connect to (MQ, CICS, batch, ISPF)?

Thank you, thank you! :) I never would have found that myself.

I'm trying to run some code from an older version of Access and I get an error that says "User type is undefined" on my "Dim VistaDB As Database" statement. It was not a user type before and I don't know what to use instead. Here's the whole little routine that's just meant to clean up some data...

I don't have a lot of experience either, but I don't think it's practical to ask anybody to enter that much information. They could find what they are looking for faster by scanning the table, manually. You need to quantify your search with some pulldown lists to select from. For updates...

So, you are appending one record to an existing table? Maybe your append query isn't specific enough and is picking up some extra records?

I do it in Excel and copy and paste it into Access when I'm done. But, I don't know much about using Access charting.

I'm pretty new to this, so I do things as simple as possible. I think the Access charting facility is really hard to use. So, I'd create a query of the elements you want to chart, export it to Excel and use the Excel chart functions to build your chart. When it's done, copy and paste it back to...

I'm new here and don't know crap, but I assume each of your products are comprised of multiple rows in a table; otherwise, it would be a simple comparison of the columns between two rows, using VBA. So, if that's the case, I'd do a make table query to select all product 1 rows; a make table...