Net Display does not remember left and top position settings
When I log out of POS the Net Display defaults from the assigned left and top
settings back to original settings so I have to adjust every time I open. How
do I get these settings to remain?
A couple of points:
1. The size of the Display holds to the settings I assigned.
2. I am trying to run both POS screen and Net Display on the same screen for
I read someone else here had that problem. Fixed by logging in as someone
with local admin priveleges, making the changes, then logging back on as the
user. Might be worth a try.
> When I log out of PO...Creating a form / card
Was hoping someone could help, been trying for ages. All I want to do
is remove all the excess cells and space from my work-sheet so that I
get a nice tidy form / card.
Thanks so much.
dhunter84's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33373
View this thread: http://www.excelforum.com/showthread.php?threadid=531997
Dan, you can't remove them but you can hide them, select the rows you want
to hide and format rows hide, do the same for the columns...Display map from contact on Outloo 2003?
Apparently the fuction "Display Map from Address" in my Outlook 2003 is
broken. Nothing happens.
I tried the suggestion on http://www.outlook-tips.net/howto/displaymap.htm
to make it work, but as it says at the end of the description, Outlook 2003
crashes when using Display Map with a link in the key MapScriptURL.
Is there any way to make this funktion work?
thanks for a pointer
so far we don't have a way to make other urls work with 2003. Does the
default map fail too?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coaut...Nested tabbed forms
My database is designed for entering data requests. There are fields to be
answered for every request taken and then, depending on the type of data,
certain other questions may be asked.
In order to save space, I created tabbed forms and nested other tabbed forms
in them via subforms. I did this so that some questions could be sort of
"hidden" from the main form and could be viewed only if a particular record
needed to ask those questions.
My problem is that using tabbed forms via subforms does not link the answers
to those questions to that particular record. How can I have...In excel and a pivot table
Hi there, I'm learning to use pivot tables. How can I stop the table listing
(blank) in certain cells?
I want to keep the data it relates to but would rather see that cell empty
In step 3 of the pivot table wizard, you can click the Options button, and in
this dialog there's a checkbox "For Empty Cells, show" and you can fill in
something (or leave blank)
> Hi there, I'm learning to use pivot tables. How can I stop the table listing
> (blank) in certain cells?
> I want to keep the da...Exporting all forms record either in a table or Excel 2007.( Any m
i have a form that contains 347 records.I want a macro that copy all the
field from each record and generate a table in access and save all the fields
in a row.
i.e Record 1 all fields should be saved in Table first row then record 2 in
second row an so on till All records saved.
Moreover Is there any alternative option that either all records fields
exported to excel file.
>i have a form that contains 347 records.I want a macro that copy all the
>field from each record and generate a table...SUM: Display automatic
when I highlight number fields, in the "lowerer" right of screen it shows a
COUNT of the rows i have selected...can I do the same for SUM? If I use
autosum it will store the result into a cell below my selection...want to
eliminate that step. In other words if I select 3 numeric cells...like to
see the sum of those values in the special area on the screen.???thx.
Place the cursor in the Status bar (where the count appears).
Right click and select SUM
Microsoft Excel MVP
"GaryW" <GaryW@discussions.microsoft.com> wrote in message
news:710A992C-F90E-4D...Access form in 2003 vs Access form in 2007
I created an Access form in 2003 that contains 3 command buttons (like a
switchboard). It works fine on my system but when I take it to a Vista
machine with Access 2007 nothing works. Any suggestions?
Thanks Beetle, worked like a charm. Not quite the correct instructions but
close enough that I could wing it the rest of the way.
I'll be careful how I fish the beetle next summer.
"AR trout fisherman" wrote:
> I created an Access form in 2003 that contains 3 command buttons (like a
> switchboard). It works fine on my system but when I take it to a Vis...Open my form at specific record
I had asked before about how to make a value of a combo box depend on
another, I received good information on what and how to do it, my
question now is how do open a form from the second combo box at the
What I have now is a form "find contact" which has two combo boxes
where I can choose a company and then a name from that company from my
command button I can run the query which find thew chosen entry but I
would like to open the "contacts" form at the specific entry.
I have searched and have seen a few suggestion but its difficult
finding the best soluti...after crash forms display #name?
I was working on my Db when all of a sudden it crashed. I saved a backup
and closed it down. I opened the back up and now on my main " Job
Information" form, almost all of my text boxes with equations display
"#Name?". Some of the text boxes reference other tables, some other forms,
and some the same form they are located on. I checked the data source an a
select few boxes and all the data, according to my table, is correct. Its
worth noting that the entire DB was working perfectly before this crash.
Now if i go into design mode for the form, delete any t...Outlook 2003: Message/Contact display name issue
I want my outgoing emails to only show the email addresses of the
Sometimes the outgoing message have only an email address in the To: Field,
other times email addresses show more like something like this 'FirstName
Is there a way to tell Outlook to always/only use the persons email
address...without having to go into every contacts display name field and
make a change there?
Thanks for some insight into this issue and possible solutions.
...How to have a listbox display currency
I have a form in my program that the user clicks on in special cases.
The form is asking the user to supply some additional information. As
a reference on the form, I planned to have a Listbox display some data
the user entered before. It works except...
The item displayed for the user to reference is currency. No matter
what I do, I cannot get the listbox on the 2nd form to display the
number (used only for reference for the convenience of the user - not
for any calculations) as currency.
For example. User enters $4,567 in an earlier form. This number is
stored in a cell and is display...display a picture in excel as an icon
I want to put a picture in a Excel cell and have it represented as an icon
until someone clicks on it.
What we have is an inventory list with pictures.
Nothing I've tried seems to work very well.
Maybe you could put both the thumbnail and larger picture on the worksheet.
Then assign them the same macro. If you use nice names, it might even work!
I named my pictures:
(big and Small)
Dim myPict As Picture
Dim OtherChar As String
Set myPict = ActiveSheet.Pictures(Application.Caller)
...PWA 2003 grids don't display after security updates
PWA 2003 grids don't display after installing Oct security patches for IE7
and XP and Vista. We re-installed the Project ActiveX controls and it didn't
help on XP. Re-installing on Vista machines did correct the problem but not
on XP. We are using Project 2003 SP3. We are unable to see any data under
Project Center or any of the pages that display a grid of any kind. I am able
to log directly onto the Project Server and us IE7 on the server to access
PWA just fine, however the server doesn't have any IE7 security updates. Any
help would be greatly appreciated.
We do...Get rid of stacking format in window displays.
Can you please display things straight across in a line, not stacked? It
makes them hard to read, also make windows open up bigger, save my last open
size and re-use when opening a window. Also, when display data is subform,
make the window resizable so I can drag open to see more data at once.
Sheri Salomone Please vote to fix this, thanks!
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, foll...Excel 2007 displayed dates
When I enter dates in the Uk english format (dd/mm/yyyyy) in Excel 2007, even
though they are formatted to display dd/mm/yyyy, they are dispayed in the US
english format (mm/dd/yyyy). The formula bar shows that the cell contains a
date in the UK format as entered. The language setting in Excel Options is UK.
I wrote a macro containing an InputBox requesting a date, having previously
defined the variable for this input as Date. The input is entered in the UK
format but when assigning the value of this variable to a cell, it is
displayed in US format. Not only is it displayed cont...Serialisation
A general query
Im serialising a person object with the following member variables
Private _forenames As String
Private _surname As String
Private _dob As Date
Private _marital_status As MaritalStatus
'Public Get and Set Properties here for each of the above
' I'll not detail them all to save space but Ill show attributes
<XmlElementAttribute(Elementname:="dob"...Display Pivot Table Chart in Powerpoint
Is there a way to display excel's Pivot table chart in within
Powerpoint? This would mean that I can tweak the fields even from
within Powerpoint, and the chart dynamically changes. Has anyone
achieved this before?
If you copy the pivot table and then within PowerPoint do Edit>Paste Special
and select 'Microsoft Office Excel Worksheet Object', you can then double
click on the table and change it as you would in Excel. Only problem is it
doesn't work once you've started the Slide Show - so don't know if this
Have a problem with one workbook. When the arrow keys are
used to navigate vertically to a cell outside of the
window area, the display does not scroll. The correct
cell is selected; it just remains off screen.
Horizontal navigation is OK, ie the display scrolls
horizontally to keep the cursor in the window.
I can't find any reference to this phenomenon in the help
or KB. Does anyone know how to fix it?
Have you checked to see if the window is frozen?
I use a similar method the force users to stay on the certain pag
until they have entered certain data.
--...data entry form #6
I have a template with drop down fields and other data validation. What I
need now is when this form is used, to write the selections and other
information inputed to a excel data list. How do I do this?
...form/mail merge in Excel w/out using Word
I have a simple data table in one worksheet and have a form template
in another worksheet - both in the same workbook. Since there is not
a mail merge function in Excel like there is in Word, I was wondering
if anyone had any workarounds to keep both the form and data in excel
and run the merge and print outs from Excel.
I'm using Excel 2007.
See JWalk's site.
Gord Dibben Microsoft Excel MVP
On Mon, 15 Aug 2011 11:23:50 -0700 (PDT), TiChNi <email@example.com>
>I have a simple data tab...compare 2 lists and common ones display on the 3rd column
Is there a way to compare data in 2 columns, and display the same ones
that occur in both lists to a 3rd column?
Use a macro:-
j = 1
For i = 1 To Application.WorksheetFunction.CountA(Columns(1))
If Application.WorksheetFunction.CountIf(Columns(2), Cells(i, 1)) >
Cells(j, 3) = Cells(i, 1)
j = j + 1
> Is there a way to compare data in 2 columns, and display the same ones
> that occur in both lists to a 3rd column?
>...fonts do not display in toolbar
Recently we had to reinstall publisher 2003. It worked fine in the original
The reinstall is not displaying fonts in the toolbar. We have tried changing
the video resolution as suggested on a previous discussion group and also
numerous suggestions from the program help menu. This did not fix the issue.
Word art and font schemes are working but the toolbar only shows times new
roman. Does anyone have any experience with this issue?
Do you mean you are missing the little window where you can select your
MVP Microsoft [Publisher]
How to...Displaying the HOME Tab ?
Using Excel 2007.
How do I get the opening sheet to always open up displaying what's on the
HOME tab, such as the Bold option, etc. ?
That is the default? What do you get?
Do you have any add-in? It might be taking you to the add-in tab...
> Using Excel 2007.
> How do I get the opening sheet to always open up displaying what's on the
> HOME tab, such as the Bold option, etc. ?
If you have create a custom Tab and you open the file by double clicking
the file in ...Mass deletion of records
I want to reset my CRM database (but keep the customizations). What's the
word on deleting records directly from SQL? I know it works, because I once
did it in a test environment, but what are the risks? Is the warranty
somewhat cancelled if we do that?
The answer I got from Microsoft Support Services was that any kind of
backend edits/chnages are not supported or recommened through Microsoft. If
it breaks, don't call them!
"Fred Bang" <FredBang@discussions.microsoft.com> wrote in message