Query Delete and append
I am trying to add information to a table with an append query and that works
fine since I duplicated the table. The information comes from a linked XLS
sheet, I need to delete the information and replace it every day. When I
created a delete query it works fine but when I try to add the information
again using the append query it does not work unless I open the query in
design view, save it and run it.
I have dozens of other queries doing the same and they all work fine.
What am I doing wrong? I looks like I am getting a 3349 error but why does it
work once and then when I delete the ...Run macro for each record in a query
I have a table [practices], which contains details of 'client
organisations'. From time to time I need to send an email to certain 'client
organisations'. I have a macro called 'send_emails' which uses the
SendObject command, which I use to send the emails (a button on a form runs
the macro). The emails include a report that is specific to the 'client
organisation'. Currently I select the 'client organisation' with a combobox,
run the macro, select another 'client organisation', run the macro again,
It would be extrem...Formula Help?
How do I express the following formula?
If C1, D1 and E1 equal values in Q1:Q12, then W1=HHH,
If C1 and D1 equal values in Q1:Q12 and E1 equal a value in R1:R12,
If C1 and E1 equal values in Q1:Q12 and D1 equal a value in R1:R12,
If D1 and E1 equal values in Q1:Q12 and C1 equal a value in R1:R12,
If C1 and D1 equal values in Q1:Q12 and E1 equal a value in S1:S12,
If C1 and E1 equal values in Q1:Q12 and D1 equal a value in S1:S12,
If D1 and E1 equal values in Q1:Q12 and C1 equal a value in S1:S12,
If C1 and D1 e...Nz Function 10-08-07
I am using the Nz Function it work fine but my Currency is now gone how can i
get the currency format to return?
SELECT qrySubCost.Division, qrySubCost.Carrier,
Nz([Cumulative_Impact],"N/A") AS CumulativeImpact
Are you using this query as the record source for a form or a report? If
yes, you can set the Format property of the control that is bound to the
CumulativeImpact field -- however, note that you're putting a text string
("N/A") into a format for currency .....
<MS ACCESS MVP>
"Octet32" <O...Help : Deleted Items Retension
Someone deleted something out of their deleted items late yesterday and
wants it back badly.
Where can we check the deleted items retension settings, if any ?
What's the procedure for making these deleted items visible so they can be
(Exch 2k/outlook 2k environment)
Thanks a lot.
The Deleted Item Retention setting is in the user Properties in Active
Directory Users and Computers, on the Exchange General Tab under Storage
Limits. You would need to deselect the default and put a figure in the "keep
deleted items for (days" field.
Once you have enabled it; then...instr for select Query
I've rersearched this forum extensivley and get the idea on how to do
it but don't have enough experience to make it all the way.
In a MS Access select query, I have a field that returns names in the
;#Lastname1, Firstname1;#Lastname2, Firstname2;#
I can't seem to sting the instr, len etc, functions together properly
to clean up the string to:
Lastname1, Firstname1; Lastname2, Firstname2
I've seen the Microsoft examples as well, I think I have to parse
through it to break it up then concatenate back together the cleaned
names, but the closest I can g...Appending worksheets
I have a huge workbook with some 200 worksheets (Excel 2002) and wouldlike
to create one single worksheet by appending the data on all worksheets one
after another. Is there an easy way to do this without programming a macro?
Thanks so much.
Provided the total data rows do not exceed 65535 (assuming a standard top
row for col labels), one way would be sequential manual copy > paste into a
single new sheet placed to the left of the 200 source sheets. At an est 15
sec per manual op, 200 sheets would only take roughly an hour of work to
Thereafter, to clean up, jus...Help Desk Features
Has anyone used the Microsoft CRM for Help Desk in addition to its core
functions? Can the tool truly be a helpdesk tool out of the box for a small
company? I am in need of simple call tracking features with the ability to
develop more as well. Thanks.
I'm interested in this as well if anyone can provide any info...
...Macro to change pivot field with latest value 02-19-10
Hi there and thank you advance for any help.
I have written a macro that changes (hides / shows) fields on a pivot table.
On of these changes the field used for the page fields section of the pivot
table. However, when i add a field to this section, it defaults to All. How
can have this field default to the latest value in this field.
Let me explain further: I want the pivot to be shown either by date or by
week. The macro then changes the page field section to show either the date
or week field. If the date field is selected, I would like the macro to
change this to the late...Append and Append To priviliges
Anybody know what these two priviliges do for a record??
Append allows a user to be able to add items to an object for example you
can append an address to an account.
Append to allows a user to append this object to something else. You would
need append to priv on the address object.
They work together.
"Jay Mehta" <email@example.com> wrote in message
> Anybody know what these two priviliges do for a record??
So, in the example you gave of appending an Address object to an
Account object,...lost e-mails 08-17-10
I set up a folder for each month to save the e-mails that I receive. These
are extremely important to my business. Are there any way for me to retrieve
these. Also, why would I want to compact my e-mails and if I do can I
"Annie" <Annie@discussions.microsoft.com> wrote in message
> I set up a folder for each month to save the e-mails that I receive. These
> are extremely important to my business. Are there any way for me to
> these. Also, why would I want to compact...I need help with MFC and Crystal Reports 9
I have created a VC++ 6 application using MFC. I have created my reports in
Crystal Reports 9. Now I am having a problem on how to have my application
call the crystal reports. I know that I need to create a class for printing
and for previewing the cr reports. What .tlb do I need to use to create the
problem COleDispatch derived classes? I have used CR with VB but using it
with C++ seems to be a whole lot different.
...Creating A Search Database..Need Help
Hi, i need help creating a search database using excel lookup functions
vlookup, match and index. The criteria is below:
I have a sheet filled with data. Data Sheet:
Title, Season, Air Date, Star Date, Synopsis (Respectively. Data i
sorted alphabetically by Title)
I have to create another worksheet, in which a user types a Seaso
number, and the formula will display the related results. For example:
User types in Season 1
Title Air Date Star Date Synopsis
Pilot xxx xxxx yyyyy
New aaa bbb zzzz
--...Why do Outlook folders and emails disappear !!? HELP!
I have Office 2003 on Windows XP: I create personal folders, move emails in,
and all are gone later (didn't even shut off computer). Inbox emails also
disappear and I believe I've correctly disabled the Auto Archive. I am a
business and this is a serious loss of needed emails and information! Please
> I have Office 2003 on Windows XP: I create personal folders, move
> emails in, and all are gone later (didn't even shut off computer).
> Inbox emails also disappear and I believe I've correctly disabled the
> Auto Archive. I am a busine...call function in query
i want an query function to have serial numbers between two pre said numbers
like between 100 and 105 = 101,102,103,104,105.thus i created an function
in standard access module .
public function _ foils(firstfoil as int ,lastfoil as int) as integer
for foils = firstfoil TO lastfoil step 1
IN query window it appeared as foils( <firstfoil>,<lastfoil>)
while accessing and running on QBE window and while runnig query
error accoring as "undefined function "foils" in qbe
how to build query f...Querying
I have been playing with MS Query in Excel2000, and have
noticed that when I type data that contains both numbers
and letters, query doesn't recognise it and does not
I have tried to format the cell so that it is recognised
as text but still it does not recognise it. It is also
interesting to note that MS Query puts a decimal point and
a 0 behind the data that are numbers.
Please tell me what I have to do to make MSQuery recognise
data that contains both numbers and letters
...Help with Test
I am trying to complete a test in MFC (which I am not very familiar with).
Any help would be greatly appreciated!!!!
� Create a grid of 20 Columns by 50 rows. Marks will be deducted
for using the Microsoft Flexgrid control.
� Each cell in the grid must display a random value between 1 and
� Each cell in the grid must allow for a threshold value to be set.
� If a threshold value has been set for a given cell, the cell's
background colour should adhere to the following conditions:
If the random va...Running low on storage on a Ex 5.5 bridgehead server, need help qu
Our environment is a multi Exchange server , with a mix of E2K3 and 1 Exch
5.5. The storage issue is on the 5.5 box. The 5.5 box is setup as a
bridgehead server without any recipients. Any incoming external email comes
through the Exchange 5.5 box 1st. I have noticed that the priv.edb is 24GB,
and the pub.edb is 68MB, 326+ edb logs. Should the priv.edb be this large,
especially since there are no mailboxes stored on this server? Should we be
having that many edb logs? Would it be safe if I were to stop the Exchange
related services, and rename both priv and pub EDBs, and then restart th...Re-Post Append to Append Query
Awhile back, I posted about the following:
Have a main form and sub form.
When generate a new form, fill in the main form and tab to sub-form, an
append query is executed that populates the questions and possible answers
for the questionnaire selected in the main form. The user then selects there
Now, however, additional questions have been added. This means I need to
execute some kind of additional append query that will ignore question ids
that have already been populated, and add new ones.
As he so often does, Allen Brown very kindly posted responses and I ha...append query with dtae and username
I am using an append query to add a new line to my table - one of the field
in this table is "Update_Date" and one is "Updated_By".
How via this query I can populated those two fields with the current
date&Time and current username of the user .
Please ignore- wrong Group, sorry
> I am using an append query to add a new line to my table - one of the field
> in this table is "Update_Date" and one is "Updated_By".
> How via this query I can populated those two fields with the current
...Excel help and advice needed please
I'm not very good with Excel, which must be obvious or I wouldn't be asking
for help would I?
I have a spreadsheet which has grown to hold 23,562 data entries from 7888
name categories, and I need to trim it by deleting old and excess data.
Doing this manually will take too long to consider doing it on a regular
basis, and there must be some method of speeding the process up.
I can manage to get the data into alphabetical and date order, and run the
subtotal tool to show how many entries are under each heading..
The smallest entry is 1, and the largest entry found so far is 17....Help: Shortcut for editing a calendar series
When I want to edit an entire series of calendar events, I have to go
through the annoying 'do you want to edit this occurrence or the entire
series' dialog. Does anyone know if there is a keyboard or mouse/key
combination that opens the series for editing without the dialog? Thanks
for an advice.
You'll only have to deal with the dialogue once if you want to "open the
series for editing..." So I don't understand your question.
What are you trying to do? Edit each separate occurence or "edit an entire
series of calendar events"
MVP...need a bit of help programming
hi i am trying to build a program for basic accounting based on an ol
dos program which i used to own 12 years ago!
i cant find it anymore so im trying to build this program in excel an
i have most of the work done but i need help sorting the basic data
all the framework is there for inputing the data around a cashboo
principle using item codes as keys for manipulating the data later on
trouble is i dont know how to do the manipulating to get the seperat
data out and sorted
the file will be available for download if anyone would like to take
look at it:
email me at firstname.lastname@example.org a...formula needed 02-07-10
I am looking for a formula and this is really stumping me. I have a
worksheet that has one column w a name and one w a date that of things given,
since the name can be on their numberous times as can the date, I need to
find a formula that will look to see if the cell above is the same or not and
count only if it is different, (which I have that formula) however, I need to
go a step further, because not all the names recieve something on the same
day, so I need it to if the cell is blank then to leave it blank. How can I
do this in ONE formula....so, in short I am looking at so...Group by Range in Crosstab Query
I have created a crosstab query which displays the number of days from
referral to consult. I want to groups the days into ranges (0-14 days);
(15-21 days);(>21 days), etc. and show total unit numbers based on that
range. The sql statement currently reads as follows:
TRANSFORM Count(qryWaitTimesMOReferralToConsult.Unit) AS CountOfUnit
SELECT qryWaitTimesMOReferralToConsult.[Ref To Consult (Days)],
Count(qryWaitTimesMOReferralToConsult.Unit) AS [Total Of Unit]
GROUP BY qryWaitTimesMOReferralToConsult.[Ref To Consult (Days)]