Search results

Thank you George, I have had a lot of fun playing with AI over the last few days. Now starts the real work. I will take your recommendations to heart and spend some time doing just that Regards Alan

Do you have any idea how good ChatGBT would be with VBA and/or the Access way of handling SQL?

Excellent outline. I am setting up a new system where all my menus and submenus are "driven" by listboxes. This allows me to prevent an unauthorised user to even see a form/menu, let alone open them. Do you think this concept might be an option for this OP? Regards, Another Happy Retired GrandPa

Hi All, The majority of my systems (FE and BE using Jet) are running on single machines or on small networks (4 to 8 workstations. Nevertheless, even on the single machine I have to allow for more than one user and/or the fact that the owner may not want certain info to be available to any of...

It's the Inventory that I'm looking for. The Inventory for Business - not the Person Inventory. Thank you

Hi, Microsoft used to have Inventory templates for 2003 and 2007. They don't anymore. Anyone know where I could retrieve one of those old templates? Regards, Alan

This sounds very impressive. Have you been able to test it yet?

In most cases, i will have little, if any, control over their networking. In some cases we might have a SQLServer back end but the majority will be running on a split Access system with Jet as the database. Respectfully, I think I disagree about the need for the administrator account. Surely the...

My systems will be running on small LAN driven networks. In some cases even on single stand alone PCs. I can't rely on any external security facilities as I will have little, if any, control over the environments. I don't know anything about Active Directory, What is it?

Hi All, I need to create a login/control system that will control: 1. All users to access certain menus/modules 2. Several other levels to access more sensitive menus/modules 3. It should have a reasonably secure facility for new users to create their own logins/passwords etc (In much the same...

Hi All, I think AI is going to put MANY corporate programmers onto the unemployment register. I have been playing with free Co pilot and have set it some tasks. Although I haven't checked the code, it has generated more code in 45 seconds than I could have done in a week. At the moment it is...

Hi , I am not able to reply to any of the messages I am getting. The "site" tells me it thinks my messages are spam and that I should contact the administrator. (Nowhere o0n the site can I find a facility to contact the administrator) Please can you help me resolve this issue, Alan I have sent...

Hi Dave, I am not able to reply to any of the messages I am getting. The "site" tells me it thinks my messages are spam and that I should contact the administrator. (Nowhere o0n the site can I find a facility to contact the administrator) Please can you help me resolve this issue, Kind Regards...

Hi, Has anyone out there used any form of AI to improve/speed up Access development? If so, did it really help? What AI tool did you use. Was the time saved greater that the AI learning time?

Hi Dave, Thank you for your response. I have seen so many dire warnings about Access alone being poor at multi user networking. Almost all suggest using SQL server. The database will never get significant in size or number of users. Kind Regards, Alan

Hi Albert, Thank you so much for all the effort you put into this reply. However, when JUST starting out? And depending on how comfortable you are with SQL server and SSMS? My answer to this statement is Not very comfortable at all. I have never worked with either it's a great road and idea...

You are absolutely correct Fortunately the client,in this case, is a small non profit organization managing a retirement home. They are pretty unsophisticated in IT terms. I am doing this project for them at no cost as their funds are very limited. Nevertheless, I have always hidden tables etc...

Hi Guys, Thank you for the help. DBGuy... nice to see you are still around after all this time. (You might remember me as Alan from Malawi on Utter Access) CJ London. Thanks for the detailed response. I really appreciate it. As there are never likely to be more than 7 or 8 users, it would seem...

Hi,l I am about to start a new development that will ultimately have to migrate to SQLServer or something similar. Are there any difficulties or roadblocks associated with doing the development using Access with SQLServer from the beginning?

Thank you. I do not have the skill sets to maintain most of these. However Vet Geo looks promising