queries written inside MS-Access are getting deleted
Some of the queries I have written inside MS-Access are getting deleted
automatically. And while I run the queries through code, I get this error
'Query should have one destination field'
Explanation: I created a query in MS-access. Ran it from the code. Closed
the database. Started it again, and now for that particular query, it is
showing 'SELECT ;' only. Strange. I am in panic mode now
What can be the possible reason?
My first thought is that the database file is corrupt. Unfortunately it's a
type of corruption that Compact and Repair probably won...how to store list of varying types
I am writing a program that parses data found in a proprietary protocol
packet into individual chunks of varying sizes, based on the Opcode tag of
the packet. sizes could be from a single byte to an very large null
terminating string. The parser is part of a pipeline that works on the
incoming packets so that an user at the end can do whatever he/she wants to
do with the data (display it, apply operations, etc)
I planned on creating a ProtocolPacket class that represents an entire
packet, and contains a vector of dataElements. dataElement is a class that
contains a pointer to the data, i...Updating 2004 FI list
Does anyone know how to update Money 2004's Financial Institution list? When
I check to see if my FI is online and supported, it is. When I check the
Money 2004 list, it is not there. Any solutions? Thank you, any help would be
...Get Access Data into Excel
I am using excel macro to get data from access database.
My sql query gives me 5 records or more than that.
I am able to pull it different cells.
But I want all the 5 results in single cell.
im not exactly sure what your trying to do, but maybe something like this
will do the trick
dim accval as string
accval=accval & " " & rs!:xxx
loop it till rs.eof=true
> Hi All,
> I am using excel macro to get data from access database.
>...how can i relate between two columns in two sheets?
Question no too clear - you can use this space to give a detailed question.
But here goes:
On Sheet1 I can type formulas such as
If I type = and then click on the cell A1 of a worksheet called My Yearly
Totals, I will get the formula
='My Yearly Totals'!A1
Note that a sheet name having spaces get surrounded by single quotes.
Does this answer your question?
Microsoft Excel MVP
email address: remove uppercase characters
REMEMBER: Microsoft is closing the newsgroups; We will all me...Deleted Distribution List
Hi , LONG time Outlook user here..and I'm stumped !
I accidentally deleted a Distribution list from my Outlook 2007 contacts
this afternoon. Immediately , I tried EDIT >UNDO , but it was greyed out.
I searched Deleted Items in Mail ( thinking all deleted Outlook items ended
up there ) and I couldn't find it. I searched Personal Folders as well ..but
still no joy.
I ended up recreating it , but the question remains , ..." Where did it go
?? " ( in case I do it again..)
Next time it happens simply restore it from your backup.
What, yo...Word default paper size- networked user accounts
Word 2004- processors various, OS 10.5
How do I get Word to default to A4 (instead of US letter) for networked
The succinct answer to this is "By ensuring that your operating system
locality preferences are set correctly before you install."
Microsoft Office picks up all its global settings from the "Language and
Text" system preferences in OS 10.6 (I think they were called something else
If this has been done wrongly at installation, you need to set the System
Preferences correctly and then delete the individual user's...Programmatically listing Relationships of ADP file
I'm fairly new to access and would like to get a listing of the relationships
in the ADP file. How would I go about doing that programmatically? I
haven't the first idea of where to start. I did find something that said to
loop through the relationships collection, but I can't seem to find it.
FWIW, I'm fairly fluent in Excel VBA.
On Tue, 23 Mar 2010 12:30:01 -0700, Barb Reinhardt
A good start would be to open a VBA window, click the Help button, and
look for Relationships...alphabetical list
ok...I have complied a list of my DVD collection and what I am trying to do
is alphabatize the list. What problem I have when doing it is when I click
sort button it always groups words like "A" and "The". I want it to ignore
those words and focus on the word after "A" or "The"
Create a helper column and add this formula to it
=SUBSTITUTE(SUBSTITUTE(A20,"The ",""),"A ","")
Then sort both columns by the helper column
"Ronnie" <Ronnie@discussions.microsoft.com> wrote i...can't interface
I can see my message with others in my WLM desktop yet can't see it at the
I do not get answers.
how do I set up WlM desktop so i can interface with you?
Comcast stopped newsgroups so i am going directly to m.S.
Please disregard this inadvertant duplication as i made an error which will
not be repeated -thank you for undrstanding.
> I can see my message with others in my WLM desktop yet can't see it at the
> I do not get answers.
> how do I set up WlM desktop so i can interface with you?
> Comcas...How can you see in real time who is sending email
How can I see in real time who is sending outbound email?
Several times per week I have users sending out large amounts of email.
I need to know if there is a way to see who is sending in real time.
Something that will point me to the user(s) doing the sending right now
Thanks for any help,
On Tue, 15 Nov 2005 11:41:45 -0500, "theitman" <firstname.lastname@example.org>
>How can I see in real time who is sending outbound email?
>Several times per week I have users sending out...Can I add additional emoticons to Communicator 2007?
I would like to increase the available emoticons in Communicator 2007. Anyone
AFAIK, you can't but this would be better asked in the Communication server
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?
http://forums.slip...shared email, can't privatize appointments
I have 2 secys who share an email address. THey eachmade an Outlook calendar
for themselves on their own laptop. However they say they can't keep any appt
"private" from the other person--that "private" doesn't work. Is this true,
and is there a way around it?
"kamp" <email@example.com> wrote in message
>I have 2 secys who share an email address. THey eachmade an Outlook calendar
> for themselves on their own laptop. However they say they can't ...Help!!Getting audio files to play continuously during slide show?!
I have Powerpoint 2002, and i am having a hard time getting the music file to
play continuously during the slide show. it plays on the first slide (which
is the only slide that has the little speaker picture on it), but then it
doesn't transition to the next slide until after the song is done, when i
want the song to play while the slides are transitioning. HELP please!
Have a look here and see if it helps, there are tuturials in video
demonstrating the process.
MVP - PowerPoint
"MegaB86" <MegaB86...can't create item
can't create item, when i hit a link to e mail on a
internet explorer . i get the error mesge .cant create
...Can I add a baseline value to a chart?
I have a chart that shows results of tests taken on different dates to show
improvement. I need to add a baseline to the chart showing the Desired
From an earlier reply:
You can add the lines to the chart by using extra data series.
Here is a collection of examples.
Bernard V Liengme
remove caps from email
"Jeanine" <Jeanine@...Event 5895 Error: Can't clean up the following tables: Activity
I have CRM 1.2 and I have applied rollup 2, but it didn't fix this problem.
Thank you very much.
When I do the crmdeletionservice.exe -runonce, it gives med 3 possiblities.
But I can se in the eventviewer that it is the activity table which is the
My only problem is that I don't know how to use the Query Analyzer.
Thanks for you answer, I'm sure thats the sollution.
I didn't know it was that simple to use the query analyzer :-)
I did just as you write in your guide, and it worked perfec...getting addresses from 2000 to 2002
I am having trouble getting email addresses I added in
outlook 2000 on a 98 box to outlook 2002 on an XP box.
We are on an exchange server and for some reason when I
added addresses to my address book they did not get saved
on the exchange server. Now I can't see them on my XP
box. Any ideas how I can get those addresses from my 98
box to my XP box?......thanks....Dave
Where were the addresses being stored were they in the Mailbox Contact
folder or were they in a PAB (Personal Address Book).
"Dave" <firstname.lastname@example.org> wrote in message
news:1bfe401c4217...Can you program Excel to draw an asymptote?
I want to know if there is a way to get excel to put an asymptote on a chart
if you already have a parabolic data set on the chart. My goal is to find to
value of the asymptote for further analysis. I know I can fudge a straight
line graph onto the chart but it is not meaningful without the true value.
"csusbgirl07" <email@example.com> schrieb im
> I want to know if there is a way to get excel to put an asymptote on
> if you already have a parabolic data set ...Best Practices shows 114 GB Database Size limit
I just ran a best practices scan against my Exchange 2003 SP2 Server and it
shows that the Mailbox limit is 114 GB. I though the limit was going to be
75 GB in SP2? The value data in the Database Size Limit in GB registry key is
72 hex. DO I have it configured wrong? SHould it read 114 GB in the best
practices scan? Any help would be appreciated.
72 Hex is 114 decimal...you need to set it correctly in your registry.
"mrjules" <firstname.lastname@example.org> wrote in message
>I ju...can I find merged cells?
I'm trying to sort and get the message "merged cells must be the same size".
How can I 'find' the merged cells?
David, here is a macro by Dave Peterson that will do it
'macro looks for merged cells
'By Dave Peterson
Dim myCell As Range
Dim resp As Long
For Each myCell In ActiveSheet.UsedRange.Cells
If myCell.MergeCells Then
If myCell.Address = myCell.MergeArea(1).Address Then
resp = MsgBox(prompt:="found: " _
& myCell.MergeArea.Addre...Can Access 2007 analyze w/Excel?
I have installed Office 2007 and I am not able to locate the option to
Analyze a report with Excel. I was able to do this with Access 2003 and it
would put all the data from a report into an Excel file. How do I do this in
Access 2007? I do not see the option anywhere after opening the report.
I forgot to mention that when I have the report open, The export to Excel
option is greyed out as is the sharepoint list option right next to it.
"CEV" <email@example.com> wrote in message
>I have installed...Can't read mail in reading pane of outlook 2007 if not in safe mode
I have a problem since I installed the outlook 2007 beta 2. I receive mail
as nice as possible, but when I want to read it, there is only the title,
from whom and to whom data in reading pane. The mesage is, let's say
Anyone have the same prob?
When I start outlook 2007 in safe mode, everything works OK. The only prob
with safe mode is, that you always have to set the reading pane on and hide
the big buttons....
We'll if anyone has a solution...I haven't find it...
In the next week I will reinstall the system and see... maybe, just maybe I
...can't re-call or re-schedule outlook meeting, appointment
Why can't I re-call appointment or meeting, I sent out?
I can't even re-schedule it, reschedule button is greyed out.
What settings I need to look at to enable re-schedule option, if not what is
the purpose of reschedule button in Outlook 2003?
...how do i get font style back on toolbar?
new to this...when i started my document the font style was displayed on
toolbar...now it is not...what do i do and thanks to those who help!!!!!!1
Melissa, try view, toolbars, and check formatting
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"melissa" <firstname.lastname@example.org> wrote in message
> new to this...when i started my document the fon...