Search results

I get it. Isn't it the case for both Weekday and WeekdayName? Am I wrong in assuming that since I omitted the start day parameter in both Weekday and WeekdayName, it takes the default value of Sunday (being the first day) and therefore should be synced?... but for some reason they aren't.

Hi, I've got a form element (txtStartDate) that is linked to a Date field in a table. I've created another element in the form (txtStartDay), a text box, that displays a week day of the corresponding date. This however does not work as intended. The displayed weekday does not correspond with...

Hi, I have a few fields in a form and a corresponding table. The first element of a form is a combo box. Based on the selection, the "Course Sequence" field is being populated based on another field. Where I'm stuck is the third field which is supposed to get a MAX of type of courses of a type...

Thanks. Hopefully, it'll all work out fine. Would really appreciate some comments on the actual db file. Being a new Access user, not sure if I'm going in the right direction (with what dataset I have been given). Will need to read more on update queries. Can they spot the differences between...

Thank you for your response. I share the concerns you mentioned, unfortunately, this has already been explored and sadly that's where we are. The SLA does not cover some of the information that need to be inputted locally. We are not going to change ANY of the data provided to us, only...

First of all, thank you for helping me with my other queries. In recent weeks I have learned a lot by just reading this forum. I'm still a total newbie when it comes to access and, as you can imagine, my knowledge is very fragmented. I have already described the situation a few weeks ago in...

Brilliant. Thank you. Both solutions work like a charm. Really like the option to choose what you'd like to search for (eg. ref or name) In the first solution, was there any reason to change the rowsource from a query to a table? Is one more preferrable to the other?

Hi, I have created a search field with a list box/list in a form (search for a learner name), as well as a subform displaying learner details and courses enrolled on. The search box and search list controls work fine. Once you type some characters in the search box, possible matches appear...

Thanks. That was it.

Please find attached the db file. Thank you all.

Thanks, however, that the following happens: I change the value in the FamilyName combobox: a) GivenName field is empty b) When I click on the GivenName comboBox, the options from the previous FamilyName selection are available c) when I click on the GivenName combo Box AGAIN, the right...

I'm just practising my ComboBox skills and have stumbled upon this. I have a form ("DropDowns") with two combo boxes on it: "FamilyName" and "GivenName" What I did: "FamilyName" ComboBox: RowSource: points to the FamilyName record from a "Learners" table. SELECT DISTINCT...

Sorry I have not been back for a month but I've now been given slightly different requirements for this database. It's a bit frustrating but in a way, it's slightly simpler. Will formulate some questions in the next few days. Will definitely need your help. On a side note, can anyone...

Thanks. I think I understand the logic. Will digest it, try to implement it and report back in a couple of days. Thanks

Ok. Thanks. But that still leaves me with the question of how to create the relationship between the linked dataset and my custom table. My custom local table has no records yet and no learnerID or CourseId. In one of my previous posts I asked if it is possible to autopopulate the records of my...

Ok, now I see where I'm failing to communicate it. My custom fields ARE in a separate table. I don't want to amend (is it even possible) linked report data so I can just replace them (the linked excel report files) on a monthly basis.

Yes, both have LearnerID Yes, it's possible that some details will be amended (eg. updated contact details in the Learners table, or some course details fields in the Courses table. What will remain always the same is the LearnerID in both tables and the CourseID in the Courses table Since...

Yes, it is cumulative. Each month it is the current and full snapshot of the data. For example in September's Courses report it'd be: September report John Doe/Course A October report: John Doe/Course A Joe Bloggs/Course B November report: John Doe/Course A John Doe/Course B Joe...

Not sure I understand this point. The monthly report data is the current state of things. I'd want to start with the latest import and build on that. I'll research a compound index. Not sure what it means. Yes, the Learners table does have those details about learners. I'm sorry I'm...

The background story is that: we have a parent organisation doing the data entry for us. On a monthly basis, they provide us with a set of fixed spreadsheets/reports. For that reason, I don't want to do data entry again. The problem with the those reports is that they are box standard and...