fast search in file
quick questions, what would be the best choice for
fastest caching method (to the file)? I need fast inserting and retrieving
data (searching) from that file.
You may want to investigate a database format like .mdb or other ISAM
methods. If you are just searching through text you may want to use
CStdioFile to search line by line through the file.
"alladyn" <email@example.com> wrote in message
> quick questions, what would be the best choice for
> fastest caching method (to the file)? I need fas...BOM Import using Table Import in GP
It is my undersanding that the BOM information only exists in 3 tables, BOM
HEADER, BOM LINE and TARD1001 for reference designators. Can I use the Tablle
import to add new BOMs to the system? Does the table import wipe out the
whole table? Would I have to extract the data first, append the new bom data
and re-import? Or will it append new records?( I understand the risk of no
1. Yes, you can use the table import to add new BOMs (I used to do this
years ago when I was in support & consulting).
2. No, the table import does not...Can we Get Table Names from an access database while using MFC provided CRecordset class
Can we Get Table Names from an access database while using MFC provided
> Hey Friends
> Can we Get Table Names from an access database while using MFC provided
> CRecordset class.
Yes. The CATALOG sample in MSDN shows how.
Scott McPhillips [VC++ MVP]
You can use access the system tables directly, especially using a CRecordset
object connected to a Database object that is associated with the database
in question and this SQL statement:
SELECT Name FROM MSysObjects WHERE ( Flags=0) AND (Typ...VB to see if file is present and linked table question.
We presently have 3 databases that the user open's exclusively, then backs
them up. Then they also, have to disconnect linked tables, then do some
reports then relink them. They're doing this manually. I know it can be
done with a push of a button.
I'm creating another database just to run the backups and linked table
My questions are:
1. Doing a backup is nothing more then copying the file to the backup
folder, but I need to make sure it is not open by someone prior. I can look
to see if the .ldb is present. How would I accomplish this? And is ...Slow, fast, fast, slow
I hope I post correct here.
Got myself a new Dell M65 with an NVIDIA Quadro FX 350M on board. Switching
from a generic Intel Graphics GPU on another pc, I find Visio not performing
as expected. Other software (Adobe, OpenGL software) runs just fine. Any
ideas on what to tune to improve the redrawing speed of Visio. Dragging
objects is well, urmmm, a drag...
rarely has to do with the graphics card, usually not enough memory.
"Philip De Jonghe" <firstname.lastname@example.org> wrote in message
>I hope I post correct he...Can I share a table template I created in Quick Tables?
I have created a few table templates and saved them into the Quick Tables in
Word. I would like to make these available for other users of my document.
What can I do to make these ready available in their Quick Tables short of
saving them individually to each work station?
Can they import or save them when they open your document?
> I have created a few table templates and saved them into the Quick Tables in
> Word. I would like to make these available for other users of my document.
> What can I do to make these ready available in th...fast tiimer with MFC
For my purposes the Standards Windows Timer (eg. CWnd::SetTimer(1, 1, NULL))
is too slow - regardless of the time-out value I set, it is going to be at
least 55 milliseconds between WM_TIMER messages.
So I want to use the QueryPerformanceCounter() function to compare very
small time intervals. Now, if using win api32 I would know how (and where)
to place this code (in the message pump fragment), but I am using MFC. So
where can I place this code in a loop within the MFC framework? I'm just
using a simple dialog based app. In a method of the dialog class? Which One?
Or in the app...Trying to set up account, geting nowhere FAST!
From: "Lenora" <email@example.com>
Subject: Understanding what Microsoft Communities
Date: Friday, September 14, 2007 5:41 PM
Hello out there!
What is Microsoft Communities all about? Is it something that comes with no
charge when you get Microsoft Vista? This is the 4th computer I've had
(besides ones at work). First a Compaq that I loaded everything I could
from work, the computer guy gave me stuff...did work at home, brought it
back to work, and visa versa.
Second was a re-built computer that was given to me by a man in the town we
had moved to...out of the g...excel format for worksheet and table
can any one please guide me regarding the work-sheet format
and the number of tables it may contain?,
the XML tags and attributes for XLSX?
Microsoft MVP Excel
"MG" <firstname.lastname@example.org;adk;l> wrote in message
> can any one please guide me regarding the work-sheet format
> and the number of tables it may contain?,
> the XML tags and attributes for XLSX?
Tables are a fe...extracting data from a pivot table
I have a need to use data from a pivot table on other worksheets in my file.
The problem is that when a pivot table changes the data in the cells do not
update to my other parts of the spreadsheet accurately.
...returning the path of a linked table in VBA
Is there any way to capture the path of a linked table (say, tblContacts) in
Thanks in advance,
"Paul" <BegoneSpam@forever.com> wrote in message
> Is there any way to capture the path of a linked table (say, tblContacts)
> in VBA?
Parse it from the Connect property of the TableDef, e.g.:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than ...A table with two fields pointing to the same field in another table
I have a table called Test. This table includes two fields called
"Start_Date_Name" and "Finish_Date_Name". These fields hold the
primary Id of a row in another table called Date_Properties, which has
a field called "Date_Name". Typical values for Date_Name include "Test
1, 2006"; "Test 5, 2007".
I wish to have a query which produces a table like this -
Test Name Start_Date_Name Finish_Date_Name
Barry's Test Test 1, 2006 Test 1, 2007
Barry's 2nd Test Test 4, 2006 Test 1, 2007
Liam's Test Test 1, 2005 Test 4, 2008
The proble...Time Based Calculations
Try Chip's page at:
Please respond in thread
"jain_sanju" <email@example.com> wrote in message
Re: Time Based Calculations
> Sanjay Jain
That's not a whole lot to go on but if the times are entered as XL times
then mulitply the times by 24 to turn them into numbers that can be used in
calc...How to retrieve all data of a table(with only 3 rows and 3Columns) in only one row in a view?
i have a table table1 in sql server database with 3 columns and 3 Rows like
Column1 Column2 Column3
Data 11 Data 12 Data 13
Data 21 Data 22 Data 23
Data 31 Data31 Data 33
i would like to create a view view1 based on table1 which retrieve data like
Column1 Column2 Column3 Column1
Column2 Column3 Column1 Column2
Data 11 Data 12 Data 13 D...SetWarnings alternative that "Okays" error messages
I have some macros that are running quite a few exports of queries and
also some maketable queries. I'm wanting for them to run WITHOUT me
watching over them and clicking "Yes" to making a new table and the
like. It is also likely that I will get an error message such as "n
Records were not written due to conversion errors...". I am prepared
to drop these records and I really don't care about them as I know
that the data I am importing and querying is unreliable in several
Is there a way to turn off these error messages and just export the
whole thing witho...Shockwave flash object and 'interactive' state
I'm using MFC wrapper for shockwave flash object to play swf files. On rare
occasions I run into files that cause the flash to return 'interactive'
state (3) instead of 'complete' (4). I can't find any info on how to handle
such state or if it is even possible to play these files using the object.
Can anyone please let me know what that state means and how to handle it?
Any pointers to on-line docs will be appreciated.
...locking bar chart colors in pivot tables
I use pivot charts frequently, and change the data displayed frequently. I
would like to "lock" my stacked bar chart colors so that my largest data
segment in the legend always displays blue in my stacked bars, my second
largest data segment always displays red, etc.
As Debra Dalgleish points out, loss of formatting is a known problem with pivot
charts. There's information in the following MSKB article, suggests recording a
macro as you apply the formatting:
XL2000: Changing a PivotChart Removes Series Formatting
To apply colo...hiding rows based on cell contents
I would like to hide an entire row whenever the contents
of one cell in that row equals 0. Is there any way to do
Any column, a specific column, or range of columns.
You would need a macro and once you know how to use
macros you would generally post in excel.programming.
Getting Started with Macros -- install and invoke your macro
Actually you could use AutoFilter if only one column to select 0
Ctrl+A to select all cells (all columns)
Data, Filter, AutoFilter
Click on the drop down arrow on your column of interest
Ctrl+;...Creating a custom table...
A couple of issues regarding table creation. I want to insert a set of tables
in a document header, but so they appear in the middle (vertically) of the
page concerned. I want them in the header so the user cannot inadvertantly
modify the table contents directly without actively entering into the header:
1. I have a dialog where a user can specify the number of rows that must be
in a table. For example if they enter 4 then the table must be created and
inserted with 4 rows and 2 columns. There are always 2 columns - how do I
achieve the table creation and insertion at a specific...Merging cells accepts changes in table -- Word 2007
I have a 47-page table with some really funky formatting. I hope I can
describe it so you can picture what I'm describing.
The first four columns of the table have tall cells that serve as a "header
row" for the last six columns. Each of these header rows is tall enough that
it spans from five to forty rows in the the last six columns. The person who
built the table merged cells vertically in the first four columns in order to
create the effect.
In many cases, these header rows needed to span a page break, so the person
who built the table started a new row for ...inserting pictures into table
i am doing a yearbook, so i created a table, with hidden lines, and within
each cell i would like to insert a photo of a child, but they do not
automatically fit into the cell, i have over 300 students to do. what is an
easier way to insert the photo into the cell?
You certainly have your work cut out for you. Place the cursor in a cell, fill,
fill effects, picture tab. All of Publisher menus are tear-offs, you might want
to tear off the fill menu, saves a click or two.
Mary Sauer MSFT MVP
"bran...Scrolls too fast.
I have a document that scrolls down much further than it
should. What I mean is that the document is only 600
entries, but when the little scroll marker is at the very
bottom, it goes all the way down to 14495.
Normally scroll markers do not go down this far. For
example, another file that has 332 entries, goes to 340
when the scroll marker is at the bottom.
This makes the scroll bar virtually useless since every
tiny movement takes the spreadsheet several hundred
entries down instead of going down slower, like in sets of
I would really appreciate it if someone could help m...Creating a Table of Contents in Excel
I need to print a Workbook with a Table of Contents
Worksheet that AUTOMATICALLY lists the page numbers for
each individual Worksheet when the Workbook is printed.
I have a great example of this already in a workbook. I'll be glad to send
it to you, upon your request... Contact me at firstname.lastname@example.org.
"Scott" <email@example.com> wrote in message
> I need to print a Workbook with a Table of Contents
> Worksheet that AUTOMATICALLY lists the page numbers for
> ea...vlookup and Access Database Table
Can vlookup be used to get a result from an Access Database Table?
The vlookup function itself is an Excel function and as such can only
retrieve data from an excel sheet.
However you may be able to use the import external data menu option in the
Data menu to retrieve your data from the access database, pull it into your
excel workbook and then use the vlookup function. I never tried this myself,
but maybe the idea can be applied.
Jeroen van Nieuwkerk
> Can vlookup be used to get a result from an Access Database Table?
> Thanks....Table formatting lost
I receive emails that started off in Excel as a short table. The
sender then cuts and pastes into Outlook. When the message arrives it
has lost all formatting for the table. Is there any solution apart
from sennding as an Excel attachment?
Do the copy as a Picture and then paste in Outlook.
Gary''s Student - gsnu2007k
> I receive emails that started off in Excel as a short table. The
> sender then cuts and pastes into Outlook. When the message arrives it
> has lost all formatting for the table. Is there any solution apart
> from se...