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 can I know which SP has been put on the exchange2K
Where can I see this msg?
Open exchange manager, organization, right pane.
"Geoffrey" <firstname.lastname@example.org> wrote in message
> Where can I see this msg?
check for the answer on the 10th(9th from ur posting)thread on this
site,that is named"finding on version of sp installed"
...Save formatted text from RichEdit control to rtf-file
How can I save the text from Rich edit control (2.0) to *.rtf , *.txt ,
I tried to get the buffer and putting the buffer to file, then saving
but the text in the file is something different.
Please let me know what to do?
Here is the Code I ma using:
mFile.Seek( 0, CFile::begin );
int iTotalTextLength = m_oChatMessageControl.GetWindowTextLength();
HWND focusWnd = ::GetFocus();
cBuffer2 = m_oChatMessageControl.GetSelText();
LPTSTR...How can I print just the flip side of a booklet?
How can I print just the flip side of a booklet? I printed the first side
just fine and then my computer went funny and I had to shut down and start
back up again. I have 25 copies of the first side that need to be printed on
the back side.
Pub 2000 user here:
There may be a better way but I think you will have to print a page at a
time i.e., File, Print Page 2 of 2; then 3 of 3 and so on.
"pqc18" <email@example.com> wrote in message
> How can I print just the flip side ...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...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...Create static text from cell reference
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...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 Can I Control When Messages are Downloaded from Server
I have the box "Check for messages every ___ minutes" unchecked
Yet seemingly randomly, messages get downloaded a couple of times a day
without my clicking "Sync." This is problematic due to the way I share the
Is there another setting I need to keep this spontaneous downloading from
"Gripper" <Gripper@discussions.microsoft.com> wrote in message
> I have the box "Check for messages every ___ minutes" unchecked
> (too...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>..."x" button enables deletion.... can we put a focus trigger there?
on three forms, I put focus triggers on the "delete" button because I need
to validate some additional data before allowing the user to delete.
However, if the user clicks on the corner "x" button to close the form and
gets the dialogue box saying they have changes, do they want to "Save",
"Delete" or "Cancel", they can delete the record anyways. Is there any way
to put a focus trigger on the button of the dialogue box, or on the "x"
Thanks in advance.
I assume you are working with Dexterity.
To work with an add...Publishing Layout and tables
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to copy and paste text from one cell of a table to another cell in the same table. The document is in Publishing Layout. The paste command deletes the text in the destination cell and then places a big empty text box on top of the table. I do dozens of these documents that are primarily tables and graphics. Previously I used Publisher on my old PC. Should I go back, or can this be done in Word for the mac?
On 2010.01.29 8:44 AM, in article 59bb1ce2.-1@webcrossing.JaKIaxP2ac0,
"Toni_T@officefor...I do not have access to the D: drive from Publisher, why?
I do not have access to the D: drive from Publisher, why? It keeps saying
khaganman <firstname.lastname@example.org> was very recently heard
> I do not have access to the D: drive from Publisher, why? It keeps
> saying "incorrect function"
Is the D: drive your CD drive?
Ed Bennett - MVP Microsoft Publisher
...Text Very Small When Replying
I'm able to change the text size when I'm replying to an email but how does
one set the default size?
No matter what I ser the font size to when replying it always reverts back
to the smallest size when
I do another reply.
Look, I'm 54! I can't read that small text!
Are you using stationery?
Also, Alt + T, Options, Compose,.......
"JamesJ" <jjy@darwin_roadrunne0r.com> wrote in message
> I'm able to change the text size when I'm replying to an emai...Extract text from field
If you have a filed that contatins the following data:LastName, FirstNameWhere LastName has varing lengths. Can you run an update query to obtain just the LastName part of the field? If so, what would be the command?Many, many thanks in advance. On Tue, 6 Mar 2007 14:09:45 -0500, "Mary M" <none@no_email.com> wrote:>If you have a filed that contatins the following data:>>LastName, FirstName>>Where LastName has varing lengths. Can you run an update query to obtain >just the LastName part of the field? If so, what would be the command?>>Many, many thanks in...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...Adding a certain text label in a excel chart
I am plotting in regularly basis a certain set of data in excel.
Based on some data analysis this set of data has to be fitted to these
y = 1/x^a (1) and /or
y = b/x^c (2)
from data analysis, constants a, b and c are found and are placed lets say
in cells A1, B1, C1.
On my graph, I am putting then two small text labels where the real equation
is displayed: smth. like: y = 1/ x^3.45 and / or y = 0.256 / x^3.12 The
whole process is similar with excel curve fitting, when the “show equation on
chart” is checked.
Thank you in advance
My question is: Can ...Can't upgrade companies to SP4
R [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or
number of supplied values does not match table definition.I had a base
installation of GP 9.0, no patches. Decided to download SP4 and install.
Install of the MSI went fine and upgrading the master databases worked, but
going company by company, I get the following error:
The following SQL statement produced an error:
CREATE Procedure SVC_POP_Make_PO( @PromisedDate datetime, @OrderedBy
char(15), @BatchNum char(15), @ItemNumber char(30), @VendorItemNumber
char(30), @LocationCode char(10), @Uo...Can't receive EMail #5
Keep getting this pop up along with 'server did not
connect within 60 seconfs, do I want to wait
A time-out occurred while communicating with the server.
Account: 'Richard', Server: 'pop.east.cox.net', Protocol:
POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC19
Please reply using email@example.com
please read this information from Microsoft
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravestar@Datenschutzminis...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...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...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...Can I do this query in one step?
Suppose I have a talble like this, each record has a unique ID. All"A"s or "B", "C"s should have only x or y or z property attached. Iwant to find A, B or C which has more than one properties.1 A x ...2 A x ...3 A x ...4 A y ...5 B x6 B y7 C z....resutls would look like:A xA y....I think I can do this in two steps or with a subquery. Then I thoughtof self-join but didn't figure out how to use it in this case.Thanks a lot! SELECT DISTINCT and do not include the record ID perhaps? Or is the record ID vital?"muster" <firstname.lastname@example.org> wrote in me...How many pages can a booklet have?
Hi how many pages can a booklet have? Is there a limit to the pages in a
publisher booklet. Each page has three photos.
There is no limit, your RAM may decide for you. What version Publisher?
Mary Sauer MSFT MVP
"Verystumped" <Verystumped@discussions.microsoft.com> wrote in message
> Hi how many pages can a booklet have? Is there a limit to the pages in a
> publisher booklet. Each page has three photos.