Search results

Hello, I would like to add a drop down menu in one of my forms that shows all the options that have already been used in this field. For example, if the field was language and I had already entered people speaking English and Polish, I would like to be able to choose English or Polish or enter...

Hello, I am using AutoExec to always start with the same form. This form has a header and then a table. I have added a button to the form that allows people to hide and show columns, this button was a predefined button that was available. However, the selection is then saved. I would like to...

Hello, I am trying to either hide a subform if it contains no records using a macro, since unfortunately my place of work does not allow using Modules. I have been trying the following in my If-statement: DCount("*", "subformName") = 0 However, I get the error that ms-access cannot analyse...

Hello, I have to two tables, one with people and one with the orders that people have made. I have a form which is basically a pretty overview of some of the data in the people data in table form. I want to add a column that has all the unique values of a field, let's call it order type, in the...

Hello, I have a form that I use to create new entries for my data table storing information on people. Each person is assigned a unique alphanumeric code. As soon as the user has entered an alphanumeric code into this field, I would like to check if it is unique. Right now, I have set the...

Hello, I just started my first larger ms-access project. I am using a button to open a different Form with data mode set to "Add". When the form is opened, I would like to automatically insert a temporary variable into one of the fields. A bit more context: I have two forms, one that shows...