User Profile

Collapse

Profile Sidebar

Collapse
DimBulb
DimBulb
Last Activity: Mar 24 '21, 06:56 PM
Joined: Mar 23 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DimBulb
    replied to SQL VBA Delete statement not working
    in Access
    Hi Joe Y,

    one of the things that might help you in formulating SQL within VBA is ..... & chr$(34) & around both sides of the string parameter in the SQL statement. chr$(34) is the ASCII code for the double quote. if you concatenate it in there, it forces the double quote in round the string parameter.

    The other thing that might cause a rejected delete is if you have a parent child relation e.g. order header/order...
    See more | Go to post

      Leave a comment:

    • DimBulb
      started a topic Data Binding
      in C Sharp

      Data Binding

      Hi,
      I am just learning C#. I have an Access VBA and SQL background.
      I don't understand the databinding controls in the winform toolbox. I feel I should be able to just pull them across from the toolbox and create bound controls, or a bound form - but the book shows me code that I have to write.
      If this is the case, why have GUI controls for it ? What am I missing here ?

      Thanks in advance for your help.
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...