Search results

Hi, it's me again. I haven't got to implement the above. First I wanted to replace your magic code wizardy generating the dates for the next 25 years to my Operating Schedule table where the dates span this academic year only (August 2019 - July 2020). The reason I'd like to do it is the fact...

Thank you both. You've been most helpful. I'll need to go over the files you've attached. Such a great opportinity to learn new things!

Thank you. Much appreciated. I am out now will have a look in the evening. Before I left home, I had a very quick look at the first file. I like the idea of generating all the dates straight away for all the courses. I have noticed that you created a query with system dates. Wouldn’t the...

What controls did you use in the subform to record specific days (eg. multiple comboboxes?)

Hi. Thank you. Yes, that looks good.

The report will be something like that the attached screenshot.

Thanks. I saw some examples online but was hoping there must be a simpler way. I mean so much code just to save a couple of values in records. Will revisit it.

Thanks. Not neccesarily. More a list of all dates for 1 course. If you choose a course in the combo box of ListSessions Form and click on the button present in the form, it'll run the qrySessionList producing a list of dates/days that particular course will run. The problem is that it does not...

I agree but, as I've googled, if a listBox has multiple values (eg. Monday and Tuesday), it does not save the value to table fields.

Right, I was trying to do as much as I could before I reply. I've made some progress but not much. Mostly on my second point above. I'm attaching my test database to better illustrate it. Form: CreateCourseCode: One of the controls it has is "DayName" listBox that lets you select multiple...

Thanks a lot. Two questions: TblDates: reference table with all the dates and the teachingday field QryCourseCodes : contains course codes with the actual start /end dates Do I just create a relationship between the date field in tblDates and the startDate (and separately endDate) in the...

I have a table with dates for this academic year. The table is structured as follows: Date_field, teachingDay The date field contains dates starting 01st August 2019 and ending 31st July 2020. The teachingDay field contains either 1 or 0. 1 - it is a teaching day 0 - non-teaching day...

Thanks guys. Minty's db works fine and is just simpler. I didn't know you can just type an expression (like an Excel's formula) in a text box.

The txtStartDate in the form's control source is StartDate field in the table (which is formatted to Date) - hence the date picker on the form. I'm not saving the txtStartDay anywhere. I just want it displayed on the form. That and the txtEndDay. The reason for that is to assist the person...

But wasn't Format(...) supposed to be working independently of the system locale? The fact that it works fine for you and not me means that it doees seem to draw on the system settings of a particular computer, doesn't it?

Thanks for the help and the link (very useful). So I've changed the code to: Private Sub txtStartDate_Change() Dim USADate As String USADate = Format(Me.txtStartDate, "mm/dd/yyyy") Me.txtStartDay.Value = Format(USADate, "dddd") End SubStill the txtStartDay results are inconsisent...

No, this is just for Course Code creation for cohorts of learners. Then learners will be assigned one of those course codes. There will be nothing about individual learners in the CourseCodeGenerator table. In the end there will be 3 main tables: - Learners (learner id and personal details) -...

Yes, the LAIM and CodeSequence are (or should be) unique to each other. The table in this test database hasn't been cleaned up yet. In the end, there will be one LAIM corresponding to one CodeSequence. Thanks for the formula. I'll change the Count to something else. Anyway, I don't think it's...

Regarding the date conversion - how do I do it? Also, is it possible to do it in the background so administrators using the form see the UK format and it gets converted to the US format to do any calculations.

Thanks. I'm trying to run the following: Option Compare Database Option Explicit Sub testme() Print WeekdayName(1) End Sub but I get the error: Compile Error: Method not valid without a suitable object. Sorry, am new to Access:)