Search results for query: *

Actually I did try that...doesn't selecting MAX in the Balances section output the highest value and not the value for the latest day for each month?

HI, I've got a really simple table showing Dates and Amounts. MONTH DATE AMOUNT BALANCE Jan 1/3/2013 $50 $50 Jan 1/5/2013 $100 $150 Jan 1/23/2013 $40 $190 Feb 2/6/2013 $10 $200 Feb 2/18/2013 $10 $210 Mar 3/4/2013 $100...

Hi again, hoping i can get some help here... if I have a list of names and birthdays to go along, and i want to use a formula that lets me know if they are "under 2 years", how can i do this? i think i'm getting confused when it comes to leap years etc but is this even relevant? thanks in advance

Hi! sorry, i saw some old posts on this topic but i cant seem to figure out how to do still... i'm doing a 'simple' excel file where i have date ranges. so for example, Summer Term runs from May 1 to August 31. I have a formula where I can count the days of the week within this date range. I...

yes, this works but the text would be all over the place. I'm trying to find a way to do this that will probably take complex formulae and not a copy paste job. Sorry, maybe i'm not explaining myself well enough...

thanks, all makes sense, but copying and pasting a table into Outlook is not blackberry friendly. So looking more for a method of getting the info into Outlook, without pasting, so that the information is transferred in some way as text?

Just wanted to add... Prior to the table being summarized, so before filtering on the rows and hiding the columns, the original table is just a list of items, an "X" marked against some, and columns that would have an "X" depending on the item. So: Item# "X" A B C D E...

OK, strange question but hoping there will be some kind of an answer... If I have an excel table where I'm summarizing information through filters (so only showing relevant info), I'd like to get this in a format to email where it will be blackberry friendly. So for example, today I have a...

Thank you. I think this will work... The only other thing is that in the query the FileID is retrieving from, there is a field where it's necessary to enter a Date [forms]![SalesForecast]![SelectDate]. If the user is choosing to Find a Record based on the FileID, I'd like the SelectDate to...

Just wanted to add another piece of info: Essentially i want the search to be similar to a combo box, but with the ability to enter in a value that needs to link with a field in the underlying query.

Thanks - How would you link the query and record number to the search field then? Does this make sense?

Sorry - let me rephrase... I have a subform within my main form that lists records from a query. i'd like to put a search tool on the main form to look up a record in the subform. However, the search box needs to be typed in manually to match the record id to find the correct record. (sorry i...

Hello, Can someone help me - I'd like to create a search tool in my form to locate a specific file (unique identifier FileID). Where do I start? Can you point me into the right direction please... I just want a field where you type in the identifier and then press a button Find to locate the...

Thanks. I can have it bound to the MasterData table, but then how do i get the selection to be the lookup criteria? Does it make a difference if I use a Listbox or a combobox? I've tried the combo and i can get this to link to the masterdata table, but then i lose the ability to allow the...

Hello, I have a Form that is populated by a query (qryMasterData). I'd like to insert a Listbox on the form that looks up the values based on a Table (StageLevel). When the user selects the StageLevel, this should then save in the underlying table (tblMasterData). The Listbox works fine, but I...

Thanks. So in terms of re-protecting the sheet and allowing the shape to be re-sized (the shape being the picture and not necessarily the textbox as you rightly mentioned that the picture object is not in the textbox), can this be done now?

When I don't select the textbox, then it doesn't work properly. I need to select the textbox first, and then it pastes as a picture, although you're correct that it doesn't actually copy INTO it. So what I want to unprotect is the picture to re-size. I'm confused as well... but sorry to...

Here it is, Range("B4:AR107").Select Selection.Copy Sheets("Email").Select Sheet11.Shapes("Text Box 20").Select ActiveSheet.Paste Selection.ShapeRange.IncrementLeft 16.5 Selection.ShapeRange.IncrementTop 69.75 Selection.ShapeRange.ScaleWidth 0.95, msoFalse...

What I mean with the textbox is that I copy a range from within the workbook, and then paste this by selecting a textbox first. The reason I mentioned a picture is because when i right-click the pasted range, the properties state that this is a picture. So the requirement is: Since the...

Last one, I promise!! If want to be able to resize a picture that I've pasted into a textbox while my worksheet is protected, is there a specific "AllowObject....=True" term for that? I've looked in the Help and cannot figure out which one I need to use. Thanks, Allison