16,916 Topics
 | |
| | 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 … |
| | Hi. I have a c# project created in Visual Studio 2010. The project runs successfully on Windows XP 32bit but I get an error when building on Windows 7 64bit. The error is as follows: Could not load referenced assembly "C:\WINDOWS\system32\stdole.dll". Caught a FileNotFoundException saying "Could not load file or … |
| | 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 … |
 | How do I use other libraries in C++? Specifically using the PDCurses library in the latest version of Visual Studio Express? What's the general way to set a libray up, how to use it? Thank you for your time and patience.  |
| | 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 … |
| | Hello, I am attempting to make a section in my application where a user can enter their own code which will be executed at runtime. I have looked up how to compile and run Visual Basic code while the program is running (Below). Dim VBP As New VBCodeProvider Dim CVB … |
 | This is sample code for a ASP.Net Login page (using Visual Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net. The datebase used is the Access Northwind Database. With the connection string being placed in the [i]web.config[/i] file. [b]1. [u][i]Web Config[/i][/u] File code:[/b] [code] <?xml version="1.0" encoding="utf-8" … |
 | 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 … |
 | I'm using VS 2010 professional with SAP crystal report. And I have an windows form application for displaying some crystal reports. This is working well and good in the system I'm have developed it but, when I set this project to run in setup mode or in other machine then …  |
| | 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 have problem in programming specially in visual basic, can anyone help me?  |
| | 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 … |
 | I'm currently using Microsoft Visual Studio express 2013 for Windows Desktop. I have a program that I created and want to share it with friends, but I'm trying to locate the .exe file. (It's a terminal program that gives a quiz). How can I find the executable file. Or do … |
| | Hello :) I am having a bit of trouble with a bit of code. I'm not really sure what is needed. The program contains a few buttons etc however, I am having trouble with two picture boxes. For this thread they are called **picBlue** and **picGreen** I want **picBlue** to …  |
| | Hi, I have a problem. I have put up an image on a form of .jpeg format.(copy and pasted).. But when i save it... it works fine at home.. .when i copy it on a cd... it is not saving the background image. Rather ... when I try to open …  |
| | Hi guys, I have worked with PHP and MySQL before and recently I wanted to try and learn ASP.net MVC since some of my friends are using it in the work place. But the most confusing thing about this is, why does all the tutorials out there not mention how … |
| | Hi all, I found a great VoIP application for WP7 that prevents the service providers to block SIP: http://www.codeproject.com/Articles/722556/How-to-build-a-VoIP-application-for-Windows-Phone. The core of the solution is the following: as it is known, SIP protocol is used in VoIP technology, but its port (5060) is blocked by many mobile service providers. That's … |
 | Hi All... To made payment integration, I used e24PaymentPipe.dll got from client. The problem is that it is always results in failure ("-1") when I try to connect to Gateway Server using "PeformInitTransaction" function. To be able to use e24PaymentPipe.dll as third party dll, i performed following steps: (note: OS … |
| | Earlier I raised a question in this forum regarding the sorting of database and Reverend Jim answered me as follows. It was Ok SELECT * FROM mytable ORDER BY fieldname But then I faced another problem As I mentioned in that I wanted to sort ORDER by 'Tdate' which is …  |
| | Hi Champs, Im using VBA for Excel. and Im trying to use the code below to move through records and increment their values by one since they meet a certain criteria Sub promotion() Dim x As Range Dim y As Integer Sheet2.Range("c2").Activate Do While y < 1002 y = ActiveCell.Row … |
| | Hi! I using Crystal 9 in Visual Studio 2010. When update database field I got this error "crdb_adoplus.dll cannot load ". I have downloaded crdb_adoplus.dll but I don't know where to place this dll.Any idea? |
| | I'm having trouble with the AND operator when I used it 3 times. If Text1.Text = "THIS" And Text2.Text = "THAT" and Text3.Text = "THOSE" then Call Display elseIf Text1.Text = "THIS" And Text2.Text = "THAT" and Text3.Text = "THOSE" then Call Display2 else MsgBox"Failed" End If It always ends … |
| | hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas … |
| | how can i know My Application is already running.I want to abort new application and pop up to user to close already running application.I am using App.PrevInstance object but its not working. I want to use mutex and windowform..how can i use it..Plzz help.. |
 | Hi comrades. I am new to VB6 and I have a problem. I would like to develop a programme that generates a school timetable. The school is three steamed from form one to form four. Some subjects are optional. I am ashamed to repot that I have been thinking of … |
| | Im developing a windows form application is Visual Studio Express 2013 I made a New Project -> Empty CLR Project then i added the windows form UI and i coded the (myprojectname).cpp this code #include "MyForm.h" using namespace winformapp; [STAThreadAttribute] int main(array<System::String ^> ^args) { // Enabling Windows XP visual … |
| | Hello everyone, Please can someone help me with a code to find two(2) fields at thesame time. As in with a msgbox "Enter Date" then after that "Enter Shift". Because there are two 'shifts' tied to a 'date' I will really appreciate this help. |
| | I need coding for update, add, delete , view command button.. Pls help me.. |
| | when I create a program with VB6 and I do storage program that I have made the message "System error & H80004005 (-2147467259). Unspecified error". Can you all enlighten me? thank you for your help |
| | when making a component (ocx file) of the combo box, and the wear components of the user control, then I compile it into ocx files. Once finished I include the components of it into the main program. then I do click and drag the combo box to the form, but … |
| | I have visual basic 2010 windows application assignment in which I have to populate a one dimensional array from a text file stored in the projects debug folder. The text file is 6 five digit numbers on seperate lines. One number was typed then enter was pressed 6 times. The …  |
| | hi my name is vishal. I am learning how to transfer vb6 to table in ms Word using adodb. I have done word template named DCS Clinical Report which contains table of 10 columns and 13 rows. I am able to export it as a template but i am unable … |
| | So I'm new to C++ and I am doing a project that requires the creation of a menu for a simple game. The project instructions are: Write a program that will ask the user to purchase a vehicle for their character in a racing game. Tell them how much their …  |
The End.