Search results

Exactly this is what I was looking for. Works like a charm. The normalisation may be ideal, but my scenario is a little tricky due to existing tables and forms. @arnelgp you are a life saver always. Big thank you.

Thank you. The DesiredOutcome column may have duplicate records. Duplicate values need to be checked in the columns and combined. How can we do that? Thanks in advance.

How could we combine values in columns excluding duplicates (column-wise) and blanks? Duplicate check on column-wise only, not row-wise. Below is an example scenario. Please advise how we can achieve this. Sequencing of combined items not much important. There may be a preferred sequence to...

As suggested earlier, I have split into multiple tables with linking. it works at the moment. if running into difficulty, I will return back to you. thank you very much for the support.

Thank you everyone for the answers. As all understood, it's like a questionnaire data filled by someone. The whole history of one person/customer from the first date of visit, purpose, the outcome of the meeting and subsequent events with more fine information. As suggested I will try to break...

Understand tables can have a maximum of 255 fields. I have around 400 fields which all are unique and cannot be reduced by normalising. How this limit can be overcome without affecting any queries or forms linked? Thanks in advance.

Thank you. found the problem. using "yyyy-mm" format for sorting, this was the hidden field. Thanks for the clue. Now problem solved.

Thank you. It worked for me. I tested creating a totals query and generating crosstab from the total query. your sample was an eye-opener for me.

Would like to compare the monthly figures against each year. Have a totals/crosstab query grouped at month level like below. 2020-01 25 2020-02 50 2020-03 40 2021-01 20 2021-02 25 2021-03 35 However, I would like to have this in the below format Month 2020 2021 1 25 20 2 50 25 3 40 35...

Thank you. Your app has so many features. Could you please refer me to the exact feature where multiple combo items stored in one table. I am so novice in using access. Sorry for asking the basic question again.

I understood as below. I will have 4 fields in the combo table with additional combovalue filed. Will store the comboID(autonmber) in the main table. can use query to show combovalue or combodesc or both as required. thank you. ComboID(autonumber) ComboValue ComboDesc ComboObjectID 1 1 Male...

Yes, this is the outcome I look for. In this way, ComboID will be unique and this needs to be stored in the main table. But comboID values not always a running unique number. For example "1" in the gender field represents "Male" and another field may represent "Applicable" or something else. It...

Thank you for the suggestion. I tried the above method, it helps to keep all combo in one table. While building the query to pull the description for various fields, I failed to build the relationships since they all in one table. How to achieve this? Below is an example query what I have not...

Final data taken out is in CSV format with all fields are coded like "1",2", "3" etc. There are more than 100 comboboxes with structured dropdown items. Comboboxes can be linked to tables or value list. Tables will be more helpful since queries can be built to describe the codes but value lists...

thank you. it worked like a charm. you are a star.

Thank you now it successfully renames the network files. I tried to modify the below code for moving files in network location path with below code, it doesn't work. I think I miss something here. for your kind help. Option Compare Database Option Explicit Public Function fncMoveFiles(ByVal...

Hi arnelgp, Again have to come back on how to solve a specific problem arising from the usage of the above functions. File rename and moving work fine if the folder location is named starting like "G:", "K:", "C:". However, if the location is on a network location starting like...

In the number filed having a mix of numbers like 1.35 or 0.22 or 3. However, I can see all with two digits including full number like 3.00 or no decimals for like 0.22 as 0. Which is the right format to solve this problem. Would like to see display decimal digits only if it having decimal value...

Thank you arnelgp for solving this problem. Always you post detailed code which is really helpful for the beginners and non coders. much appreciated.

Thank you, Doc. I will start learning about FileSystemObject.