Search results

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

Do you have a breakdown by Country? My site got loads of hits from China. Irrelevant what my opinion of them, this doesn't count for me. Shimon

Hi, I would suggest having the MariaDB tables as linked tables, name them lnktTBL1, lnkTable2 etc. Create a duplicate set of tables names Table1, Table2 having the same structure. Upon startup run a Delete query on Table1 and Table2 and then have an Insert (update?) query that copies all data...

Hi, This is what I found. If you install an SQL Server Express somewhere in your network, you can share all hosted databases with all users in your network... there is no limitation based on the number of users, only in size and compute power. Sincerely, Shimon P.S. I couldn't add the link...

Hi, I downloaded the example app and tried it on a file created and updated by Enterprise Architect. This is a UML oriented analysis and design tool. The file format is ( at least in older versions of EA) an Access format. I changed the file extension from eap to mdb and opened the file in...

Is this a DB that you created? If not, maybe this is relevant: within Access, Forms, Reports and Queries have a RecordLocks property that controls how the underlying data is locked. Setting this to "No Locks" (0) should mean that optimistic locking is used, and two or more users can edit the...