Passing Field Values
I have added a new button on to "Sales transaction Entry" screen.
How to pass the screen control values to the corresponding button's
function (in VBA)
You will need to bring up the window and add the "control fields" to VBA.
Then you can reference them in your VBA script and pass them to whatever
other code you have written.
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my p...Auto Filter returns no results
I have a spreadsheet with about 11 columns and 800 rows. I have all
columns ready for auto filter. The last column (K) has numerical
values in it, and I would like to search for all rows that contain a
certain number. When I do this, it returns no results - even when I
know that a number is listed. If I select to show all that 'equal' the
number, it will return the result, but not when filtering for
'contains'. [I need to use 'contains' because some cells have more
than one number in them (separated by commas).]
I have Office Professional 2003 - Excel 2003 - SP2.
...Why does CSplitterWnd::GetRowInfo() return -1 for a window size?
I am trying to create a derivative of CSplitterWnd that will keep the
ratio of its two panes constant when the window size changes. I
create my splitter window with its two panes, one on top of the other,
and then I call my derived class's RememberRatio() method, which is:
int current0, current1, min0, min1;
int rowCount, columnCount;
this->GetRowInfo(0, current0, min0);
this->GetRowInfo(1, current1, min1);
m_ratio = (double)current0 / (double)(current0 + current1);
I was surprised that the ratio was 0.5 when it should have be...Append Query
I have a table "Rates" with the following data:
StartDate: 5/15/08 End Date: 6/23/08 Rate: $53
StartDate: 6/24/08 End Date: 7/15/08 Rate: $86
StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99
I have another table "Transactions". I want to create an append query such
that if I supply the StartDate and EndDate, the query will populate the
"Transactons" table with date and rate data from the "Rates" table for each
and every day within the date range. Example: If I supply the StartDate of
6/23/08 and the EndDate of 6/25/08, the query would pop...Can't find CD/DVDdrive
My DVD drives have disappeared. they don't show as hardware in control panel.
Working fine yesterday - no software changes made.
Both have power to them. I've unplugged everything and put a new lead from
them to the motherboard.
Doesn't appear to be anything physical.
Followed various posts on this site. Mr Fixit recognises the problem but
can't fix it.
Went into registry. Higher filters there but no lower filters.
On 06/20/2010 05:13 AM, Philx5 wrote:
> My DVD drives have disappeared. they don't show as hardware in control panel.
...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein..."Find an event" feature in the Windows Live Mail/Calendar
In the Windows Live mail it is quite simple to "Find a message" as we type
something in the search box and enter. But, I do not see any search box with
the Calendar. Are there any ways to "Find" something in the Windows Live
Calendar? Looking forward to hear from someone. Thank you.
...Like numbers in a field
I am working with a 25,000 row parts issue listing that was created by parts
issue date. There are many repeat numbers in the part number column as the
same part would have been issued on several different dates. I would like to
be able to combine the like part numbers to know how many parts were issued
over the course of all of the dates. Any ideas??? The Column headers are
Part Number, Quantity, Unit Price, Total Price and Transaction Date.
Create a new query based on your parts issue listiong table. Drag the Part
number field into the query grid twice. Click on the Total...CFtpFileFind return null creation date
I am trying to list the URL and timestamp of some files on a server in a
list box in a simple dialog using FTP. The code is as follows:
CListBox* pbox = (CListBox*)GetDlgItem(IDC_LB_FILES);
// Create session object to initialise libs
CInternetSession sess(_T("My Test"));
// Declare a FTPConnection
CFtpConnection* pftpConn = NULL;
pftpConn = sess.GetFtpConnection("ftp.,mytestsite.co.uk",
if (!pftpConn->SetCurrentDirectory("/Testdir/T...Where can I find the newsgroups that have disappeared from the MS news server?
I've been an enthusiastic user of these wonderful MS newsgroups for years
(mostly the Access groups), but I've noticed that Microsoft has been
removing them from their news server.
Are the discussions continuing on a Web-based forum somewhere? If so, I'm
disappointed because I've found reading the message threads with a
newsreader like Outlook Express is much more convenient than trying to
manage the browser-based forums. But if that's the only thing available,
I'd gladly use them.
Can anyone tell me where I can go to find the question and answer gro...Does anyone use "location" field in Outlook?
After all these years, I just noticed when I go to make an appointment in
Outlook (2003version, with BCM), that there's a second field after "subject"
which would seem to be the one everbody mostly uses. The appointment fields
1. SUBJECT: (example: "Conference call with Joe and Mary)
2. LOCATION: (does anyone use this?) Is the idea to put something like
"Annapolis, MD" meaning maybe a meeting there or something?
I know it's a hokey question, but wondered about some examples of how other
people are using it.
Standard following us...Empty From: field
We use a exchange 2003 server and I have notice that my outlook 2003
client behaves strange if the From tag in the header looks like this;
From: �� <email@example.com>
I�ve hooked up Thunderbird and it shows the From field as I think it
should, instead of a blank from field it shows firstname.lastname@example.org
If the header looks like this; From: email@example.com
or like this; From: �name� <firstname.lastname@example.org>
it works just fine.
The problem is the first example�
Jonas <email@example.com> wrote:
> We use a exchange 2003 server and I have notice th...Finding sheets
I'm just an inquisitive person, I guess ;-)
I would like to create the name of a particular sheet dynamically, then
read data from it. For example,
That will give me the name of a particular sheet. A start date and end
date are in A36 and B36, respectively.
I would like to take the name of the s...how to create a field based on many different conditions
Hi, I'm trying to create a field based on many different conditions in Make
Table Query in Access 2003, e.g., if VAR1 and VAR2 meet certain condition,
assign a value "A" to the new field "Category"; if VAR1 and VAR2 meet other
condition, assign a value "B" to "Category" so on and so forth. I keep
getting separate field for each condition, something like "Expr1023". Please
help! Thank you!
Since you haven't provided the expression or SQL statement, I will assume it
is quite complex. I would remove the complexity from the query ...Sorting Spreadsheet with Merged Fields
I have a huge spreadsheet that currently fits comfortably on an 11 x 17" page
making it difficult to work with and understand....just too big. I'd like to
make the spreadsheet fit on an 8.5 x 11" (landscape) page by stacking fields.
This is marketing pursuit data so most fields hold text. When I stack the
fields some fields must be merged. So far...not tough....I have a beautiful
spreadsheet with all the data in a convenient format, easy to understand.
The problem is sorting the first field (priority) per field grouping....can't
sort because of merged fields. I t...Search a field
I'd like to have a small button next to specific fields in my form, which
when clicked, will allow the user to search all records relating to that
field. In my case my serached vehicle will be Vehicle Regstration, Surname,
Reference and Accident Date.
Is there an easy way to do this?
Put a command button on the form. When you start command button it will run a
wizard for the setup. Tell it you want a search function. After the search
button is ready, run it and set up the search procedure you want.
>...Reference last entry in column
In Excel 2002, I need a way to reference the last entry in a column of data
that has data added to it on a regular basis. Is there a way to do this that
is fairly simple? I am trying to make a checkbook register in excel and I
want to have the current balance shown in one place at the top so that when
the list of entries gets long the user doesn't have to scroll to the bottom
to see the current balance. I also want to have it show on a different sheet
where the current balances for different accounts can all be seen one one
page. Any help would be appreciated.
http://www.xl...Hard return in wraptext cell?
Is there a way to place a hard return(carriage return) in a cell with wrap
so as to align text in the way user wants rather than what excel places?
Sure. Where you want a new line just press Alt+Enter. To remove that just
place the cursor at the end of the line before the new line and press Delete
"MP" <NoSpam@Thanks.com> wrote in message
> Is there a way to place a hard return(carriage return) in a cell with wrap
> text format
> so as to align text in the way user wants rather than wh...outline won't number after hitting return
I've set up the document per Shauna Kelly's instructions, but can't figure
out why it won't continue to number the outline. It'll give me Heading 1,
but when I hit return it goes back to "normal". What in the world am I doing
You would need to modify the Heading 1 style so that it is followed by
Heading 1 style (though that is not what would normally be wanted as a
heading is normally followed by some text.
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a pai...Control+Z was Undo, now Shrink. How to return to enlarged view?
"Control+Z" used to be Undo, now became shortcut for Shrink. How to return
to enlarged view of my email text body, pls? Thank you. Gary
This doesn't sound like an Outlook issue...sounds like another program is
hijacking the traditional Windows shortcut keys. See if you can figure out
which one...likely one you installed around the time this started happening.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***
"Gary Fan&qu...Getting the "name=" (bit, picklist) value that is returned from SOAP
OnChange event to poulate other field on a case.
One of those fields is a bit, and one is a picklist. Those nodes in the
response come back with <attribute="new_active" name="true">1</attribute>
for the bit field and <attribute="status" name="On Hold">3</attribute>
How can I read the name value? I've tried selectSingleNode("//status").name
with no luck.
I am doing a similar process, using a SOAP response message. I ge...Find Where Specific Fonts Have Been Used in a PowerPoint Presentat
Is there a way to find where specific fonts have been used in a PowerPoint
presentation. The Contents tab of the Advanced Properties pane list the
fonts that are used in a presentation but not where. MS Word will search for
fonts with the find dialogue. I am looking for similar functionality with
In article <6CDAC5DB-AFCF-4485-9EAB-5146B5B5411C@microsoft.com>, John B wrote:
> Is there a way to find where specific fonts have been used in a PowerPoint
> presentation. The Contents tab of the Advanced Properties pane list the
> fonts that are used in a...Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help
Desk form in Outlook. We would like the ability to link specific fields
from the Contacts Folder (Example B), in a drop-down list box if
possible. We are far from knowing that something like this is even
possible. Would appreciate *any* suggestions. Thank you.
...Any reason CurrentDb.TableDefs(0).Connect returns empty sting in Access 2007?
I use the function below to return the server or database name for various
However, now that we've switched to 2007 the line
which used to return the connection string is returning an empty string.
Function GetConnectionProperty(ServerOrDatabase As String) As String
' Returns name of connected server if "Server" passed in.
' Retuns name of connected Database if "Database" passed in.
Dim sConnectionString As String
Dim aConnectionPieces() As String
Dim sConnectionPiece As String
Dim i As ...Can my form fill in a field, yet allow me to override?
Each customers is sent to us from a salesman, and we provide service for 1-7
days before the activity ends. A new charge is generated for each day of
Employee #1 uses the customer service form to generate a bill, and includes
the name of the salesman. Employee #2 uses the form to generate a bill on
the next day, and has to look up the first bill, in order to know which
salesman to record. The same thing happens every day until the activity ends.
With each new referral for service, there's a strong chance it will be due
to a different salesman, so the customer number an...