Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...How to link with an Access DB
Hi, I have an Acces DB with many tables.
I need to choose the name of a customer in a cell of Excel.
For example, in acces I have this tables:
I need to choose the last name from a drop down menu in a spreadsheet and
then in other cell I need to put all the data regarding the last name that
I hope to be exaustive, and sorry for my english. :-)
...[Access 2007] How to edit custom menubar created in Access2003?
This is my first post to this server, Hello everyone.
We're working on a database created by my collegue in MS Access 2003. Since
some time we've moved to MS Access 2007. Now we find problems editing the
menubar. Each time we want to remove/add/alter a menu item my collegue goes
to his MS Access 2003 and changes a menu.
In 2007 the full menubar is visible under Add-Ins ribbon menu.
Normally there should be a system table USysRibbon, but it is not there.
There are only MSys* objects. How can we change the menubar directly in MS
Access 2007? Is that possible at al...Worksheet Auto update
I need to find a way to automate a process.
Is there a way to automatically replace the content of a worksheet with the
content of another one?
Every morning I get a sales report in excel for the previous day sales. I
save it in a folder and then I do a pivot table on this sheet to determine
sales by product category for example.
The following day, I open the previous day file, replace the sales report
with the new one and then refresh my pivot table.
Is there a way to have my sales report update anytime I get a new sales
To be more clear
I have a workbook with two tabs: Pivot...Access 2003 resets form variables during debugging while the form is open
I am using MS Access 2003. (FWIW, this is about an ADP project, not
A form has a variable that is initialized (by some function call) in
Form_Load() and then stays unchanged for the form's entire lifetime.
(In a language more advanced than VBA, it would be a constant, not a
variable; unfortunately, in VBA I cannot initialize a constant by non-
constant expression). Specifically, in my case it looks like this:
Private sTempFileName as String
Private Sub Form_Load()
sTempFileName = GenerateTempFileName(...)
Priv...converting text to a formula
is it possible to convert a text string to a formula?
I have built a series of cells using CONCATENATE to produce a text
string for a vlookup formula - is there a way to now use this text as a
working VLOOKUP formula?
West's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16123
View this thread: http://www.excelforum.com/showthread.php?threadid=277050
> is it possible to convert a text string to a formula?
> I have built a series of cells u...if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...formatting auto replies
Does anyone know of a method that allows outlook 2k2 to format automatic
replies regardless of the format of the original message? I setup this
automatic response rule that replies with a template, but problem is, when
replying to http clients (hotmail or yahoo), the message at the receiver's
end has words totally misplaced, all over the page. Any suggestions would be
...users with restricted access
We have some users that we have directed to only get their information
from a report that has been set up. Because of that, I set up a
parameter query to make the information more easy to see.
The parameter query prompts for last name or broker #, is there a
way, when the last name is entered to include Jr's & Sr's? Or should
this be another field in the table to make the last name field more
...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...Access 97/2000/2003 comparisons
I have a rather large application that uses an access 97 database (DAO). We
also have a version that works with access 2000, Oracle, msde, and SQLServer
(ADO). We would like to retire the DAO version of the product, but there are
places where the ADO version is much slower compared to where we run DAO
seeks (very noticeable when looping). So, I have a few questions.
1. Are there any tips/tricks to speed up ADO queries to compare with DAO
2. Would there be any benifit in using access 2003 over previous versions of
the software besides the added features (xml support, etc).
3...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...pulling certain characters from a string of text
I need to look up "certain critera" within a string of characters, then
return that "certain criterea" to a new column.
Some examples of a strings of characters may look like these:
My "Certain Critera" I have listed on another sheet, named "REP ID"
How do I pull out the 3 characters of "Certain Criterea" from the string of
text and copy or enter it into a new column?
> I need to look up "c...auto reply to incoming messages
SOS. I am having trouble with my Outlook 2002. I am trying to set up an "out of office assitant". It says i need to have Microsoft Exchange for this to work. So i went back to my Office XP disk and tried adding it in seperately and then i tried reinstalling Office XP, and still nothing. Anyone have any suggestions, thanks!
"Paul" <email@example.com> wrote in message
> SOS. I am having trouble with my Outlook 2002. I am trying to set up an
"out of office assitant". It says i need ...no access to send internet email
Exchange 2003. Can a mail enabled user be restricted to send internal email
only and not internet email?
> Exchange 2003. Can a mail enabled user be restricted to send internal
> only and not internet email?
yes, that is possible.
There are multiple ways to archive this goal. Depents on your
If you have mailing to external over an SMTP Connector, try this:
First look into your SMTP Connector, you will find Delivery Restrictions
It is self explaining.
If you have trouble with that or you won't find it,
then i will need additi...can I snap wrap points to a text box
rather than having to add individual wrap points to the edge of a frame,
which is never as accurate anyway, can they be set to 'snap' to a frame (eg
the ellipse) so that they are perfectly inline, (and which would of course be
a lot quicker)?
Edit points will not snap. There are options for edit points, select a point,
right click. If you hold down control, the cursor will turn into an x, you can
delete a point with a click.
Truly a good draw program would be preferable.
Mary Sauer MSFT MVP
&q...Excel. I am having a problem with hidden text
As I type text in some cells, it does not always dispaly if it exceeds the
cell length. I wish to keep the cell lenghts for the entire document, but do
wish for teh text in that particular row to be displayed.
How about if you select that cell, then
format|cells|alignment tab|check wrap text
And with that row selected
> As I type text in some cells, it does not always dispaly if it exceeds the
> cell length. I wish to keep the cell lenghts for the entire document, but do
> wish for teh text in that particular row to be displayed.
Da...Publisher can not save file
I recently started having troubles with my Publisher 2003. Whenever I go to
save my files now, using save as or just the save button, it gives me a
dialog box that says "Can not save file." It does that twice, then it
disappears. I also noticed that when it does this, it leaves the .tmp files
in the directory where I tried to save. I can change the name of the files,
and sometimes it will save it. Most of the time not though. I have NAV, and I
noticed that it was said there was an issue with Publisher and NAV. Is this
the same with the 2005 version, and is this anything anyone...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...default text height comment
Is there a way to set the default text height for a new comment?
(I've looked through help but can't find it if it's in there.)
I assume you mean the font size? There is no text height available in Excel.
A comment has a shape property and that is what you can use to change the font size.
They didn't make it easy ...
Range("D4").Comment.Shape.TextFrame.Characters.Font.Size = 12
Portland, Oregon USA
(free and commercial excel programs)
wrote in message...Change the text of a shape rather than its master
I build custom masters by mixing two general shapes, say square and
circle together, and have text on both the shapes.
But after I drop an instance of the master into a page, I cannot
modify the text of the instance. To do so, I need to modify the text
on the master, which is non-sense for me.
How to change the text of a shape without modifying its master?
How are you doing this? By code or by the UI?
Are you grouping the shapes? If you drag two shapes to the stencil, it will
group the shapes. So instead of a square and a circle you have three shapes.
A Square, Circle and the...Why will my publisher 2003 not print graphics?
I have recently loaded windows 7, and since then I cannot print any graphics
from any publisher document, text and infills print but lines do not! I have
looked at the advance printer settings and the "Do not print any graphics"
box is not ticked.
I have also tried reloading publisher but this did nothing. Any ideas anyone?
Might take a look at the web site of your printer model to see if there are
Windows 7 drivers. Will the document print okay if you convert it to PDF?
There are free converters around. www.primopdf.com is free.
It is always wise to completely remove ...Removing spaces from text #4
I'm in excel and i have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space?
Use the TRIM() function.
"lj" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I'm in excel and i have a bunch of text data that has an extra space at
> the end of the text on the right hand side for each cell. Is there any
> easy way to remove this space?
I tried using that function but the results st...Using Publisher 200 with Publisher 2003
How do I covert PUB2000 documents to Pub2003 documents and vice versa?
Pub 2003 can open anything, no conversion necessary. Going backward is a bit
trickier. File - Save As and chance the file type to a Pub 2000 file.
Possible problems can arise if you've used a feature that was not available
in the 2000 version and your file size will grew immensely.
MVP Microsoft [Publisher]
"nasuco" <email@example.com> wrote in message
> How do I covert PUB2000 documents to Pub2003 do...Removing text from cells leaving numbers (help with function)
I need a function that will remove all text from a cell and just leav
numbers. Formatting cells to number does not work.
For example if I have:
(Sired] Tennessee 37013 (herein
I just want 37013 left.
Anybody know a function to resolve this
Message posted from http://www.ExcelForum.com
The following will strip the text from the active cell and place the number
in the adjcent cell one column to the left. If there are subsequent numbers
in the original string you will get erroneous results. Put the cursor on the
cell to be processed and run the macro.