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...Lookup #9
I would like to use lookup function.
Usually the Vlookup would lookup the first instance the lookup value
comes across. eg data set.
Name Container Type
--------- -------------- ---------
John A 34
John B 45
John C 44
Peter A 67
Peter B 77
Now if I do a look up for John and Peter, the unique value would be
always 34 and 67
Now suppose I have another sheet where the type is requried as a
function then it would always use 34 and 67...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...Taskbar Icons TOO small
I'm trying (in vain, so far) to adjust the size of the icons in the taskbar
as they are just TOO small--using some of the other posts as guidance , i
went to properties on taskbar & CLEARED "show small icons in start menu"--but
that hasn't helped. Anything else i can do to get these taskbar icons to
> I'm trying (in vain, so far) to adjust the size of the icons in the
> taskbar as they are just TOO small--using some of the other posts as
> guidance , i went to properties on taskbar & CLEARED "show sma...Microsoft Icons for Web Use
I have several Office documents I'm linking to on my web site and I'm
looking for where I can download the icons for the Office
applications. Anyone? Specifically, I need an icon for MS Word and
MS Excel. It was much easier to find the Acrobat icon for use. :(
If you have Office you already have access to the icons. Select one of the
applications in the MS Office folder then Command+I for Get Info. Click the
icon in the Get Info window & Command+C to copy it, Paste to wherever.
NOTE: As an FYI, as with all corporate logos & trademarks there are
copyright restrictio...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...a document has gone in compatibility mode how do I get it back
I lost a couple of documents that I had saved and was changing the saved
title and as I have said the document has gone into compatibility and I cant
get it back.
I have a spreadsheet with 79,000 cells of information in rows and
columns. On a separate worksheet I have 5,000 cells of information.
I would like any information in the first sheet that is in the second
sheet to turn to red.
Sheet1, column A
Sheet2, column A
I would like the two strings in sheet one which appear in sheet 2 to
turn red, leaving the middle string black.
Is there a way to do a lookup to compare the cell value to a range
using conditional formatting?
Thanks for any help.
-----...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...