HQ Global Customer #2
We have come across a problem where the last visit on the purchase history
tab in the global customers option at headquarters and also in store
operations manager local customers is not being updated.
Our customer is using version 1.2.180. I have also tested this on my system
using version 1.2.184.
Please can you investigate this. I will look forward to your response.
PS - I have not received a Microsoft response. Please can you look into this
and reply to this e-mail.
You will not receive a Microsoft response from this board.
You need to create ...Lists Box
I have a form with fields; ID, DATE and QUANTITY. The Date andQuantity Field I've changed into a List Box showing the two columnsrespectively and the ID field is left as a normal text box. When Iclick on any item in the list box the ID change change according towhich ever entry I have selected. Unfortunetly ID field staysconstant!!Any suggestionsThanks Hi, Asif,did you include the ID field in the ListBox?The easiest solution:1) Add the ID field to the RowSource.2) Point the BoundColumn to the ID field.3) Set the ID field column width to 0.HTHVlado"Asif" <firstname.lastname@example.org...In-Box
My in-box label in left rail shows 4 messages, however they do not download,
while at the same time other new messages download. Has Outlook forgotten
how to count?
You probably have a filter applied to your view so that some messages are
Verify that your view is set to the Messages view via the View-> Current
If that doesn't work either, use Customize Current View from the same menu
and use the Reset Current View button.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, H...Combo Box Result
I have two unbound combo boxes (c1 and c2) that based on the value of c1,
will determine what shows for c2. By selecting c1, it will correctly limit to
what c2 shows, but when I select the option for c2, it is not choosing the
correct value. The result set for c2 is based off a table, that has the
ISID ISD ITID
1 red 1
2 blue 1
3 green 1
4 red 2
5 blue 2
6 green 2
c1 will select the ITID, which then limits what I see in c2 to the correct
set (I even brought in the ISID column to make sure the numbers ...Message box with Combo box function
Is it possible to create a combo box within a message box i.e. whenthe user clicks on preview report a message box appears and says"which report do you want to open?" and a combo box displays thedifferent reports available with the user clicks, upon clicking therelevant report opensThanks * Asif wrote:> Is it possible to create a combo box within a message box i.e. when> the user clicks on preview report a message box appears and says> "which report do you want to open?" and a combo box displays the> different reports available with the user clicks, upon clickin...combo box query
I have a combo box that includes a drop down box when selected. Can this be
in any way altered so you can scroll down the box ? at the moment, i have to
select the box with my mouse, then browse through the contents using either
my up / down buttons or the little down arrows. It would be so much easier to
scroll up & down.
When i select the combobox, presently it scrolls excel and not the box.
And help appreciated.
...Edit Box Display Control
I have a dialog-based app, and I want to have a read-only edit box to
display changing output(when the user hits a button, the displayed
numbers change in the edit box). Can I change the background color of
the edit box, or should i just draw a rectangle and write text to it
to control the background?
Just change the readonly style of the editbox. Take a look at the
Check Abdoul [VC++ MVP]
"matt" <email@example.com> wrote in message
news:firstname.lastname@example.org...To chage the string of the Message Box
I was told the following query, and it works good. How can I change the
Notes By to be a Msg String : "Dicatat Oleh". I want it as a variable,
because i have already the table of String message, so that it can be in many
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes & [Note by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;
Thanks in advance for many helps.
Are you talking about a stored query that you...Macro Question #2
I have an excel spreadsheet with a load of columns with various bits of data
in them. Basically i am struggling to get the VB code together which will
find specific entries in a specific column and then remove the relevant row
in which that specific piece/pieces of data are held, UNLESS, a specific
entry is named in another cell.
For example, i want to find Monday, Tuesday and Wednesday in column A and
then remove the specific rows they pertain to, UNLESS column F has 'NOT'
written in it.......
Hope that makes sense.
Public Sub ProcessData()
Dim i ...Automatic update the number in a text box
I have text boxes in my charts. In that text box, I need to copy a number from another sheet each time I update charts. I am wondering if there is a way that I can update the number automatically.
Thanks in advance!
Is the number in the same cell every time? Here's how to create a new
text box that's linked to a cell (whenever I try linking an existing
text box, Excel just draws a new one on top of the old one).
Select the chart. Press the equals key. Navigate to the other sheet and
select the cell with the mouse. The formula bar reads like:
- ...how do I get the x-axis to plot values rather than categories in .
how do I get the x-axis to plot values rather than categories in Excel
By using an XY rather than a LINE chart
Bernard V Liengme
remove caps from email
"Boggins" <Boggins@discussions.microsoft.com> wrote in message
> how do I get the x-axis to plot values rather than categories in Excel
...can't change default file location #2
When I click "open file", Excel always open "C:\Program
Files\Common Files\Microsoft Shared\PROOF". I have
changed the "Tools-Options-General-Default file location"
to "My Documents" but still no effect. Please help.
Did you exit Excel before trying again?
>When I click "open file", Excel always open "C:\Program
>Files\Common Files\Microsoft Shared\PROOF". I have
>changed the "Tools-Options-General-Default file location"
>to "My Documents" but still no effect. ...Turn on Edit option in Combo Box
How do you turn on the Edit option in a Combo Box in Excel 2000? I have no problem entering the drop-down part, but cannot get it to allow editing. Please help.
What kind of combobox? Forms toolbar, Control Toolbox, or Data Validation.
What do you mean by editing? Do you want to edit an entry on the list, add a
new entry to the list, or just be able to type in a value that's not on the
MVP - Excel
Excel Blog - Daily Dose of Excel
"Pam at Greer" <Pam at Greer@discussions.microsoft.com> wrote in message
ne...Filtering Combo box items based on related table field- Please Help!
Hi im stuck on filtering a combo box. I have users who can be assigned
a category. Jobs can be assigned a category and also have a list of
people working on that job (in the JobDetails table). I have the
CategoryID (FK on Categories.CategoryID)
CategoryID (FK on Categories.CategoryID)
JobID (FK on Jobs.JobID)
UserID (FK on Users.UserID)
Then in the job details when listing users for a job (many users can
be for one job) i would like to only show the us...Comment Box or description box
Is there a way to assign the comment box to appear when a certain item is
sold, so therefore a description can be inputed.
you can use the Item Message (item definition - Special tab) to remind the
cashier to set the comment on those items when sold.
> Is there a way to assign the comment box to appear when a certain item is
> sold, so therefore a description can be inputed.
...Outlook Configuration #2
I want to know if their is a way to configure outlook using a script. What i
mean is that i need to change the configuration of 100 outlook to point to
another exchange server.
Thank you for the help
> I want to know if their is a way to configure outlook using a script. What
> mean is that i need to change the configuration of 100 outlook to point to
> another exchange server.
> Thank you for the help
Outlook Profiler is loved by all who use it.
...Help with Excel #2
Im new to Excel and need o do a work place shift roster. I need to put in the
shifts people work eg: E (early) L (lates) N for nights ... but i also need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need this so
at the end of each week i can sum the total hours each member of staff
does... can anybody tell me how please
change ranges to suit
"Jezzer" <Jezzer@discussions.microsoft.com> wrote in message
news:A4E5DB47-DD0B-4EFE-98CA-916925ABAC6A@microsoft...How do I add input data in the input ranges in drop down boxes.
I have a spreadsheet that was sent to me that has drop down boxes with data
that you can select and it is link to other drop down boxes. I would like to
add additional data in the drop down box range but cannot find where you add
additional data to select in the drop down boxes.
If the dropdown lists are created by Data Validation, you can select the
cell, and choose Data>Validation. In the Source box, you'll see the
range where the list is stored.
If that's not it, right-click on the dropdown list, and choose Format
On the Control tab, you'l...Excel.exe error message #2
I am getting this message when trying to open a shared Excel Spreadsheet. "Excel.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log has been created.
How do I resolve this problem?
File could be corrupt in which case you need to get someone with either XL2002
or 2003 to open it using Open and Repair, or if you are using 2000 or 97 then it
may be your toolbar customisation file is getting close to blowing up on you.
If so then go look for a file called *.xlb and either rename it to *.old or just
delete it. NOTE:- This is your toolb...Printing Labels #2
Is there a way to print labels off of a excel spreadsheet?
yes there is.
excel will print to any printer regardless of the media the data is printed
You may have to play with it to get it to fit your labels. you may even have
to trun the text 90 degrees(vertical). we have a special file that contain
certain special purpose label that our receiving department needs to print
periodily and they print on the same bar code printer as all the bar coded
labels print on.
"Todd Nelson" wrote:
> Is there a way to print labels off of a excel spreadsheet?
You m...Business Portal 2.5, user cannot get requisitions assigned to him?
UserA created three requisitions and sumit them to his supervisor, UserB.
In database table ReqMgmtDocument, I can find these three records and
OriginatingName is UserA and CurrentAssigned is UserB. In Business Portal,
UserB got in Employee -> Purchase Requests -> Filter by: Assigned to me,
and got "Query returned no result". Does anyone know how to solve this
problem? Thank you very much.
...The From box
Every time I create a new email the "from" box appears.
How do I turn this off.
Create a new message; View-> uncheck From Field
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office XP CD slipstreamed with Service Pack 3
"Mike" <email@example.com> wrote in message
> Every time I create a new email the "from" box appears.
> How do I turn this off.
...Debug Error #2
Could anyone throw any light on the following:-
I have a WIN XP home machine running Outlook 2000 for mail.
I have set up 2 profiles one for me and one for my wife.
When I first turn on the machine and go into oulook (either profile)
everything works fine.
Then I close Outlook and go back in on the 2nd profile and get the error box
"Microsoft Visual C++ Debug Library
abnormal program termination
(Press Retry to debug the appliacation)
Abort Retry Ignore"
No matter what you choose the appliacation closes and then...Formatting: display blank when "O", 2 decimal when a number is d
I want to display a blank whenever there is a "O" and I need to display 2
decimal when there is a number.
so far I found 0;-O;;@ this formula helps me display a blank cell when
needed, however it doesn't give me the 2 decimal I need.
assuming you mean zero and not the letter O, you can't format for letters
"ED" <ED@discussions.microsoft.com> wrote in message
>I want to display a blank whenever there is a "O" and I ne...font sizes for To, From, and Subject text boxes
How do you change the font sizes for these 3 textboxes
when composing an email? When you set the fonts under
Options->Mail Format, only the font in textarea for the
message body gets changed.
Correct. That's what that setting is for -- to change the message font. If
you want to change the font sizes of other elements, you'd have to design a
custom form. In some cases, changing the overall Windows font size might
also have an effect.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Dev...