Search results

Thanx Paul. Stay well. Joseph

Hi, I have two list boxes which I want to cascade but my code does not work: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "(ProgrammeID) = " & Str(Nz(Me![lstProgrammes], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark...

Hi, Thank you for your responces. However, I couldn't adapt it; hence, I resorted to using another approach by lebans here: http://www.lebans.com/rownumber.htm Stay well. Joseph

Hi, If I want to arrange records sequentially in a report I would do the following: From the Toolbox (Access 1 - 2003) or the Controls group of the Design ribbon (Access 2007 and later), add a text box for displaying the number. Select the text box, and in the Properties Window, set these...

Hi Bob, I appreciate your help. It worked. Stay well. Joseph

Hi, I am trying to pass the filtered data in a form to a report. The build filter function is as follows: Private Function BuildFilter() As Variant Dim varWhere As Variant Dim varSex As Variant Dim varRank As Variant Dim varItem As Variant Dim intIndex As Integer Dim...

Thank you Eugin. I got a similar error when combining Rank with another field e.g NRC, Family Name etc. Stay well. Joseph

Hi once again Eugin, By the way I am just trying to adopt the code and expand on it by including more controls on the form. I need the multi select listbox to be able to select one or more than one entries. Rank is for ranks like in the military. Not quite sure since it appears in the...

I have been looking through the codeand observed the same but did not know how to fix it. I will appreciate your help. Thank you Paul. Joseph

Hi, Below is part of the code I am using to query database on a form. However, the combination of the two blocks of code (i.e. ' Check for Sex/Gender in multiselect list and ' Check for Rank in multiselect list) below is not working. Instead I get Syntax error (missing operator) in query...

Resolved. Thanx Joseph:p

Hi, I downloaded a sample treeview application I have modified most of its to suit my need, except one thing. I want link parent/child node the main form to the main form through a subform on the CategoryID. The following is the original code where when a child not is clicked only pops up a...

Hi, Given the following tables: T_Personnel PersonnelID=PK Family Name=text T_Divisions DivisionID=PK DivisionName=txt T_Stations StationID=PK StationName=txt The three tables above are linked as follows: T_PersonnelTransfers TransferID=PK PersonnelID=FK DivisionID=FK StationID=FK How can...

Thank you so much. Regards.

Hi, I have two list boxes on a form. The first listbox contains CATEGORIES and the second contains ITEMS that belong to respective categories. So, when i click a category the next listbox displays the items that belong to that particular category. I need to know how to add new items to a...

Hi Anthony, It worked! Thank you so much for helping me out. Stay well. Joseph

Hi Anthony, I have followed your instructions and the first part worked where i created a query to group PersonnelID and TransferDate without duplicate. Fine. I have also created another query Q_PersonnelTransfers from T_PersonnelTransfers that holds all transfers. Then I joined the two...

Thanx people. Please, remember that a Person could have more than one transferDates to different divisions/stations. Hence, I want the query to include the following fields based on the maximum (recent) TransferDate: PersonnelID--TransferDate---DivisionName-----StationName 1...

Please, allow me to ask this question again which has gone un answered since the first post. I have three tables namely: T_Personnel personnelID=PK FamilyName T_Division DivisionID=PK DivisionName T_Stations StationID=PK DivisionID=FK StationName I am recording personnel transfer history in...

Hi, I am trying to create a crosstab query that should only return records with the personnel's recent transfer date, recent Station and recent Division. A Divison can have more than one Station, and and a Station can have more than one personnel. The database is aimed at tracking personnel...