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...how to set the worksheet direction in Excel XP
in a right-to-left interface the vertical side showing the row numbers of the
excel worksheet appears on the right side of the sheet. how do I change it'
to appear on the left side?
does tools / options / international - default direction ... help?
"inbal" <firstname.lastname@example.org> wrote in message
> in a right-to-left interface the vertical side showing the row numbers of
> excel worksheet appears on the right side of the sheet. how do I change
> to a...Controlling multiple TCP connections from Outlook 2003 clients
I've noticed that Outlook 2003 clients can have multiple TCP
connections to the mailbox store on Exchange. As the following web
"This behavior is by design. Outlook can open multiple connections to
parallelize its data communications with the Exchange server. The
actual number of connections will vary according to the version of
Outlook that you're using and the mode in which you're using it. For
Microsoft Office Outlook 2003 in Cached Exchange Mode, you'll see four
connections for the mailbox, ...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...Select all of a certain column across multiple worksheets
Is there an easy way to simultaneously select (or do a find-and-replace) on
column H on every worksheet of an entire multi-sheet workbook, without
having to select that column on each individual worksheet by hand?
Right-click on first sheet tab and "Select all sheets"
In activesheet select the column............will be selected on all sheets.
Gord Dibben MS Excel MVP
On Mon, 24 Aug 2009 16:43:02 -0700, "Charles Belov"
>Is there an easy way to simultaneously se...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
http://www.accessmonster.com/Uwe/Forums.aspx/acce...linking worksheets #3
I know ho to link cells to oher cells. But is there a convenient way to link
ranges or worksheets to others.
just link the first cell
and copy this formula for your range. The reference will adapt
j van c wrote:
> I know ho to link cells to oher cells. But is there a convenient way
> to link ranges or worksheets to others.
...Sumproduct with multiple date criteria
Having a tough time with this one.
Column A = Start Date, Column B = End Date, Column C = Quantity.
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
The date ranges on sheet 2 represent the beginning and ending of a week
Column A Column B Column C
01JAN2010 24JAN2010 1,000
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
Do the Sheet 2 Star...Excel worksheet with VBE codes don't work elsewhere
Some of my excel worksheets with embedded controls and VBA codes don'
work when I open it on another PC. Is there another way to make i
lazybear's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3519
View this thread: http://www.excelforum.com/showthread.php?threadid=54955
Specifically what problems are you having? Saying "don't work"
means absolutely nothing.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
ww...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...Querying multiple records in two tables
Hi, in my database I have tables for users (UserID, UserName),
projects (ProjectID, Project Name), and qualifications (QualID,
QualName). I have join tables for users_qualifications (UserID,
QualID), and projects_qualifications. (ProjectID, QualID).
What I need to do is run a query for a project to show which users
have the exact matching qualificiations.
Users can have many qualifications, projects can require many
qualifications, users may only work on a project if the qualifications
required/held match exactly.
Assuming that ProjID, and QualID are numeric, the following sho...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...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...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...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?
...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...Email to multiple people but show only the recepient name
Is there a way to send to ten people at once but only
have one name in the To: box at a time? So that the
entire list of people is not sent.
Use the BCC field.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Terry asked:
| Is there a way to send to ten people at once but only
| have one name in the To: box at a time? So that the
| entire list of people is not sen...How do I get Outlook Today to show appts from multiple calendars?
I want the opening page (Outlook Today) to show the next week's appointments
from 2 calendars. I can only get it to show one calendar and it defeats the
purpose of having the summary. Ideas?
If you provide some basic information like:
version of Outlook
where the two Calendars are located (eg is one a Public Folder, a shared
Calendar, a sub-folder of your mail Calendar)
you'll find getting a useful answer here much faster and less laborious.
in Canberra, Australia
"MORE CALENDAR" <MORE CALENDAR@discussions....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...Worksheet chnage event
I have the following triggered by a worksheet change (there's some other
stuff before this line, but that's all working) which causes an error:
Case Is = "Open"
Range("a" & Target.Row & ":ac" & Target.Row).Select
.ColorIndex = xlNone
Range("o" & Target.Row & ":q," & Target.Row & "t" &
Target.Row_ & ":v," & T...Linking Multiple Excel Sheets
I am not an expert in Excel....!,
I encountered a situation where in I had to get data from 14 excel separate sheets having same structure (differing in values).
After playing aroung with excel for few minutes, I found "Import External Data" under Data. Manually I imported all the 14 sheets and in my main sheet wrote a small formula which would give a consolidated information.
With this you also have a feature which refreshes data (at specified time / or when opened).
There might be a different & faster way to do it, which I am not aware of!!!. Anyway this worked for me........Accessing PST File from Multiple Partitions
The setup is a standard home Outlook 2003 configuration from an ISP's
POP server. It has worked fine for years.
I have the server configured to retain mail for a couple days, so that I
can check the web interface from the office or from a laptop at the
coffee shop even if the home machine is up and has pulled in Email, as
it does every few minutes. Works fine.
I recently put Windows 7 on the home machine, installing it on a
separate partition. Eventually I would guess that it will be the
standard OS on this machine, but for now it is experimental and the
machine defaults to th...