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...Have Outlook 2000. How do I get rid of spam?
I need step by step directions because I don't know the termenology.
When we open Outlook it comes up under my husband's e-mail. Then I Open
mine. He is not spamed. I get hundreds each day. HELP!
winnieB <winnieB@discussions.microsoft.com> wrote:
> I need step by step directions because I don't know the termenology.
> When we open Outlook it comes up under my husband's e-mail. Then I
> Open mine. He is not spamed. I get hundreds each day. HELP!
Step by step:
1) Open Internet Explorer.
2) Browse to http://spambayes.sourceforge.net/
3) Downoad SpamBaye...user initials and auto correction
Can someone please help me with the following...?
People usually type JD in the To: field when they want to send me an email
via Outlook. After a recent addition and deletion of another account with
the initials of JD I'm finding that it is default to this user - and it's
not even trying to qualify the correct recipient with a list of possible
users, like it does with other similar users.
I would like it to ask for qualification and also default to my account. Any
"Joey D" <email@example.com> wrote:
>Can...All macros failing part way through with different error messages
All the macros I have in various workbooks are failing - usually part-way
through - with different error messages each time. When I check the debugger
and try to edit the text, there seems no reason why there should be a
problem. The macro has so far stopped on instructions to :
- open a workbook
- select a worksheet
- paste a column in a different place
Several times the macro has just stopped running without completing and
without showing an error message.
I cannot run a host of urgent daily reports without using the macros. Please
NO way to help unless you tell us exactly...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...macro #2
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
I am trying to edit and create some macros in an excel spreadsheet that was
created by someone else. There are macros for this spreadsheet but for some
reason when I go to Tools -> Macro -> Macros it doesn't show any in the list.
When I go to Tools -> Macro -> Visual Basic Editor there is code for the
macros. I have some buttons on the spreadsheet that I want to assoicate with
the macros but the buttons almost seem like they are locked, when i write
click them nothing happens but a shortcut menu should appear. Is there maybe
some special security on there I don't...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...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How
do I do that?
x-axis y1-axis radius(y1/2)
0 0.00 8.0000
1 0.25 8.0242
2 0.50 8.0691
3 0.75 8.1281
4 1.00 8.1989
5 1.25 8.2803
6 1.50 8.3716
7 1.75 8.4729
8 2.00 8.5832
divide the y1-axis by what?
2 as an guess with y1-axis in column c
in the y1/2 column(d?), enter
> I want to divide the y1-axis column and save it to radius (y1/2) column. How
> do I do that?
> x-axis y1-axis radius(y1/2)
> 0 ...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...Macro
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...Getting font properties
I have a LOGFONT - complete with all desired properties including face name.
I use CFont::CreateFontIndirect() to create a font.
If the font I have specified is not available on my machine then it uses the
nearest available in some appropriate sense.
So far so good.
But CFont::GetLogfont() just returns me the LOGFONT which I used to create
the font, and not the one it actually adopted - in particular as regards
Is there an easy way to get the face name of the font it actually used?
Author MOZART the music processor for Windows -
http://www.mozart.co.uk...macro for invoice totals
I have this macro that inserts lines and copies a invoice header.
Now I want to total the invoice.
In the first row after a value in B in E the word totals must be inserted,
H, I and K must be summed the amount of lines differ on each invoice but
there is a heading from where it must be summed. CTNS(H), QTY(I), Total(K)
Thanks a lot.
Public Sub Deilv2()
Dim LastRow As Long
Dim row_index As Long
Dim rng As Range
Set rng = Range("B2:K25")
Application.ScreenUpdating = False
LastRow = ActiveSheet.Cells(Rows.Count, "b").End(xlUp).Row
For row_index = LastRow - 1 To 26 S...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...Time update as a limited user not working
I added time update permisssion to my limited user acct. but it does
When I try, the time synchonization is greyed out.
How can I get it to work.
On Apr 4, 12:33=A0pm, Mint <chocolatemint77...@yahoo.com> wrote:
> I added time update permisssion to my limited user acct. but it does
> not work.
> When I try, the time synchonization is greyed out.
> How can I get it to work.
Is this Windows MCE SP2?
What method did you use to add time update permission to your limited
Does your unlimited user accou...Is there a way to sort a column without invoking a macro?
I am trying to get a feel for some probabilistic properties. For
example, I am trying to look at the statistics of the intervals between
randomly occurring pulses. I have no problem getting a column of
uniformly distributed pulse times, but they are unsorted, Every time I
recalculate with cmd-=, I get a new unsorted set of pulse times because
of the use of the RAND function.
Is there a way of taking this unsorted column and pasting it into
another colun that would be sorted without invoking a macro?
To simplify and be more specific consider the following.
1. In A1:A100 I have a set...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...Limiting CRM application ability to aasigning user to approprite CRM security group
IT administrator that I have for client does not like the idea of CRM
application assigning user group automatically. They prefer to do the
security group assignment manually.
Is this possible? What do I need to do to achieve that?
I did it the following way for a customer:
1) You will need to precreate the five groups within your AD. There is no
need of having a own OU (Container, Organizational Unit) for them. Follow the
naming convention of your company or use the default namings from Microsoft
for the five groups. There is no need for your AD Admin to assig...Macro Help #18
Well I think this is a macro. I have searched my excel book and i can not
seem to figure out what to do.
I want to write something that if this statement is true, then the font
color changes. But here is the potential problem. THe location of the text
will change. So i need it to search for this text and then change the color.
Does that make sense? Is this possible? If this can be done it will really
help me. Thanks in advance.
This is exactly what i am trying to do.
You type in a persons name into cell a1. you also type a name into cell a2.
These names will transfer over ...Where can I get a good holiday booking form for my golf business?
I need a quality Booking Form for my Golf Holiday business on the Costa Del
One which includes sections for accommodation, dates, numbers, flight
enquiries and car hire enquiries. Any help would be much appreciated on a
Wrong forum. Try templates or doing it yourself. :-)
Please hit "Yes" if this post was helpful.
> I need a quality Booking Form for my Golf Holiday business on the Costa Del
> One which includes sections for accommodation, dates, numbe...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...Frame window does not get displayed properly
I have a Dialog based applciation. I want to create a Frame window
when clicked on the button on Dialog. The problem is I handled the
Painting of the dialog (I draw a picture on so WM_PAINT message I
handle.) but doing this I am not able to draw the frame window
properly. It appears to be transparent to me .
I am setting the CFrameWnd to be the child of CDialog
Please Can you let me know how to draw the farme window of how can I
have a floting window on a dialog.
I don't know if what you are doing is a good idea.
But if you want to have a floating window ins...