Smart List-GPS error 18
Someone have seen this error before, in smartlist, in open purchase order by
...Sorting Combo box items
If someone could tell me how to sort the contents of a combo box in 2007 it
would be much appreciated.
Base the combo box on a query that has an appropriate ORDER BY clause in it.
Doug Steele, Microsoft Access MVP
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)
"Teeder" <Teeder@discussions.microsoft.com> wrote in message
> If someone could tell me how to sort the contents of a combo box in 2007
> would be much appreciated....Is it possible to Cond. Format a List box
Is it possible to format a list box , so as if one row has a zero balance is
this field (Part of Script) [tblInvoice_ItMdt.TotalAmount FROM
tblInvoice_ItMdt] I could change the colour of the
font?...............Thanks for any help............Bob
Access doesn't allow this natively, and I doubt that anyone has come up
with a way to do it with a listbox. As far as I know, the closest you
would get is to make a continuous view subform, and use conditional
formatting on it. You could lay it out so it looks pretty much like a
listbox... but of course if your listbox is multi...Dynamically loading pieces of a bitmap file to an image list
Similar questions have been asked, but I am not sure if they are in
reference the same type of situation.
Perhaps there is a better way, but I basically would like to make my
app skinable by reading its graphics from a single bitmap file, and
give the user the ability to select a different file during program
Right now my graphics comes from bitmap resources and are put into an
image list. I'm not sure how to read graphics from files, or how to
read parts of bitmaps into image lists.
So my question is if anyone knows how to dynamically load a bitmap from
a file and p...PING distribution list
I would like to test the distribution group in Exchange 2003 or 5.5. I
would NOT like to send a email to all members of the distribution list,
so is there a way just to, sort of, PING the group and then to get
pingbacks, successful or unsuccessful, from members for the group.
What exactly are you trying to accomplish? Are you somehow unsure that the
AD members in your DistGroup are valid?
Ben M. Schorr - MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.ht...How do I get Excell to sort dates that range from 1800 to 1900's
I have posted a cemetery survey on Excell spreadsheet. When I try to sort
the birth dates or death dates in ascending or descending order the range of
1900 dates will sort but the 1800 dates fall after the 1900 and will not
sort. Why? Is this inherit with this program?
The WinXL default dates start with 31 December 1899, so earlier "dates"
are interpreted as Text.
You can use helper columns and text functions (LEFT(),RIGHT(),MID()) to
put the Year, Month and Day in separate columns, then sort.
Take a look here for additional workarounds:
http://j-walk.com/ss/excel/files...Validation List Query
I've got a validation list showing a project problem status: New,
Resolved, In Progress. These options are a named range 'Status'.
Thus I do Data>Validation>Allow:List>Source:=Status
No problem there. However, from time to time I need to input a custom
status, which could be anything. The problem being that once I have a
cell validated it does not allow me to type anything in it. Is there a
means that keeps the validation drop down, but also lets me input my
own data if, and when, I need to?
I could always remove the validation from the individual cells, but
h...Removing Folders From Folder List
Can you help !!
I am using Outlook 2002 (10.4219.4219) SP-2
I have reorganized my folders and now have a problem with my folder
list. I have removed an old archive folder, and can not now remove
this from the folder list.
I had problems prior to this with this folder, as outlook would not
let me close is.
Any help on this would be appreciated
...Contact oddity and why are there 2 Contact Lists?
Running Win 7, and was receiving emails in WLM with my maiden name listed in
the TO:. I found out that I had my maiden name listed in Contacts (I run a
high school mailing list here) so I decided to check it out and changed the
last name to all caps. Sure enuf the next email I rec'd showed that name.
I then deleted the email address connected to my name in the contact list
and everything is back to "normal" (whatever that is <G>)
Why in the world are there 2 contact lists on my computer......one thru WLM
and one thru Windows Contacts?
...Formula to return non-zero values in a list
I have a list of numbers in a column like so -
What formula would I create to always give me the a SUM of the las
couple values before the zero value. The list always ends with a valu
other than zero, so in this case, the '8' is the end of the list, and
would like to SUM the 3 "last" values, those being 8, 1 and 4. As
use this file, the zero values will automatically be updated with ne
information, so I need a formula which would constantly reflect thi
Message posted from http://www.ExcelForum.com
If you don't mind having an extra col...Form Dropdown Combo Box
My dropdown combo box currently displays one column. What I would lik
to do is have the box dispay column A and B but only extract the I
from B. How would I be able to do this
Message posted from http://www.ExcelForum.com
I'm not sure if I understand the problem correctly, but have you trie
using a CONCATENATE function to join the values in Columns A & B?
Say you have first names in Column A and surnames in Column B. Us
something like =CONCATENATE(A1," ",B1) in Column C for the dropdow
list. You could also use =A1&" "&B1. The apostrophe marks are just...Can validation lists be enlarged
When a validtion list is created can this be enlarged in a spreadsheet which
has been reduced to view.
for a workaround see:
"AC" <AC@discussions.microsoft.com> schrieb im Newsbeitrag
> When a validtion list is created can this be enlarged in a
> has been reduced to view.
...conditional formatting sort
Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Thanks for your time and assistance.
On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
You can't sort by color, but you can add a column to your query like
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.
>Is there a way to sort after condition...The opposite of the "sort" function
I have a list of alphabetically ordered data in a column.
Is there a function for randomizing the order of these data?
In article <firstname.lastname@example.org>,
> I have a list of alphabetically ordered data in a column.
> Is there a function for randomizing the order of these data?
Exellent solution! thanks!
Let's say your data in A1:A10
In B1: =RAND()
copy from B1 to B10
Select A1:B10 > Data > Sort > Sort by select Column B > select As...Delete button missing on HQ Global Customers list
I have a strange problem with HQ Manager. All PC's and Server are
running HQ 1.3.1002. When all but one user with admin level access
opens HQ Manager, enters maintenance mode, and clicks Database, Global
Customers, the Delete button is visible for a split second and then
vanishes. The one user that can see and use the Delete button can use
it from any PC, so it appears to be related to the user account, except
that the button is missing when running HQ Manager on the Server. As
far as I can tell, the users that cannot see the Delete button have
exactly the same permissions and level. There...Sorting emails by domains, from org to edu (right char is the most significant)
I need to sort the domains according their emails.
That is, how to sort, according to the domain name ( the right is the
most significant )?
On Feb 15, 11:09 pm, "duzhid...@gmail.com" <duzhid...@gmail.com>
> That is, how to sort, according to the domain name ( the right is the
> most significant )?
you'll probably need ...contact list #13
I hope I am in the right area, we are running Exchange 2003 one Server 2003
and have Outlook 03 clients. We have address lists in the public folder an
admin and a vendor, these contain contact information on contrators and
vendors. In the folder list I can browse down and few and click on a contact
to send them an email, but when I open a new email to send and I click on to
and what to chose the list from the address book drop down box they are not
there. How do I set it up so vendors and Admin contact list appear in the
drop down box in the contact list?
David ...Printing mailing list directly to envelops using Access
I have come across what I thought would be a simple problem to solve. I
would like to print mailing lists directly onto envelops using Access.
Currently I print to labels and then put these labels onto the envelopes,
then a thought struck, why not print them directly onto the envelop. I have
tried custom page layout, but nothing seems to work.
Any suggestions are deeply appreciated.
With your report open in design view, from the File menu select the Page
Change the Orentation to Landscape. Then from the Paper Size list select
the desired envelope size. In...how to find an item in a list control?
In a list Control how to find an item. If it is found then the item should
how to do this?
i wrote the following code but its not working
what's wrong in the code?
info.flags = LVFI_PARTIAL|LVFI_STRING;
info.psz = (LPCTSTR) str; //fd.m_strEditCtrl;
for(int i=0;i < m_ListCtrl.GetItemCount();i++)
if((nIndex = m_ListCtrl.FindItem(&info,-1)) == -1 )
thanks and r...data sort
ok now should be simple >>
I need to sort by month on data that is held in format >> day/month
custom/ends with/ 11... does not work
custom/ends with/ ??11.. or *11 does not work either
contains 11 does not work (& would also be wrong if data set contained 1011)
but still I am stumped so any help would be great
I would be inclined to add a new, temporary field of formulas that pull off
the right 2 digits, and sort by that: =RIGHT(A1,2)
...Fill table with values from list
I have a list and a table on separate sheets in an Excell workbook.
First sheet has a list of names. I'm trying fill in a table on the
second sheet with the EXACT names from the other list as they are
assigned to various groups. (Each name will be used exactly once).
Any idea how I can program the table to anticipate the content like
...add extra item to a combo box?
I have a form with a combo box on it and wish to add 1 item to the
How do I do this?
PS I can create a new combo box with an extra item but the table does
not reflect this extra item ... I can however open the form and move
to any record and use the drop down list to add the new item ...
if the cbo is a bound object you can use the Not in List event and program it
to add the text using ado or doa to the table and then I use a macro to
requery the cbo. If it is unbound I am unsure, I have never done an unbound
"Geoff Cox" wrote:
> Hello...Changing Newsgroup order List
Is there a way to change the order of the groups listed? For example I want
Word to be the second group and not the third listed.
Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol
a sin? Is the KJV the only translation to be used? If you want to learn, get
answers, and be able to defend the faith, CERM is your place.
John Wolf wrote:
> Is there a way to change the order of the groups listed? For example
> I want Word to be the second group and not the third listed.
I don't believe so. They appear alphabetically fo...Elegant way to restrict data entry to list of values
I need to provide a way to restrict data entry on a large range.
For example, I need the first 100 rows of column 1 to only provide
'yes, no' as possible entry values. The first 100 rows of column 2 to
provide 'yes, no, maybe'; the first 100 rows of column 3 to provide
'client, server, unsure', etc ...
I thought about using named ranges linked to drop down controls, but
that would result in many controls (over 300 based on above example) on
the spreadsheet and lead to performance issues.
Can anyone suggest a better way to go about doing this? It would be
ni...Macro: Save and update/replace comments in a list
My macro makes a list (in sheet "BOARD") of all files in a folder
given as variable path.
To each file my macro generates an hyperlink / "open-file funktion" as
This file-list is placed in range A5-A?? (depending of number of
The macro works well (Hurra!!!)
Now I want to write (short) comments to the file-names in column B /
respectivly row (you know there are a lots of incomprehensible
filenames in the world, and I want to add and save some information of
content in my file-list machine).
My aim is to save the filenames + comments in ...