Search results

  1. T

    Bradford Factor Calculator

    This database was compiled to meet a need for an easier way to calculate the Bradford Factor for absence tracking. The main query that does all of the work was written by LBH (from this forum) so, to give him the credit he deserves, I'm posting this for all to use as they see fit.
  2. T

    Calculated Field in Query that won't work!

    I'm trying to produce a calculated field (Bradford Factor) using a count of the start date (number of incidences) and the workdays total. I've tried pretty much everything I can think of and looked at all manner of websites to no avail. The calculation works fine on the report but I want to...
  3. T

    Any Ideas?

    I have an Access 2003 database running on a server. Today (for about the 5th time in 6 months) Access reported that the VBA was corrupted and tried to repair the database. As usual, it didn't work but I don't know what to do to prevent this in the future. Any ideas? Our IT bloke is scratching...
  4. T

    Summary Subreport won't display data

    I'm trying to report our raw material spec data (width, thickness, hardness) in an Access 2003 report with a summary/subreport in the report footer that shows the data that has changed in the past 60 days for our suppliers. The 60 day summary report works fine until you put in in the report...
  5. T

    Installing MSGraph Components

    Hi Gang! I'm trying to add graphs to a db to help display scrap/rework totals on a week by week basis. The query works absolutely fine but when I try to add a graph to a blank form in design view, I get a pop-up "Installing Components". This takes about 2 minutes EVERY time I try to do anything...
  6. T

    Either I've gone stupid .....

    Hi Gang! I'm trying to change the contents of a control's label based on the contents of another control. I've tried using the AfterUpdate on the second control but nothing happens. Am I giong stupid or have I missed the point with this and should I be going directly to the code on the form? BTW...
  7. T

    Importing *.csv into Access97

    Hi! I've got a problem with a csv file from our MRP system. It always contains spaces BEFORE the data in the fields and I need to ignore them when I group the data. The crosstab report works absolutely fine but I don't get the right output because of those darned spaces!!:mad: HELP!!:confused:
Top Bottom