Recent content by Voyager

  1. V

    Assistance needed in sql syntax while breaking code into multiple lines

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

    Assistance needed in sql syntax while breaking code into multiple lines

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

    Assistance needed in sql syntax while breaking code into multiple lines

    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 & “‘“...
  4. V

    Assistance needed in sql syntax while breaking code into multiple lines

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

    Assistance needed in sql syntax while breaking code into multiple lines

    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 =...
  6. V

    Assistance needed in sql syntax while breaking code into multiple lines

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

    Assistance needed in sql syntax while breaking code into multiple lines

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

    Assistance needed in changing cursor color

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

    Assistance needed to stop blinking thumb in activex scroll bar

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

    Assistance needed in changing cursor color

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

    Assistance needed in changing cursor color

    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?
  12. V

    How to remove Label stuck to Text box?

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

    How to change the colour of title bar?

    I acknowledge it. Sent from my iPhone using Tapatalk
  14. V

    How to change the colour of title bar?

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

    How to change the colour of title bar?

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