Recent content by craigprice

Hi, Not sure if this is possible at all but I have a table with the following structure; 01DAY | 01NIGHT | 02DAY | 02NIGHT | 03DAY | 03NIGHT |Etc etc. up to 31. These are either filled with null values OR D or N I am wanting to build an update query which will look at a form where a FROM...

This is an example from excel, if you check tblrota form that shows the idea My aim is to have a rota view of; Shifts and Month You can flick through shifts to look at all the shifts and the months for their shift etc etc. I want it to tell me how many staff are on days or nights on that...

This is my basic idea; Rota system – picks up “default” shift pattern for each shift (1,2,3,4) this then looks at which shift the colleague is part of and then uses the specified defaults to list their days/nights to work, the exception being if they have time booked off in tblAmendments, I...

Now having another issue with this. While trying to build the rota I want to lookup a table to see if the colleague has booked off holiday, I came up with this. Nz(DLookUp("[Type]","tblAmendments","[Colleague_ID] =" & [ColleagueID]),Nz(DLookUp("[01day]","qryrotadefaults","[Shift] =" &...

Hi, thanks for your response, still having trouble getting my head around relationships. The skills can have multiple colleagues with each skill, do I just do this as a multi value lookup?

That's good to hear! I really want to learn but feel I keep falling down. qrySHIFTAJAN was the old query, I saw the error of my ways and have changed this to simply look for the shift referenced in a textbox on the Rota form now, same for month. Basically under rota in the query I used...

Ok so how would I go about doing that, do I create a second query to count the entries in each row?

Hi, I am producing a form for a rota system, within the rota I want it to look at staff on the day/night shift and check their skills and count them, the counts then populate a footer item with numbers so we can work out where and what cover is needed, this is probably me being a novice and...

Basically I have my DB file which users connect to via a F/E form. I'm happy to load the data once and then if the number of items in the query changes then the recordset/array is recreated rather than pulling all the time. Bascially what will happen is Managers will input any ongoing service...

Hi, I've added a link to a sharepoint list and am able to add info to all columns except one (this is a required field) this appears to be a multivalue field as when I look at the table it shows the value for old items as this: ;#ITEM1;#ITEM2;# etc etc. Does anyone know how I can...

This looks to be the right way I'm going, pretty new to doing anything more than just data tables haven't really worked with relationships. The current setup is basically that in AppLinks there is a clickcount, this increases on each click by a user, I want to swap this to make it...

Hi, I have the current setup: TBLAPPLINKS ID AppName AppLink 1 Google http://google.co.uk tblWorker ID loginID 1 12345678 I want to take these two tables and have an auto building table that will add each login ID from tblWorker to a new form as a Field name alongside those from...

Ok, I managed to get it to work in a sense, now I just need to stop it from adding duplicates but can't figure this out! This is what I have so far Private Sub Form_Timer() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = Access.CurrentDb Set rs = db.OpenRecordset("updates")...

I had thought about using outlook as an option but I think it may be irritating for management to have their phones going off with the regularity of the different notifications we'd have. Is there a simple way to get an IF statement to run on each record on the current form? I thought...

To add more complication the items may differ on weekends too so don't know how well that would work... Not wanting to sound difficult just trying to explain as best I can :D Thinking about it, I think the easiest way to explain what I want to do is basically run an IF statement on all...