Search results

@The_Doc_Man Hey, I just want to thanks you for all the time you spend on this threads and the efforts to help.

I think you missed to tagg "SOLVED"

Yes, thanks for clarifying the point. I understood the needs of this VBA codes, specially for continuing FE upgrades for many user's without looking whats version they are using or changing their FE file. In my case systems is for "Info Mng and Acc Sys" which is not require continuous upgrades...

Thanks The_Doc_Man for your kind interest to help me. Although it's some how difficult for me to understand your level of explaining's, but I am on going to learn thease steps. Yes, I am already doing both 32bit and 64bit *.accde files by the simple way:- 1- Copying my master file to two files...

Thanks for your help, Yes I distribute the .accde files (front end and back end) since long time. Each time I upgrade a system I should create 2 .accde files for the users 32bit and 64bit with it's long process of protecting each file. I am using office 2016 64bit and VBA with a limited...

Yes, but I am little confused about the steps

could you or other share the solution steps, so me and all others searching for this article solution can benefit from it. Thanks in advance

As I am searching for an increment VBA counter solution, preferably @yunhsuan to mention which one solves his issue, and mark the thread as solved, so any ones searching can easily follow it.

Dear @bastanu I searched and find your solution solved my problem in a single Subform Combo-Box. Thanks a lot for helping all of us.

Refer to my previous replay https://www.access-programmers.co.uk/forums/threads/autonumber-advice.314336/post-1727941

Me also, looking for your replay.

Hi Stuart H I see in the Design pic, you have four columns in your query, go to the column Number 5 which is empty column in the query, then in the Property Sheet, try change Unique Value or Unique Records to Yes, then one of it will solve the duplicate data for you.

Hi ChrisMore, You are welcome. I am learner and trying to help up to my level of knowledge, but unfortunately, that codes still above of my knowledge level. Here is many experts they can help on this matter.

Format the date entries field dd/mm/yy or mm/dd/yy or dd\/mm\/yy

just you can make a new simple query reading from this union query, in the field write :- MaxDAte: Max(More Info Date) It will show only the max date

I thought Format([Order_date],"YYYY") instead of Year([Order_Date])

The same idea, Try format: dYear = Format(me.DateOfReport,"YYYY") dMonth = Format(me.DateOfReport,"MM")

You are welcome. Happy to help.

Hi, On your case the remarks should be in the class table not in the name table. Then you can issue the name report grouped by the classes, and at the group footer of class report show the remarks.

Hi, I thought you could make a UNION query, unified with tow column, Id and Information, For the five fields Like this: SELECT ID, More Information1 AS Information FROM TableName UNION SELECT ID, More Information2 AS Information FROM TableName UNION SELECT ID, More Information3 AS Information...