Recent content by kolorasta

  1. K

    Sum() in empty table doesn't return zero

    sorry I didn't mention that it's an access project (SQL Server)
  2. K

    Sum() in empty table doesn't return zero

    i have a query with this basic structure SELECT id FROM table1,(SELECT SUM(field2) as total2 FROM table2) - (SELECT SUM(field3) as total3 FROM table3) as total to understand better let's say that: table1 are clients table2 is money that enters for clients table3 is money that exits from...
  3. K

    Select, Insert and Update un same query

    thank you for your answer...have a nice time
  4. K

    Select, Insert and Update un same query

    i didn't understand your answer... there is a little humor in your answer... i know that :D but your whole answer is a joke or you gave me the right answer for my problem, removing the "and" word??? thanks
  5. K

    Select, Insert and Update un same query

    i'm using access with sql server (.adp) and i have this query to insert records in a table: INSERT table1 (field1, field2, field3) SELECT (field1, field2, field3) FROM table2 WHERE (condition) this is an schema of my query... What i want to do is to add and UPDATE sencence like this for...
  6. K

    Hyperlink

    you can create a textbox to look like an hyperlink with the font color what you want doing this: create a textbox with the color and other atributes you like for the text. then create a button with an SPACE in the hyperlink property and backgrount prop to TRANSPARENT and no caption... resize...
  7. K

    i filter subform but Sum at footer doesn't change

    Thank you dave for your time... i said that it was an Access Project at the end of the first post ;)
  8. K

    i filter subform but Sum at footer doesn't change

    working with .adp (Access Project - SQL Server) "&" sing does not work,neither "" (double cuotes)... just '' (simple cuotes) and + (plus sign) in access (.mdb files) you can use & and "", but not in SQL Server (.adp) queries.
  9. K

    i filter subform but Sum at footer doesn't change

    i'm trying to concatenate fields... i put squera bracket because i want to show the square bracket in the concatenated field..look the screen capture how it is shown
  10. K

    i filter subform but Sum at footer doesn't change

    it's seems there is an error in the SQL record source of the form SELECT documentos.numero, '[' + CAST(documentos.id AS varchar(10)) + '] ' + UPPER(documentos_tipos.abreviatura) + ' - ' + instituciones.abreviatura AS descripcion, documentos.importe...
  11. K

    i filter subform but Sum at footer doesn't change

    Hi... I have a form with a subform in the form i have a combobox with a code on the "onchange" event to filter the subform Private Sub ComboInstitucion_Change() Documentos.Form.Filter = "id_institucion=" + ComboInstitucion.Value Documentos.Form.FilterOn = True End Sub in the subform footer i...
  12. K

    change hyperlink color

    i want to show my users in someway that they can click in a text box to do something (ex. open a form) i don't like how color blue looks in my forms if i set the "is hyperlink" to "yes" so i was wondering if there is some way to change mouse cursor when is moved over the textbox there is an...
  13. K

    change hyperlink color

    thank you very much
  14. K

    change hyperlink color

    it's just simple text with the "is hyperlink" property set to "yes" and some code in the "on click" event .... it's just to let the user know he can click there... and i don't like how blue looks like in my forms
  15. K

    change hyperlink color

    is it possible to change the hyperlink font fore color of a textbox with the "is hyperlink" property setted to yes? it appears in blue. sorry for my poor english:rolleyes:
See more
Back
Top Bottom