Search results

  1. T

    VBA Copy Cells to Database Table

    Hi I have a Data being recieved to a excel spreadsheet at 6am, i would like to copy this data automatically to database. I started with just one cell to start with but it it not working what VB i have tried is in the attachment
  2. T

    Date

    I need to put a contol on a Db that makes sure there is a entry for every day. I have [date] and [well reading] in the table.
  3. T

    Graph - Daily usage

    I would like to produce a graph which has a year to date usage and a trendline of what we should not exceed. I know how to do graphs but i cannot seem to get the query to run correctly We document at the moment a daily reading [Date] [Well1] [Well 2] In a query i have got the daily...
  4. T

    Sub Reports

    I am only a beginner at Access, and have got a report i send out every month and it is consists of lots of subreports, I email this out as a PDF at the moment but would like to be able to send it out in excel, when i try it will only do the first Subreport. i would also like to keep all the...
  5. T

    Warning email sent when the previous 7 days reach max

    I have a table which we are allowed to use 35000 cubic metres of water in a 7 day period, from all the wells. listed below [WellID][WellsDate][well4][well9][well5][well10][well12] they enter usage in a form need it to be able to calculate usage (average used?0 and give error if we are...
  6. T

    Automated adding of column

    I have inherited a database at work for the accrual of annual leave at the moment they input it manually, but would like this to auto incrament every month on our financial month. these are the fields [First Name] [Surname] [Department] [Position] [Start date...
  7. T

    Auto incrament fields

    First NameSurnameDepartmentPositionStart date CompanyStart Date SalaryLB start DateLeave BalanceToil BalanceSick LeaveLS Leave I have inhearited a database which they now want me to look at they are wanting to automatically incriment the holiday entitlement. can someone help me please
  8. T

    Subtracting off the same field

    Help Me please I have designed a database which has a current date 1 field and a well reading (Readings) 9 fields which goes something like this [WellsDate] [MainMeter] [GasMeter] [Well 4] [Well 5] [Well 9][Well 10][Well 12] [Well 14][Rendering Heat] I am trying to subtract the readings...
Back
Top Bottom