Search results

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

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

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

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:

Hi I have a form (continuos form) in an access project (.adp) at the form's footer i have a textbox with a "=sum([fieldname])" as control source the sum works fine until i filter the form when the form is filtered the textbox gets #ERROR to filter the form I use VBA me.filter="id=something"...

Hi. hope you can understand my english. I have 2 SQL Servers. Is there some way to set to which sql server connect the .adp (or .ade) via code?? Now I have 2 sql servers (development and production).. but soon I will have more server at production in different cities. All SQL Servers have...

Hi. I have 2 SQL servers SQL Server 2005 Express (english) for development SQL Server Enterprise (spanish) for production I have a combobox for a BIT field The combobox rowsource is false;"No";true;"Si" The combobox shows "No" and "Si" (no & yes in spanish) and stores False or True respectivily...