Allen Browne's Search Screen clears the first record combo boxes
I am using Allen Browne's Search Screen and can't seem to stop the first
record's entries being blanked out with the reset button. I changed the
original cmdReset_Click() to only set the header fields to Null but my first
record's fields also reset with each control. I am using combo boxes in the
detail section (to display words instead of record id numbers) which isn't
part of the original database. Can someone help?
Terri, can you confirm whether:
a) the data is being lost, or
b) the data is not being displayed properly.
There is a di...Lookup function question
I am looking to create a formula that will see if a value from column 1 sheet
1 is present in column 1 sheet 2, and if it is, return the value from column
2 sheet 2...
Can anyone help me with this?
Thanks in advance...
This gets A1 from Sheet1 and tries to find it in column A of Sheet2. If
found, the value in column B is returned.
Gary''s Student - gsnu201001
> I am looking to create a formula that will see if a value from column 1 sheet
> 1 is present in column 1 sheet 2, and...IE8 back button returns to top of page
On our laptop whenever I'm on a site and click a link, then hit back to
return to the first page it will not return where I was on the page. It
reloads back to the top of the page. For instance I'm a Craigslist junkie
and whenever I click a post and go back it puts me at the top of the page and
not where I left off.
This does not happen on most web pages. It is caused by poor programming of
To avoid the issue at craigs list, use Ctrl+left mouse button to load the
link in a new tab instead of the current tab. (If you have tabbed browsing
en...OR and AND function
The OR and AND functions only give TRUE or FALSE results.
Is there any way to OR or AND one number with another to
give a numeric result. For example, 0x64 AND 0x5F to
yield 0x44 (creates lower case from upper) or conversely,
0x44 OR 0x20 to yield 0x64 (creates upper case from
lower). Thanks for any help you can give me.
Use an if statement before the AND OR function.
>The OR and AND functions only give TRUE or FALSE
>Is there any way to OR or AND one number with another to
>give a numeric result. For example, 0x64 AND 0x5F to
>...what is function vs. formula?
my question is what is function vs. formula?
I need to know so that I can study for finals. I'm trying to get as much
information as I can on the subject so that I may possibly get a good grade
Formulas can use Functions or not.
Functions have to be used in formula mode.
This is a formula =A1+A2+A3+A4+A5+A6+A7
This is a formula with a Function in use =SUM(A1:A7) which saves you a lot of
Gord Dibben Excel MVP
On Tue, 1 Mar 2005 15:17:03 -0800, "francine"
>my question is what is function vs. form...Excel Look up and Return Data
I have a "data table" in one Excel file (call it DATA, the table is
sorted on a field called 'CODE') and a second Excel file (call it
FORMULA). I need to lookup information from the DATA table and return
it to the FORMULA file, this will be done by matching a Raw Material
Code number from the FORMULA file to the DATA table. When the code is
matched, I would like to return 5 consecutive cells (in 5 consecutive
columns) of data to the FORMULA file. Currently, I am using 5 vLookup
functions to do this in the 5 consecutive cells. I am doing this to try
to ...Onsave function
Hi i'am searching for a onsave function to send a e-mail.
Hope anybody can help.
You should consider using a 'server-side' plugin registered on create
or update for this.
Easiest way is to use Workflow.
Just create Workflow - fired on record update. Within workflow you can
easily send an email.
"Maarten" <Maarten@discussions.microsoft.com> píše v diskusním příspěvku
> Hi i'am searching for a onsave function t...Query Optimisation problem. CTE with Ranking function used by12 x union stm
I hope you can help me with this one and get this query to run a bit faster.
I have a CTE which looks at data in the table and gives it a ranking number
using the rank() over (partition by ?? order by??) syntax. This is done
because I then need to run some DQ tests on the data, based on the ranking
order of the records.
(UK NHS RTT status codes for anyone who is interested...)
CTE statement is below.
with CTE as
rank() over (partition by R2T.Refrl_refno order by R2T.RTTST_Date,R2T.
SORCE_Refno) as 'Rank',
RV...Functionality that should be in the core GP product
1. PO Receiving Tolerance
2. Add-Item marked by default
3. IV Batch Post to GL Default
4. Doc Date Verify
That these aren't part of the core product is puzzling. For instance, not
being able to limit the over-receipt on a PO is a gaping hole in the POP
Anyone else agree with this?
MCP-GP, MCT, MVP
East Coast Dynamics
2. What do you mean?
3. v10 made this the default
4. If you mean prevent people from entering dates like 11/10/9002, I agree.
Charles Allen, MVP
"Frank Hamelly" wrote:
> 1. ...Looking for Non-records...?
My goal with this question is to learn how to construct a select query that
will locate records of employees that have NOT attended a particular course.
Here's the information...
tbl_Employees: EE_ID(pk), LName, FName, etc...
tbl_Course_Archive: Course_ID(pk), Course_Code, Course_Name, etc...
tbl_EEID_CCode: EE_ID, Course_Code
The employee can attend more than one course and would therefore be listed
potentially more than once in the tbl_EEID_CCode.
I would like, through a parameter query, to have the user identify the
course name ("*" & [Enter Course Name] & &quo...Two problems, Conditional Formatting and Printing a record
I know these are two seperate problems, but I got them to work and I don't
First: I have 6 fields that are conditionally formatted to be bold/red
bg/yellow font if a corrosponding check box is ticked. It is coded:
EXPRESSION IS [HP].Value=-1 Where HP is the Checkbox
It doesn't work.....sort of.
Second: I have a macro that print previews a report based on the ID
(primary key) of the currecnt record (to be printed). When the button is
clicked, a pop up appears asking for the ID (ID1). This is the macro
coding: [ID1]=[Forms]![App 1]![ID1...Return address shows wrong domain....
I have a client who is running SBS 2003 with Exchange. They can send mail
fine but it shows the return address as a .com domain when they are a .ca
domain. Needles to say they are not getting any 'reply to' mail....
They are getting mail that is addressed to the .ca accounts.
I am thinking this is a setting in the Exchage server but can't find where
The computer name is using the 'domainname.local' as the ADS root.
Any help is appreciated.
Thanks and have a great day,
Most likely a >Recipient Policy< issue
You need to set the correct domai...Logical function for finding different formated cells
I am interesting in such question:
I have table with two types of cell formating, one with font 12 and one
with font 10. Is there a function to do something like this:
= IF (in target cell font is 12, result A)
= IF (in target cell font is 10, result B)
Say we want to test the font size in A1.
First install this tiny UDF:
Function fontsize(r As Range) As Integer
fontsize = r.Font.Size
then in another cell:
=IF(fontsize(A1)=11, "result A","result B")
Gary''s Student - gsnu2007
> I am in...Replace or Substitute functions
I have a field the may contain spaces, dashes and slashes for instance
4022916389 /5-12-03 trans. I want to create a formula that will
replace all of these characters with "no space".
The formula =SUBSTITUTE(A1,"-","") will only remove dashes.
Is there a way to nest multiple replace or substitute functions
together to accomplish my request? If so, please let me know.
Thanks for your help
"Doug" <firstname.lastname@example.org> wrote in m...IF function help
I need some help creating an IF function. I have a list of salar
brackets e.g A 0 - 10,000
B 10,000 - 20,000
C 20,000 - 30,000
D 30,000 - 40,000
On a seperate spreadsheet i have different cells with peoples salarie
in. In a seperate cell underneath their salary cells, i have an empt
cell that needs to have the relevant letter in that shows which ban
they fall into A,B,C,D etc.
What i need is an IF function in the blank cell that will automaticall
come up when a persons salary is typed in.
E.g : - if i type in 24,000 into the salary cell, i want the blank cel
to then come up with ...dialog callback return?
I have a VERY lite application which just uses a dialog resource and no real
window regsistered class window.
Anyway, in my Callback procedure when should I return TRUE or FALSE? Does it
matter for a simple dialog? Does it matter for a real Window? Should I call
DefWindowProc(hwnd, Message, wParam, lParam); for window or a dialog
Is it returning TRUE or FALSE which Allows the dialog manager to perform
default dialog operation in response to the message?
Thanks for clearing up some confussion.
int APIENTRY WinMain(HINSTANCE hInstance, HINSTANCE hPrevInstance, LPTSTR
lpCmdLine, int ...Adding a Field to a Function
This function gives the ,father,mother.age,sex to a horse if he has no name
or if named shows his Name, I want to add one field to both Names the field
is called "Extra"
Thanks for any help ..................Bob
Function funGetHorseName(lngInvoiceID As Long, lngHorseID As Long) As String
Dim recHorseName As New ADODB.Recordset, strAge As String, strName As String
recHorseName.Open "SELECT * FROM tblInvoice WHERE InvoiceID=" _
& lngInvoiceID & " AND HorseID=" & lngHorseID,
CurrentProject.Connection, adOpenDynamic, adLockOptimistic
If r...how do I add rows on excell using the =sum function
i have 100
about 7 numbers and I would like to know how to add them.
If your numbers are in the range G1 to G15 try it like this:
When you need to reference a range of cells think of the colon as the word
"to". G1 to G15 = G1:G15.
Microsoft Excel MVP
"mona" <email@example.com> wrote in message
>i have 100
> about 7 numbers and I would like to know how to add them.
> =sum (g1-15)? ...User Defined Function vs. Named formula
I have used Named Formulas and am now learning about User Defined
Functions. One thing I found with named formulas is that the naming
conventions around global/local selections. Reading about UDFs makes
me think they might be a better option for a lot of my work.
Any insight as to When to use one over the other will be appreciated.
IMO they are different beasts.
A named formula would be used to shorten formulae by including a name rather
than the sub-formula (especially where it is repeated), and to improve
readability/maintainability, as the name would/should be meanin...If/Then in a Function?
I have a column of numbers and I need to multiply them by one of two se
values. Basically the first 10 get multiplied by X and anything ove
10 gets multiplied by Y.
Think of it like paying someone overtime. Up to 40 hours you get pai
one amount and every hour over 40 you get paid a different amount.
Can I do this in one statement somehow?
Basically it's If B2+B3 <10 then B7 = (B2+B3)*25
If B2+B3 > 10 then B7 = (B2+B3-10)*10 + 250
How can I do that in Excel
Message posted from http://www.ExcelForum.com
in B7 should give ...Excel Scrollbar not functioning
The scrollbar on one of 6 worksheets in an Excel program
approximately 6MB in size mysteriously stopped working. I
can no longer scroll down the page and when I try to do so
the scroll bar moves but the page is idel.
I developed the file on my hard drive and then transferred
to a network through Citrix. I started having the problem
on the network so I took it off but it is still happening
now. Again, it only happens on the one worksheet but the
other five are fine.
Just one quick, simple diagnostic to try out on that worksheet ..
Ensure that there's no pane frozen i...multiple range in SUM,IF
Im above array formula, 3rd criteria i am trying to set range > 31 AND <=93
but it doesnt work .. could anyone help ??
as an array formula
or (not an array formula) either
...Add Named Range
I am using the Named ranges in excel to store metadata about each cell in
excel that can persist with the excel file. So 1 cell = 1 Named
Range.Advantage of using this approach is excel automatically updates the
name references, even if we cut-and paste cells.
As per this link(http://office.microsoft.com/en-us/excel/HP051992911033.aspx
), the amount of named ranges is limited only by the amount of available
I wrote a small macro that adds names to each cell in excel, considering an
average data of 10000 rows into 10 columns.
Could someone please give me some advice of how to use PMT function
(or other function???)?
I can calculate the pmt if I have the loan amount, interest rate and
payment's period but I just don't know how to do these two scenarios:
I have a loan for $10,000. I want to pay $200 each month for the next
5 years (60 payments). I'd like to know what is the formula I should
use to calculate the interest rate.
Same as above, this time I know the interest rate would be 8%
annually, loan amt still $10,000 and payment $200 each month, how to
calculate to get the nu...total of a range of times
This should be simple for some of you, but not for me.
I am a runner, I have 4 ind. cells w/my split times. How do I get a total
for the tallied times.
I'm far from being experienced but am trying to learn..any and all help will
be much appreciated.
To help you in your quest to "try to learn" I will direct you to Chip
Pearson's site so's you can learn just about all you'll ever need for Time
Gord Dibben Excel MVP
On Sat, 13 Nov 2004 15:19:02 -0800, "Roger WG" &...