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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Allilue
  • Content: Threads
  • Order by date
  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. Allilue

    Protect Worksheet but allow re-sizing of objects

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

    code to select range, copy and paste to fit into cell

    Hello, I have a range that varies in size (number of rows and columns) depending on hidden cells. I'd like to copy the range and paste this into a cell in another sheet. The only thing is I want to resize the selected and copied range and make it fit into the cell. So if the range is A1:Z50...
  9. Allilue

    Protecting Excel Sheet with Formatting

    Hello, I have created a button that adds rows to my spreadsheet table. Since the sheet is protected, I've done a Sheet1.Unprotect ("password") and Sheet1.Protect ("password") at the end to re-protect. However, I've formatted the original protection to allow users to format cells, columns...
  10. Allilue

    code to hide columns that meet criteria

    Hi! Hope someone can help me here... I want to be able to hide columns within a table if a certain row range is blank. So for example: Row 1 Description A B C Row 2 Test 1 X X Row 3 Test 2 X Row 4 Test 3 X So in this case, I want to hide Column B (no...
  11. Allilue

    Form Selection - Refresh Listbox

    Hello! I have a form where there are 2 selections to bring up records in a subform. The 1st selection is Month (combo box) and the 2nd selection is Name (List Box). When I select the Month, this automatically brings up all records associated with the selection (ok). Then I select Name, and...
  12. Allilue

    Combo box selection to change query

    hello! Can someone point me into the right direction here? I have a form that is linked to a query. I'm trying to create dropdown that allows the user to select a date. Once the date is selected, I'd like this to update a query (criteria for date column). Is there a simple way to do this...
  13. Allilue

    Query to do a cross-tab (I think!)

    Hello, Can someone help with setting up a query please? I have a table that Has a Start Month and various periods (months) to get to an End Date. I've only specified a column for Start Month, Year, and Number of Months. Is there a query I can do that will help to show all months in columns...
  14. Allilue

    Macro to hide row if cell=0

    Hello, Is there someone who can help me with a spreadsheet I have? I have about a million rows, but most of them are zeros. I need to keep them there but is there a macro that can hide the row if a cell within a specific column = zero? I'm hoping this will be very simple! Thanks! Allison
  15. Allilue

    Linked Fields

    hello, I have a subform where there should be linked fields. I initially created the linked fields from the form wizard. Now I have copied this subform and the links seemed to have unlinked somehow. When I try to click on the build button, nothing happens. How do I link master and child...
  16. Allilue

    Report Sorting and Grouping

    Hello, I have a report in which there are 3 levels of grouping. all of these have footers and are in ascending order. SETRollup PrelimRollup CostCentre However, I need the ascending order for CostCentre to override the ascending order for PrelimRollup. When I change it so that CostCentre...
  17. Allilue

    Simple macro to cut and paste

    hi, this is a pretty simple macro i'm trying to create. basically, i can't do any code, but wanted to know if you could provide the "shell" of this macro to help me out. I have 2 worksheets in excel. The sheets are pretty much identical. Based on 2 criteria in Sheet A, I would...
  18. Allilue

    Update Query Criteria using Form

    Hello, Is it possible to create a form to select multiple criteria in a query? I want to be able to run many queries (from one query using different criteria) without having to save the query and display the results. And if this can be done, is it quite "simple"? Help!
  19. Allilue

    combo box not picking up records with null fields

    hi, i have a form with a combo box where you can select a Code. There are 2 subforms on this form which both have this Code field, and other fields as well. for the most part, when i select a specific Code, the records will be displayed on the subforms. I think the problem is that some Codes...
  20. Allilue

    combo box to look up 2 subforms

    hello, (sorry, this is a long one...) i have finally got my form working the way i want it, however, i have one glitch that i can't solve. my form has 2 subforms (Actual and Budget). there is a combo box on the form that the value selected will bring up a common code for both subforms (i.e...

Part and Inventory Search

Back
Top