Recent content by Haahz

  1. H

    Wages Query

    The hourly rate, normal hours worked, and overtime hours will all be different. Would there be a way to have this query so when data is entered it calculates the overtime worked if overtime has been worked. Sorry math isn't my strongest point.
  2. H

    Wages Query

    Anyone? I really need a hand, and its urgent.
  3. H

    Wages Query

    Hi I've just created a query to find the wages of certain staff, hours worked * hourly wage, it works. How would I go about calculating overtime, for the company their overtime is calculated at their normal wage + 10% of the normal wage. I've got a tick box, stating if a certain employee has...
  4. H

    Inserting data from Excel?

    Hey, I've got a list of data on Excel that I need to put into one of my tables, I only need the one row from Excel, how would I go about copying the row from Excel to Access? Thanks a lot. Haahz.
  5. H

    Combo boxes

    Right I've spent hours and hours looking how to create a cascading combo box. I've downloaded many examples of them, but I cannot get my head around the way they work. I've got a database and I need to create a cascading combo box, I've got a combo box with Car Make this lists all Car Makes for...
  6. H

    Codes

    Hi, I'm sorry about this very basic question, you will most likely think I'm stupid, but I've got a code to make a Login Screen, and I know I have to put it in Visual Basic, but I haven't a clue where it goes. So could someone tell me. Sorry for this silly question, I have looked around a bit...
  7. H

    Registration plate

    Yeah they are.
  8. H

    Registration plate

    How would I make sure the number is unique without doing it manually?
  9. H

    Registration plate

    Yes it does.
  10. H

    Registration plate

    Hi, I'm having trouble validating a registration plate field for cars. I need it to do the following rules: 1st Letter cannot be I,J,Q,T,U,Z, 2nd Letter cannot be I,Q,Z, Last Letter cannot be I or Z Also how will i make it so it can include both old and new systems, old would be something like...
  11. H

    Use data from one row on another?

    Hi, I'm very new to access and I'm building a system on Access for a company. The system is a booking and stock control system, and I've become stuck. I have made all the tables, one row on the table is really bugging me, I've put Car Make as one row for example Citroen, Fiat, Ford etc, I want...
Back
Top Bottom