Combo box list selection based on earlier selection by user
I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the Product selected from
combo box 1 and upload the corresponding RO# in the combo box 2 list. Now I
am using both combo boxes as Unbound and in the combo box 2 I have the two
columns Product and RO# - in the Criteria row of RO# I have the following:
Like IIf([Forms]![xa_f_lookup]![RO#]=" ",[Forms]![x...Run report on multi selected records.
I try to make a report for a custom entity that works like the Account
Summary: let's say that it's Customer's Inquiry Summary for entity Customer's
I made the report so that I'm able to run the report on Customer's Inquiry
But when I select multi records in the list of Customer's Inquiry and run
report, only one record is show in one page of the the report.
I would like to have the selected records appear in the report with each
record on each page.
How can I do this?
...grouping a chart in Access
I have a query that is 31 rows. I created a report that is grouped by Farm
Name and House. The data shows correctly on each page for each Farm and
House, but when I add a chart it gives me the data on the first page, but
then gives me 30 pages of blank charts, till the next group. What did I
miss? I am using Access 2010 beta.
I expect the issue is with the section of the report containing the chart or
the Link Master/Child properties of the chart control.
MS Access MVP
"dstraub" <email@example.com> wrote in message
new...Legal archiving for a group of users
I have a situation for legal reasons that i have to
archive all communications for a group of users. I need
to know how I can setup an Archive with either creating a
seperate storage group for the users or installing some
3rd party solution. I've just never had a situation like
this and need to know what my options are for doing such
a task. Thanks in advance for anyone that might respond
In article <firstname.lastname@example.org>,
"Linnie Gooch" <email@example.com> wrote:
> I have a situation for legal reasons that i have to
> archive a...Can't select objects in Excel 2007
I'm trying to create a form in Excel 2007, and although I can manipulate,
copy & paste controls (check boxes, etc)
I can't select multiple objects to align them, etc.
I've checked on-line help (and have followed the instructions), and other
websites, but no one seems to have indicated a problem.
It is extremely cumbersome and I need a solution. Any ideas?
Thanks in advance,
I know this is about a year too late, but it may help others who have stumbled across this page looking for similar help.
On the Home tab, in the Editing group, click Find & Select....Recovery Storage Group error when trying to add database
Running Exchange 2003, SP1, native mode on Windows 2003
I have created a recovery storage group, and when I right click on it to add
the database to recover, I get the following error:
The search filter cannot be recognized.
ID no: 8007203e
Exchange System Manager
I have verified that AD has synced. Any ideas?
The problem is that in the distinguished name of the database there is a
parenthesis without its match. Examples of this would include:
cn=Mailbox Store 1 (SG1,cn=First Storage Group,....
cn=Mailbox Store 1 (SG2),cn=Second Storage Group (TestServer,cn...Exmerge options with Recovery Storage Group
I recoverd mailboxes into a Recovery Storage Group. I want to exmerge
into a pst rather then the users mailbox. when I run Exmerge from
outside the recovery storage group on one of its mailboxes, I get an
error in exmerge when getting a list of mailboxes from the recovery
group and it says to look in the exmerge.log. that says "it cannot
identify the user with the msExchmailboxGuid" and then gives the GUID
number. Is this caused by the users mailbox being in the recovery
group. Can the exmerge only work with the built in version and going to
the users live mailbox?
Thanks in advance...orphaned mailbox's in Exchange 2003
For some reason I have about 9 mailbox's that have
suddenly become orphaned because their user accounts have
been deleted. I have used a utility in the past called
killmail that allowed me to disconnect the mailbox's from
the user accounts so that I could recreate an account and
then reattach the new account to the old mailbox thus
allowing the user to keep the mailbox with it's contents.
Can anyone tell me how I can get the killmail utility so
that I can do this?
The same functionality of killmail was built into Exchange 2000 SP2 and
beyond. Its called remove Exchange a...Help with grouping columns
Maybe I'm overlooking the obvious...but I'm having a hard time groupin
Here's the goal:
Columns A - L are the 12 months... Jan-Dec.
I want to group 3 columns (3 months) at a time. So I'd have 4 colum
groups side by side.
I select the entire first 3 columns...data...group/outline...an
group...creates the group fine.
I then select the next 3 columns (next 3 months)...to be in their ow
group. When I try to group them...it just ads them to the firs
group...making one large group.
The first 3 columns are not selected when I do this.
I've also tried playing with the s...Lot Selection not Showing when I select PO on Receiving Entry
Usually, the Lot selection screen would pop up when I select a PO at the Line
Detail of the Receivings Entry, now it does not! And GP will let items post
without a lot number! It seems as if a setting has changed. Any ideas
Any help is appreciated.
Are you sure the item is marked to track lots? This wiould be set item by
item on the Item Maintenance Options window.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
&q...Can't Create New Message Outlook 2000
I have a Windows 98 computer running Office 2000 Small Business Edition.
Yesterday, mysteriously, it began misbehaving. When clicking on "New" to
create a new mail message, you get an hour glass and then a "not
responding." When clicking on other shortcuts other weird things happen,
i.e. when you click on Tasks it goes to Notes, when you click on Calendar it
crashes, when you click on Contacts, it goes to calendar.
We have uninstalled Office and gone through the KB article 252566 to
manually remove leftover files, but when we reinstall, the same thing
happens. ...Select contact then hangs
Hi, please help. I have a user that when she selects a
contact using To: in a new email, after selecting 2, it
closes outlook??. Spec is W2kSP4\office2k with all
windows updates and office updates installed. Profile has
been deleted and re-created, plus i have set up personal
folders and moved contacts into there, and set that
folder as a default, but makes no difference.
...Add users to a Distribution Group using csv file
Is it possible? I have a list of approx 3200 users that I want to add to a
common duistribution group w/o having to do it manually. At present I have a
csv file with all the users that I want to be in the group. Is there a way
to import them into the group using this file w/o recreating their accounts
using csvde or ldife?
"kage13" <firstname.lastname@example.org> wrote in message
&...Selecting rows from various sheets
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
aa 1 1 1
bb 2 2 2
cc 3 3 3
aa 4 4
cc 5 5
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5
shav's Profile: http...select text in Calendar
I'm working on a calendar in Publisher. I'm adding text into a cell by
spacing down 1 point, then typing in 8 points. Doing fine until April. At
that time, I can only select cells (whole days). It will not let me select
the text. Help is no help. Any hints out there. Did I accidentally select
something to do this?
Have you added a picture to the cell or a shape? If you have send it to the
back, make the cell no fill and try again.
Mary Sauer MSFT MVP
"GoBonnieGo" <GoB...Have Stores Create Records in HQ
Is it possible to have the stores databasse create records in the HQ dbase
and not the other way around? For eg. Sometimes clients forget when they get
new products to create it in HQ then send out to stores.
We have a utility to allow you to create an item simultaneousely at store and
in HQ. Contact m efor more detail.
Afshin Alikhani - [email@example.com]
CEO - Retail Realm
> Is it possible to have the stores databasse create records in the HQ dbase
> and not the other way around? For eg. Sometimes clients forget when they get
&g...I need a templet or file for creating a personal checkbook.
I would like a templet or file that I can covert to Lotus 123 that will track
There is a few templets out there but I can not convert them to Lotus?
Any help would be appericated in advance.
...Create an Scheduled Tasks without a User Password in C++?
is there any way to create an scheduled tasks without a user password, for
example, i'ma Administrator on my pc, without a password? I use the
VisualStudio 6 and the OS is WinXP Professional! The function what i use is :
/* SetAccountInformation(L"", NULL); */ // first
that is what i mean?!
It's is impossible to create an new right scheduled Task without inputting a
user password .
if it do , there will be a bug in windowsXP.
it you will to research that , I can advise you to get...Cannot create new, reply, forward
Hello - I am using Win XP and Outlook 2002 on an Exchange
server. We have recently changed domains and since then I
can receive mail but my new message, reply and forward
commands no longer work. Buttons are there by commands
are greyed on teh menus or missing.
Have tried uninstalling Office XP (inc registry keys) and
reinstalling, then installing SP1 for OffXP but that
didn't seem to rectify this. Does anyone know why? I'm
going crazy and my systems manager is baffled.
All suggestions welcome.
I can't, it won't let me access the Email Accounts
settings either...Deleted Mailbox/Retention
I'm working with an Exchange 5.5 server at the moment, and our client
asked us to delete a mailbox (which we did). Now they've decided they
want it back. I know Exchange has a deleted item retention that keeps
this stuff for 30 days, but I also know this is just meant for
replication to other servers - in short, can I work with this stuff?
If yes, how do I get it back?
If no, is my only option to restore an old backup of the exchange
database on another machine, and pull the emails out to *.PST?
> Hi all,
> I'm working with an Exchan...Web Site Created with Publisher 2000
'Need your help folks.
I've created a web site with Publisher 2000 and wish to have a counter to
track number of visitors. Calls to my I.P. didn't prove to be fruitful. They
gave me a script and told me just type the text on the page. Not only does
this not work but it doesn't seem correct.
My site is at:
and the script is there as string of text.
What am I doing wrong??
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Don Schmidt <RetiredEngr@BabyBell.fa...How to move Ex2k3 Sp1 between Admin Groups
All my Exchange 2003 servers have Sp1 applied. (we are still in Mixed Mode).
How do I move a Exchange "003 server from an admin group with only itself
and an Exchange 5.5 server init to another admin group with both Exchange
2003 & 5.5 servers in it ?
1) How do you actually do it ?
2) Should I remove the Exchange 5.5 Server first or remove it after the move
You cannot move servers between admin groups. You can move users between
admin groups, though if:
a) You're in Exchange native mode
b) You use the site consolidation tools in Exchange 2003 SP1...Creating an lookup price-list
I am trying to build a lookup list in excel but unable to decide how to
Let me try to illustrate the problem here:
I have a price-list workbook which has data like below:
Header Row -> Name Brand Packing Price
Data Row 1 -> Horlicks Nestle 500 g $10.00
Data Row 2 -> Britannia Nestle 500 g $3.99
Data Row 3 -> Taj Mahal ITC 250 g $7.78
Data Row 4 -> Seaking Grasim 100 ml $4.23
I want to create another worksheet where users can select Names from a
dropdown and automaticall the brand, packaging and price column would
Basically the i...Creating a worksheet from others (IF statement)
I tried looking fort his answer and I think it is answered in parts of other
questions but I cant get it together.
I have a file called invoices.xls which is a workbook of 12 monthly
worksheets for the year. Each item in a monthly worksheet is a row that
houses project information financials etc (project cost, outsourced cost,
project name etc)
We also have another file (wip.xls) where we double handle all of that
information and cut and paste only those files that we are currently working
I would like wip.xls to be automatically populated with certain cells f...Shared Mailboxes?
i have 10 or 15 users who work in a department who would
like to be able to take emails out of their mailboxes and
put them in a shared mailbox that everybody in the dept.
can get to. does anybody know a good way of going about
"Brian" <firstname.lastname@example.org> wrote:
>i have 10 or 15 users who work in a department who would
>like to be able to take emails out of their mailboxes and
>put them in a shared mailbox that everybody in the dept.
>can get to. does anybody know a good way of going about
Sounds like a good candida...