Search results

Hi, I've created a set of queries that I'd need to export every month. I've started looking at macros and have found that I could export a query using a series of ExportWithFormatting actions A couple of questions: - Is it possible to export it without formatting? I can't see an equivalent...

Hi, I have a table with a couple of variables. The table is structured as follows: Period | YearCode | ------------------------- R04 | 1920 The only thing that'll change here is me occassinally changing 'R04' and '1920' to some other values. I want to be able to change it in one...

Hi, I've got a field with records as follows: 17/18RO 18/19RO 17/18RO 16//17RO It's all consistent: 2 digits / 2 digits RO I'm trying to extract just 1718 or 1819 or 1617 in a query (basically the 4 digits) I've tried val([field]) but it only returns the first 2 digits. Please advise...

Hi, Last month some of you were kind enough to help me with some date genreation. Public Function fncInWeekDay(ByVal dte As Date, strWeekDay As String) As Boolean Const holiday_tbl As String = "tblHolidays" Const holiday_field As String = "HolidayDate" Dim lngCount As Long...

Hi I am trying to exclude value 40 in a query. Most records in this field are blank, some have numerical values. I would only like to exclude 40 from those values keeping all the blanks and other values. When I do: <>40 It also removes all the records with where this field is blank keeping only...

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...

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...

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...

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...

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...

How to create a table with autopopulated information Edit: Apologies for the generic title 'How' - looks like I pressed Submit before finishing writing the full title:) Hi I'm new to Access. I have been using it for a few months producing simple queries on data generated by the college's...