Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Allilue

  1. Allilue

    Simple excel with Dates to show END OF MONTH balances

    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?
  2. Allilue

    Simple excel with Dates to show END OF MONTH balances

    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...
  3. Allilue

    MS excel dates to establish ages

    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
  4. Allilue

    MS Excel count days less list of named dates

    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...
  5. Allilue

    Excel Table (hidden rows and columns) to copy to Outlook in text?

    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...
  6. Allilue

    Excel Table (hidden rows and columns) to copy to Outlook in text?

    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?
  7. Allilue

    Excel Table (hidden rows and columns) to copy to Outlook in 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...
  8. Allilue

    Excel Table (hidden rows and columns) to copy to Outlook in text?

    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...
  9. Allilue

    Create a search tool on a form

    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...
  10. Allilue

    Create a search tool on a form

    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.
  11. Allilue

    Create a search tool on a form

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

    Create a search tool on a form

    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...
  13. Allilue

    Create a search tool on a form

    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...
  14. Allilue

    Listbox to provide values and update Table

    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...
  15. Allilue

    Listbox to provide values and update Table

    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...
See more

Part and Inventory Search

Back
Top