Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...MS Office 2008 home version with Pro for entourage
Hello and thanks for any help you can provide.
I have MS Office 2008 Home & Student edition. I want to install only
word, excel and powerpoint and then separately install Entourage 2008
Pro (as provided by my hosted exchange co.) in order to connect to my
exchange server. I have done this before and remember some convoluted
errors but it eventually worked. My latest attempt did not. Has there
been a change to prevent this from working?
...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
I don't understand how these work. We sell bundled services and although I
can set them up in the CRM, how do the services you add to your kit product
show on your opportunity or order?
The kit almost act like any other product record - it won't break into its
various components "line item products" automatically via out of box. It
does give you the logical tracking of other product "bundle" behind the
scene. Not much intelligence beside that.
Some things to consider:
1. Does this integrate with ERP, like Great Plains - the integration does
impa...Using atl based win dll with CString functions from the mfc projec #3
I have atl based general windows dll with class which contains functions
which uses CString as parameters or return values. This dll might be used
from the atl or mfc project. Dll can be used from ATL project without
problems but whenever I try to use this class from the MFC project I get the
following linker errors:
error LNK2019: unresolved external symbol "__declspec(dllimport) public: int
__thiscall MyClass::AddMenu(long,class ATL::CStringT<wchar_t,class
StrTraitMFC_DLL<wchar_t,class ATL::ChTraitsCRT<wchar_t> > > const &,long)" ...
If I replace CStri...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Opportunity Product
I have a question (or problem, I don´t know), in the Opportunity Product
form, I need to add a Percentage disccount instead of an Amount
(manualdiscountamount field), is this possible?, if yes, how can I do it?.
This is very urgent for me and I´ll really appreciate any help.
Thank you in advance.
On Apr 20, 2:51=A0pm, AlexMC <Ale...@discussions.microsoft.com> wrote:
> I have a question (or problem, I don=B4t know), in the Opportunity Produc=
> form, I need to add a Percentage disccount instead of an Amount
> (manualdiscountamount field), is this po...MS Excel Print setup
When i save a document by using landscape setting,& by
opening again that document it does'nt show saved setting.
It shows portrait option,not landscpe option.
...using vba so search multiple Sheets
i'm trying to search across multiple sheets based on data submitted via an
input box. So essentially, you click the button, a box appears, you type what
your looking for and if it finds it, it'll select it otherwise a error
i found the below code, but it only works if the cell with the value in it
is active (i.e. i've clicked on it).
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer
On Error Resume Next
currentSheet = ActiveSheet.Index
datatoFind = InputBox("Please enter the value to search...Not using zeros in graphing.
I have a running workbook that has tons of information. I have added a sum
page in order to have all the data summed up in one simple place. I have
formulas that read back into the workbook to link to a cell. Depending on
what moth it is, that cell could be empty as it is a yearly wookbook. For
example, if this is August, then there is information in the workbook up to
August, but none after. With that said, the sum page has the #DIV/0! in the
cell which essentially equals zero. I also have graphs that I have linked to
this sum page. My problem is in order to keep the graphs up to...DPM and VMM on same server using side-by-side SQL installation
Windows 2008 Std R2 Server, 64bit
VMM 2007 is currently installed (with the built-in default database) SQL
2005 Express Edition, SP3, 32bit.
I was advised by Microsoft that both VMM and DPM could be installed on the
same server (small DR environment)
The VMs are hosted on a Windows 2008 Enterprise Server w/ VS2005R2 - because
the hardware didn't support HyperV.
VMM works great to manage the Windows 2008 VS2005R2 Host running Win2K3
server instances ... after lots of trial and error.
Now, I need to install DPM 2007 onto the same server... DPM wants to install
the 64bit vers...email
How can I change the time that it takes for message to
shift from BOLD (unread) to PLAIN TEXT (as read) in my
inbox. If I open MS OUTLOOK it will change within 30
seconds to PLAIN TEXT from BOLD appearing as read, even
if I don't want to read them at that time. Therefore,
later, I don't know if I read that one or not. I have
seen the time limit change on the setup somewhere, but
can't find it now!
Outlook does not have this option to mark an email as read when viewing in
the Preview pane.
Only Outlook Express does.
"Joe Dobbins" <joe...MS Access 2007, Forms
When using the "Forms Wizard", I need to use the "Style: Ricepaper", but it
isn't available in the 2007 version and I have not been successful trying to
find it in Office Online or on the web.
Does anyone know where I can get it?
Access 2007 has 25 AutoFormats, but as you noticed, they are virtually all new ones. It's actually
nice to see that these were updated.
To get the older Ricepaper style you could probably create a form in an earlier version of Access
and then import it into your current database. If you're using the ACCDB file format, you would...Won't save office applications, appcrash
Help I cant save documents , excel etc in office 2007 on vista laptop. I have
tried open office but this suffers the same problem. Also tried uninstalling
and reinstalling office but no change.
see below for word report, in excel the fault module was given as PROPSYS.dll
Problem Event Name: APPCRASH
Application Name: WINWORD.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428028
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c0000005
Exception Offset: 00000001
...Use a VBA Macro inside an Excel Cell
This is a multi-part message in MIME format.
its been helpful to me so maybe it will do good for you too:
how to create a simple macro within Microsoft Excel, and then how to use =
that macro to calculate a single cell value.
&l...Using "fixed" decimal place function data for charts
Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.
I'm not familiar with a "fixed function". I...slow sync with Calendar using Kyocera 7135 via Outlook 2003
I'm stuck and need help. I have a Two Day Old Brand New
Dell Dimension 4600. Does anyone out there know what to
do when Outlook 2003 is giving a Log report that reads
that Outlook Calendar - Slow Sync synchronization failed?
This is a first time occurence for me. Outlook also
reported that a device is trying to get access to my E-
Mail addresses which may indicate a Virus may be present.
I've run my McAfee Virus Protection and it didn't detrect
I'm at my wits end and don't know what else to do.
Can anybody help?
...MS Office Excel97: Removing Page Breaks
How do I remove page breaks? For some unknown reason they started appearing on a
spreadsheet recently. I see dotted lines dividing up the sheet and large "Page
...." in the background. According to an Office 97 book I have, I should go to
Tools->Options->View-tab and set the Page Break option off. There isn't any. If
I right click outside the page area, I see PG menu items but none seem to work.
There's also a PB View in the View menu, but clicking on it doesn't seem to do
Wayne T. Watson (Watson Adventures, Prop., Nevada Cit...Help
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...invalid use of property message
I am trying to cre4ate a macro that checks the value of a number of sheets to
determine if they are already visible and if so it will not close them -
With Sheets("Pay Inflation - Biometrics")
Sheets ("Direct Cost Savings Breakdown")
Sheets ("OT Reduction")
Sheets ("Nurse OT Reduction")
Sheets ("Premium Labor Utilization")
Sheets ("Pay inflation - Timestamp")
Sheets ("Calculation Error")
Sheets ("Le...can not Send/receive using Outlook 2003
Just bouhght new computer and am loading all of my software that worked onmy
old one. When I try to send and recieve I get the message object not found.
I have used test and this work ok. I have also reloaded all of my broadband
and office software numerous times to no prevail.
ADSlL broadband with bigpond
Check to make sure the accounts are setup correctly if they are then run
Detect and Repair, still an issue then create a new profile. May also want
to check your anti-virus software program setting for outgoing mail and
disable that option.
Rega...using rule creates multiple entries. How can I stop this?
I'm going to give you the details of this so maybe someone can just tell me
how to correct or whether it can be corrected. I've tried creating different
rules, rules with exceptions, multiple rules with multiple exceptions, all I
can think. Here is the scenario. Although I'm using Lisa as an example,
this problem applies to every staffer in my 9 person office.
Lisa is my secretary. She sends me internal email, staff questions and
stuff which goes to a a "Staff" subfolder of the Inbox. I have a rule for
She also sends me mail she has scanned. I ha...How do I set my office hours.
I work different hours than others in my department. They are always
scheduling meetings when I am not at work. Also there have been several new
members added to the team in another state that do not know my schedule.
How do I indicate in my calendar what my office hours are?
Ben Woodford <Ben Woodford@discussions.microsoft.com> wrote:
> How do I indicate in my calendar what my office hours are?
Tools>Options>Calendar Options. However, I don't think that will affect
what others view when they schedule a meeting with you. If you're using
Exchange, enable the Out...