10,989 Topics

Member Avatar for
Member Avatar for Not Available

How do i do a loop which is verifying that cells in the same column are numeric until the last cell which will be determined by an empty cell? Thanks so much

Member Avatar for Stuugie
0
191
Member Avatar for kimangel

Hi expert, I have the code to delete all entries in the datagrid but it seems it will not delete just in one click. Pls help me on this. Thanks Private Sub cmdRefresh_Click() Set rs = New ADODB.Recordset rs.Open "select * from ItemPurchased", cn, adOpenStatic, adLockPessimistic Do While Not rs.EOF …

Member Avatar for dwirch
0
95
Member Avatar for singhSP

1. Form created in VB2008 3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record] 2. Database created in MS Access 2003 File Name: Contact.mbd Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number] How to Create Connection? How to get data on form load from …

Member Avatar for Santanu.Das
0
10K
Member Avatar for Mauricio_3

hi guys i have recently come to a problem where the equal sign keeps adding after getting a sum of two numbers. for example if i add 5 + 5 it would equal 10, but it will then keep adding 5 over and over again. Dim Answer As Double Amount1 …

Member Avatar for qumar.farooq.3
0
167
Member Avatar for Papa_Don

Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that …

Member Avatar for Papa_Don
0
4K
Member Avatar for PinoyDev

hi good day! I need some help here.. I have a SHAPE recordset..everything in the database has its value..Im stucked with this error: **"Error : -2147467259 - Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large."** My code below: cmd.ActiveConnection …

Member Avatar for PinoyDev
0
266
Member Avatar for PinoyDev

Good day! I want to save the data report with the .mdi(microsoft document imaging printer viewer) on a specidied folder.. 'Print to a Specified nondefault printer Dim PrintData As Printer Dim defprinterpos As Integer Dim currentPrinter As String For Each PrintData In Printers If PrintData.DeviceName = Printer.DeviceName Then currentPrinter = …

0
71
Member Avatar for PinoyDev

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 …

Member Avatar for PinoyDev
0
450
Member Avatar for Dudestreet

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 …

Member Avatar for hericles
0
316
Member Avatar for Sudha Granger

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 …

Member Avatar for cgeier
0
579
Member Avatar for kimangel

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

Member Avatar for J.C. SolvoTerra
0
245
Member Avatar for filipgothic

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 …

0
92
Member Avatar for PinoyDev

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('" …

Member Avatar for PinoyDev
0
281
Member Avatar for stickerman

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 …

0
65
Member Avatar for kimangel

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

Member Avatar for LesF
0
85
Member Avatar for CheapApples12

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 …

Member Avatar for chriswelborn
0
140
Member Avatar for JACK wizkid
Member Avatar for PinoyDev

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('" & …

Member Avatar for pritaeas
0
218
Member Avatar for Pavan_6

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 …

Member Avatar for J.C. SolvoTerra
0
196
Member Avatar for ice23

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() …

Member Avatar for ice23
0
312
Member Avatar for Bensjariou

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.

Member Avatar for Bensjariou
0
552
Member Avatar for Nehan
Member Avatar for loginsatara
Member Avatar for pritaeas
0
53
Member Avatar for loginsatara
Member Avatar for Core3R

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 …

0
85
Member Avatar for hemendar4

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

Member Avatar for Santanu Das
0
210
Member Avatar for dtbn

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 …

Member Avatar for ice23
0
14K
Member Avatar for MaryRose_1

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

Member Avatar for Nutster
0
168
Member Avatar for razamughal67

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 …

Member Avatar for razamughal67
0
457
Member Avatar for pito_donje

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

Member Avatar for razamughal67
0
225

The End.