filter not working
Dim strSQL As String
linker = StobMainFrame.Value
Select Case linker
strSQL = "TStobDaily.Category In('61','73') AND TStobDaily.DateIn
>#5/31/2007# AND PendDte Is Null AND Tstobdaily.LogInID=fOSUserName()"
The "DateIn" is still bring back dates less than 5/31/2007. Any
Take a look at what is actually stored in your DateIn field in the table.
Is it ONLY date values, or date/time values?
Microsoft Office/Access MVP
Microsof...Can someone help; pipe delimited text import not working
Im trying to import a pipe delimited text file into access 2007 and I get the
following message when I try to finish the import
"Method Execute TempImexSpec' of object '_Wizhook'failed. It doen't seem to
be recognizing the "|" pipe sysmbol I entered? Help nothing seems to be
working for me.
Can you import the text manually (which is how you usually set up import
specs anyway)? It could be a data issue or an import spec issue...
Can you copy the import text file and remove all but maybe the first few
records and see if o...Customize Outlook Today does not work.
When I click on the Customize Outlook Today button under
Outlook Today it doesn't do anything.
<email@example.com> wrote in news:firstname.lastname@example.org:
> When I click on the Customize Outlook Today button under
> Outlook Today it doesn't do anything.
OL2000: You Cannot Customize Outlook Today After You
Install Critical Update 813489 for Internet Explorer
http://www.kayodeok.co.uk/weblog/200311/customize_outlook_today_work_aro...outlook 2000/auto name fill in won't work
When making new email messages and using contacts already
entered the auto name fill in option doesn't work. Is
there a place to turn on this feature? Everyone else
I've asked (and the books I've read) say this is an
automatic feature! But not on my outlook 2000.
Any help is appreciated. I'm tired of typing
Outlook 2000 doesn't have an auto-complete feature. It has an auto-resolve
feature. If you enter an abbreviated form of an existing Contact, Outlook
2000 will attempt to resolve it to that contact. If it underlines it green,
it means it found a match. If it und...page setup feature is not working
We have a user at our firm that has Excel 2002. When he goes into page
setup and changes the view to landscape, nothing within the document
actually changes. When you go to print preview, the document is still
in portrait. we have tried repairing the installation of office and
that didn't seem to work. We will try to remove it and then install it
again. I wanted to see if anyone has had this problem before. Thank
I often find that these types of issues are directly related to th
attached printer. Before uninstalling, try selecting a differen
printer (if possible) or verify t...Right mouse click not working
I seem to have turned off my ability to use my right
mouse click in Excel. My right mouse button works fine
in all other apps (Word, Windows, etc).
Any suggestions - I am lost without it.
See your other thread
Regards Ron de Bruin
"Rita" <email@example.com> wrote in message news:firstname.lastname@example.org...
>I seem to have turned off my ability to use my right
> mouse click in Excel. My right mouse button works fine
> in all other apps (Word, Windows, etc).
> Any suggestions - I am l...Exchange SRS static port not working....
I have added in the following registry key onto my Exchange 2003 SRS
Value name: TCP/IP
Value type: REG_DWORD
Value data: Decimal 5002
The server is running Windows Server 2003 Standard, SP1, Exchange 2003
SP2 mailbox server, also has RPC over HTTP configured to static ports
which works fine.
However, after restarting the SRS service, its still not listening on
port 5002, heres an extract below from portqry.exe that shows it
listening on a random port 42203.
Any ideas anyone please???
I havent rebooted ...Working with Footnotes
I am using Word 2003 to create an on line magazine. I do not want the footer
to start on the first page - the cover - how to I stop this from happening?
I tried using "from this section forward" and it didn't work? Thanks for
maybe you can find a
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- Microsoft Partner
~~~~~~~~...Concatenation not working in Excel 2003
I have two fields that I am trying to concatenate. When I use th
concatenate function: =CONCATENATE(F2,E2), it does not show the tw
concatenated fields it only shows the function. The same thing happen
when I do =F2& " " &E2.
I have tried this with several different worksheets and none of the
Any suggestions before I pull my hair out.
gschoser's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1545
View this thread: http://www...No link addresses work when I select them in Outlook.Help please
I would appreciate any help to make any links work that are quoted in
Ian Wallace <Ian Wallace@discussions.microsoft.com> wrote:
> I would appreciate any help to make any links work that are quoted in
If Internet Explorer is your web browser, try this: Open IE and click
Tools>Internet Options>Programs>Reset Web Settings.
...Work order to Purchase Order
We've just implemented RMS 1.2 at our store. I noticed
that RMS can automatically place appropriate purchase
orders for items sold within a specified time period. Is
there a way for items on a work-order that are out of
stock or soon to be below acceptable quantities to be
added to the counts in the purchase orders without manual
I'm editor of the Microsoft Business Solutions Community site
(www.microsoft.com/businesssolutions/community) and we're having a Microsoft
developer from the RMS team answer questions like yours on ITEMS this week.
We'll po...IMF Doesn't work after 10000 UCE's scanned
It seems like when ever the IMF scans about 10000 emails it stops working
because people start receiving spam. Once I restart the smtp then IMF works
Is there a registry setting that will change this limit?
There's no limit on number of messages scanned!
How did you determine this happens after 1000 messages are scanned and the
number of messages scanned is causing it?
MVP - Exchange
NEW blog location:
"JCas" <JCas@discussions.microsoft.com> wrote ...Application.Volatile not working as expected
I have a spreadsheet with some user defined VBA functions. If I bring up the
spreadsheet by itself, everything works fine. If I load the subject
spreadsheet from a "rollup" spreadsheet, (uses the subject spreadsheet and
others like it as input), the user defined VBA functions are not being run -
when using Excel 2000. If I use the same spreadsheet and run it under Excel
2002, the user functions do get run before the "rollup" spreadsheet starts
reading data off the subject. (Functions are defined as
"Application.Volatile"). Why? Is there a work around?
Try a...can multiple users work on same workbook at the same time?
We like to be able to work on different parts of the same
How can this be done? now if one of us is working on it,
others get a message saying that this file is open by so
and so and can only be used as a Read-Only.
Is it possible to have multiple people made changes to the
same workbook at the same time?
A. Thrompian, check out the Share Workbook command on the Tools Menu. It's
just what you're looking for.
"DDM's Microsoft Office Tips and Tricks"
"A. Thrompian" <email@example.com...Outlook Connector Not Working....
This morning Outlook 2003 with the Connector was fine. Now it fails to work.
Allowed the update to download and it said it installed, but I still get the
error message on startup of Outlook. Microsoft...what have you done to my
Outlook? I can't download emails this evening for my business?
Office Outlook 2003. Been using web-based email for several years which
meant I had to employ Outlook connector when setup. This afternoon, I open
Outlook to check enmail and get a pop up requiring Connnector to be upgraded.
I follow promps, it goes through the install, closes the ...Application_Startup doesn't seem to work
I have the following code in Class1 code
Public WithEvents objReminders As Outlook.Reminders
Set objReminders = Application.Reminders
MsgBox "Reminder handler initialized"
Private Sub objReminders_ReminderFire(ByVal ReminderObject As Reminder)
' irelevant code removed
And this in Module1 code
Private Sub Application_Startup()
Dim MyClass As New Class1
MyCl...Disclaimer does not work
I have a problem with the SMTP disclaimer. I did follow the 317680
procedure, I've created the script then I´ve registered with smtpreg.vbs. But
The script was registered in the routing group bridgehead server to avoid
the MAPI problem. (All the servers sent SMTP mail to it and the outsise). At
the same time I'm using webmail (OWA) to forward mail outside the
organization. But the disclaimer doesn´t show up
So I don´t understand the problem. Pls
...Reply to not working
When clicking on 'Reply-To' or 'Reply-to-All' button, not
all names appearing on the To: field. In fact, sometime
none appeared. Any ideas what could have been wrong with
...Money stopped working with WAMU
Ever since Washington Mutual updated their website my Microsoft Money
downloads stopped working with those accounts. I upgraded to Money Plus and
this is still not working. Microsoft Support is non responsive. Can anyone
help me resolve this problem?
> Ever since Washington Mutual updated their website my Microsoft Money
> downloads stopped working with those accounts. I upgraded to Money Plus and
> this is still not working. Microsoft Support is non responsive. Can anyone
> help me resolve this problem?
I downloaded two ...Read Mail button in IE8 not working
I upgraded from IE6 to IE8 today, and find that the Read Mail
button does not work.
In Tools / Internet Options / Programs / E-mail is set as
Outlook Express (same as it was in IE6, where the Read Mail button
Also checked Control Panel / Add-Remove / Set Programs Access
& Defaults / Outlook Express is ticked.
What else should I check or set?
P.S. Using Windows XP with SP3.
Thanks for the quick reply, but tried that and it didn't work.
"VanguardLH" <V@nguard.LH> wrote in message
news:hsnr0n$p6...text wrap options don't work
Suddenly, I'm having 2 problems with text wrapping I never had before.
Situation 1: When I place an image overlapping a text box, the words do not
move out of the way. The image (or another text box, I've tried that too)
just sits there and blocks my view of the words in the first text box. I've
tried clicking on the various text wrap options, but when I choose any of
them (Square, Tight, Through, Top & Bottom, or None) it simply ignores me and
acts as if I have chosen None for everything. Situation 2: For some images
(perhaps the type of image makes a difference) onl...Working with dates and time
I need to calculate the elapsed time in hours from data in 4 date and time
columns (date dd/mm/yyyy format and time in 24 hour format) e.g.
Start Date Start Time Stop Date Stop Time
10/12/2008 15:10 13/12/2008 12:50
11/12/2008 02:00 11/12/2008 16:30
11/12/2008 10:10 13/12/2008 09:00
I need to then be able to find the average elapsed time in hours.
Manually the solution for the above is:
Average elapsed time: 43:40
As I am not used to working with date and time fields, any he...Check Activesheet for chart sheet or work sheet
Is there any method that will check whether the active sheet is a chart sheet
or a worksheet?
You could use the Typename funciton.
> Is there any method that will check whether the active sheet is a chart sheet
> or a worksheet?
...Report view in Listview control not working?
I have a listview control on one of my access (2003) forms.
Currently I am populating the control with all the file and sub-folder names
in my templates directory - using a recursive bit of code that utilises the
I am able to view the results fine if I set the listview's "view" property
to 0, 1 or 2 (big icons, small icons or list). But if I set the darn thing
to 3 (report) I don't see any results.
Has anyone got any pointers on what might be going wrong? (In case it is
relevant, I have not set any column names.)
While I'm at it, has anyone got an...Delay Send Not Working
Delay send isn't working correctly. User creates a
message, clicks on Options, and selects Delay Send until
after date/time. The date/time passes (by a few hours)
and the message still sits in the Outbox.