Search results

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

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

Thanks to you both, I did not see the big "Show All Actions" Button... It is working now using the temporary variable, but I will also have a look at OpenArgs.

@theDBguy : I tried that but this is not an existing option, and when I try to type in SetValue it doesn't take it and the field is cleared as soon as I click somewhere else... Do I need to enable this somehow?

Hey, thanks for your fast replies! I already have a subform in the customer form as a preview of the orders, but since there are quite a lot of fields, I would prefer opening a different form for adding and editing orders. What is the difference between saving customer ID as a temporary...

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