10,987 Topics
 | |
| | Hi all. I have error with script below : Dim sql as string sql = "select * from [table] where [field] like '%" & text1.text & "%'" how must I write "%" after "like"? |
| | Hi, I'm new to Access and have only had one online course in it recently. I want to try and build a Home Inspection database that would allow me to add images for the findings during a Home Inspection. I've found a lot of bits and pieces of information on …  |
| | I got a runtime error 3705 "Operation is not allowed when the object is open". When I click debug, it highlights the connection object I made in the module. I have a form named frmUser. When I click mnu_User from the mdiForm, I got a runtime error 3705, but when … |
| | Hello, I am trying to create a "stock Price Program" for an assignment that will allow you to type in a stock symbol such as "goog" in the client side and the server side will respond with a price for that stock symbol, this price can either be hard coded … |
| | [B][COLOR="Red"]how do i add the numbers in label1 and label2 and i want it to appear at label3?[/COLOR][/B]  |
| | [CODE]Private Sub cmdDeduct_Click() Dim sConn As String, xQuantity As Integer, xStockTotal As Integer, xPre As Integer Set oConn = New ADODB.Connection Set rsDeduct = New ADODB.Recordset sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\inventory.mdb;Persist Security Info=False" oConn.Open sConn If LenB(cmbItemName.Text) = 0 Then MsgBox "You have to select an item …  |
| | i am using floppy as ATM card.. am thinking that using the serial number of the floppy, i can check with the database and confirm it and loging the user.. but i have problem in getting the code for getting the code for getting the serial number of the media.. … |
| | How do I check if a form is open (not only loaded, but also open) |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
| | How can i add treeview control to my project. I cannot find this in components. |
| | [CODE] Private Sub cmdAdd_Click() Dim sConn As String, xQuantity As Integer, xStockTotal As Integer Set oConn = New ADODB.Connection Set rsAdd = New ADODB.Recordset sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\inventory.mdb;Persist Security Info=False" oConn.Open sConn If LenB(cmbItemName.Text) = 0 Then MsgBox "You have to select an item from the … |
| | I'm writing a text editor for my own use ( I'm "home learning") where I want to be able to leave comments for myself, like in code section of the VB express IDE. I have figured out how to get the Integer Location of the apostrophy, but can't get it … |
| | I hope that this question is not out of place here. I have an access 2007 database for which I made a perfectly functioning simple "front end" program in VB6. That was back in XP or Vista days. I hadn't used it since the switch to Windows 7, and when … |
| | i want code for search in vb6.if i give see it will search seeni,seenivasan,seetha,mooseetha,etc |
| | problem is in form5 when i add stock it didn't refresh... just download my attach file "datagridprob.zip" and try to correct my code in "add_stock form" then if you got it right kindly post your code here...thanks... |
| | Hi again, sorry for yet another thread. I am using the KeyDown function in my form and it is not able to perform because of the other controls. For example, there is a text box in the form. Once the form has loaded, when I press vbKeyRight, my code does … |
| | how to connect adobe photoshop to visual basic 6.0? |
| | [CODE] Private Sub Command1_Click() Dim xSold As Integer Set db = New ADODB.Connection db.CursorLocation = adUseClient db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\inventory.mdb" Set rs = New ADODB.Recordset rs.Open "SELECT * FROM storage WHERE Current Stock = '" & Text1.Text & "'", db, adOpenStatic, adLockOptimistic If rs.BOF = True … |
| | Hi, Can anybody help. How to scroll data in DataList by using mouse scroll. DataList have no Scroll method. |
| | I have multiple projects in the same database that use the same dll code. Currently I have to define in the dll what the project names are and what the unc path is that each particular project needs to reference for it's excel file. The excel file contains notes that … |
 | [URL="http://www.daniweb.com/forums/thread341763.html"]http://www.daniweb.com/forums/thread341763.html[/URL] Regards to that, i also wanted the system not to be able to delete Administrator Accounts via my code also posted there. Here's the code again: [CODE] Private Sub cmdDelete_Click() ' On Error GoTo err Dim intYN intYN = MsgBox("You are about to delete a record." & vbCrLf & … |
| | i want to convert a fie(document,excel,picture) to binary format using VB.Please how can i achieve this |
| | Hi, I got a runtime error 3709. It says "The connection cannot be used to perform this operation. It is either closed or invalid in this context." I can't find what's causing the error.. Here is my code: [CODE] Public Sub S_LOAD_flxUser() Dim strSql As String Dim rsLoad As New … |
| | How to run a command of MS DOS with code through visual basic 6.0 for ex. setting the path, zip and unzip files etc. and also the commands of Visual Foxpro Databasese through VB. |
| | hello guys! Its been a long time posting here since I've switch to dot net...But I CANT LEAVE VB6 in programming.! I just want a little help.. Anybody can recode this statement regarding connecting to SQL SERVER local database.. The connection is succesful. But i want to trap the error … |
| | hello, im using vb6 with access 2007 (.mdb) im using adodc connection. my question, how to prevent if the data existed in my database. i've put primary key in my database and i need an example like it's giving msgbox "data existed!" anyone can help me? thanks.  |
| | Placing ComboxBox in DataGrid Cell is a task usually found in Invoicing application. Here is my version of same. |
| | ...here is the scenario...in my inventory system i have database and it's fields are "Item Number,Description,Last Week Stocks,Deliveries,Total Stocks,Total Withdrawal and Current Stock...this is my logic if adding new stock it will add to 'Current Stock' and to 'Total Stocks' and if withdrawing stocks 'it will add to 'Total Withdrawal' … |
| | Is there any code that will enable me to click on portions of the form with the use of coordinates? I know most of you find it easier to just use controlname.click but it is not possible for my application. Hope someone can help. Thanks. |
| | Hi, I am trying to output some data from sql db within excel to XML. I am updating the sql db from the excel worksheet and then outputting the records from the db to xml. I have used CDATA to parse html within xml but i can only get one … |
The End.