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

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

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

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

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