Search results

Thanks both. I am going to study the blog post more in detail tomorrow and reflect on the best way forward. I really do appreciate the time you guys have spent on this, thanks again.

Thanks Pat, that's why at this stage I am attempting to establish whether what needs to be done can be done via SQL. My belief is that it can, only I'm not fluent enough in SQL to come up with it easily. At the end of the day, if it's not easily doable, I may ditch the Access prototyping idea...

Ok, so: In this post the query in the first picture is generated by this SQL statement SELECT [Schedule].DateServed, [Schedule].PPId FROM Schedule WHERE id IN (SELECT MAX(id) FROM Schedule GROUP BY Schedule.PPId); Essentially Schedules is the table where the teachers are listed, next...

Thanks - let me see if I understand you: if I had an SQL statement that creates sequential dates, what requirement would it clash with, exactly?

Thanks for the questions Firstly about VBA The organisation I'm helping with this has a policy that blocks VBA I am prototyping this as a proof of concept, and to do this I have identified Access as a relatively straightforward prototyping solution This means that the final solution may...

Thx for the question theDBguy - the criteria is based on FIFO, meaning: if I schedule 5 days and 1-5 teachers are scheduled, next time around if x=3 then teachers 6-8 would be scheduled. Hope it makes sense.

Re: Error "The record source '|' specified on this form or report does not exist" The error seems to say that it's trying to interpret the pipe character | as part of the record source. I think it really depends where you are getting the error, is it on a form, a report, a query, etc...

No. If x=2 the routine should create 2 records, not 22. That is correct. That's the specification I posted. These questions really pertain to the operational aspects of the system, which are well in hand, although I do appreciate the concern. What I'm keen to explore is to how create new...

Thanks isladogs, I did not know that.

I posted a reply to last post but it seems like it's gone into a moderation queue.

Most forums get around this issue by activating a feature whereby the user can edit their own posts only within a certain timespan (e.g. 1 day, 7 days etc.). After that the post is locked and only a moderator can edit it. I think this makes sense. Generally there should be little reason...

Thanks Pat. Firstly I want to clarify, I am not intending to change the date on each record. I am looking to create new records and, along with that, for each new record created I want to set a new date. As to what the date would be: let's say that the following query lists all the volunteers...

Thanks again. I will study your blog posts about it.

I see, thanks arnelgp - the issue is, I am unable to use VBA for this project.

Thank you theDBguy, I appreciate it, you gave me some food for thought, I will try with a record count :D

thanks @theDBguy, glad to be here :)

Hey everybody, I am picking Access up again after a long time. I am trying to insert (append) some new records onto an existing table. These new records need to have a date that auto increments by one day for each new record, based on the existing latest date,but I'm hitting a roadblock...

Hey everybody. I am an ex-programmer who used Ms Access almost daily. That was back in the 90s so my recollection of how things work is rudimentary at best. I found this community by googling an Access-related question and I decided to join. I tend to prefer friendly forums such as this to...