How to autofill a sequence
How can I autofill a sequence like the following.
I would start with:
..... and it would contunue to autofill....
Can this be done without vba coding?
Greatly appreciate any help.
1 Select the relevant range you that already contains the series.
2 With the range selected, point your mouse over the bottom right corner of
the last cell in the range.
3 Right click your mouse and drag down as far as you need.
4 Release the right mouse button and you should be presented with a number
of options - select "Fill Series"
XL200...Fewer records after UNION?
I am using Union to bring two tables together. Before the union, one
query has 1500 results and the other 97. After the union I have only
1350 results. I should have 1597. What could be the reasons behind
receiving fewer records after a union than what each of the union
members have before the union?
Sean M. Severson
UINION eliminates duplicates.
Try using UNION ALL instead, and see whether you get 1597.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"NerdRunner" <email@example.com> wrote in message
news:1187955413.049914....validating xml defined by DTD
I want to bypass the dtd validation that child elements must appear in
a certain order ...
In a DTD child elements that are defined and seperated by commas they
must appear in the same sequence in an xml file in order for the xml to
be valid ...
eg if the dtd defines an element Parent with two child nodes
<!ELEMENT Parent (a, b)>
Then the following xml is valid
but the following xml
is invalid ...
Does anyone know of any wa...Event ID MSExchangeSA 9097
Anyone shed any light on the following event i've been having every 5
minutes for the past few MONTHS!!
Event Type: Error
Event Source: MSExchangeSA
Event Category: Monitoring
Event ID: 9097
The MAD Monitoring thread was unable to connect to WMI, error '0x80041006'.
For more information, click http://www.microsoft.com/contentredirect.asp.
this link might help
Dirk van Mierlo
"Dan Williams" <dan_williams@newcross-nu...Please help! Only Recording Sound Missing- wtf?
Ok so I can hear everything - except what's being recorded. Not the most
technically with-it so bear with me. OS is Vista home basic and sound card is
the preinstalled VIA. System sounds are fine, all playback is fine. When I
record I can see it being monitored - I can save it, and play it back without
problems. However - I can't hear it when it's BEING recorded. Checked in
device properties via control panel and nothing wrong - can see the sound
I had installed and uninstalled a number of sound-recording and related
software over the last 6 months or so and...Times out of sequence
In Access I can use the DateDiff function to calculate the difference of
time between two times and it will also show negative time! in excel I have
only been able use if(time1<time2,1+time1-time2,time1-time2). Could I
somehow use automation to access that function... ? or is there an easieer
way in excel to show negative time!
If you use the 1904 date system, Tools>Options>Calculation>1904 system, then
you can display negative times.
Be aware that there is a difference of 1432 days between the 2 system's base
dates, so do not mix dates in the same workbo...Offline Address List Error
one Exchange 2003 Sp2 server
This is a hosting environment with several companies.
Category: OAL Generator
Event ID: 9337
Here is the Event Id Description:
OALGen did not find any recipients in address list '\"Name of address
list"'. This offline address list will not be generated.
- OAB_"name of address list"
As a result of this there is no way of logging inn from an outlook 2003
client if you are a member of the address list metion in the event id.
The error from the user side is:
"The name could not be matched to a name in the ad...opening an excel file opens a duplicate file of the same file
i have an excel file that when i open it it opens another duplicate file of
the same name with a (2) at the end of it.. if i edit one it updates the
second.. how can i tell it to not open another duplicate file?
It's actually opening a second window into the single workbook.
Select the window you don't want to see and hit ctrl-w.
Then save the workbook (or you'll be doing it again when you reopen the
> i have an excel file that when i open it it opens another duplicate file of
> the same name with a (2) at the end of it.. if i edit one it upd...Activity sequence in CRM 3.0
I have got a problem in CRM Cases, I want the following procedure occures
when a case is created until it resolves:
1- Support-1 create new case and fill primary field and problem description.
2- After filling General field in Case information, this fields must be read
3- Support-1 should try to resolve this case otherwise he assigns it to
4- Support 1 and 2 must register all activities pursuant to a
5- Each step in this rule must be registered in CRM as an activity but these
activities have sequence and serialization.
Now, my proble...Event ID 1000
I am getting to following error when I open Outlook XP:
Event Type: Error
Event Source: Microsoft Office 10
Event Category: None
Event ID: 1000
Time: 11:13:16 PM
Faulting application outlook.exe, version 10.0.2627.1,
faulting module mso.dll, version 10.0.2625.0, fault
For more information, see Help and Support Center at
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6f 75 74 ure out
0018: 6c 6f 6f...All Day Event
I have more than 11 items scheduled as All day events.
I can only view eleven of them in the Calendar View.
How can I view more than eleven items - is there a
What is your screen resolution, upping it to 1024 x 768 should allow for 16
<firstname.lastname@example.org> wrote in message
> I have more than 11 items scheduled as All day events.
> I can only view eleven of them in the Calendar View.
> How can I view more than eleven items - is there a
That worked - Thanks
>-----Original Mes...Using email to update Table records
Wasn't sure exactly where to post this so here goes:
One of my employees is trying to utilize the functionality in Access 07 where
she can create an email that allows the recipient to make updates to a tables
record then emails the new info back and that updates the databases' table
accordingly. The problem is when she creates the email (using the Create
Email button on the External Data tab) the email includes every record in the
table, she only wants to send out one particular record in the email and
doesn't want the recipient to be able to see all the other record...event id 4879 MSDTC Client 2
I have a problem with an application on a windows server 2008 r2. This
application works ok on all clients running windows x32. But when I run it on
my server it crashes with event id 4879 MSDTC Client 2 encoured a problem
contacting the server itself. I've tried the binacle to set permissions to
network service also change and tried almost every settings under dtc in
dcomcnfg. I'm no expert at sql and get no help from the developers of the
program. It can be some new securitything in R2 server or is it that it's x64?
Glad for help and tips asap.
Best rega...record replication ?
I have a little problem that has been bugging me for quite some time
I have got a table of retail stores and their addresses of with theses
and some other less important here
So if a store only occupies one adress (say 25, Main street) his adress
number will be in NoMin field
but if a store occupies more than one continuous adress (say from 25 to
31, Main street) it will have 25 in the max field and 30 in the min
The parity field says if the interval contains only even number, odd
number or both.
what i wa...How do I create one record using multiple relationship tables?
I'm trying to create a query using different tables to create one summary
table for a mail merge. But when I did the relationship I got 6 record for
the same person and I want to send just one letter with all the information
for each person.
...Add events in 2003
Added events but only added to the year 2007. None for 2008 and beyond.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Poll: What version of Outlook do you use?
"Phippsy&quo...Recording Soundtrack in slide show
I am using PP 2002 and have put together a 25 slide, slideshow. I have been
able to add a soundtrack to it and it works great on my computer. Went I
send it, it goes without the soundtrack.
How do I get PP 2002 to include, embed or transfer the sound track I thought
I had recorded. It appears as thought the sound icon is just a link to the
file on my computer.
Any help would be appreciated.
I have received PP slideshows with the back ground music or a soundtrack and
they have played on my computer without andy root sound file.
If you have a wav format sound file you w...Prevent entry of duplicates
I would like to prevent the entry of duplicate records in a table. Sounds
simple enough, but here's the catch:
1. The duplicates I'm trying to avoid are a combination of 5 fields
2. This is database with a SQL backend
I have tried to create a unique index based on these 5 fields; however, when
I use the upsizing wizard, I receive an error and this index does not make it
to the SQL server.
I know that I should try to keep things like this at the lowest level
possible (i.e. table), but was wondering if anyone had any suggestions about
how to do this from the form.
For...how to prevent duplicate message in a PST for Two Different Computers?
I tried to synchronize my email through copying a PST from my desktop to my
laptop. but when I opened the PST in outlook2003 on my laptop and connected
to internet, outlook always downloaded all the message again even if PST has
all these messages. so I have to delete all the duplicate message. it is a
pain to do it manually everyday.
I think one way is to delete the message on server once it is downloaded to
local computer. but I can not do it since I need to keep some important
messages on server.
any comment is highly appreciated.
John Kerry <email@example.com> wrote:
After I transfer Offline Address List from Exchange 2k3 to Exchange 2k7, I
got a warnning Event 9320 on Exchange 2k7.
It seems the limitation is too low to some objects, it's easy to change OAL
Generator to Medium on Exchange 2k3 by System Manager, but how can I do it
on Exchange 2k7? Definitely, System Manager doesn't work on it, and I check
Get-OfflineAddressBook, there is no setting about OAL Generator.
Any suggestion? Thanks.
MCSE+Internet, MCDBA, MCP
This is a multi-part message in MIME format.
Content-Type: text/plain...Sharing Record
Our client has requested that for CEO, he/she should be able to see the
records that have been assigned and owned by particular users. How to
accomodate this request beside asking the users to log on using their
take a look at accounts for example
you could create a report that gives you a list of users and when you choose
a user you will get a report of the accounts they own. Or you could simply
have a report that lists all reports and shows the owninguser etc. Its late
so there may be a better way :-) but this is an easy solution
of course if its a one of reques...Sequence with schema designer
I designed a schema in VS C# 2005 Express and am wondering why it
chooses to place a sequence tag around the elements of a table. And
additionally, if I move the elements around within the table, the
sequences in the *.xsd are not rearranged, but are left as is(in the
order in which the elements were created in the table).
Being a noob to xml, I'm just wondering:
1. Why is the sequence tag automatically added?
2. Why is it not updated if I change the ordering of elements in the
This is the xsd file:
<?xml version="1.0" encoding="utf-8"?>
<xs:schem...Moving to last record in a subform.
On my main form after the last combo box is populated I display my subform,
and I want to move the last record.
After searching the web I found the following code and tried it, Even though
the subform is populated (subform is based on a query matching values on
it never prints the debug message.
If i REMOVE the if statement i.e. not checking the number of records within
the subform it throws an error "3021 : No current record" this happens once
then the program can continue to run and display rows in the subform but
still never moving to the last row.
...how to synchronize OnReceive Event of CSocket object,
I need to synchronize OnReceive Event of CSocket object, in my SMTPGateway
any sample/url..........on this...
thanks in advance
thanks for ur interest in solving my problem....
I will tell u the exact scenario....
void CClientSocket::OnReceive(int nErrorCode)
const TCHAR THIS_FUNCTION = _T( "OnReceive" );
if( bInProcess )
bIsOnReceive = true;
bInProcess = true;
bInProcess = false;
..."Find an event" feature in the Windows Live Mail/Calendar
In the Windows Live mail it is quite simple to "Find a message" as we type
something in the search box and enter. But, I do not see any search box with
the Calendar. Are there any ways to "Find" something in the Windows Live
Calendar? Looking forward to hear from someone. Thank you.