Search results

  1. E

    query to only show if ID is matching in other table

    Inner join deos work but the one thing I forgot to say is I have a tick box on each medication to say whether a report is required or not. So like say they have 5 medications and two need to be shown or 5 medications and none need to be shown. Just tried it now and it just shows a blank body...
  2. E

    query to only show if ID is matching in other table

    Hi all, I have two tables. One with a persons name and ID, DOB, GP etc (TblName) and one with the persons ID and medication they take (TblMedication). I have a query that runs a report. The header is made up of the first table (TblName) and the body of the second table (TblMedication). All...
  3. E

    What's your best/worst joke?

    On his recent visit to Ireland the Pope was asked what he thought of County Down... He replied it has not been the same since Carol Vorderman left :)
  4. E

    Hello Everyone!

    Hey Andrew welcome aboard!
  5. E

    Copy zipped file and unzip

    Worked a treat. Thank you ever so much!
  6. E

    Copy zipped file and unzip

    Just one more thing ha... I want to stop the process if the file already exists. What would I have to add to my code for that to happen? Private Sub Command47_Click() Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath = "\\LEIGH\Users\Public\Documents\WSRP"...
  7. E

    Copy zipped file and unzip

    Yeah that'll do it! Thanks
  8. E

    Copy zipped file and unzip

    Here is the file...
  9. E

    Copy zipped file and unzip

    So I had a play around and I decided to change the idea. I was hoping to copy a zip file and unzip it in a new location but instead have just opted for copying and folder with files to a new location. Each location is on a local network so it takes a little while to process. I was wondering if...
  10. E

    Copy zipped file and unzip

    I've managed the copy aspect fine but am struggling a bit unzipping the file. Its a bunch of folders with files inside. Don't know whether that makes a difference? When I try the standard unzip method it says bad end of statement. Private Sub Command47_Click() FileCopy...
  11. E

    Copy zipped file and unzip

    Hi guys, Just wondering how easy it is to add a button to a form with a function to copy a zipped file to another location and unzip it? Cheers, Paul
  12. E

    Open another form based on ID if no records

    Thanks for the reply and the work you've done. Guess I'll look into openargs as I've never used that before. Also as you said you wouldn't do it this way, what would your suggestion be? All the work I've done has been in this way with opening and closing forms.
  13. E

    Open another form based on ID if no records

    Hi, Sorry about that. I have now removed the auto minimize stuff to make it easier to play with. Basically when the main form opens [FrmResident] if you select a resident from the drop down and press "View GP Details". If they have a GP it'll show you the info. If not you'll get a message box...
  14. E

    To automate a process

    Thanks for the replies guys :) I shall indeed go through your three steps and report back on here when I get this thing moving.
  15. E

    To automate a process

    Hi all, I have been wondering whether it is possible to do something with a database I have. I make time sheets for staff members at work. I currently use a system of a bunch of word documents with a four week template of their hours on and I create a default word document template for the...
  16. E

    Open another form based on ID if no records

    Hi all, I'm working on a database for residents at a care home. I've just started and I want to automate a process where I can click a button and see the contact details of a GP. It's all working but I want it to be that if the resident has no GP it will open a form so you can choose a GP. I...
  17. E

    Sum to work out annual leave

    Sorry no what I meant was someone suggested normalising the tables so to remove some tables and simplify it. I reduced it down to a bunch of tables. One for day, one for week, one for location, one for staff, one for location. But was told I could put the day and week option within the table. I...
  18. E

    Sum to work out annual leave

    Yeah I changed the design before and it was suggested I use the weeks and days as lookups rather than in tables as I previously had them. I have read the dangers though and I agree. What would be your suggestion based on my database. I am still just learning as I go.
  19. E

    Sum to work out annual leave

    I've managed to work this all out apart from one vital part moving forward and that is if the end date of a staff member is before the default start date. That they are not included in the query for that year.
  20. E

    Sum to work out annual leave

    The equation is total hours over 28 days /4 x 5.6 x (number of days worked / number of days in fiscal year) In regards to holidays etc they do not count. It's just based on the above. And it's the uk that I'm in :)
Back
Top Bottom