Search results

  1. H

    Using a query that creates a random result as the criteria for the a field in another table

    Hi All, I have sorted it myself, I used a DLookup in the vba and that has worked, see below in case anyone else is wanting to do a similar thing Thanks Matt
  2. H

    Using a query that creates a random result as the criteria for the a field in another table

    Hi All, I have a test database that I am using some for next looping to enter records to quickly make a lot of records for testing. The table has only a few fields which is a date, disease (I work in a hospital hence this field) and new diagnosis which is a tick box. I then have a second table...
  3. H

    Cannot access a new DB or open an existing DB

    Ok a quick update, I put my name in the name and hit enter and that worked so I can make databases and open etc... So now does anyone know how to take this off so it doesn't show up everytime? Many thanks Matt
  4. H

    Cannot access a new DB or open an existing DB

    Hi All, Need some real help here, whenever I try to make a new database or open an old one I get this, this isn't the password for the databases, I have no idea why it is showing up. Is there a default admin password that anyone knows of and how would I stop this from happening in future? I am...
  5. H

    Overtime worksheet

    Thanks for all the suggestions guys. I used your method Pat and calculated the minutes then converted down to hours it's a lot better than how it was and I am happy that it accurately show was was owed and taken so thank you all. Matt
  6. H

    Overtime worksheet

    Sorry posted before finishing the post. It calculates the difference between the times with a running SUM() at the bottom. If usual<actual then time is added and if usual>actual then time is taken away, this is shown by colour codes - green = owed, orange = taken. The issue that I have now...
  7. H

    Overtime worksheet

    Hi, I am in need of some help, I have created a database in work which has a continuous form that I used to allow myself and colleagues to record the overtime that we do, the form has the staff name, date, usual end time and actual end time and then a calculated field formatted to time which...
  8. H

    Making a calendar type thing

    Thank you guys for the help. @ArnelGP this solution worked a treat I tweaked it a little without managing to break it completely so i will get the monday of whatever week the first of the month is on this will be very useful for the purpose of the database Thank you all very much
  9. H

    Making a calendar type thing

    Hi, I wonder if someone could please help me, I have a form which has a lot of list boxes and text boxes above them - the text boxes hold dates and the list boxes show people who are attending on that date. Currently the first box shows the monday of the current week and the rest populate with...
  10. H

    Hello!

    Hi All, Names Matt, I did ICT in school where I was awful at Access but somehow passed. Now I work in an office that wanted databases for various things so me being me I was "Yeah I can do that" I had to relearn everything which I have been doing over the past couple years but now I want to...
Top Bottom