editbox-multilanguage help pls
For a special reason (telling later) I didn't define _UNICODE in my code.
The result was that I can not type in arabic/persian in the edit box in
which I could before (showing strange characters instaed not ???).
Of course this isn't always true (On two computers running both winXP one
showed strange characters while the other treated normally)
1)What should I do so that my program acts normally on all computers?(& what
are the probable different settings on those computers)
2)What are these strange looking characters(single byte,multiple byte,....)
Going back to the reason whic...corrupted .pst file, inboxrepair doesnt help
Somehow my inbox .pst file (999MB) got corrupted (not sure
how, one day it worked the next it didnt). (I've got
latest updates, SP, as well as Anti Virus).
When i try to load it using OutlookXP on Win2K it loads
and loads (for about 30minutes) and then appears as
something like "this file has an error use Inbox Repair
Tool to fix".
So then i try Inbox Repair Tool and it went through the
file, makes a backup, and fixes the two errors (2 items
without a folder).
However when i then try to load the repaired .pst file it
still loads and loads and then tells me the...OSQL help
I am trying to create a batch file to automate a process for RMS. When I
type in the sql statement in RMS Administrator it runs fine. But when I
create a batch file I get an error message as follows:
Msg 208, Level 16, State 1, Server ******, Line 1
Invalis object name 'CUSTOMER'.
Here is the statement I am using (with the proper username and server name
OSQL -U sa -P -S -Q "UPDATE CUSTOMER SET CustomText4=left(newid(),6) WHERE
I then tried running several very simple osql statements from the command
prompt and kept g...Help with custom formatting of a cell
I am trying to set up a format rule so that I can change the display
of a number based upon its magnitude as follows:
if the number is greater than or equal to 0.1 -> display it as "0.10
else if the number is greater than or equal to 0.0001 -> display it as
else if the number is greater than or equal to 0.0000001 -> display it
as "0.10 uA"
else if the number is greater than or equal to 0.0000000001 -> display
it as "0.10 nA"
else if the number is greater than or equal to 0.0000000000001 ->
display it as "0.10 pA"
el...Please Help Running a Macro from a formula
Is there a way to cause a macro to run from a formula?
As an example:
GoToNeg and GoToPos are macros which will manipulate B1
Thanks in advance!
If they really are macros that alter things on a workbook, you can't do it.
If they are functions that return a value, then that is possible.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Vic" <firstname.lastname@example.org> wrote in message
news:email@example.com...help with macro code
I am trying to copy a range of cells to another
worksheet .... and then move to the next column
Please help with code - I'm getting a Runtime error 1004
' Macro2 Macro
' Macro recorded 08/10/2003 by SARAH RANSOME
' Keyboard Shortcut: Ctrl+f
When you do xltoright the over 1 (.offset(0,1)) are you sure you're still on the
worksheet--you didn't go all the way over to column IV did you?
Another possibility: Are y...Need Help!
Hi there .. I am new to this forum .. was needin some urgent help on
this excel file of mine which seems corrupted for some reason. I try
to open the file when i get the message "The file is not in a
recognizable format". I click on the OK dialog and I can see my
worksheet name , but i dont see any on the internal contents.
I am using MSOffice 2002.
These contents hold vital info. Is there some way I can open this file
with least damage to the contents ?? Someone around here face a
similar prob and get around it ? Please help !!!
Some people have reported that they have recovered ...Outlook 2007 & "The form you have selected cannot be displayed"
I recently upgraded a user's PST from the older 97-02 format to the
new format to avoid the 2GB limit. I created a new PST (in the new
format), made it the default send/receive location and then imported
the emails from the old PST. I did the same with his Archive PST file
as well. Upon restarting outlook, the user couldn't reply to emails
and got the infamous "The form you have selected cannot be displayed".
I promptly did all the know hacks to eliminate this message (edit
registry to not use forms cache), cleared the forms cache, ect. All to
no avail. So, I did a repair on...Need Help with Exchange 5.5 migration to exchange 2003
I need some help in moving exchange 5.5 to exchange 2003.
I will appreciate if someone can help me through this. I have good knowledge
about exchnage 5.5 but I am very new to Exchange 2003.
If someone can just guide me I will really appreciate it.
Please email me your info along with your phone number where I can reach you.
All I need is just a little help with just two questionand I am sure there
will be atleast one expert out there who will be able to help me. I have
tried everything ( Groups / MS KB)
but no luck.
Please email info to: firstname.lastname@example.org
Aloha ...Recycle Bin Help
When I delete anything its goes into the reclcle bin but when I go into it
to restore the file its not there. When I go to delete all in the bin it
says I have the files in there but I can't see them.
...Pivot Table Data Transfer
Please help me? Thank you for reading.
I have a working pivot table with over 50 entries. I need to take
certain parts of the data to new worksheets so clients can not make
changes. I need this marco to run each entry in the pivot table to
produce the transfer data and then copy and paste the information into
a new workbook for each entry in the pivot table with two forms(already
created) with the data in it. Can someone please help me?
Here is the code below:
For Each itm In
I am trying to create various many-to-many relationships to the
Contract entity. One example is linking Contracts and Contacts via an
intermediate custom entity called Contract Contact. A Contract can
have many Contract Contacts and a Contact can have many Contract
Contacts, so this should achieve the many-to-many relationship
However, when I create my new Contract Contact entity and create a
relationship to both Contract and Contact entities I encounter some
Firstly, I cannot create a new Contract Contact from a Contract, I
don't get the new button, but I can fr...Date formatting on a Pivot Chart's Data Table
I have a Pivot Chart that has a text field for series, a date field for
category and a number field for data items.
In the charting options, I've hidden the legend and shown the data
When the data table appears in the chart, it shows the dates in the
I'd like it to show in the format:
I can't find any options inside the Pivot Chart context menus or
toolbar for applying date formatting on the Data Table.
I've tried formatting cells in the Pivot Table and it applies them
there, but still shows in the format listed ...Displaying items within pivot table fields
Within a macro I've written I have the following syntax (which is not
working); at the time that the macro reaches this line of code only
the "ACCDNT" item in the "complaints_code" field within the
"ComplaintsTable" pivot table is being displayed:
.PivotItems("ACCDNT").Visible = False
.PivotItems("ADVERSE").Visible = True
Basically all I want to do is have the macro display the "ADVERSE"
item instead of ...Help With formulating a cell
Hey everyone. I have a really dumb question but I am just not good at this Excel thing. Haha. I am trying to create a spreadsheet that will allow me to have a column of sequential numbers next to a column of names which in turn is next to column of dollar amounts. The dollar amounts can be changed just by, uh... , changing them, but the number and name in the columns next to them must saty the same. Okay, so far? Okay-here's my problem: How do I create a cell that will allow me to enter one of the sequential numbers and have either the name and dollar amount next to that typed-in nu...Cannot close the Customer/Vendor Relationships window
One user accidentally opened the Customer/Vendor Relationship in one of the
forms in Sale module. She doesn't have access to add or delete a customer or
vendor and this prevents her from closing the window. She tried the
File->Close but the system is asking if she wanted to add the customer. If
she clicks cancel it does not close the window, if she clicks Save it says
that she doesn't have the proper security rights.
Kindly advise how the user can close the window without using force logoff.
Click anywhere on the first line in the grid, then go to Edit &...relationship
I'm not sure how to go about this. Can someone point me in the right
I have two tables. There are two fields in one table that will match two
fields in the other table. When I change the CurrentRevision value in
tblRevisions, I want matching record in tblOnTimeDelivery to change the
CurrentRevision value also.
Here's what I have:
and other fields
and other fields
Thanks for your help,
From your description, I'm having a bit of t...Fields from two Tables on Report.
My project is in MS Access 2002.
In that I have one Form which enter data in two different Tables, when
I click on Submit Button it will run two diffrent queries one by one.
Now I want to generate Report from that Tables.
But I don't know how can I put Fields from two different Tables in
Report's Detail Section.
If Feilds are from only one Table than I can set Report's Record
Source property to that TableName.\
But I don't know how to set it for two tables?
Even I put fields in Report and set there Control Source Property to
that [TableName].[FieldName]. But when I open r...Help With E-Mailing in Publisher
I have version 2003 of Publisher and when it was installed you could go to
file and go to the drop down send in e-mail and select: send in message! Well
it wouldn't send to one person in the office so our computer guy uninstalled
it and reinstalled it well now it only gives me the option to send the page
as a atttachment and that's not what I need, I need to send it in the
message, I can't even preview it,it only gives me the option to send it as a
attachment!! So what do I do because everyone else has that capablity! Is
there a setting I can chose that will change this! Ple...help needed
Please help on the following issue:
I have to check if one of the check boxes in the following cells is
checked I need a macro that checks if the check box in cell G14 is
checked in sheet Account Tracker. If its checked then I want to do the
formula in G17, if the check box in H14 is checked I want to do the
formula in h17 & if the checkbox in I14 is checked I want to do the
formula in cell I17.
A second thing I need is that based on the above logic as there will
be only one set of values in g17 or h17 or i17 .If the values in g17
or h17 or i17 are negative than I ...Querying one-to-many relationships
I have two tables, one table with one primary key and one table with several
NDC APPL_NO APPL_TYPE_CD
57866660701 074105 2
57866660701 074140 2
57866660701 074207 2
57866660701 074410 2
57866660701 075927 2
57866660701 076494 2
There are a two things I need to do after joining these two tables. One is
to find out if there are any records in the second table with different
values in the "APPL_TYPE_CD" field for one NDC number. The other is to only
return the first record from the second table, not all...MSDN Library Help
I would like to know where and what format the favorites
list of the MSDN Library is saved. (I mean, it reappears
even if the MSDN library is unistalled and reinstalled.
...Help! Cant print with Microsoft Vista...
I have been able to print with Microsoft 2000 through my printer Canon
BJC-50c, but when i connected it to my new laptop using OS Vista Ultmate... I
cant print. The paper loads when i press print, but it just stop there with
my power light blinking away. When i press the cleaning, check noozle or test
buttons, it prints out
It prints the above, when I click those buttons on the maitainence print
tabs. But it does not print my Word doc, websites, wordpad etc etc.
Appreciate any advice. Thanks in advance!!
...pivot table sorting
I want to rearrange my columns in a pivot table.
does anyone know how to do this?
You can manually drag the selected item to its new position. Also, you can
right click on an item in the column you want to change and select Field
Settings..., click the Advanced button, then make a selection from the
available radio buttons (like Ascending), then OK and OK.
"robert" <email@example.com> wrote in message
> I want to rearrange my columns in a pivot table.
> does anyone know...Count If.....help
I am trying to sum the amount of time two words "high" and "very high" appear
in a col....I can get this to work for one word but when i try and nest the
statement it doest work - Why and how to i solve it.
=COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks
First, your question is ambiguous. Are you tring to count the number of
times a cell's contents - as a whole - is either "High" or "Very High"? Or
are you looking to count how many times the a) word or b) phra...