How to convert thisSQL Statement into a format the MS Access 2003 will accept
Basically I want to write a Between statement in MS Access Design View.
The database is number format. 'yyyymmdd hh24:mi:ss'
This works in Excel but not in Access.
( t3.TRANSACTION_TIME_LOCAL >= (to_date((to_char(sysdate-31,'yyyymmdd')||'
'||to_char('23:59:59')),'yyyymmdd hh24:mi:ss' ))
and t3.TRANSACTION_TIME_LOCAL <= (to_date((to_char(sysdate-1,
'yyyymmdd')||' '||to_char('23:59:59')),'yyyymmdd hh24:mi:ss'))
...Opening publisher #2
Hi, I'm very new at this, so please bear with me. I have
a Dell Dimension computer with Windows XP Home. I was
recently sent an email with an attachment I can't open.
My son, who is something of a computer whiz, says the
file was created by Microsoft Publisher.(I don't even
know what that is) My question is: is it possible for me
to open the attachment, and, if so, how? If anyone can
help me, I'd appreciate it. This is how I learn. Please
respond by email to email@example.com. Thanks, John.
After managing to set up OE-QuoteFix on his new PC, Ed reads a messag...Errors in Outlook 2003
I have upgraded my Outlook to 2003 and am having problems
attaching to my exchange server. I get the error message
that the Default folders could not be opened, and Outlook
will close. If I change the delivery to the personal
folders Outlook will open, but no mail is delivered or
sent. If I try to change the delivery location while in
Outlook I get the error message "The specified default
store could not be opened. Please make sure you can
access your default store and try again.".
If anyone could help me out it would be greatly
Try creating a new mail profile...Outlook Security Template dosen't ask for username & password on sbs 2003
I am trying to use the Outlook Security Template from the Office 2003
Resource Kit to amend the default security settings for all my clients
on Exchange 2003 -
I have install SBS 2003 sp1 with exchange 2003 sp1 using office 2003,
I've download the outlook 2k3 resource kit. Installed the admin pack,
registered the DLL and OCX files, change the registry setting to tell
outlook to look for the security template setting in exchange. I am a
domain admin with owner permissions to the outlook template folder I
created in the root of the public folder.
The steps I've taken are as follows
1. ...WordArt causes Publisher to encouter a problem
I have tried other methods listed on here and have had no luck.
It would seem that when I add a wordart to a file, close the file, and
reopen that file I get this message...
Microsoft Publisher has encountered a problem and needs to close. We are
sorry for the inconvenience.
AppName: mspub.exe AppVer: 10.0.6815.0 ModName: mspub.exe
ModVer: 10.0.6815.0 Offset: 00012ad0
I can open previous files with Wordart but not new ones. I can't recall any
recent changes made to my computer.
I also have received this message on other files I have created but I can
still open them...
Publisher h...Adding hyperlinks with parameters
I have a batch file which needs to be run from an excel sheet with a
parameter, like this:
But when i try to run the Hyperlink, the Excel shows an error message
saying it can't open the specified file (probably because the is a
space between the file and the parameter)
is there any known way to run the link from the excel?
On Mar 2, 12:45=A0pm, Pasha <pavel_v...@mailto.mod.gov.il> wrote:
> Hey everybody
> I have a batch file which needs to be run from an excel sheet with a
> parameter, like this:
> c:\1.bat myParameter
> But when i ...Adding Blank Rows after the last Detail of the Report
I've used this code from Dwayne:
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer
intNumLines = 12
intTopMargin = Me.Section(3).Height
intLineHeight = Me.Section(0).Height
For Each ctl In Me.Section(0).Controls
For intLineNumber = 0 To intNumLines - 1
Me.Line (ctl.Left, intTopMargin + _
(intLineNumber * intLineHeight)) - _
Step(ctl.Width, intLineHeight), , B
My report needs to print blank rows (at least...Error message in publisher #2
When i open my document i get an error message but it doesn't tell me what
the problem is. The message reads: Publisher has detected a problem in the
file you are trying to open. If you are certain that this file came from a
trusted soruce and does not contain harmful information click ok. If you
received this file from another person or machine and are not sure that the
contents are safe click cancel.
I can open the file but the message comes up every time. If it told be what
the problem was that it detected - then maybe i could fix it. I do know that
since the problem started i ...DST update for Exchange 2003 and Outlook 2003
I am seeing a lot of confusion and am trying to provide our Exchange Admin
and Help Desk Staff with some guidance. I would like to confirm the
following order for the DST updates.
1. The Windows 2003 OS on the Exchange Server has already been updated.
All of our Outlook users on on Outlook 2003.
2. We need to run the update against the mailboxes as relying on our users
to do so would be fiasco in the making. Does the Windows XP SP2 instance on
each workstation need updated before we run the update against the
3. We have a group of people whom only use Outlook Web Access ...outlook vcard, ad integration user properties
my boss is trying to get hix fax# in his vcard.
he is using his address from the global address list
I have modified his profile in active directory users and computers: I go
into AD users and computers, double click on his user, go to the telephones
tab, and enter his fax #. but when I did this his fax # is still not being
pulled up in his outlook vcard. Does anyone know where outlook is trying to
get this field from / how i can get this field into his vcard?
...Default PO Price Different From Cost Prices in Item Card
The standard cost, current cost and the orginating invoice cost in the item
card are all the same (£2.11).
When creating a PO, the correct Unit Cost appears as long as the quantities
have not yet been changed. However, once a quantity has been entered, the
Unit Cost changes to another figure (£12.89), which we're not sure where it's
being pulled from.
Has anyone experienced the same problem or have any thoughts on this matter?
If you have ordered this item before from the same vendor, you will have a
vendor item card. That card records the last price...Outlook 2003 changes the outgoing account when unable to send by selected account #2
Hello everyone. I have a problem with outlook 2003. I have multiple
email accounts. When outlook is unable to send an email by the default
account or another account I selected, tries to send my email by
another account and doesn't warn me about that. Does anyone know how I
can set outlook not to change the outgoing account without warning?
...index_files : Directory Publishing Problem
Each time I publish my site to the web using Publisher I have to go into the
index.htm file and remove index_files from the paths (currently about 300
times) This is getting annoying. How do I make publisher do it right?
The other things is it puts all my files in www.a45.i8.com/index_files
instead of using the root path of www.a45.i8.com. Please help this is getting
> Each time I publish my site to the web using Publisher I have to go into the
> index.htm file and remove index_files from the paths (currently about 300
> times) This is getting annoying. Ho...ADDING A NUMBER
how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them
Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.
"Helpme" <Helpme@discussions.microsoft.com> wrote in message
> how do i add a number to a range of cells? I need to add 11.27 to a
> of different cells e...Question abount sent items
I know this is by design but I am asking the question
anyway. When I associate someone elses' mailbox to my
account and send an email on their behalf, Is there a way
to make the sent items appear in their mailboxes instead
Thanks in advance
...Exchange 2003 with multiple site
I have one domain and one Exchange 2003 server. Now we want to introduce
another Exchange 2003 server as a replication server. Can we do that? The
resion we want to do this so some people can access there email via Outlook
express or on there Cell phone using POP3 client.
You can't simply "replicate" Exchange servers. you would need to implement
some 3rd party software to do this. Warning - it isn't cheap.
Is there some reason they can't access the existing server via IMAP or POP3?
Why do you need to install another server just for that?
Ben Winze...adding new records
I am totally new to CRM, so I hope this is really easy question:
This concerns permissions.. I have a "sales" group, and with one of those
people i need to be able to let them add new records on behalf of other
"sales" people. Is there like a standard permission setting for it?
(obviously every "sales" person can add new records if they select them selfs
as the owner)
By default the person who creates the record will be the owner. After record
creation the person could reassign the record (manually) to another user.
If all rec...click on a cell to expand with more information
I am making a phone contact record for work. How can I make a cell (with a
customers name in it) expose more details or information about that customer,
when hovered over with the pointer? I also need to know how to enter the
information to be viewed.
2nd question - How do I create a line between multiple entries for the same
customer and the next customer?
John Doe 05/05/05 123-456-7891 9:00 left message
John Doe 05/08/05 123-456-7891 9:30 left message
John Doe 05/08/05 123-456-7891 10:00 returned call
_____________...Outlook 2003 on XP RPC error
After installing Outlook 2003 on an XP system that was
connecting to Exchange 2000 with Outlook XP just fine, I
get an error starting Outlook stating
"A system component, RPC, required by Outlook to connect
to the e-mail server is not configured properly. For
more information, contact your system administrator."
When I click OK, I get
"The connection to the Microsoft Exchange Server is
unavailable. Outlook must be online or connected to
complete this action."
Then a box to confirm the name comes up and when I click
check name I get
"The name could not be ...When adding attachments...
....in Outlook the following errors comes up:
"Out of memory or system resources, please close some
programs and try again"
Quotas are fine. I have deinstalled/reinstalled Office,
cleaned 'temp' areas, and many other tidbits. Any other
This might help as i had this problem with Outlook 98.
Is the file you are trying to copy to attach nested in sub folders? if so try and copy the attachment to a root drive like c:\
Ignore previous email. wrong spellin
if the attachment is nested in sub folders(this means you have to open different folders to get to ...Connector and Outlook 2003
I've been using Connector with my Outlook 2003 and MSN account since last
summer with no problems till I changed my pw the other day. It seemed to stop
working completely. Removed connector, reinstalled, repaired, got mad, gave
up and now I'm here cause I hate using 2 different programs for my email
(using Live Mail now for MSN and Outlook for gmail and work email). When I
try to add the MSN to Outlook, I get an error that says "The Requested
Operation Failed" and when I try to add it through Outlook Connector by
hitting "Add a New Account", it doesn...Publisher Calendar font changes?
I am attempting to create a six month event calendar in Publisher, I start
with the Understated Calendar template. After completing the calendar
wizard, I start adding events to the appropriate dates, after I complete the
events in the first month, I switch to the second month and add the new
events. My problem is that when I go back to the first month, the font
changes for the first event revert back to the default font, this occurs even
after saving the document. Does anyone have any thoughts how I can prevent
this from happening? I am using Publisher 2000.
Open another instance ...can't expand public folders #2
When I try to expand public folders in exchange system admin, it hangs and
never returns. I would like to understand the cause of this behaviour and how
to correct the problem. Thanks, Brian
...Can receive but not send attachments Outlook 2003
My Outlook at home uses my business server for email. I
receive attachments. When I try to send attachments, the
email does not get sent. I can go onto Microsoft
Exhchange on the web to send attachments through my
office server, and there is no problem. I had the same
problem with my earlier version of Outlook at home
(Outlook 2000). Any ideas?
Do you get any error messages when the mail is mot sent?
This posting is provided "AS IS" with no warranties, and confers no rights
"Doug" <firstname.lastname@example.org> ...5pt space between paragraphs when copied from Word to Publisher
When I copy several paragraphs from a word document and paste it in Publisher
I always get 5pts added before and after each paragraph. Is there anyway to
change this so I don't have to delete the space each time? I have Office
version 2003 and Windows XP.
Paste special as unformatted text... or
Select all, Format, Paragraph, change the before and after.
"BoKay" <BoKay@discussions.microsoft.com> wrote in message
> When I copy several paragraphs from a wo...