Search results

I'll keep that in mind, but for now I think I'll go with your initial suggestion as I think it will be easier to update the shifts if/when they change. All that will have to be through forms and as simple as possible as non-technical people will be maintaining it... Scary, I know.

Yes, it makes perfect sense, and I think it'll work perfectly for our needs. I made the tables already and they're pretty much exactly as you described so that's good - I've decided to add a Mon-Fri checkbox in the Shifts table, since most people work the same shifts each day of the week I'll...

Thanks for that, I think a separate table is definately the way to go and your idea there is definitely better than anything I've come up with so far. Just want to make sure I've understood you right... So for a simple member of staff I would have a an entry in the staffList table, and 1...

Hi, I'm looking for a little advice on how to set up part of a database. I've been asked to make one to keep details of around 300 employees, including their shifts. Their shifts is the main thing that we will be pulling from the database as this is to be used for resource planning. The...

Hi, I have code that calls an append query and then a delete query as part of an import process. The queries were set up in the query design interface and are called by name in VBA. This works fine, but I wonder what options we have for error checking. I have turned off error message for this...

Hi, Thanks both of you for your replies. CJ, it's good to hear that you've been ok with that many people even though circumstances are a bit different. I'm hoping with a couple of design changes this will work out OK. I'm going to take Pat's hint about my monolithic table and split it into...

Hi, I recently made a database that we will use to allocate appointments between a team of up to 30 in 2 different sites. I have tested it with 10 people in the same site using it and have had no issues so far. One of our managers wants to know whether it is likely to cause issues with...

That's a fair assumption, I should have been clearer. I've always avoided using number format unless there will be calculations performed on that information. I've never seen the DateValue function, it would have saved me a lot of headaches over the past couple of weeks if I had :) This is...

Thanks, clientRef is a string and adding quotes prevented the errors although the query still doesn't return any results. clientRef is also a required field, so I will leave the * until I understand what is going on a little better, but will bear what you said in mind for future reference...

IsSkint's code won't come out of SQL view. It says "Wrong number of arguments used with function in criteria expression" Bill's code gives a "data type mismatch in criteria expression" error and I need to click OK a bunch of times to get to an empty table. It's encouraging that you both use...

Hi Bill, The date is relevant as we sometimes have to rebook a client. tContactEvents will contain entries for a rolling 30 day period so we can use it to generate reports on success rates etc. I am considering making a separate table for these historic entries, but so far it hasn't been...

Hi, I have a database that is used to allocate appointments to our staff. It has 2 tables, one that lists the clients we need to call in that day, and another that stores details of each contact attempt. I'd like to design a query that find all clients who we have not dealt with so we can...

Hi, I wasn't in the office yesterday but just gave this a try. The XML import doesn't actually fail, but it doesn't do anything useful either. It created 2 new tables named "Report" and "Detail_Collection" but created no records in either. I selected the option "Append to existing table" but...

Hi, Sorry I should have been clearer. The report I mention is available through an internal reporting tool (not Access) and is set up to just pull the details of appointments we have booked for a certain day using another internal application - we have no control over it other than choosing...

No, I don't have future events in there but that's something I'll try to add in. My code to select based on the different priorities has to use the dateTime column to check when the last contact attempt was to make sure we leave enough time between tries, so it should be easy enough to add. You...

Yes, that's the sort of thing 'm concerned about. I'm using the general "note" field to get around that. I write details on the action to that field, and will check for "reserved" on the most recent entry in the log when considering which client is chosen next. I'm hoping that even if the users...

I can definitely see the merit in approaching this the way you describe. I was reluctant to start over at first, but after thinking this through yours is clearly a far more elegant approach to the problem. I see now why mine felt so sloppy/clunky. I'll be working on this today and will hopefully...

Hi again, I'm looking at getting something like you suggested running. How would I know when a client has been dealt with so that their details are not given to another user? I'm guessing I would have the code find the next client, and then check through the contacted events for a successful...

Hi lagbolt, I was actually toying with the idea of having a second table to write results to as that will simplify some of the other bits I need this to do (like importing a new list of clients each day and collating results). I was thinking it would be a bit more work like you said, but I see...

Hi, I've made a few posts here and got some help to get me this far, I'm looking for a couple of pointers. A quick rundown of what I'm doing: I have a table with a list of clients to contact in a 2 hour window. Some clients are marked as a priority and should be called first but could appear...