Recent content by brt

Thanks for your reply. I added Archives.DivisionID and Divisions.ID to the RecordSource query and linked them (if I only add Archives.DivisionID, I cannot select Divisions.ID for the combobox’ RowSource). In the combobox, I put two columns, Divisions.ID and Divisions.Name, the first being...

Hi, I have an access project with two tables. “Archives” contains all the folders of an enterprise with for each folder its title and the ID of the division to which it belongs. The other table is called “Divisions” and contains the division ID’s and for each ID the name of the corresponding...

Thanks for your reply Bob. Actually, I have a properly working Access application. It’s goal is to manage the archives of a water company and the database contains references to all files in the archives, as well as the users borrowing these files and the files that are actually borrowed and...

Hi, I want to create an access spreadsheet form in which the user can add data, which will be – after being processed – added to a database table. The spreadsheet form is for this reason not directly linked to a database table. In the spreadsheet that I actually have, I manage to copy...

Thanks. Actually, the error is in the last line: Set rsf = rst.OpenRecordset VBA needs to have two arguments for the OpenRecordset command. I tried to put the same two arguments, but I still get an error message.

Hi, I want to filter records of a recordset to export them afterwards. What I did is opening a new recordset, applying the filter and then creating a new filtered recordset. While executing the code, I get an error for the following line. The error is saying that the function should at least...

Hi, I have a comboBox that shows all divisions of an enterprise, read from a table. The selected division will be used in a search form. Now I’d like to add an item “all divisions” to my comboBox. I tried the addItem method but apparently this is not possible when the items of the comboBox are...