Recent content by jdraw

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