Search results for query: *

Hello, I need to change KeyCode = 110 (dot in numeric keyboard) to other symbol (for example "a") in whole application (or form). I tried such code: Private Sub frmMain_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown If e.KeyCode = 110...

Mayby i asked a wrong question... i'll try one more... I want to set such parameters: http://www.pn.com.pl/guest/access.JPG but from VB.NET code. I know how to set "Defaul Value" in VB.NET: fTable.Columns("MyCol").Properties("Default").Value = 1 But i don't know how to set "Format" or...

Hello, I want to add new column to my Access 97 table: fTable = fCatalog.Tables("tbQualityData") fTable.Columns.Append("MyCol", ADOX.DataTypeEnum.adCurrency) fTable.Columns("MyCol").Properties("Default").Value = 2 It works, but next I want to change the Access property of MyCol column...

The answer (probably not perfect, but it works) is: 'Read: Dim DaTbSpec As New OleDb.OleDbDataAdapter("SELECT tbAttributes.Attribute_Name, tbAttributes.Attribute_position, tbSpec_data.* FROM tbSpec_data INNER JOIN tbAttributes ON tbSpec_data.Attribute_ColName = tbAttributes.Attribute_ColName...

Hello, I have a dataadapter that joins two tables with and inner join. I'm trying to use CommandBuilder to create SQL commands. I know it's impossible to do it directly, but I found two suggestions: 1. "You can only update 1 of the tables in the join. So pick one, change the SQL query for the...

Thanks a lot for help! GrdSpec.Rows(0).Cells(9).Value = "New value" BsTbSpec.EndEdit() Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(DaTbSpec) DaTbSpec.Update(CType(BsTbSpec.DataSource, DataTable)) Works great! Larry

Hello, I have VB 2005 Express Edition and i'm trying to understand the DataGridView control... I have DataGridView "GrdSpec" connected to my Access db: DaTbSpec = New OleDb.OleDbDataAdapter("Select * from tbSpec", ConnQual) DaTbSpec.Fill(DsTbSpec, "TbSpec") Dim BsTbSpec As New...

Hello, I have VB.NET 2005 Express and Crystal Reports XI Developer Edition Release 2. I have a simple application with CrystalReportViewer and a simple report. I try to publish my application and install it to other computer. At installation start there is an error: "The application requires...

Hello, I'm beginner. I have PowerPlay Transformer 7.0. I want to connect to Access database which is connected to SQL server with password. When I'm connecting Transformer to table in the Access file (in fact this is a table in SQL Server) - Transformer asks me for the password to SQL Server...

Hello, I have CR 8.5, I have three tables: Contacts_Header, Contacts_Persons and Contacts_Items. I want to make such report: Contact 1 Person A Person B Item X Item Y Contact 2 Person C Perdon D Item Z How i can do that? I tried to make two subreports 'Persons' and 'Items' in...

Thank You for instant answer! Is there any place in Crystal where i can read which functions was delegated to Crystal? The problem is in my computer it works fine, but in different computer (the same CR, database, windows) it doesn't work... I neet to check why is so, but i don't know how to...

Hello, I'm running Crystal v8.5. This is my Crystal record selection formula: {Table_1.RECTYPE} = "H" and {Table_1.ACCOUNTNO} = "PRODUCTS" and {TABLE.EXT} = ToText (Year (CurrentDate)) and {TABLE.CONTACT} = "W magazynie" and Left ({TABLE.CONTSUPREF},7 ) = {Table_1.CONTACT} and...