11,868 Topics
 | |
| | I am trying to convert access2.0 database to access2010. 2 days trying to recode this to run in access 2010 but no success. Global Const CONNECT_SQL = "ODBC;DSN=PCGINV;DATABASE=pcginv;UID=;PWD=" Global gqdfTemp As QueryDef Global grecSQL As Recordset Sub GetSQL(strSQL As String) On Error GoTo Err_GetSQL Dim db As Database Set db … |
| | Hello, I need to create password protected PDF file in VB6.0. How can i do this? any reference link, suggestion or source code? Thanks. |
| | hi I want to make a query that first find the sum of two columns of different table then subtract it Example it is a visual basic program Dim large_tbl As String Dim sell_large As String large_tbl = "SELECT Sum(No_Of_Bottle) FROM add_cotton where Cateogry='Large'" sell_large = "SELECT Sum(Quantity) FROM Sell_Detail … |
| | Program 'C:\Users\johnpal\Desktop\SMSapplication\SMSapplication\obj\Debug\SMSapplication.exe' has more than one entry point defined: 'SMSapplication.Program.Main()'. Compile with /main to specify the type that contains the entry point. C:\Users\johnpal\Desktop\SMSapplication\SMSapplication\Program.cs 13 21 SMSapplication... while compiling visual studio how to solve this problem  |
 | Every single time I try to use a control from components on vb6, I put the code, I run the program, then when I try to open the same program in another day, its not working, its giving me the error : Line 13: Class MSAdodcLib.Adodc of control Adodc1 was … |
| | i need to create a project that able to run both under linux and windows(visual studio)... i pretty much finish all coding and able to run both windows and linux in separate files the problem i deal with is the header file which visual studio required #include "StdAfx.h" and not …  |
| | Friends again problem with date function In my form there is a text field -txtDod- of Date type formated like "dd-MMM-yyyy" My input is also formated like "dd-MMM-yyyy" Now see my code Private Sub TxtDod_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKeyReturn If Not IsDate(TxtDod) Then LblMsg = "Enter Date … |
| | Need Help.. I have two tables tblRecieve and tblReleased tblReceived --ID-RcvdPcs --1 5 tblReleased --ID-RlsdPCS --1- 2 as you can see i have received 5pcs and i already released 2pcs in same id so the remaining pcs is 3. how do i code this to prevent user to released more …  |
| | hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date … |
| | I have 2 spreadsheets - uat.xlsx and main.xlsx - both in the same directory. main.xlsx [[Click Here](null)](http://www.excelforum.com/attachments/excel-programming-vba-macros/297600d1392477870-merging-two-spreadsheets-using-vba-based-on-a-number-of-conditions-r1hrn.png) uat.xlsx [Click Here](http://www.excelforum.com/attachments/excel-programming-vba-macros/297601d1392477913-merging-two-spreadsheets-using-vba-based-on-a-number-of-conditions-evdad.png) I am trying to copy across information from uat.xlsx to main.xlsx, by accomplishing the following in VBA (the VBA code will be stored on main.xlsx and launched by button click): …  |
 | Hello, can anyone provide me with some sample code? VBA access. I need an insert into statement where form.control.value = some_column and another.form.control.combobox.value = some_column can anyone help? thanks |
| | I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim … |
 | -->>Hope all is well?,I 've been trying to create an ActiveX DLL and Active X EXE but the thing is when I'm finished with My... -->>document and need to see the resulting Interface a problem arises! When I run My file affter having all the settings... -->>in a debugging window … |
| | i have a program relate to account which subtract value of a Customer but problem is when the user amount is same mean ================ ============ Customer Name Amount ================ ============== John 200 Max 100 John 200 if i input 100 the result will be ================ ============ Customer Name Amount ================ … |
 | Hello All, When I click a record on the grid it does not display on the form, please help me out. here is my code below: Private Sub MSHFlexGrid1_Click() Dim cur As Single cur = 1 MSHFlexGrid1.Rows = 11 MSHFlexGrid1.Cols = 11 Adodc1.Recordset.MoveFirst Do Until Adodc1.Recordset.EOF If MSHFlexGrid1.Rows = 1 … |
| | i have a problem in watermarking code , implementing in vb6.0 someone known Vb6.0 coding contact me... mehboobfraz85@gmail.com |
| | I am having an impossible time finding a solution for this. I need to combine cell contents in an unusual way (see below), based on if there is an "x" in column A. See below for the exact representation of what I need to do in a worksheet with 200,000 … |
| | Just wanna ask if it is possible to add 1 or more DETAIL sections in a VB6 Report. If it is, any link to such or steps on how to do it. Thanks. |
 | Hi people, I am doing some unpaid work for a friend on an Access/VB application they have. Everything worked for 5 years and then suddenly one day they got the following error: Run-time error '91': Object varialbe or With block variable not set. When I click on debug it shows … |
| | can any one give me simple data entry application code |
| | I have a 31,000 line spreadsheet, that will become a printed book. Based on the current column width (which has to stay the same for printing purposes) there are many lines that are only one line of text, and others that wrap to multiple lines. For some reason, for lines … |
| | I am trying to combine cells depending on the contents of other cells. If Column A has an "X", I want to combine all cells below it, values seperated with a space, until the next line where an "X" appears. There is also data in Column C, which I don't … |
 | when I will make a report on vb6 using crystal report 8.5, the error message "Visual Basic has stopped working" what is causing the above? |
 | Hi I will from the database only copy some textboxes to excel to specifik place in the excel sheet Just those from the database surename,lastname,adress,zip,zipadress,prn only one at the time PS ! the excel sheet is an invoice one textbox to excel i4 = prn one textbox to excel f9 … |
| | Hi All, I would like to ask one question about "ScrollX". After using this component, my whole porgram is closed automatically when I close the "Form". Does anyone have better ideal to solve it? Regards |
| | how to create a report with data from duatabase on the same server or different servers, using SQL Server 2000, using the **crystal report 8.5** or **data report of VB6 ** For example I have table A and table B with the same table structure, table A is stored in … |
| | Hi What have I done that is wrong the Excell sheet will not be visible I will have it visible when I press the command button Dim objXl As New excel.Application Dim objWb As excel.Workbook Dim xlTmp As excel.Application Set xlTmp = excel.Application xlTmp.Workbooks.open ("c:\kundreg\bokfaktura2.xls") '"bokfaktura2.xls" xlTmp.Workbooks.open ("app.path & \kundreg\bokfaktura2.xls") … |
 | Private Sub Command1_Click() Dim dbName As String Dim rptName As String Dim Preview As Long Const acNormal = 0 Const acPreview = 2 dbName = "C:\Users\user\Desktop\SVSPTODA REGISTRATION SYSTEM\SVSPREGDB.mdb" rptName = "MyReportName" Preview = acPreview 'acNormal With objAccess .OpenCurrentDatabase filepath:=SVSPGEGDB If Preview = acPreview Then .Visible = True .DoCmd.OpenReport rptName, Preview … |
| | Was trying to save the contents of a listview column (2nd column) into a table in the dbase, 1 column of the table per content of the listview column, meaning only 1 row will be affected. Here's my code using while loop. Fcount = 2 Scount = 1 While Scount … |
| | I found a script on ExtendOffice.com that does this perfectly, except the BCC email address isn't displayed in the field. The value is there, but invisible (as it does indeed work). I want to alter the following code so that the auto-BCC email will be visible in the field when … |
The End.