Search results for query: *

Hi, I have one small application (VB6, ADO, Access) with one form ans following project references: VB for applications VB runtime VB objects & procedures OLE automation MS ActiveX Data Object 2.7 Library Everything seems working OK, but when I want to build msi file using VS installer 6, it...

Hi, I have msflexgrid populated with names and want to filter it based on the first letter. Is there any other way than just delete whole content and populate it with new data? I think it's pretty common task but couldn't find any sample yet...

hi, just trying to put together my first vb express 2008 application (after using vb6 for several years) i want to get values from access table (based on selection from two combo boxes) and insert them to text boxes: here is my code: Private Sub Button2_Click(ByVal sender As System.Object...

hi, i am looking for a sample code how to detect default printer in xp/vista. i have a code for printing into pdf file using bullzip and cannot figure out how to set back original default printer. thanks.

hi, i have one flexgrid populated with data (just text not numerical): Set txtStream = fsoStream.OpenTextFile(DataLoc) Do While Not txtStream.AtEndOfStream strTextFromFile = txtStream.ReadLine MyData = Split(strTextFromFile, ";") FeedData = MyData(0) & vbTab &...

hi, i want to create a program which would prevent computer running in defined time period (it would shutdown) i wrote some code but it's not working :-( when started it has status non-responding. Option Explicit Dim notime As String Dim RETVAL2 As Variant Declare Sub Sleep Lib "kernel32"...

hi, long time ago (in 2002 ?) our company bought accpac 3.5 (?). part of the package was pervasive.sql 2000 (v7.8). we have never used for real data, but now we have to switch from accpac plus to accpac erp 200. meantime we replaced data server and almost all workstations so everything has to be...

hi, i have a ms access table with [Code] field containing the following values: D1, D3, D5, D6, D7, W1, W2, HP-D1, HP-D2, G-TSE, G-TSD, G-ASE, G-ASD, G-ASV here is a part of my code: Dim selGable As String ... selGable = Left(rs3("Type"), 3) rs2.Filter = "Code LIKE 'D*' OR Code LIKE 'W*' OR...

hi, i have three combo boxes - combo0/country, combo2/state, combo4city - populated by queries: SELECT [MyData].[Country] FROM MyData GROUP BY [country]; SELECT MyData.[St-Prv], MyData.Country FROM MyData GROUP BY MyData.[St-Prv], MyData.Country HAVING...

hi, i have text boxes where user suppose to enter numerical values, which are used for calculation. to make it look nicer, i want to format content of text box into standart format #,##0.00 (usa/canada regional setting). however, after this formating is done, the field with calculated result...

Hi, is there any way how to make ms word to print selected page as default, insted of "ALL"?

hi, i have two problems with installing and running vb6 program on vista. 1) the program runs well on xp, but during installation on vista i got this error: *** ERROR: An error occurred while registering the file 'C:\Windows\System32\msadox.dll' *** ERROR: (User Responded with 'Ignore') 2)...

i have one field "Type" in ADO recordset (reading text field from Access table and showing it in datagrid) this field can have values like (xxx is extension/number): ASE xxx ASD xxx ASV xxx TSE xxx TSD xxx TSV xxx i have five checkboxes on form (chAS, chTS, chE, chV, chD) - as default all...

hi, i am working on one report showing profit and commission for a specific project. this looks quite easy; i just need to use value (%) for commission from another table, based on difference between listed price and actual price. here is the table: Net_Sales_Price Discount_fm_List_Price Comm...

hi, i try to automatically read data from excel table (instead of manual typing data) using existing program. the issue is how to invoke "click button" on another form. For I = txtFrom.Text To txtTo.Text frmLUMBER.cmbSIZE.Text = ws1.Cells(I, 1) frmLUMBER.cmbGRADE.Text = ws1.Cells(I, 2)...

hi, i tried to format recordset, but '#' is causing syntax error sSQL = "SELECT [BOOM], Format([volume],"#,##0.000") AS BVolume, Format([total],"Standard") AS BValue FROM qLogs_Inventory;" is # a special character for visual basic? how to make it work? original, unformated and working sql...

hi, i have the following code (vb 6.0, sp6, windows xp home, sp2): DataGrid1.ClearFields sSQL = "Select [boom], [volume], [total] From Logs_Inventory;" Set RSTALL = New ADODB.Recordset RSTALL.Open sSQL, objAccessConnection, adOpenKeyset, adLockOptimistic Set DataGrid1.DataSource = RSTALL...

hi, i was looking for program which would allow run a program/batch on shutdown (enabled in xp professional) in 98/2000/xp home. there is one application shutdown folder lite, but it wasn't working for us. so i built simple shutdown program using sample code from vbnet.org. i added there the...

hi, due to my hdd crash, i moved from win 98/office 2000 to win xp home edit/office 2000. now, when i try to run some queries/reports i am getting an error message undefined function 'format' for expression like format([curdate], "mmmmm') any idea, please?

hi, i have the following tables: 1) CUTS with fields CUTID, NUMBER 2) LOGS with fields CUTID, BOOM, VOLUME, TOTAL i have one form fSELLOGS with Combo0 populated with CUTS.NUMBER and list box List4 populated with LOGS.BOOM, LOGS.VOLUME, LOGS.TOTAL i have event procedure: Private Sub...