Recent content by Shimon

For beginners, I would recommend Ryan’s tutorials. I find myself going back there every time that I don’t use regex for a few months.

He probably stole it from this post. I think AI is male. Shimon

Hi, I am just now starting to use AI in a similar manner and would be greatfull for a video series. Sincerely, Shimon

Hi, There are two distinct organizations, providing similar services in two cities. We (my daughter) started off about seven years ago, in a small storage room, with five sets with between 5-20 dresses per set. We had an Excell sheet for each set, and i created a cross query to print out each...

Hi, The application was written for (and in) Hebrew. The main benefit of using this version of Access is that the orientation of all f Forms (and therefore the controls and other frames or whatever they are called) are placed nicely in a RTL manner. I also like to use this environment, but...

Thanks Pat, The reason I would like to refactor is so that all the objects are in English. I find it very hard to change ( or even follow the logic) when I have to figure out where the pieces go . If I go that route, even with a find and replace utility, it means that most updates and...

Hi, Thanks for all your effort in making this forum such a great place for info and help. This subject is super important IMHO bad-data-is-bad-for-business-1-and-2.324342 Sincerely, Shimon

Thanks Gasman.

I will now relate to some steps specific to my current project. The current project is protected, so that a standard user does not have access to Design view or to any DB objects. There is always a Form open, that fills the application window. If you exit the Program in any unplanned way, it...

The following paragraphs outlines the planned steps necessary for refactoring with minimal effort and risk. The first steps might seem to be excessive, but will pay off on the long run. Create a test(s) for each component that might be affected by the refactoring. Create a one button "Run All...

Hi, I inherited a Database written in a Right To Left Language. It was written by a programmer who has no formal training, and therefore has several basic design flaws. As it is written in Right To Left and the code is Left To Right, I find it very hard to understand and follow the code...

Hi, I tried to refactor the DB so that the main table names and columns would be in English, so that I can show a screenshot. The First attempt took about 3 hours and failed. The second attempt took about two hours and failed on a stupid calculated field. I say stupid, as in my humble opinion...

Thanks all for your input. I spent a few hours creating a set of queries to copy all the tables, delete the data from the original ones and append the original data from the copied tables back into original ones, after creating the necessary PK and relations. I then removed part of the...

I'll try, but I don't know if I'll get to it until next week.

Hi, I'm not really an Access developer, but took up the responsibility for implementing changes in an existing Access database. I do have previous experience writing "raw" applications in Access and served as a Data Administrator (not DBA) in a big project. The application is for a Non-Profit...