Recent content by maxgold

Thanks, but that doesn't really solve my problem. People are going to save the form sometimes, I know that I regularly hit ctr+s while working out of a habit. As soon as I do this, the form is saved and then birthdate is visible when I open up the file again. That's why I would like to set...

Thanks, but unfortunately I am only allowed to use Macros and not VBA code and modules...

I am sorry, reading my question again, I may have been unclear: it's not that the shown/hidden column configuration isn't saved, but I would like it to be, it is rather the other way around - the configuration is being saved but I would like to disregard this information and ALWAYS show the...

I have removed the close (X) from the form, I don't understand what that has to do with opening it up with the same columns hidden / shown every time? I do want to save all of the other changes, I just want to make sure that on startup, I show the same columns. That's why I thought I should add...

Thanks, I just figured it out - despite the official description of the German version of DCount stating to use commas between the inputs to the function, you actually have to use semicolons in the version I have... It's working now!

Yes, I do. They both have "ID" in them, refering to the name the linking fields have in the two tables.

I have created a sort of minimal example. Let's say, on startup I want only first name and surname to be visible, but birthdate to be hidden. By using the button, it is possible to make birthdate visible as well, but after saving, closing and reopening the file it should again only be first name...

I'm sorry, but I don't know how to "to check this table and Hide/Show column depending on the Visible column"

Thanks, but unfortunately this still gives me the same error. It seems as if my MS-Access might not know DCount? However, according to https://support.microsoft.com/ the version (Professional Plus 2016) should have it. I also tried other Tables, but nothing seems to work, also not outside of...

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

@Petr Danes : This works perfectly, thank you so much for the detailed explanation!

Thank you for the explaining the options at which point I could implement this! I think I will try and compare the BeforeUpdate and the LostFocus. I am still fairly new to this, could someone also explain me how to check if the value exists already? I've had a look at Dlookup but I'm not...