Access 2.0 to Access 97 09-07-04
I have a vb 3.0 application that accesses data in an
Access 2.0 database. If I convert this database to Access
97 it no longer works saying unrecognizable database
format. Is there some way I can access Access 97 databases
from vb 3.0?
> Is there some way I can access Access 97 databases
> from vb 3.0?
You'll probably need to upgrade your VB compiler as well. VB 3.0 creates
16-bit applications, whereas Access 97 is 32-bit, so if your VB application
is accessing database application objects in addition to accessing data,
then you'll likely run into problems. Th...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...inbox repair #2
firstname.lastname@example.org <email@example.com> wrote:
And the question is???
...Excel 97 crashes #2
I'm working with Windows XP and Excel 97. When I enter the menu command
"tools -> options" Excel crashes immediately. I tried to solve this problem
with the following run-commands, but it fails:
Any ideas how to get this work?
"Tom" <firstname.lastname@example.org> wrote in message
> I'm working with Windows XP and Excel 97. When I enter the menu command
> "tools -> options" Excel crashes immediately.
See the follo...outlook 2000 #2
cuando hago dos click sobre un mensaje el outlook no
respode y se cuelga
...dates in excel #2
need help with the date function
this is the situation
i use excel daily to create a report. as this report is
printed out i just save changes made.
except at the weekend when i also make backups so that my
boss can send the report by email on monday mornings.
in the report we use the NOW function to display the date.
when we used to open the backups the date never used to
change ie if saturdays backup was opened on monday morning
it used to still display saturdays date.
now for some reason the date is automatically updating.
anybody know how to prevent this happening
You probabl...Passwords #2
I want users to have to put in a password when they open outlook. I have
selected the check box on the outlook settings to have it prompt for a
password. When it prompts for the password it wants to authenticate to the
exchange server and not with active directory. Am I forgetting something?
You can't authenticate to Exchange - Exchange doesn't have the capability to
do so. You may see the Exchange server listed, but rest assured, the
authentication is taking place with Active Directory.
"Tbaker" <Tbaker@discussions.microsoft.com&g...Timesheet Problem #2
I am trying to populate a timesheet with dates depending on the start date
in B2. If B2 is the 16th of the month of Sept, I don't want anything to show
up on the calendar for the 31th (blank in other words). Here is the formula
I am using, but not working. Help. TIA
With seed date in cell $B$2 and using rows down to
leave the 31st blank. But show all other dates no exceptions
for weekends and holidays.
EOMONTH is in ...Solver Add-in #2
I have an Excel File (around 4.5 megs) with 28 sheets. using the Solver
add-in on the NPV function subject to a few restricting criteria.
Max iterations 100 Max Change 0.01 under the Tools --> Calculation menu.
Now when I launch Excel for the first time, I can click Tools --> Solver and
see the conditions et al. but exiting from the Solver once and then later on
trying to reaccess it through the same Tools --> Solver the Solver dialog
does not come up. I have to quit excel and restart it again to view the
Solver dialog. What could be going wrong here? Any ideas/suggestions?
No ...refund check #2
I have multiple customers requesting that the Refund Checks module be able to
create Manual Payment batches in Payables Management. Right now Refund
Checks only creates Computer Check batches.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/B...Header & Footer #2
I often get files from other users who do not maintain the headers
Is it possible that we adjust the Header and/or Footer for on
worksheet and the Header and/or Footer is automaticcaly updated for al
other worksheets in the same file. It would save a lot of time, sinc
otherwise you have to go to all the worksheets and make the change
Thanks in advance.
PS: Using Excel 200
Message posted from http://www.ExcelForum.com
Group the sheets first(right click on a sheet tab and choose"Select all sheets")
Change the header in File Page Setup
Ungroup t...2 Formatting Questions
Can we, in the CRM forms, format dates to read into the “15 Aug 2005”
format? This is possible in reports, but by default, the forms use only
numbers for dates, but in any format.
Any ideas of how to track multiple currencies in the same application -
specifically USD and Canadian? I know a Microsoft CRM installation currently
supports one language. But aside from using a picklist to specify "USD",
"CAN", "MEX", or other I'm concerned about how their forecasting.
www.visalign.c...Outlook 2007 adding contacts issue #2
I apologize in advance if this has been answered, but I couldn't find it anywhere...
today I added contacts to outlook 2007...never had used it before on Vista ever...and closed out went to lunch...
came back, I cannot add any new contacts. All options to add a greyed out...
If I select file new.....adding contacts is there but greyed out...
any ideas on what to change?
Go to your contacts page and type CTRL + N. The new contact page will open.
Or on your contacts page, click New on the button that appears just below
the File menu item.
Or on your contacts pa...Outlook blocked access to the following potentially unsafe attachments #2
We have just upgraded to Office 2003 and a lot of
attachments do not get sent. We receive this error
message instead. This particular attachment is a url.
You may find this page useful: http://www.slipstick.com/outlook/esecup.htm
Ben M. Schorr, Outlook-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"jackie" <email@example.com> wrote in message
news:018e01c3aae6$81a637e0$a40128...Outlook Client on CRM 1.2 Server Box for Demos
Did a CRM 1.2 install on Windows 2003 Server and all is working well.
I have been seeing things on this newsgroup that say I should be able to
install the Outlook client as well on this machine although it is an
This is for demo's only. I am running it under Virtual PC. I would like
to not have to have 2 Virtual PC images running just to show the Outlook
integration to CRM.
When I try to install the Outlook client I get a message at the start saying
that the Outlook client is already installed. It is not.
...Quarter-End Payroll Reports #2
When trying to process quarter end payroll reports I am receiving and
unhandle script exception: [Microsoft][ODBC SQL Server Driver][SQL Server]
Could not find stored procedure 'SCSB.dbo.uprGetPension'.
...PST PAssword Recovery #2
Dear All ,
How can i recover my PST file password in Outlook 2003.
If any 3rd party tool is available please send me the link.
have a look on this sites:
Maybe it helps.
Share Outlook without Exchange: Public ShareFolder
Synchronisation for Notebooks: Public SyncTool
"Brinesh Kishore" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:uNOCy5odHHA.5044@TK2MSFTNGP05.p...Excel: how to merge data from 2 workbooks with 1 col. in common?
I've got two separate workbooks. Each workbook contains unique columns except
for one, which is a "key" column, or an id field.
Example: I have a client # column in both workbooks. In the first workbook,
I also have first name and last name columns. In the second column, I have
phone number and address columns. How do I merge the two workbooks into one
so that for each client # I have their first name, last name, phone number,
Well, I think I'd start by getting all the data into one workbook. With both
workbooks open, select the worksheet with the phone n...Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook?
Wow! I tried this out, and it seems to work beautifully. It's odd, though,
that I haven't seen this technique mentioned in any of the several Excel
references that I've looked at.
Basically, I have a workbook with several worksheets...one worksheet
contains a large list with all the records.
I wanted to set up the other worksheets to have certain functions...I wanted
them to use only certain columns from the main list, and to contain only
certain records from the main list that met specified conditions.
This is the best solution I have found so far - i.e., creating database
q...Charting Problem #2
I have a problem with charting a Dynamic chart.
I goes ok to set up the dynamic function as a range. It also shows the
correct series. The range is as follows:
Where P2 is an input from a listbox, and the name of the range is:
When I try to change the reference for the series i get the following message:
"Your formula contains an invalid external reference to a worksheet. Verify
the path, workbook, and range name or cell reference are correct, and try
The serie...Data List #2
In relation to an earlier question, I am looking for a way of creatin
box which displays the contents of a list, which when clicked on can b
copied to a current cell, but other items added to this list.
For example, in one spreadsheet a list of;
In another spreadsheet, a view of this, so that the values can easil
be copied over, but also the abaility to add another name.
| John |
| Paul |
| Peter |
Message posted from http://www.ExcelForum.com
Lookup data validation.
It is very straigh...Multiple Users for office #2
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi, if I have office:2008 installed on my imac and I set up a new user (one of may staff has left and the new person is using the same machine) how do I get office to appear in the list of applications? I am hoping i dont have to reinstall given it is the same licence being used, just by a new person.
All help much appreciated
> Hi, if I have office:2008 installed on my imac and I set up a new user (one of may staff has left and the new person is using the same machine) how do I get office to appear in the...File Association #2
I opened a file in .xls and accidently checked the "always use selected
program". Now I realize .xls is the worng program to use. I tried to right
click to "Open With" but I only have the "open" option.
Depending on your operating system, holding the Shift key while
right-clicking should give you the Open With option.
"need helpful advice" <email@example.com> wrote in
message news:23E5BCBE-41BF-44D3-9045-038194A55AA7@microsoft.com....Ballmer says Microsoft can survive crisis #2
While the technology industry is not immune to the troubles facing the
U.S economy, it is positioned to weather a
downturn, Microsoft CEO Steve Ballmer said in a talk last week in
"As I travel and talk to people in the industry, I would say given the
current circumstances, people still see a certain
buoyancy in the market," he said.
Ballmer said the industry is global, shielding it in part from the
crisis in the United States. In addition, he said, the
consumer side of the market has been less hard hit than the business
Ballmer spoke at the Churchill Club'...Month Formula #2
Is there a formula that would read the previous cell and insert the following
month? Ex. Prev Cell is "June" the next cell would read "July"?
That really depends if what you have in the cell is a date or text. When
you select a cell in question, what does it say in the Formula Bar? Is it
"June"? Or is a number/date *formatted* to show June (mmmm)?
If it's a date, check out the EOMONTH function from the Analysis Toolpak.
Zack Barresse, aka firefytr
"Todd Nelson" <ToddNelson@discussions.microsoft.com> wrote...