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: Jamie2002
  • Content: Threads
  • Order by date
  1. Jamie2002

    Linking Dates to a Date Range

    Please can someone help using Excel or Access I have a list of data ie; Name StartDate EndDate Type Program 1 14/12/2003 10:00:00 14/12/2003 11:15:00 A Program 2 14/12/2003 13:15:00 14/12/2003 13:30:00 B Then I have a list of transactions ie; Trans...
  2. Jamie2002

    User Form - Displaying Data from Sheets

    Probably really easy this one. I'm working on budgets.....(great).....I would like a User Form that floats above the sheet and displays key data eg Profit - but it is always visible while I'm off on an assumptions sheet making changes. Also it would need to be dynamic and constantly updated...
  3. Jamie2002

    Code to Output Reports

    I have a table with a list of names in it. I then have a query that links by name and is used for a report. How do I write codes to link the query to the 1st person then output the report, then link to the second person and output the report...and so on.eg Table 1 ------- Mr X Mrs Y Mr Z I...
  4. Jamie2002

    What code do I need to put around t

    What code do I need to put around this to say if the file is already open then skip this command... Workbooks.Open Filename:="C:\Documents s\Desktop\Financial_Model.xls" Thanks. Thanks Jamie
  5. Jamie2002

    Auto set a wallpaper

    Is there a way that I can have program or code or something in my Startup folder so that when windows starts up it will change the background(and/or)screensaver to one of my choice... The thing is the IT department have nothing better to do than make it so everytime you log-on the wallpaper and...
  6. Jamie2002

    Dynamic sheet reference in formulas

    Say I have sheets 1,2 & 3. Then on Sheet 4 I have a formula that says; ='[c:\windows\desktop\Workbook1.xls]Sheet1'!a1 * '[c:\windows\desktop\Workbook1.xls]Sheet1'!a2 Could I have a cell where I type in Sheet1 or Sheet2 etc and this will in turn alter the formula ? I have tried...
  7. Jamie2002

    VBA to - Open Excel files, run links and close

    How would I even start to write code that would open a file update links and calculate cells and then close the file? I am looking to do this in turn for 10 files but all from one set of code. Due to system memory all the files won't open at once, max of about 3 and that's with 383mb memory...
  8. Jamie2002

    VBA to - Open files, run links and close

    How would I even start to write code that would open a file update links and calculate cells and then close the file? I am looking to do this in turn for 10 files but all from one macro. What it is I had a 65mb Excel file (a business model) obviously this was causing problems in itself so I...
  9. Jamie2002

    Stop Screen Flickering on Formula Run

    In Excel how do you stop the screen flickering as it runs long macros......? Thanks Jamie
  10. Jamie2002

    Count if Formula

    I'm currently using a countif formula which has the condition as eg ">50" This returns a count of anything in a list greater than 50. What I need though is to have this 50 as a variable. I have tried a cell reference but Excel is then looking for the cell ref in the list ie...
  11. Jamie2002

    Find a which table a field is in ?

    Using SQL 6.5 how do I find which table a field is in if I have the field name ?? Also how do I list all tables and fields in the database, security levels is not an issue as we have no security or administrators set-up what-so-ever. Thanks Thanks Jamie
  12. Jamie2002

    Write a FORMAT code in a cell

    How do I write code in a cell to format a number in a particular way? What I'm doing is writing a formula which pulls in text and then inserts numbers into the text, ie ="Sales this period were -" & A50 However the number is formatted in the original cell it comes through as eg...
  13. Jamie2002

    Run-Time Error 1004 - Urgent Help !!

    I need help urgently, this morning I was playing around trying to get a spreadsheet to change scenarios by way of a command button and kept getting a 1004 run-time error. Now I've come to do my real work and macros that do data sorts and format and back-up my spreadsheets are all failing with...
  14. Jamie2002

    Code to change Scenario........

    I have made Excel record a macro of me changing a scenario.....then looking at the code it produced the following; ActiveSheet.Scenarios("Scenario1").Show When I try and run this pre-recorded Macro though I get the following error; Run-Time Error '1004'; Show Method of Scenario...
  15. Jamie2002

    Use a textbox to display a cell value

    I'm looking at putting boxes over a graph with further information about the graph. I have created a textbox off the Control Toolbox and thought the easiest way would be to use the linkedcell option. If for instance I want to link to a cell in a sheet called "Graph Data" and it's Cell...
  16. Jamie2002

    Problem with Unrepairable Databases

    I've been writing some databases lately with a bit of code in, nothing amazing, simple changes to list boxes sources, changing row sources based on selections in list boxes, etc. Everytime I compact the database though half way through I get an error to say the database needs repairing, then...
  17. Jamie2002

    Sort on a List Box

    How do you use the GROUP BY function to sort on a numerical field in a list box....? Thanks Jamie
  18. Jamie2002

    How to change Row Source

    I'm trying to write code to change the row source of a list box. On another thread is shows that the SELECT statement needs to be enclosed in " ". Half way along the code is a format(field1, "#,##"), I am getting an error because access expects the code to end after the...
  19. Jamie2002

    Right align numbers in a listbox

    I have a series of listboxs which based upon the selection in the previous listbox return summary figures. ie each list box has a narrative and 4 columns of numbers. I have formatted these numbers so that they show like £123,456 but they automatically align to the left, how do I get these to...
  20. Jamie2002

    Auto Select 1st Record in List Box

    I'm using 4 list boxes whose data all depend on the previous ones selection by using queries and when each one is updated the rest of them all refresh to show the available selections. For eg Listbox 1 contains values "Horse Racing", "Football" & "Other Sports&quot...

Part and Inventory Search

Back
Top