Search results

Hi isladogs, Yes I see that as my responsibility to post the right one which is yours. Your code in #16 not only solved my problem but also gives multiple ways to solve the issue. Great one. I like uncle gizmos version too. Multiple suggestion in this post really good one. updsql = “ insert...

Gasman, dbguy, isladogs, docman... thank you thank you very much. As you rightly pointed out I have made a mistake in using square bracket. I mean I didn’t use square bracket in a field that’s where it went wrong. Now I am able to update the records. Thank you. You guys make this forum a...

Ok this is how I changed the code and again error as runtime error 3134 updsql = “ insert into tasks (received,sender,[sent at]” updsql = updsql & “employee,department)” updsql = updsql & “values #” & me.rvd & “ #, ‘“ & me.snd & “‘,” updsql = updsql & “‘“ & me.sntat & “‘,” updsql = updsql & “‘“...

Immediate window response Hi Gasman, islodogs, I am sorry I didn’t realise the immediate window was keep on adding the contents every time I run the debug code. Yes what I have you was older code. As you directed I cleared the contents and given you the update code and immediate window response...

Hi isladogs, Thanks. I want to make one thing more clear which I didn’t update you properly. I am using this code now updsql = “ insert into tasks (received,sender,[sent at]” updsql = updsql & “employee,department)” updsql = updsql & “values (‘“ & me.rvd & “‘),(‘“ & me.snd & “‘),” updsql =...

All four of you, Thanks a ton for valuable inputs I think I’m close but not yet reached the solution 1) A’s Gasman suggested I have changed my syntax and dixed the quotes 2) I’m still getting the error 3) As pbaldy suggested I had debugged the code 4) Immediate window shows insert into tasks...

Hi experts, I am going to ask an pretty old question. Though I researched everywhere I could not figure out a solution and I strongly believe you can help. I am trying to use sql insert into statement to update a table with form data. But when I break the code into multiple lines I am getting...

Hi Isladogs, Haven’t tried using non activex items. Let me try.

Hi experts, I’m using a dark themed form since we cannot change the colour of default scroll bars I have taken activex scroll bar and was able to change the colour. But after I finish scrolling the thumb starts blinking which looks awkward.All I needed is to stop that blinking. I tried setting...

Hi dbguy, Yes I use a darker theme and cursor color is equally darker so that users could not see the cursor line. So i want to change the color to white so it’s visible.

Hi Experts, I am using a form with dark background whenever I open it the cursor is invisible. When I checked it deeply I understand cursor is in the same dark color as form field so Users are unable to view. Is there a way to change the cursor color to white?

Hi Kirkm, Just click twice in the label border on the top left where you can find a small grey point and then delete it. You can now delete the label alone. Sent from my iPhone using Tapatalk

I acknowledge it. Sent from my iPhone using Tapatalk

I see what you are saying. What a foolish thing I was trying to do. This is simple answer. What you said works for me if I open the form in Maximize mode with border property chosen to None. Thank you. Sent from my iPhone using Tapatalk

I am sorry. I didn’t explain the story well in my earlier post. This is what I did. 1) Understanding that changing the colour of the title bar will become an unwanted work if I want to trigger some events while minimising or maximising the form I have decided to do a work around. 2) That’s is...

Hi experts, Thanks for your time and valuable suggestions. I was able to use the code given in this link https://wellsr.com/vba/2017/excel/remove-window-border-title-bar-around-userform-vba/ with some minor tweaks it’s successful. All I did was 1. I have placed first two codes in a standard...

Sure. I will if I can especially for the lot you have helped me out. [emoji3] Sent from my iPhone using Tapatalk

Docman, Thank you very much for taking time to address my issue. Then I have to do an extensive research to get my answer.

Hello experts, Could you assist me in changing the colour of title bar. There were certain suggestions asking me to change the theme settings of windows but I want only to change the colour of me access form. Is there a way? I browsed but did not find a solution I am in need of. Could you assist...

Hi Vlad, Thanks for your constant support. Yes it is an variation of earlier post. I see your code meets my need. Just one more thing 1) Before going to the next_task I wanted to loop through all recordsets in the "rsemp" with the specific record in the rstask to identify if any recordset...