11,868 Topics
![]() | |
[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 … | |
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 … | |
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 … | |
Explain me what is meant by form level variables in visual basic? and how to declare these variables? | |
'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 … | |
'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 … | |
[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] | |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
what code should i write in VBA if i want the textbox to show the same as my label caption? | |
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 | |
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 … | |
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! | |
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 /> … | |
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 = … | |
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 … | |
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 | |
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 … | |
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 … | |
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 … | |
## 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 … | |
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 … | |
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 … |
The End.