Search and replace query
I need to be able to specify my search criteria including leading and/or
trailing spaces, and similarly with the replace text.
I could not get Excel to accept/handle spaces as part of the search mask.
How would I do this?
For example if I want to replace all uses of the word he in a database with
she how would I specify space he space for the search, and space she space
for the replace?
Works for me.
Gord Dibben Excel MVP
On Sun, 19 Sep 2004 16:31:09 +1200, "KiwiBrian&...Nothing shows up in Database objects in Database Wizard
Hello, I am having touble with Visio 2003 once again. Though the db wizard,
I created an excel spreadsheet (table) for data and am tryinig to link the
chart back to this original database so that when I change something in the
database it will change correspondingly. I am going back through the DB
wizard, and can only get as far as selecting a database object to connect to.
I have selected the original dada source, checked table, but nothing showes
up under the database objects. Am I or my computer missing something?
Have you defined a name for the region ...Access Database Conversion to Excel Database
I need to convert a downloaded database in Access format
to an Excel format I can use on my desktop.
Use Data>Import External Data in the menubar
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"greg" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I need to convert a downloaded database in Access format
> to an Excel format I can use on my desktop.
...Can't open data file OR restore backup file on 2003
After reinstalling XP, and then Money, I cannot get Money to open my data
file. I have gone through the standard process repeatedly but my data never
I tried the the method described in "Run the Standard File Repair utility",
downloading http://support.microsoft.com/kb/902466 and running it, but it
gives me an error message about a missing DLL file and wont' run.
Describe "cannot get Money to open" -- how are you doing this? What's
happening? Error messages? How did you reinstall Money after reinstalling
Good afternoon, i have to make a huge database wich have to get data from
excel file.That is not a big problem problem is that i have to get
information for about 1000 families with 1000 elements for every family and
this database have to storage this information at leaset one year. This make
a huge pack of elements. Can Microsoft Access get so huge pack of data ? If
yes i would be glad to read some ideas.
If you are talking about 1000 columns in a table, Access can't do it. 255 is
the upper limit.
1,000 * 1,000 is potentially a million records. However if the data is
pr...reducing a pdf file's "view"
I have several pdf files of event programs that will be compiled to a book.
Problem is at their current size, they overshoot the margins for
printing/binding. How can I manipulate the pdf file to "shrink" the image so
that the programs fit on the page w/out interfering with the binding? Am I
You need to ask this in an Adobe Acrobat newsgroup. Have you looked at the help
subjects that cover this?
You could convert the PDF file to a Publisher file and manipulate the size.
Converting PDF Files
So that they can be imported into Publisher
http://ed.mvps.org/Static.a...Viewing the GAL
I have managed to deploy my first Exchange 2003 server selecting the join an
existing 5.5 environment. All appears to be working fine apart from the GAL.
When I open Outlook 2003 and check the GAL, I can only view users in Active
Directory and nothing from the old 5.5 environment.
I thought when I join an existing environment I would be able to see the GAL
as well. Are there any configurations I am missing?
Also, if I was to send an email to an internet address from the Exchange
2003 environment and I have the IMS installed in the 5.5 environment, would
messages flow or d...sum combo box based on other combo box
Hi can anyone help
i have two combo box which are Customer Number and Period Posting Date
coming from the same table,
what i'm after is after combo box which will give me all value for each
Customer in a specific posting Date month
if some select Customer Number 0001 in combo box 1
and then select 2009/07 in Combo box 2
i want combo 3 or a text box to sum the values in thee amount column and
display the total in combo 3 or they text box
thanks in advance
If you don't have to store the total (and you shouldn't store calculated
results), a s...linking 2 databases in 1
I am running 2 hqs for 2 different purposes, now the company decided to use
1 hq for both purpose.
How can i link the 2 databases into 1 database????
I tired to link them from SQL server enterprise manager-all task- export
data from database A to B but some tables can not be exported and show me
is it possible to link them or im just trying something impossible?
Advice me on that plZzzzZZzz
...Newbie Update Query Question?
I have an equipment inventory in Access.
I have a separate lookup table in an Excel spreadsheet that looks up
barcode numbers and creates a daily list of equipment on a site.
Can I use an Update Query to change the "Location" field in the main
inventory list in the database?
If so, do the records from the spreadsheet have be identical field-for-
field as the main database inventory?
Barcode Number, Item Type, Make, Model, Description, Serial, Purchase
Barcode Number, Description, Location
The Excel list mi...TRIM FUNCTION in QUERY
What do I put to trim off the spaces after a value in query? The table is
obtained from ODBC link and the values on a field somehow got spaces. Example:
My field in the query is:
WC: TRIM(PO_WORKCENTER_ID) ????
That should work.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> What do I put to trim off the spaces after a value in query? The table is
> obtained from ODBC link and the values on a field somehow got spaces. Example:
> My...Importing Current Database into CRM Database
I would just like to know if it is possible to tranfer my current database
into the Adventure Works Database(and if so how) or is it used just for a
few records for testing purposes.
You help will be highly appreciated...
there is a redeployment tool on support.microsoft.com/downloads under
microsoft crm. This may help you.
Microsoft CRM MVP
"Rock619" <email@example.com> wrote in message
> I would just like to know if it is pos...how to start a database
hi guys, i want to start a database on excel 2000, i never had to do
this before, and i know this can be done.
i just dont know where to start from !
what i want to do is, it is a racing club, i want a listing of all
pilot and a sheet where we can enter the number of the car(all pilot
info need will be transfer) for final result of the race.(right now
they enter the car no, name , city at every race at every registration,
if he is register to 3 race they do the process 3 time.)
like in access went we create the database and after the query, that
what i want to do in excel.
any tip or link...Show child attribute on parent view
I would like to show, in a view of the parent data from the child.
I have a custom entity - TRAINING that has attribute (by creating
relationship and lookup) of a SEMINAR - another custom entity.
Want to add to "TRAINING" line in the view, the name of the associated
"SEMINAR" (done, simple) and "Number of day" takes from that "SEMINAR"
...Use query from another database
In the code below is there a way that qryOrderHistory could be in a
separate database. If so how would i refer to it in the code.
Dim db As DAO.Database
Dim qd As DAO.Querydef
Dim rs As DAO.Recordset
Set db = CurrentDb
Set qd = db.QueryDefs("qryOrderHistory")
qd.Parameters("prmCustNo") = lngCustNo
Set rs = qd.OpenRecordset()
If Not rs.Eof Then
.... code to populate an excel spreadsheet
Change your 'Set db = CurrentDb' line to something like the following ..
Set db = DbEngine.OpenDatabase("full path and name of target MDB here")
...Database Queries with database views, that base on many database t
I created 2 database views. Each of them uses 256 database tables.
From every database table only one column is used in the select list of the
view. Every database table has one column which is used for the join.
Each database table has 5 rows. The database tables have not any foreign
keys and indexes.
Both views works fine. When I use the database views in a query like this:
SELECT v1.*, v2.* FROM v1, v2 WHERE v1.id=v2.id
I should get 5 rows with 512 columns in the resultset.
But I get the following error from the SQL-Server (after about 5 minutes):
Msg 8621, Level 17, State 2...Impact of changing database column width?
We are a software product company and are planning to begin using the
Contract Administration module. To do so, we will be switching our inventory
items from Track: None to Track: Serial Numbers and we will be storing our
software license keys in the Serial Number field which is column SERLTNUM in
Unfortunately, SERLTNUM is CHAR(21) and our license keys are a few
characters wider than 21. We can get the keys down to 21 characters by
removing three embedded hyphens, but there are several databases outside of
GP where the license keys must still exist with...app with many view area windows
Is there some good sample that I can write a window app like Visual Studio
which have many area view windows docking in the left and right and bottom ?
Thank for your teaching .
You would need splitters and docking windows.
Have a look at this link for a sample:
If you are creating a new application and you are relatively new to MFC then
I'd suggest you use VC2008/MFC/FeaturePack. You can simply use the wizard
to create a Visual Studio - like project. There is also a VS sample
included with the pack.
Bog...Program stops (creating pivot table) when too many records
I have a macro which creates a Pivot Table using the records I provide and
it works fine up to probably 40,000 records.
When the database becomes too big, the program stops at the line of code
which creates the Pivot Table with an error message.
1) Pressing F5 simply gives the same error message.
2) Running the same macro from start with a reduced records works well again.
How can I overcome this problem?
Thanks in advance.
On Mar 5, 7:57=A0am, ch <c...@discussions.microsoft.com> wrote:
> Hi all,
> I have a macro which creates a Pivot Table u...Set Database in Excel
In Microsoft article 183446 under method 2, it refers to using "Set Database"
on the Data menu. I am using Excel 2002 (the article says it applies to
Excel 2002), but Set Database does not appear in my Data menu. Is this an
It's an error due, I think, to very old menu structures. The article says
that the information applies to everything from version 5.0 (1995) through
2003, inclusive. But I believe that the Set Database menu item disappeared
from the Data menu as of Excel 97. And one has long defined a name using the
Insert menu, not the Formula menu. But my rapidl...Daily Importing of External Data using Web Query
Every month I create a spreadsheet from a template by creating one ta
for each day of the month named after day of the month/year (010104).
then maually enter a Web Query on each tab which downloads dail
weather information for an insect life cycle model.
This is a very time consuming and tedious task because the onl
difference in the links is the expression "20040101" (for January 01
2004) to "20040102" (for January 02,2004) INCLUDED IN THE LINK.
Is it possible to use a macro (VBA code) to enter the Web Query addres
in cell A1 on each tab when the workbook is created an...Outlook 2007 Can't Close
My Domain Users cannot close Outlook 2007 with their domain profile. But
they can open/close other Office 2007 application. Anyone know a fix to
what happens when they try?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchang...Great Plains Invoice History view?
Has anyone built a view in MSCRM that will show Great Plains Invoice
history? I would be willing to purchase one.
...can't uninstall Office-and some other programs
I can't uninstall Office Home & Student 2007:( I get this setup error saying
"The language if this installation package is not supported by your system"
and some other program uninstalls are getting this error that says
windows installer could not be accessed. "This can occur if you are running
windows in safe mode, or if the windows installer is not correctly
installed". And Im not in safe mode...please help I lost my XP cd and cant
use th ereair install. How else can I remedy this situation?
Thank you in advance for your help.
Gre...upgraded from MSSQL 2000 to MSSQL 2005 now database's users have
I updated the MSSQL 2000 server to MSSQL 2005 server now the database's
users have no
login names. I found a way to list orphaned users sp_change_users_login
'Report' but it only listed dbo and there are actually five listed with
MSSQL Server Management Studio Express. I tried this sp_change_users_login
'update_one', 'RPS', 'RPS' but I get the following error the user name 'RPS'
is absent or invalid.
Try with Auto_Fix instead; see the example at the end of the following