Search results

  1. I

    Specifying Filename for Publish Option

    Firstly may apologise that this thread is in here as apose to the Excel group. THere does not seem to be alot of activity in there and it does not specify VBA questions allowed. Within XP & 2K versions of Excel, I have a peice of code setup that allows you to publish a sheet that contains...
  2. I

    Deleting Sheets in Excel XP from Access XP

    Why does the following not delete the listed sheets in excel? Private Sub cmdbtn_crewebbasexcgra_Click() Dim xlSheet As Object, myfield As Variant, xlApp As Object, xlWork As Object, Strfile As String Dim MyDb As Database, MyQuery As QueryDef, strSQL As String Dim objXLBook As Excel.Workbook...
  3. I

    Ahhhhhhhhhhhhhhh - Report Sorting

    Yeah I did that and it is all now sorted Many Thanks Ice Rhino
  4. I

    Ahhhhhhhhhhhhhhh - Report Sorting

    I have done a serach of the Forum and as yet have not found the answer to this. I have seen talk of Sorting and Grouping in reports but it does not appear to help me. I have a report that is based around a Horizontal Bar Graph. There are five regions from West to Albany. When the report...
  5. I

    Compact Command

    Hi I posted some while ago a question regarding the growth of Access databases. Obviously the solution to those of us who have Access is to run the 'Compact' command. However, I am writing a run-time application and the intention is that alot of the people will not have Access installed on...
  6. I

    Split Values in Graph

    My thanks to you Pat for taking the time to answer. Off to write the function now Cheers Toni
  7. I

    Split Values in Graph

    Hi Gurus Here is a little minor problem I could do with some assistance on. I have 49 fields in a data table that are under the value of 500. I have one value that nearly 1,000. Is there anyway to prioritize the graph to show the 500 on a reasonable scale and then just have a 500+ part on the...
  8. I

    Day order not alphabetical

    Cancel this question I have found a solution
  9. I

    Day Order not Alphabetical - One Solution Here

    Here is the solution I used Bearing in mind that I already had the Day number extracted from the "Short Date" as well as a function that converted the day number into the relevant day, e.g. 1 = Mon I ended up with source date that looked like this based on my query named...
  10. I

    Day order not alphabetical

    I have a query that contains both the day number 1 -7 based on a convert val from the short date, as well a field that by use of a function converts those numbers into days. How can I get the Graph in Access to display the days in the correct order, e.g Mon Tue etc etc , not Fri, Mon etc etc...
Back
Top Bottom