11,868 Topics
 | |
| | Good day! I have problems running my union all query..It only executes the first select statement but the 2nd and 3rd union was not executed. My backend DB is MSAccess 2003.. If rs_dailySales.State = adStateOpen Then rs_dailySales.Close SQL = "SELECT SUM(NetAmount) AS totalCashSales FROM InvoiceMain WHERE InvoiceType='Cash' AND DateOInvoice=DateValue('" & …  |
| | Dear Geeks, I have a situation that I am trying to figure out how to automate on excel or write a program in python. i have a csv file like this: > team1 team2 win > hawks celtics 1 > hawks knicks 1 > hawks 76ers 0 > hawks lakers …  |
| | How can you view the values of the registers in Visual Studio? I think they should appear in the Output section at the bottom of the screen. I'm using Visual Studio 2013 for Desktop. |
| | Hi im just a new here and Im hoping that you can help me. Im having a problem in my project and I cant find any solution in the internet thats why i am hopeful that in this forum somebody will help me. this is my codes Private Sub cmdupdate_Click() … |
| | Windows ViSTA - HP Pavilon Entertainement PC (Under windows XP and 2002 IBM PC, no problem) The problem is I get error 3170 and error 3051 when I define a workspace as I show in the code tested I need a solution I will appreciate very much. |
 | |
| | i can connect msaccess database over lan but not able to update changes made on other computer. |
| | i am connecting to ms access database from lan but not able to update ! ple  |
| | Hello I have a VB.NET project in Visual Studio 2013. I am hoping to customise the standard Register.aspx form and want to insert a background image. However, I can't see any 'images' folder in Solution Explorer and I wish to import an image from the desktop and then use something … |
 | Hi to all. I am planning a program that controls the other Computer's basic functions (shutdown, reboot, sleep, wake,). It is somewhat similar to Handycafe program which is used for Cybercafes. My point is that i want to make my own configured program that only accepts a passcode then automatically … |
| | How to create reports in visual basic 2010 express with mysql as database please tell me the whole process as I am very new to it and tried by several ways and places but always failure please help |
 | Hi 'Wise & Wonderful Daniwebbers', Why do I keep loosing my project settings when I add a new project to an existing solution? I have to go to every project, in the solution and re-configure each project's: * Include Directories; * Library Directories; * Linker Settings; etc., Which of the … |
| | Hi, I already have an excel file (MyXL.xls) and a Visual Basic (Form1.frm) with a command button. Now, I want to write a code for the Visual Basic so that when I click on the command button, the excel file will be opened. Any help is significant to me! Thank … |
| | i am using this code in updating multiple data in listview but it doesn't work, what code should i replace to run this command save dbConn sample RS.Open "Select * from table where field = '" & listview.listitem & "'", , conn, adOpenKeyset, adLockOptimistic If RS.RecordCount = "0" Then  |
| | I am trying to send Email using email sending software through smtp server But I am getting this Error. The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available we use 2 other email accounts but the same … |
| | how do I create an email with VB? when we click the button, type in all the data we sent to the email address we are headed |
| | Hi, I want to convert my word file to pdf file in vb6. source code will be appreciated. so far, i have tried with below code also. Private Sub Convert_WordDoc_to_PDF(DocPath As String, sDestsPDFFile As String) 'Dim worddoc As New Word.Application Dim worddoc As Object Set worddoc = CreateObject("Word.Application") Dim x … |
| | Hi, I have installed CR 8.5 and VB6. prepared one small prog. Now want to add CR control in VB toolbox so as to drag the same in vb form where I have to write code to print. So how to get the control please. |
 | Hi, I have completed my vb6 coding. I have already installed CR 8.5 also. Now how to add CR control in vb6 toolbox so as to drag it in vb form where code to print is to be written. |
 | Please read through the following suggestions before posting in this forum. Questions in this forum are answered by people who generously volunteer their time. Following these guidelines will increase the chances of getting a quick and accurate answer. 1. Use Search to see if your question has been asked and … |
 | I have underconstruction project and my table is made via VISUAL DATA MANAGER, and Im using the DATA CONTROL OBJECT as my connection...Surprisingly, this error appeared when I click the button where I am calling a form that is connected to the database....What's the cause of this error?......Please Help.... |
 | I Need To Move a Record from one Table in a Database To another Table I am using ado in vb 6.0 plz help me! |
| | Hi I want to scan a large csv (3000+line)file and just count the number of lines that meat certain criteria. 18,08/24/14,05:02:00,5056 14,08/25/14,07:05:00,5046 18,08/24/14,05:02:00,5056 12,08/25/14,13:06:00,5076 18,08/24/14,05:02:00,5056 14,08/25/14,05:07:00,5054 For instance I may need to know the number of entries that have 18 as the first column and have a date of 8/24/14 … |
| | Hi, I am working on my project and your HELP guys is really appreciated. I have a STUDENT NUMBER textbox, and what I want is when the form is open, IT WILL AUTOMATICALLY ASSIGN student number so that the registrar will not bother anymore to encode the student number...Is this … |
| | I've written a simple program in Visual Basic 6 pulling data from a database into a table. My program starts out with "Dim db as DataBase" and "Set rs as RecordSet" and then goes on to pull up the data. It runs fine on my computer. However, when I try … |
| | i have a label input & i want to show image base on label input string to show the picture with picture file name. |
| | I have a LogIN form - usertxt and passtxt and a button, and what I want to know is how to call the values of the fields user and password in the database access to open the MAIN FORM..I am connected using DATA1.RECORDSET..Is it possible instead of using ADODC?.... |
| | Hello, Is it possible to show password character * when user viewing data or entering data in maskedbox? I have field clientid that uses masked box to capture data, but as user types or views we would like to mask with * so it is not viewable and only viewable … |
| | How to update multiple data in listview |
| | i am doing attendance monitoring system for student only not for staffs and only concern lectures have the privilages to mark the attendance (if one staff taking the class then another one cannot mark the attendance for same period so help me to design er-model and data base design and …  |
The End.