11,868 Topics

Member Avatar for
Member Avatar for limesight18

[CODE]dim H, M, S, AMPM as strings DTPicker1.Hour = H DTPicker1.Minute = M DTPicker1.Second = S DTPicker1.?????? = AMPM [/CODE] im having a problem on how i can change the DTpickers AM/PM in codes im trying to load a time from a database to DTPicker, ive Split the (field loaded …

Member Avatar for ricardo.driju
0
1K
Member Avatar for Sneaky Pete

Hello, I've got a question about vba in excel. I hope you can help me with this issue. In a sheet, I want to loop through column G to check if het value is "Yes" or "No" So for, no problem, but... When a cell in the loop has got …

0
63
Member Avatar for archangel1177

Hi all, I have an interesting challenge that so far I have not been able to correct. What I have is a workbook that tracks orders and when they are recieved the sheet then copies the row that was completed and then it moves it to a second sheet for …

0
104
Member Avatar for Saboor880

Explain me what is meant by form level variables in visual basic? and how to declare these variables?

Member Avatar for tinstaafl
0
56
Member Avatar for jomared145

'I have a problem in database Program in VB 6.0 that connects to Ms access which the field datatype is OLE object. ' here is my problem 'when i tried to run my program i always got this error message '"System Error &H80040E00 (-2147217920)" 'here is my code for uploading …

Member Avatar for nkwuda.mathias
0
260
Member Avatar for Mr.LK

'I have a problem in database Program in VB 6.0 that connects to Ms access which the field datatype is OLE object. ' here is my problem 'when i tried to run my program i always got this error message '"System Error &H80040E00 (-2147217920)" 'here is my code for uploading …

0
60
Member Avatar for xirosen

[CODE]Hi.... can everyone help me pls in how to make program using visual basic that can Preview documents before printing.. Help me pls.. thanks...[/CODE]

Member Avatar for babrad
0
2K
Member Avatar for EXTRA_RICE

i am using vb2010 express. can u pls tell me wat is the code for delete?bcoz when im doing delete my database is not updating after i exit.i can add item in database but i cant delete it.any help?thanx guys? hope u understand my problem.

Member Avatar for Reverend Jim
0
153
Member Avatar for alina.nazchowdhury

I get lots of error in my program like: Warning 1 WithEvents variable 'Close' conflicts with sub 'Close' in the base class 'Form' and should be declared 'Shadows'. C:\Documents and Settings\Alina\My Documents\Visual Studio 2008\Projects\WindowsApplication1\WindowsApplication1\Form1.Designer.vb 321 23 WindowsApplication1 Error 2 Expression is not a method. C:\Documents and Settings\Alina\My Documents\Visual Studio 2008\Projects\WindowsApplication1\WindowsApplication1\Form1.vb …

0
113
Member Avatar for chumz.delossantos

hi PL masters can you pls help me with my codes for my thesis about combo box i'm a BSIT4 student in Leyte. i have a combo box named "category" the list below the box are "date" and "name" if i click date then two text box would appear text1 …

0
58
Member Avatar for bullet_1

I am using the following code to create a log file but getting an error "User-defined type not defined" Help me Thanks in advance Sub main() Dim dDate As Date Dim boDP As busobj.DataProvider 'error occured Dim sLast As String Dim sFileName As String Dim sDir As String Dim dTime …

Member Avatar for bullet_1
0
273
Member Avatar for Sharad_2

cnsrvlist3.open "Provider=SQLOLEDB.1;Data Source="& strDrserver &";Integrated Security=SSPI" msgbox("ABC") msgbox(cnsrvlist3.state) cmdsrvlist3.activeconnection = cnsrvlist3 I am trying to check the state of connection, The code works fine if the connection is fine but when any Database server is down then in that case the state should come as 0 instead of that it …

0
41
Member Avatar for SpectateSwamp

Do you use it. I do. All the time. My main program is made to be killed and restarted lots. With the short-cut link in the upper right I can start and stop the prog with little movement. When you use just one app for everything. It should reside at …

0
140
Member Avatar for sonunclejalil

my problem is i want to save a date from label in vb to field in ms access but i do not know that problem with my coding, the error appear is run-time error 91 object variable or with block variable not set, can anyone check my coding? Dim Con …

Member Avatar for sonunclejalil
0
530
Member Avatar for Abhishek_Singh

Hi there, This is the code for opening various files using vb applicaton but here i need to provide the path for file. i want to open any file using vb app using Open Dialog control. Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation …

Member Avatar for bullet_1
0
288
Member Avatar for Adnanhussainturki

hi iam a noob in vb programming and iam making a vb.net program to create a database of my shop... the code of my program is Public Class form1 Private i As Integer = 0 Private myCoolFile As String = "C:\test" & i & ".txt" '// your file Private Sub …

Member Avatar for tinstaafl
0
159
Member Avatar for tipdarath.phal

what code should i write in VBA if i want the textbox to show the same as my label caption?

Member Avatar for Reverend Jim
0
156
Member Avatar for carolyn85

please help write a program which displays a multiplication table using visual basic 6.0 can someone send me database tutorials of visual basic 6.0

Member Avatar for Stuugie
0
82
Member Avatar for DM Galaxy

I am in wonder. I just make a slideshow form and add the context menu strip as when the user click on download image then current image get copy and paste on the desktop. I use path and destination method in this but they say bitmap cannot be converted into …

Member Avatar for DM Galaxy
0
471
Member Avatar for amitash

Hi, I want to write a VBA macro in Word that open an Excel file, save that Excel file to another file (to another name), and then clear all content of the original Excel file. How to do that? Thanks!

Member Avatar for Dieter123
0
498
Member Avatar for jakub.peciak

Issue to read some part of XML file. Here is my XML file: <Report> <orders> <order savedby="manager" time="12:33:09"> <header saledate="04/Oct/2013" saletime="12:33:09" reqtime="12:33:09" /> <customer name="-" accname="123465" /> <payments> <payment transid="1" method="7" vposuser="manager" cardtype="" value="2.95"></payment> </payments> <totals deliverycharge="" splitdelchgstore="" splitdelchgdriver="" sercharge="0.00" /> <products> <product type="cookbook" qty="1" prodid="10000564" listprice="0.00" sellprice="10.00"> <stock /> …

Member Avatar for ravikash123
0
168
Member Avatar for jared.geli

hi I'm having problems in my crystal report where all the selected rows in my datagrid will show up in my crystal report but instead it showing me an exception selectcommand.connection has not been initialized here's my code in my form where the datagrid is: Dim cmd As OleDbCommand = …

Member Avatar for jared.geli
0
347
Member Avatar for locsin

greetings! When i First start my VB6 program with data report it works fine. The report displayed directly. but when i try to open other programs in other directory and then when i re-run my program in data report operation a msgbox appear "Please Enter MS Jet OLE DB Initialization …

Member Avatar for yokoshima.mur
0
3K
Member Avatar for bullet_1

I can search and find text in word doc through vba but I dont understand how to search images Its a big problem to me Can anybody help me thanks in advance

Member Avatar for Zephaniah
0
125
Member Avatar for alina.nazchowdhury

i made on screen keyboard program with visual basic 2008, i run it, its working great, i save it and then i wanted to open it again to review it, but its only showing me the code, i can not run it anymore. Anybody give me an answer to my …

0
106
Member Avatar for Abhishek_Singh

Private Sub Command1_Click() Shell ("cmd.exe") End Sub Private Sub Command2_Click() Shell ("calc.exe") End Sub Private Sub Command3_Click() Shell ("explorer.exe") End Sub Private Sub Command4_Click() Shell "winver.exe" End Sub Private Sub Command5_Click() Shell "C:\Program Files\Windows Media Player\wmplayer.exe" End Sub above code is able to open the pre-installed windows programs. But now …

Member Avatar for Assembly Guy
0
193
Member Avatar for ikocrush

I have problem connecting vb 6.0 to wamp(mysql, myphpadmin) server on my LAN. It connects to server on the same laptop using localhost but cannot be accessed by other Pcs using ip address. What could be the problem? Please, i need your help on this. OS=windows 7. below is my …

0
72
Member Avatar for Ahmed.C

## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials …

Member Avatar for JorgeM
0
330
Member Avatar for toxicandy

I have started a program that should be able to do basic cryptography functions such as reassigning letters to different letters. How I did this was by coverting each letter to an ASCii value and then storing them in an array. I am working with only the lower case letters …

0
72
Member Avatar for ariannas

Compute the Sub total ( Beginning Balance + Deposits – Withdrawals) d. Compute the Interest Earned. If the Subtotal is greater than 5000.00 the interest rate is 2 percent otherwise 1 percent. e. Compute Endin g Balance (Sub Total + Interest EarneD) Display the Interest Earned and Ending Balance in …

Member Avatar for tinstaafl
0
125

The End.