11,870 Topics
![]() | |
Good day! I just want to ask on how to drop a table. Let say all tables starting with "DailyCashSalesRpt". That means it will drop all tables starting that word. I use this code but it will only delete one specified table name.. How to use this with like? sql … | |
So. I've started learning basic programming, using special site which gives you video courses. I've got my Visual Studio 2013 (Update 3), from special site for children of our school. Now, everything went fine, until I had to meet "if" statements in C#. Curly brackets are finished just fine, and … | |
Hi Team, I'm stuck with my code and I found out this snippet to save(Export) an Excel file to **D:**. However, I would like to give a User an option to save it according to his/her necessity. Please find the Code Snippet below: Private Sub Button1_Click(sender As Object, e As … | |
I am trying to add a coloumn from database into a listbox in VB6. The following code works. The selected item from this listbox is used to find and add records to the ListBox2. Using Oracle 11g Express Edition and Visual Basic 6. Working code: (Displays the artist column from … | |
Hi expert, Just want ot ask the correct code format for moving message to a new location. MsgBox "Do you want to save?", vbYesNo, 10, 10 Thanks | |
Greetings, I need help with basic cloak, which counts how many times will small and big pointer on the cloak cover each other, with first one starting at 12 cloak. I have idea of how to do it, but I can not realize it, so if you guys have some … | |
good day! I just want to ask if is it possible to have count on dinstint? I have a query below but it produces error in the expression. Im pulling data in MSAccess using ADODB. SQL = "SELECT" & _ " (SELECT COUNT(DISTINCT DateOInvoice) FROM InvoiceMain AS A WHERE (DateOInvoice>=DateValue('" … | |
Hello there. I have program that has been used for years on using VB6 on Windows XP. It has a 'shell' command to call a word document for dropping in dta from the clipboard. I am tried in vain to get this system to work on Windows 8. Is there … | |
Hi expert, just want to ask the correct code format for moving a message box. MsgBox "Do you want to save?", vbYesNo, 10, 10 Thanks | |
Hi everyone! I want to develop an Automatic Number Plate Recognition program in visual basic 2010 using windows forms. I need the program to pull the characters from a captured image and translate it into text that can be displayed in a text box. I know i am asking alot … | |
How do you link list view with ms access using visual basic 6 | |
I have this problem when I add new project -> other projects -> visual studio installer -> Setup wizard to create setup project after finish it gives me this problem : ** The following files may have dependencies that cannot be determined automatically. Please confirm that all depedencies have been … | |
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 … | |
I have written a program using Visual Basic within Visual Studio 2008 which occasionally needs to load data from two MS Access database files into datatables for selection purposes. This all works perfectly on the built 'release' version but when I publish to Public_HTML via CPanel to my website and … | |
i need help, im a noob programmer a student actually but our prof. told us to make a device which runnable by VB 6.0 codes and we propost a device which is the noise detector but the problem is we dont know how to make the code for it.. help … | |
Good day! I just want a little help on how to add the textbox data onto the datagrid when a button is click? I have 3 textboxes(txtname,txtaddr,txtcontactno) and a datagrid with 3 columns(Name, Address, Contact #). When a button is clicked, the data of the 3 textbox shouls be transferred … | |
Hi, I want to develop RFID access system. I create a user database using Microsoft Access.When system and connection are ready, user will swap the card on the RFID reader and the card id will show on retrieve data column. The card id will use to compare with the data … | |
I am trying to create a program that automatically logs me in a certain website, e.g.: Gmail. I am using the browser control in vb6. What I'm trying learn is how to connect my commandbutton to the web page's login button script. Anybody can help me? | |
Hi...I created a project using VISUAL DATA MANAGER TABLE as backend...However, I observed in the database, I have no access in other commands / buttons such as Save or Save As....Is there an easy way to convert VM table to other Access version such as 2000-2003? | |
Im just curious what is wrong in my code, when i click the void button an error is shown, but it runs smoothly when the void button is not click. Here is my code, thanks for your help guys! Public Class Pizza Private Sub rdPrimo_CheckedChanged(sender As Object, e As EventArgs) … | |
Hi. I'm trying to use brace-initialization notation: int number{}; But I get the following error: "expected an expression". Shouldn't c++11 allow this kind of initialization? int number2(4) works just fine. Thank you. |
The End.