Search results

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...

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...

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 :)

Hey Andrew welcome aboard!

Worked a treat. Thank you ever so much!

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"...

Yeah that'll do it! Thanks

Here is the file...

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...

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...

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

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.

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...

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

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...

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...

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...

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.

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.

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 :)