Looping to create new workbooks using a set “transaction” number

I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

McNitro255 pointsBadges:

Excel to Access conversion

Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

KSoniat610 pointsBadges:

How to add exchange cluster server to an exisiting exchange server?

I have an existing exchange server 2003 working fine but to add redundancy I want to put new exchange server in cluster mode using the storage EMC CX300 (available). Please let me know how to proceed & what precautions to take & during this process how users will get effected or is that any way...

BaseerM60 pointsBadges:

T-SQL query to ACESS 2007 database

I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

DamMan5 pointsBadges:

jasper server with sql server

does jasper server allow you to use sql server as your database server..if yes can you guys help me out...im stuck with this for almost a week. thanks in advance...

Skillszone10 pointsBadges:

AS400 File to MS Access by SQL Passthrough Query

I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...

CompEng1,240 pointsBadges:

Forced Date Routine Processing

I’m trying to process a RUNDATE = 2009-08-07 into my COBOL code via a PARM-DATE Link. That date comes in… now I try to place it in the following piece of code: EXEC SQL SET :WS-PREV-WK = CHAR(DATE(TMP-DATE)- 7 DAYS) END-EXEC. What am I getting '0001-01-01' returned?

A30TPX5 pointsBadges:

Form vs. table record order

Why doesn't the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?

Mcoopers75 pointsBadges:

Meeting Invitation not updated in Calendar

I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for any...

Subbu2k990 pointsBadges:

Access – Bound sub form trying to set the value of an unbound field

I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

TJay85 pointsBadges:

In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.

In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.

UmaGandreddi80 pointsBadges:

EDM Pool Usage

I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time...so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.

Coolster015 pointsBadges:

Crystal 8 & SQL problem

I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

Virtualfrankdotcom20 pointsBadges:

What’s a good, simple reliable way to log errors for later investigation?

I'm doing new work in an old old system. It's built with a bit of everything you could use from System/34 onwards - except maybe WSU. Naturally, as I Put together new functions, I test return codes, record locks, database integrity as I go. Just spent a couple of hours finding out that a function...

Yorkshireman6,085 pointsBadges:

Estimate SQL Server tempdb space for a query

Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

BR5 pointsBadges:

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Standaman15 pointsBadges:

Install QMF V9

What are the conversion requirements for QMF objects going from V8 to V9 - queries, forms & procs and what about tables and views saved in QMF, do they need to be unloaded and re-loaded?

BhleftD10 pointsBadges:

tablespace

when does alter Tablespace trackmod yes become active

BLR5 pointsBadges:

Automatic transfer of AS400 output file to PC folder

Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this...

Radycal60 pointsBadges:

Oracle 9i migration

How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?

OracleandSQLServer5 pointsBadges: