Search results

Interesting George, I find chatgpt and copilot have good and bad offerings/suggestions/responses. I think it pays to keep options open and try some alternatives. I'm only dealing with some simple "keep busy" things, nothing deep nor critical, and use free options only. May be a whole different...

Thanks Josef. It seemed that the addin was being linked to the working database. I loaded the addin via Database Tools and selected the specific addin. With a bit of testing I see that it was removed/delinked when I closed the database and shut down Access.

John, I think the issue is that 255 will only store the number of characters entered. And 255 is max for short text. If you only store 25 characters, that's what is used. The problem is the "other" side of the question -- if you say the short text is, say 10, then trying to add additional...

Thank you Josef for responding. When using Database Tools and attaching/linking the Addin(Access not COM) to the working database, what exactly is the linkage that is established? Do you have any code suggestions for removing the entry in the registry and replacing it? I am not familiar in any...

I have an Access Addin that was registered/installed with UsysRegInfo. Using Database Tools I added the addin to a working database. My question is "How can I remove the Addin (or linkage) from my working database without removing the AddIn from Ms Access??

Switcher, hi and welcome to AWF!

Emma, Please provide some code and/or details of your tables etc. People can't guess your issue and solution without some context.

Mike, I lost my dad 43 years ago. I think Doc has captured my thoughts extremely well. Stay strong.

Hi Ricardo. Welcome to AWF!

see this from Allen Browne http://allenbrowne.com/ser-61.html

Thanks Doc.(y) I felt the OP had a single user database. I am aware of multiuser database and a separate backup strategy typically run by an operations group when users are not active. Often at a certain time, every day or week after normal hours of work. Also case(s) where a important...

Thanks Colin. Yes the wording on the property sheet is confusing. I could see the text when I clicked the button, but in form view all I saw was the image.

I solved this issue for this instance via vba Private Sub Form_Load() Forms!frmLoginwithcount!btnLogin.Picture = "" End Sub But still don't understand the behaviour.

Using MS Access 365 blank form, I created a form with a button. Added caption "LOGIN", but I have an image.

Doc, If multiuser, could he not record the login and UserId in a front end table. That was my first thought, but we need more environmental context.

How many simultaneous users on your database? If this is standalone then you could query that login table at login. If it is 7th login, then delete the first 6 and make this record 1. If this is multiuser, then you might consider the login table to be in the front end where each user gets...

Google translate: Good evening I would like your help.In the following database example, when I put a value in the "Category" field in the "Data" table, I want the "Color" field in the table to be automatically updated with the corresponding value from the "Color" table.Any help is...

Do you record each login to a table?

Hi Heide and welcome aboard AWF!

I created a small table ForecastT shortNoMaxOfIDnumberCarType 019999999Motor 019999998Motor 019999997Motor 019999996Motor 019999994Trailer 019999992Trailer 039999991motor 039999988motor 039999987motor 039999984Trailer 039999982Trailer and used plog's sql name of...