i have a form where i would like to use for search by two criterias: Lot# or
Part Number - these are two field in the table.
need help to add that to the code
Private Sub Command39_Click()
Private Sub Command42_Click()
On Error GoTo Err_Command42_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Open Orders"
stLinkCriteria = "[PART NUMBER]=" & "'" & Me![PART NUMBER] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
E...Advanced Search Criteria
Just an FYI, since there doesn't seem to be a solution posted anywhere
on the web, at least that I could find. If you want to search using
dynamic dates, at least in the case of finding items older than a
certain relative date, such as more than 30 days old, I used the
following criteria successfully in Outlook 2007:
Advanced Find > Advanced (tab) >
Condition: On or after
Value: 30 days ago
...Rules Not Working
We recently switched to a web server email program - and my email now goes to
a different folder - not the personal folder inbox and I cannot get my rule
to forward e-mails to work - we have office 2007 - What's really confusing is
if I test the rule it will show the fwd arrow on the original message and a
copy will appear in my sent folder however the receipients do not receive it.
I am able to manually fwd the email with no problems.
I have a similar problem, however it had been working but I had to remove all
my accounts and reinstall them. My MSN account would not downl...Scheduled tasks dont work but look like they are
We are having intermittent problems with Windows Task Scheduler.
1. Everything will work fine for a few weeks, then suddenly tasks that used
to work ok will complete as normal, but task scheduler does not know they are
finished, and so the tasks status sits as running.. even though the program
and executable have closed and gone away.. this stops future instances of the
scheduled task from running.
2. Tasks that are scheduled to run, and have run for weeks without issue,
suddenly just stop running. They sit waiting for their scheduled start time,
the ...Outlook 2003 Junk E-Mail Filter Has Stopped Working
The junk e-mail filter was working just fine for a couple
of weeks, but now it seems to have pretty much stopped
working. It rarely filters anything as junk e-mail now. :(
I have the same problem on one of my computers.
Have you found a soultion?
I'm using Outlook 2003 with two IMAP-accounts on two
computers (Windows XP). Everything worked fine on both
machines until a couple of weeks ago, when it stopped to
work on one of the computers. It still works on the on the
>The junk e-mail filter was working just fine for a...Autocorrect STILL NOT working!
Yesterday it was suggested that I download service pack 3 to fix the problem
I was having with Publisher 2003. My autocorrect is not working nor am I
able to apply formatting to text boxes throughout publication without
changing each one individually. I restarted my computer as it suggested
after downloading the service pack, but nothing seems to have changed. My
(c) is still set to use symbol in AutoCorrect options, I have checked box to
apply formatting to all text boxes, and no matter what, I am still getting
(c) instead of symbol and each textbox is defaulting to Times New R...Running Access 2003 db in 2007, and a few forms don't work
I have a database that's been updated from at least Access 97 (maybe Access
2, I can't remember anymore) and has been running fine in Access 2003 for
years. My client upgraded to Vista with Office 2007. Almost everything in
the database works fine, except 3 forms. Each of these forms has a tab
control. Two of the forms have subforms on some of the tabs, one doesn't.
When I try to open the forms in Access 2007 running on Vista in Virtual PC,
I get the error "There isn't enough memory to perform this operation. Close
unneeded programs and try the operation again."...Mail Notification on Welcome Screen is not working
OK, guys, I've scoured the newsgroups, and I've scoured the Knowledge Base,
but I can't figure out why the hell my Mail Notification is not showing up
on the Welcome Screen. I'm running XP SP1/all updates, Outlook 2003, IE/OE
Basically, when I'm at the welcome screen, all I see is my name. It's like
the Email notification is turned off.... but it's not. I've played around
with all the settings in TweakUI, turning the mail notification on and off,
using the Repair option, etc. I've even tried manually deleting all the
registry entries under
HKEY_CURREN...Total Minutes Worked Within IVR Timing
I need to figure out how many total minutes employee worked during the IVR
Each employee works different shift and it can run overnight into next
morning where there may be IVR coverage before employee logs out. IVR Timing
is same for Saturday/Sunday and same from Monday to Friday.
IVR Timing Table; data type is Date/Time but only Time is available because
date should be same as the schedule date
DayIs IVRStart IVRStop
Sunday 10:00:00 AM 6:00:00 PM
Monday 9:00:00 AM 9:00:00 PM
Tuesday 9:00:00 AM 9:00:00 PM
Wednesday 9:00:00 AM 9:00:00 PM
Thursday 9:00:00 AM ...Customize link not working in Reports
Money 2002: Version 10.0
When I open a report (any report) and then choose the Customize... link on
the left side, I do not get the Customize Dialog box that I used to see.
Money is basically unusable until I hit the ESC (Escape) key.
If you are using Money 2005, go into Tools/Reports and see whether you are
using Essential or Advanced Reports. My guess is that you need to switch from
Essential to Advanced. This is new in Money 2005.
"LongTime User" wrote:
> Money 2002: Version 10.0
> When I open a report (any report) and then choose the Customize....VB6 formula not working in excel
I have a few formulas embedded in my vb6 code which calculate and enter the
results in the excel sheet. These formulas work for me and everyone at my
workplace. But for some reason these formulas have recently stopped working
for some of our model users in other countries.
I noted that the problem is only with the formulas that are calculating the
percentage, the rest of the formulas are working on the sheet.
I also wanted to ask, is there a difference in using N/A and N?A in VB6? I
should probably ask this question in the VB forum, but if anyone knows,
...Why does catagorizing "negative" expenses not work
I did catagorize the income as a "negative" expense. That's how I did it on
Yahoo! but for some reason the amount in that catagory still is the same as
it was before I catagorized the income as an expense. I have a bank service
charge of $18 and then I get a $18 credit from the bank. But even though I
catagorized the credit under the same expense catagory I still have $18 show
up for bank service charges in my spending by catagory pie chart.
In microsoft.public.money, BJT wrote:
>I did catagorize the income as a "negative" expense. That's how I did it ...Work around Conditional Formatting
There are 2 worksheets (Sheet1, Sheet2) containing similar data in my
workbook. I want to underline the text in a cell in Sheet2 if the text in
that cell is the same as the cell in the same place in Sheet1. (For example,
if Sheet1!A1 = Sheet2!A1, then Sheet2!A1 is underlined.) Can I write a
user-defined function to check whether the contents in two cells are equal?
Thanks in advance.
Chips has lots of stuff on duplicates, see www.cpearson.com
Bernard V Liengme
remove caps from email
"Andy Chan" <chankhan...Why does Outlook's message recall feature work sometimes but not all the time?
Basically my users have a problem with message recall. The
problem is sometimes it works but most of the time it
doesn't. Even more frustrating is when they get a
successful recall notification message and then they get a
reply to the message that was supposedly recalled
Can anyone give me a straight answer or point me in the
direction of a reliable article on message recall.
www.winnetmag.com has an article that you have to pay for
and Microsoft just explains how to use it.
Thanks in advance,
Senior Customer Support Specialist
Message recall is really unr...How do I get Front Page 2003 to work with Windows7
I have been using FrontPage 2003 to update our website. Last month I updated
my computer to Windows7 and Office 2007. Several days later I try to log on
to Front page and receive the following message : " The operating system is
not presently configured to run this application. Load failed Cannont load
Has anyone had a similar experience? Or any advice?
Change the compatibility to Windows XP.
(BTW, if you search this newsgroup, you'll see this issue has been addressed
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
-----...FRx Forecaster Allocations do not work
We recently installed FRx Forecaster to use with Great Plains and FRx.
After inputting all of our budget data, we had our reseller set up some
allocations for us. They do not work.
We are trying to take the total expenses of several building cost
center (that contain the costs to operate the building) to the cost
centers have employees in those buildings. Next we are trying to
allocate the total expenses of a few support cost centers (IT,
Training) to all cost centers except the support, administration, and
building cost centers. Then we are trying to allocate the total
expenses of one adm...Start Menu shortcut doesn't work
I pinned to start menu on Vista, worked for a while now just won't open
Publisher, and I have to go into C:\Program Files to find it to access it
Anyone know a way to get the shortcut working again ?
On Fri, 9 May 2008 12:41:08 +0100, "Phil K" <firstname.lastname@example.org>
>I pinned to start menu on Vista, worked for a while now just won't open
>Publisher, and I have to go into C:\Program Files to find it to access it
>Anyone know a way to get the shortcut working again ?
Re-pin it to the start menu from there.
Why not put Publisher on the quick launch T...formula only works when file is saved.
For some strange reason my formulas do not work until I save the sheet.I am
using 2007 with a file that was in 2003. Never had a problem before. It is
in compatibility mode. when I enter the data nothing happens in the cell
where the result is suppose to go. If I close and save the result shows up.
If I open the file back up and take out the data I put in the result is
still there, where it should be a zero. Something is screwed up. Multiple
people have access to this file.
Sorry about the post . I found the problem. Somebody changed calculations
"bob" <...Database will not work on another pc?
I have a database (with some VBA modules) that I gave to someone else to look
at. The databse works fine on my pc and I have installed in on three other
boxes and they all worked fine.
His pc, for some reason, first give a "Compile error" when he starts to run
the application. I think asked him to look at the module (to see if I could
help him debug) and he gets a message that says the module is locked? Plus
under tools the references is grayed out?
Anyone have any ideas whay this would happen on a certain pc? All of the
pc's are running XP. It is a 2003 database running ...Spell check not working in Outlook 2001 for Mac in OSX
When I try to use the spell check for messages I get the error message:
"The spelling operation could not be completer. The spelling checker
could not be started. Some components are either missing or
incorrectly configured. See your administrator."
...Total working hours problem if it start from 30 at night and ends on the 31 morning
Dear all, i am using this to get the total wroking hours per day
TOTAL WORKING HOURS PER DAY: DateDiff("n",[TIME IN],[TIME OUT]+DateDiff
("n",[TIME IN 2],[TIME OUT 2]))/60
It is working perfectly until i have this
Employee Name Day Date Time Clock
Tia Kareem Fri 10/30/2009 5:59pm IN
Tia Kareem Sat 10/31/2009 3:27am OUT
IF i will use the same expression i will be getting total working
hours per day : -14.53
Employee Name Date IN
...Bulk deletion not working
I have deleted some records via CRM UI. But if i query into DB, the records
still stay there for almost 1 week already (with deletion statecode = 2). As
my understanding, once the job is deleted, there will be a bulk deletion
service that will remove this data from DB forever. Any other way to trigger
this deletion service?
To my understanding the deletion should be executed every 24 hours by the
Asynchronous Service. Did you check if this service is started?
There is another way to trigger the deletion than just to wait 24 hours. You
can find it here explaine...Cut and paste does not work between excel documents
I am unable to cut (or copy) a range of cells and paste them into another
excel document. I am only able to paste them into a worksheet in the same
document I am working in. Has anyone experienced this, or know how to correct
Cut and paste between spreadsheets works well. Many people use it often. Tell us
what error you are getting, or what you mean by "unable to ..."
Please reply to newsgroup, not e-mail
"R Morgan" <RMorgan@discussions.microsoft.com> wrote in message
&...Automatic completion of emails and nicknames doesn't work in Outlook 2002
Recently I moved from OE to Outlook 2002 but I have problem - when I type
e-mail addresses Outlook doesn't automatically complete it. I searched
microsoft support and I found this: http://support.microsoft.com/kb/287623/
but it doesn't resolve my problem.
Could someone help me with this?
Svilen Pachedzhiev, you wrote on Mon, 26 Mar 2007 14:47:45 +0300:
> Recently I moved from OE to Outlook 2002 but I have problem - when I type
> e-mail addresses Outlook doesn't automatically complete it.
See if http://support.microsoft.com/kb/287854/en-us helps. Also,
http://s...Work Order Deposit In Drawer
Hi I have this issue.
Let Say I have cashiers that work on the registers, and if they do work
orders, deposit ammount is not shown in any detaild sales report.
I understand that it is not sale yet that's why it does not appear, so I
will have to go with work order's but on other hand , my customer wants to
just generate one report with all the information needed. like there will be
total daily sales, let's say 1000, and work order deposites let's say 200 ,
so "total sales" will bes 1200.00
any ideas ?