Crazy Sorting Problem.....
Ok so I have colums A though D that need to line up with E through P. I have
a common symbol in D and F. I need to get rid of everything in colum A
through D that does not line up with the E through P useing the common symbol
as a referance. I am right now deleting extra info by hand. Please help.
see your other post
> Ok so I have colums A though D that need to line up with E through P.
> I have a common symbol in D and F. I need to get rid of everything in
> colum A through D that does not line up with the E through P ...Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <firstname.lastname@example.org> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...Problem Syncronizing.
HI, I have problems with a syncronized store that I had
to syncronize again from the beginning. Give me alot of
TIme out when I use the 401 Worksheet. Since some of the
data is in the HQ Database I would like to know if there
any operation I can do so then tell to the HQ client that
I just want to upload some information?. Thanks in
advance for your help.
Go to Manager, Help, About. If your version is 1.2.0151
you have a version that won't work with Global Customer
turned on. Contact MBS and ask for a Hot Fix to address
this issue. Install the Hot Fix on all PC...WaitForSingleObject Problem
I use WaitForSingleObject(hProcess, INFINITE) to wait for execution of
the MS ActiveX Control Pad Setup (started out of my application).
CreateProcess(NULL, "setuppad.exe", NULL, NULL, FALSE,
DETACHED_PROCESS, NULL, NULL, &startupInfo, &processInfo)
At the beginning of installation everything is fine, but after a
little bit of time, the CPU usage is 50% and nothing is going on (it's
after searching for installed components).
When I don't use WaitForSingleOb...INSERT INTO problems
I hope this doesn't appear twice, I did it a while ago and it never
came up! So here goes again!
I am trying to use INSERT INTO to insert one record in to a table (tna
feedback) in two fields (USER ID: and DESK/LAPTOP).
The values are generated by two different forms; stUser comes from
this form and stMachine comes from another form which has been hidden
once the user has chosen the value. This part works fine.
However, every time I run it I get an "Incomplete Query clause" error
message but can't fidure out what I've done wrong!
Here is the code:
Dim SQL ...Access 2000 Package and Deployment Wizard problem!
I have created an Access 2000 application that I now wish to distribute to
users as an MDE file. The Access 2000 Package and Deployment Wizard does a
fine job of storing the relevant installation files on a CD, exploiting A2K
However, I would prefer to let users download my application from a website.
The Package and Deployment Wizard offers a 'Web Publishing' deployment option
that appears to address this need. My only problem is that it doesn't work
for me. I get the following error message,
Unexpected error number 48 has occurred: File not found: WebPost.dll
I...last 4 wk average using calculated pivotitem
I am trying to create a pivot table/chart from data that is listed b
week. So my table has "week" as the row field and "total X" as th
column field. I want the chart to display the total for each week as
bar (the easy part) and also to graph the average of the last fou
weeks as a line on top of the bar graph. I have tried to figure ou
how to add a calculated pivot item but I can't seem to get it to wor
right. So for each week there would be a second almost subtotal lik
entry that calculates the average for the previous four weeks (if ther
aren't four previo...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...Count problems[Excel 97]
I did a search on the forum to find an answer to my question but didn'
Here is my prob :
Lets say I got this page->
1 Name Type Job bla
2 Name Type Job bla
3 Name Type Job bla
4 Name Type Job bla
5 Name Type Job bob
I want a Cell to write how many row I got( 5 in this exemple) and onl
count the cells with bla in the D column(4 in this exemple).
Sorry if I'm not really clear but if you can help me feel free t
-----------------------------------------------------------...Problems with german characters (umlaute)
it happes every months that a mail reaches us with I don't know how coded
german characters. Our german customers are calling us, asking what we're
missing on our system.
I've checked one of these mails and the only thing I found out that the
codepage, which was specified in the header, was the same than in the other
mails I've in my mailbox and which I can read perfectly.
The strange thing in current case is, that the email is displayed correctly
when the mail is opened in Outlook Web Access.
I need some help how to get hand on these problems.
Many...Using a VBscript to copy/delete/move Outlook messages
I need to write a VBscript to:
- open my Outlook (2000 or XP) mailbox
- read the list of the folders in either the Exchange Mailbox and in local
- open each folder and subfolders
- read information about messages (i.e. sender, recipient, creation date,
and so on)
- move, copy or delete messages based on the above information
Can anybody please provide a pointer to a sample I can start from?
...Using XP Briefcase with money file
I put a copy of my money file into the laptop briefcase
and I am able to keep them in sych for a while. For some
reason I get locked out, the computer knows the file has
been updated but it will not let the desk top file update
the laptop file, I get the following message;
"The source file can not be opened"
"Check to see if the other program has the file opened,
and close the file before updating the briefcase."
Other files update just fine. When I get this message, I
can't even drag a new copy of the Money file to my
briefcase, I have to rename the file an...Exchange Features Tab in ADUC when using Windows 2000 SP3
I would like to run Active Directory Users and Computers with Exchange 2003
I'm limited to Windows 2000 Prof/SP3
Everything works,except from the Exchange Features tab.
When selecting this tab, ADUC hangs.
Any ideas. (I have to stay on SP3!)
Terminal Services is always my first choice.
On Wed, 13 Apr 2005 23:35:22 +0200, "newsMS" <email@example.com> wrote:
>I would like to run Active Directory Users and Computers with Exchange 2003
>I'm limited to Windows 2000 Prof/SP3
>Everything works,except...Change color of multiple autoshapes
I need to change the color of several autoshape based on different cells
I know how to change one autoshape using a worksheet_change event
but i can't just copy and paste this and change the object name + cell name.
is it possible to have multiple worksheet_change events in the same
You have only one worksheet_change event, but in it you can test to see which cell was
changed with something like
If not Intersect(Target, Range("A1") is nothing then
' do range A1 stuff here
If not Intersect(Target, Range("A2") is nothing then
...How do I add multiple times together
Hi does anyone know how I can add multiple times togther and get the anser in
hours and minutes. I have formatted the cell for time however when I atosum I
keep getting an answer that is incorrect. Any help?
Maybe it was just a formatting problem.
Try a custom format of:
Playhouse pm wrote:
> Hi does anyone know how I can add multiple times togther and get the anser in
> hours and minutes. I have formatted the cell for time however when I atosum I
> keep getting an answer that is incorrect. Any help?
I wrote a formula in a cell that contains the following:
=countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")
I have verified that any unused cells have blanks spaces in them.
Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.
Not sure I get it, but try
=countif(f5:f268,">"&char(32)) / countif(e5:e268,">"&char(32))
"psion" <firstname.lastname@example.org> w...Problem with printing listbox bigger than one page
I created form "Invoice". It contains few list boxes (like: Brand,
Product, Price, etc.). Each list box is big enough to display 50
items. It works in this way: user is chosing product from table
Products_tbl and clicks on "Add to invoice" button which adds to each
list box new item containg apropriate information about chosen
product. At the end, user can print the form. Before it was limited,
and user could put max. 50 products on one invoice, but I wanted to
get rid of this limitation. I did it in this way: after 50th item,
with each added product I extend list boxe...Carriage Return/Line Feed Problem
I wrote some code that gets the HTML from a Web page and stores it in a
buffer, then I display the buffer in a big multiline CEdit box. The problem
is that on many pages I don't get new lines, I just get a thick solid
verticle line kinda like this: || where it should return.
Also, if I view the pages (view source) in Notepad they look fine.
Most pages do that, but interestingly Microsoft pages do the proper new line
and look great in my edit box.
Maybe I have to replace all the \r with \r\n or something like that ? Does a
\r\n still only take up 1 char ? I download the page in...FRx
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...Audience rule, problem with Domain Local Group.
I try to create a rule for my audience on Portal 2007
User = Member of --- some Domain Local Group (I need to add people from
other trusted forest)
But it can't be relolved :-(
I checked it on 3 Portals, no luck
I cam only create such a rule: Work e-mail Contains @needed_domain.com
or add individual accounts from those domains, but there are 1000, too hard
to add manually ....
Please help. Perhaps there is another way
These groups need to be either Global or Universal groups. Universal groups
are better for SharePoint, and they can contain global...Using a variable for a chart limit
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
See Jon's information
Vince F wrote:
> Since I got instant help on my last query, is there any way to use a cell
> reference as an axis minimum or maximum in format axis? It seems impossible,
> but there is a lot of experience out there. Thanks in advance.
Andy Pop...backup problem
Hi I had installed backup for office 2003, I had been backing up to a
I had removed the disk and kept getting messages that was unable to back up
to removable disk, even though I have turned off all automatic backup
I have since removed back up "feature" but still get the 4 or 5 steps
stating unable to find disk etc, any ideas how to get rid of this wonderful
If by removed you mean 'uninstalled' then it would appear the uninstall
In OL ensure backup is not selected within Addins
"Tim&...multiple instances of IE on same site
I have winxp and use IE 8. My problem is that I have 2 usernames on some web
forums. I used to be able to login using both usernames and have both
instances running simultaneously. Now I can't. Everytime I'm logged in and
try to initiate another instance the username just changes. It does not allow
me to open 2 IEs with 2 usernames at the same time. I'm pretty sure this is
just a setting but I don't know where it is. The reason I think it's an IE
setting is that when I try to login with a competitor browser as the 2nd
user...it allows it. Any help would be gre...LDAP problem
I upgraded from Outlook 2000 to 2002 and now every time I open Outlook I get
a Microsoft LDAP Directory window with Server Name, Port, User Name, and
Password. What is this thing and how do I get rid of it?
Remove .spamnot to respond by email
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 11/7/2004
You can remove the LDAP address book provider via Tools | Email Accounts |
View/Change address books. (Might be listed as Active Directory or LD...Multiple entries in CRM Contacts when viewed from Outlook
We have an odd problem going on here with this.
When we create a new E-mail in Outlook, select the To button and the CRM
Contacts, it brings up the list of contacts from CRM that we can select
from. All good so far.
The problem is that each contact appears several times and it's different
for different users.
For example, every contact appears 6 times for me. It makes for a very long
list. All of them are valid and any one of those 6 can be selected and the
address will be correct and it will track against the correct contact.
Other users have anywhere from the correc...