Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:
Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
On Apr 13, 12:56 pm, jlt...@hotmail.com wrote:
> I have an append query that I trying to call from a cmd btn...but it
> prompts me for the parameter(ie QuoteID)...
> How do I tye it into my call:
> Dim stQueName As String
> stQueName = "Quote Query"
> DoCmd.OpenQuery stQueName, acNormal, acEd...outlook xp recovered data - from CD
I just received a CD with all of my recovered outlook xp
data from a failed hard drive: how do I move/copy/transfer
the recovered Calendar, address book and contacts,
personal folders, and emails from the data recovery CD to
my existing Outlook folders? Where does that data reside
on my new hard drive (windows xp pro oper system)? Would
very much appreciate any help. Thanks.
"kevinh" <email@example.com> wrote in message
> I just received a CD with all of my recovered outlook xp
> data from a failed hard drive: ho...How do you recover a parameter?
I would like to execute an excel file, for example, with a file name
And afterwards, in that file, I would like to recover the name zz.txt.
Could you please help me?
I'm not sure what you mean by "execute" the Excel file, or "recover the name." It sounds as
though you want to make a txt file from the xls file. If so, you'll need to open it in
Excel, then do File - Save As, with the file type set to txt.
&...Recover live calendars?
Someone was helping me cleanup an old laptop and they deleted important
calendars from my WLM. I have months worth of appointments and need some
Thanks (I hope)
Did you sign in to Live services in WLM? It will not say Sign in below the
Close X if you are signed in. calendar.live.com will have the calendars
that will sync back to WLM the next time you connect with WLM.
MS MVP- Windows Live Mail
"nimbus" <firstname.lastname@example.org> wrote in message
> Someone was helping ...Recover !!
Ok i updated my old outlook and because it was too much
for my system (like all windows updates) i uninstalled
oulook then reinstalled the old version now i have none of
my old emails and there not in my hotmail either and they
were going into both, hotmail and my outlook ~ so can
anyone help me? or is it lost forever
What is the version of your old Outlook?
Try to search *.pst file
"Robin" <email@example.com> wrote in message
> Ok i updated my old outlook and because it was too much
> for my system (like all windows upda...Yes/No parameter for Yes or No or Both
RonaldoOneNil gave me the very useful info of:
=IIF([Enter Yes or No]="Yes",True,False)
for a parameter query criterion (for a check box in a form).
I would like to know if I can enter Yes or No AND have the option for both.
Presumably it would be in the Or row, but I don't know what to enter.
Thanks for any help.
Can you explain what you are trying to do with some examples?
Build a little, test a little.
> RonaldoOneNil gave me the very useful info of:
> =IIF([Enter Yes or No]="Yes",True,Fals...Pass Parameter from Excel to SharePoint
I’m trying to open an Excel file from SharePoint. Here is a the scenario.
I’d like to be able to pass a parameter from excel to SharePoint, and have
SharePoint identify if the file exists on my SharePoint site. For instance,
here is the generic URL:
What I want to be able to do is pass a file name as a Parameter, and open
the appropriate Excel file with the same name, so it may be something like
It will always be the URL and the w...Subreport always appears blank (even during basic testing with no parameters!)
I have a subreport in my report that takes a set of basic parameters.
It does not appear on my main report when the main report is run.
As a test, I decided to create a simple subreport with no parameters
and only a text field. It also does not display on my report.
As a further test, I decided to create an entirely new project with
only a main report and a subreport that displays the word "test". It
will still not display on my main report.
There are no errors at any stage. Does anybody have any idea as to
what could be wrong?
Is it not working in preview tab...Recover Unsaved
I need help. Excel closed without saving what I was working on now I need to
You do not say how Excel closed or what version you are using. The later
versions have an AutoRecover feature.
If you closed Excel without saving the file, you may not be able to recover.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
"Tori" <Tori@discussions.microsoft.com> wrote in message
>I need help. Exce...Help! I accidentally deleted emails that I desperately need to recover... Any suggestions please?
Desperate here! I have used LACIE back up, does it save emails?
On 1/26/10 10:20 AM, in article C7847266.27FB9firstname.lastname@example.org, "Gavin
Wilding" <email@example.com> wrote:
> Desperate here! I have used LACIE back up, does it save emails?
It depends on what you backed up. Without more details, we can't help.
You can use Switch Identity to access data in a second Identity.
Diane Ross, Microsoft Mac MVP
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
YouTalk <...Recover junk mail
How can I recover all of my mail from the junk mail folder that I mistakenly
afaik...locally emptying or purging the junk mail folder is permanent in WLM(and also if using WLM for http access to a Hotmail
If Pop3, access the web server holding the account to determine if the messages are present(ymmv) in the web Deleted folder.
"Justin" <Justin@discussions.microsoft.com> wrote in message news:18654186-1254-4406-9DAF-22B213E775D4@microsoft.com...
> How can I recover all of my mail from the junk mail fold...Recover
I set up my labtop for pop 3 mail. I like keeping almost
all of my e-mails on the webmail server so I can refer to
them. After I received the messages from my labtop, all
the messages on my webmail were gone. I empytied the
deleted items folder also on my labtop. Is there any
kind of folder that they go to on the computer that's
hidden before they e-mails are complety taken off the
computer. Also is there a way to pull them off of the
The messages are gone, unless whoever provides your webmail has a way for
you to get deleted messages back - ask them. In the fu...Is it possible to recover a file that's been saved over?
I'm sure I already know the answer to this question, but I
have to ask anyway. I was working on an Excel file
containing very important information on my laptop. I
wanted to save the file to my thumb drive in order to
create a backup copy. I recall being prompted by the save
action to replace the existing copy, which I assumed was
referring to the old copy that was already on my thumb
drive, so I selected the "Yes" button. Now that I've tried
to open the file on the laptop, I realize that it now has
the old copy. Basically, I saved the old version of the
file on top...Recover Outlook Tasks
I use tasks as a to-do list and have a problem with some
tasks that have been deleted by a synchronisation.
I sync a PocketPC2002 pda with a notebook and a desktop
both running XP Outlook 2002.
I didn't realise when doing a recent sync (ActiveSync
3.7.1) with the notebook that many of my tasks were
deleted. Before realising I synced with the desktop so
now none of the three devices have all my tasks.
Is there a way to recover them? There is nothing in the
deleted folders or archives.
Thanks in advance...
Did you have a backup of your PST file, presuming you use a PST file? If
...SRS Report Parameters
I have recently taken over CRM administration from a resource that left the
company and am trying to figure out why he did what he did and how to make it
function now that we've upgraded from CRM 3 to 4. We are using SRS 2005.
This guy has report parameters called CRM_URL and CRM_FilterText that are
not nullable but have no default value either, so they will not work in CRM.
I see what he is doing with CRM_URL; he uses it to hyperlink from the report
to a record in the CRM implementation. But I don't know how it gets
populated, and I can't build the reports until ...recover account
I removed an account in WLM, and lost a lot of message.
So can I recorver them.
Please help me.
If this was a pop3 account, then no. Removal of an account in WLM deletes the account and all stored messages from one's hard
To remove an account, one has to answer yes to a prompt for deletion. WLM's prompt explaining the deletion could be improved upon
making it much clearer on the impact.
Here's what the prompt stated
Are you sure you want to remove the <account name> account ?
If this account is set so that messages are delet...Report Chart With a Parameter
I have many reports where users select the parameters via a form.
Im wanting to create the graphs on a report but i get an error when trying
to load the graph;
"MS Access Does not reconise 'Forms!RptDataPicker!ComboCategory' is not a
valid field name or expression"
'Forms!RptDataPicker!ComboCategory' is the parameter in the query behind it,
Query works fine on its own.
is this just down to Access poor charting on reports?
(im using Access 2007)
How do I restore some messages that suddenly disapeared,
to an individual mailbox from a backup?
Did you have deleted item retention turned on?
If so, you can recover it from Outlook.
If not, do you have a brick-level backup?
If so you can restore the individual item.
If neither of the above, you will need to create a recovery server to
restore the database to and export it.
163713 XADM: Recovering a Single Mailbox from the Online Backup
Michael Barta [MSFT]
Microsoft Exchange Support
Please do not send e-mail directly to this alias. This alias...The Parameter error
Hi all, I am facing the problem with two users, they are able to create
account, but they cannot view there previous accounts. The error message
says that "The Parameter is incorrect" and the querry string in CRM says
"_grid/grid_container.aspx?viewid=&gridId=crmGrid" The stack trace says
error at "Microsoft.crm.Controls.GridContainerPage.ConfigureGrid()" and
load() methods of the same has error.
this Error is happening with only two users as I have 30 users, and 28
users dosenot get this error. Please give me some solution for the
problem. thanx in advance
...I need to recover my .pub files after re-installing xp...
Hi there. I am wondering if anyone knows of an easy way to recover my .pub
files from my hard drive? I had to re-install my operating system, and lost a
few REALLY important files.
Any leads on a fix / product that does this would be appreciated, and free
options would be really helpful.
> Hi there. I am wondering if anyone knows of an easy way
> to recover my .pub files from my hard drive? I had to
> re-install my operating system, and lost a few REALLY
> important files.
> Any leads on a fix / product that does this would be
> appreciated, and fr...Need variables for rpt parameters
Hi everyone!!! Hope your holiday season is going smoothly. I'm using A02 on
I have a query that pulls the data I want from my table. I have a report
with the fields on it. I have a form with no record source and the following
[BeginDate] and [EndDate] date fields - These should pull All [TDATE] from
[BeginDate] to [EndDate]. If the fields are blank, ignore and move to next
[PolicyNumber] text field with input mask '000000' - First I need to 'pad'
the letter 'E' to the front of [PolicyNumber]. Then this should pull All
[POLICY] t...Recover previous version of a file?
I sorted a portion of an Excel file to print it and found
that the whole file had been sorted so columns don't
match part way through. It was shut down and restarted.
Any way to re-organize to the original format? help
I seem to be collecting a huge amount of 'recovered folders' in my live mail
inbox. So, firstly, why are they recovered and secondly why do they keep
Wrong newsgroup (this one is for Vista's Windows Mail - not Windows Live
Mail) . . . try this one . . .
"red devil" <red firstname.lastname@example.org> wrote in message
> I seem to be collecting a huge amount of 'recovered folders' in my live
> inbo...recover deleted email #3
is it possible to recover deleted email from a pst file before the file has
been compacted? it seems since until you run compact the file doesn't get
smaller the information mut still be there.
No exchange server by the way. just email in local pst file.
Did you try Recover Deleted Items by right clicking on the deleted items
folder. This may be only available if you have Exchange.
President, San Diego Outlook User Group
"Joe" <email@example.com> wrote in message
> is it po...use parameter in getpivotdata
im using excel 2003 ,i cannot get the required data when using getpivotdata
at ALL ,i've tried many ways , really need help especially on using a
All i need is to get the data about 1SunDAY and DEPOT from the pivot
Sum of CountOfEQ_NBR
POW_ID xxouttime Total 1SunDAY DEPOT
DEPOT 1SunDAY 12
DEPOT Total 331
Q01 1SunDAY 7