12,155 Topics
I have a volunteer database and having trouble with genuine password protections. I have a "delete" button with this current code under Build Event: Private Sub delete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Delete this VounteerRecord. Are you sure?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand …
I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly. Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013. In all above sheet : Part numbers mentioned in column "C2:C60000" Quantity in column "D2:D60000" …
Has anyone used a card reader with vb6 and can you recommend one to get? I want to issue cards with names for players so they clock in to start the poker game and during poker slide to clock out where the program will determine their position and any points …
To open a new window in vb by clicking a button replacing the previus windw
I have a function that reads a text file that contains information about the sql database it connects to. It has to be invoked across multiple forms. How could I make it to where it is invoked once and then stores into variables that the program can continue to use …
hello experts . . . there is one textbox , one label and one command button i have written following to print textbox content to label `label1.caption=text1.text` and when & is inputted in textbox then underscore(_) is placed in the place of &. and i know that we use & …
Hello there Good Day Guys! I need your expertise for vb6 guys i made a small program with command search button. Its working. My problem now when i search again with different category it shown this error [COLOR="Red"]Run-time error '3001' Argument are of the wrong type, or out of acceptable …
hi i m new to vb with sql.i made login form.but after that on main form some feature will be disbleed for ordinary user and that feature will be only enabled to admanistrater.so on main form a button will be enabled with specific password that is in backend so i …
Please can someone know how to trim this code. Any help will be appreciated If Range("D8") = "EBU 2" Then If ComboBox1.Text = "Level 4" Then Sheets("Main").Range("C9") = Sheets("Main").Range("C9") + 1 Sheets("Main").Range("D9") = Sheets("Main").Range("D9") + Range("K8") ElseIf ComboBox1.Text = "Level 5" Then Sheets("Main").Range("E9") = Sheets("Main").Range("E9") + 1 Sheets("Main").Range("F9") = Sheets("Main").Range("F9") …
Im using VBA build inside excel is there a way to find if ComboBox has a value? for example i have 80 ComboBox and i want to check if they have a value like "A", "B", "C" and "D" and if the value is blank like "" then stop the …
I'm using the Visual Basic that comes with Visual Studio 2012 Utlimate, and everything I find online doesnt ever work. I am simply trying to make it to when a button is clicked the rows that are checked get deleted. Do While TodaysTrans.SelectedItems.Count > 0 TodaysTrans.Items.Remove(TodaysTrans->CheckBox.Equals(true)) Loop
Guys I want to get my iput from a barcode reader. Apparently I don have a barcode reader but, I just want to make a code ready to operate in a shopmif a barcode reader is going to be foun later but th software or program already made. Please help …
I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the …
I was wondering if it was possible to bound 2 combo boxes to each other. the first combo box with a set of information. Based on what the user selects, the second combo box changes. this involves 2 tables. table 1 ProductID Descritption table 2 Id FK_ProductID Category example: the …
First i don't know if this will be right forum but i know its related somehow? I'm using excel developer visual basic and i have a combobox Dim x As String Dim y As String x = "O15" ' range With ComboBox1 If .Text = "" Then Range(x) = "" …
Am new to the world of networking on LAN, i need help to get me in the right direction in creating a LAN Chat that has the capability to send file across the network. i want this chat to be able to handle more than 50 connections. how to connect …
i get this error message when i try to connect from clinets pcs to login with the crystal repor but the forms is correctly connect to the DB srver but the server not this is the error : Crystal report viewer login failed detail : ADO error code: 0x80040e4d Source: …
WHERE Category = '" + CategorySorter.Text + "' AND DateAdded = '" + DateValue("DateEnd.Text") + "' " thats my query and its not working, if the user input a date(like this 12/25/12) in DateEnd.Text, i want to confirm if it is existing on a database
I'm new on programming this VB 6, Advance thanks for those who'll reply. All opinions are open :3 (Sorry for poor English) === The program runs like this: I input the Student ID, then it searched using DAO now the student's info was shown up, what should I fill up …
I want to first off say, I don't know Visual Basic. I have a XML script that for a program that can only accept VB Scripts. I want a simple script to check whether, on it's own or if it can, from the XML file to see if a USB …
hi all , when i install my vb project on clients machine and runing it its show this error : Cant generate SSPI Context , what should i do ????
Hello ! I'm the ultimate beginner in programming. I have some experience in php and vba, doing my own scripts as I need them, especially in excel. Recently, for a project at works, I need to be able to scan **AUTOMATICALLY** (say every 2 minutes) from **multiple scanners** (say 2 …
when i need to install the vb6 project to network pcs this error is show : The program cant start because ActiveX Tools.dll is missing from your computer. Try to install the program to fix this problem. i search on internet for the dll required but i am not find …
Hello everyone. I am making a form to backup my Ms-Access database in vb 6.0. I have a textbox (txtdestination) a progress bar (progstat) a command button (cmdbackup) and a few labels to show different info. I have the following code in my backup form : Dim mintCount As Integer, …
hello i'm doing a project i use visual basic 2010 i have an issue with the select case it suppose to be when you press the 2 and the 3 it gives you all the names start with (a&d) (a&e) (a&f) or (b&d) (b&e)...etc. it works fine just the error …
Hi DaniWeb Forums, The I'm making a simple timer. The label flashes every time the caption changes (this is the problem). See code below. If you run this, ensure to that timer interval property is 1000 for the timer and Label1 caption property is set to "". TY. Dim sec …
Hi, How can I do to get motherboard and processor serial number in VB6? I am able to get HD serial number with this code: Option Explicit Private Type DRIVEINFO HDDSerialNum As String End Type Private Sub Form_Load() Dim info As DRIVEINFO Dim objs As Object Dim obj As Object …
Run-time error '-2147217887 (80040e21)' Multiple-step operation errors. Check each status value. === The one highlighted was: **Adodc2.Recordset.Update** Private Sub Command1_Click() Adodc2.Recordset.AddNew Text13.Text = Label19.Caption Text14.Text = Label15.Caption Label5.Caption = Text6.Text + "-" + Text7.Text Label3.Caption = Text1.Text Label21.Caption = Text10.Text Text11.Text = Text6.Text Label17.Caption = Text3.Text + ", " + …
hi all, i'm very - very newbie here, i need a help, i try to connect arduino with vb6, i want to display data from arduino to vb6, lets say the data is : "the distance : XX m", the problem is when i want to put data via mscomm.input …
As the title suggest, I don't know how to add item to a multiple column list box. When I do the usual ListBox1.AddItem "haha" it only adds to the first column. How do I populate the others? Columns property has been set to, say, 3. I googled out this issue …
I'm really new in ADO for just a substitution on Data Control (I cannot dl any access 2003 D:) --- Whenever I enter command3, it says: *Compile Error: Method or data member not found* and the highlighted one was **.EOF** Code: Private Sub Command3_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.Find "SID = '" & …
I have been using Qbasic 1.1 in MS DOS 6.22 PCs upto P4. In view of the changing hardware scenerio, I wish to migrate to VB inside Windows 7 32 bit machines. Should i rewrite all code in VB or can I import .bas files created in Qbasic 1.1 into …
When the button is clicked, I want the file (it's a XPS document) to be opened in windows. The file will be in the same directory as the visual basic project. Therefore, I need the code to open the file using "app.Path". Any solutions?
When the button is clicked, I want the file to be opened. The file will be in the same directory as the visual basic project. Therefore, I need the code to open the file using "app.Path". Any solutions?
In VB6, how do you get the contents of "Comments" from the properties of an image file? I want to place the contents in a text box so I can manipulate it and display it superimposed on the picture. The comments is where one places the the discription of the …
for example: 8 - 9 = -1 i want it to be : 8 - 9 = 1 i want to subtract a lower number from a higher number and the result will be a positive number and it will display on a Label.
i have vb6 project with cr8 and 10 , its correctly run on one pc what i need is to run this project on local netwrok , how i can do this and how i can edit the connection string and make .exe file ???? Help me plz
I'm still using a dBase 5 routine I wrote years ago (I know, don't laugh!) but have tinkered with from time to time. It mostly does what I want and is, therefore, still useful, but I wondered if there was ever a year 2000 work around as I'm having difficulty …
Hello everyone. I am developing a inventory and pos software myself with vb 6.0 and ms-access as database. In my sales invoice I want to generate the sales invoice number serially. I mean when I load the sales invoice form the txtsinvno text box will automatically generate the sales invoice …
hi all, i am creating a form in which when a particular command button is clicked, it will open another form with a flex grid. Based on the row selection the user makes on the flex the first form will be filled with datas retrieved from sql database. i can …
Hello, I have a program I have made in vb which works perfectly fine. It has a couple of variables I would like the user to define though such as the timer interval. To do this I would like to have one program where the user can download it, run …
im having problm with my date function. i want to record date in database only one but my code do not function. this checks attendance once in a day. date must not double plz help me. Sub search() 'search if id registered With ado .ConnectionString = connectdb .RecordSource = "Select …
Hi I need to use sumproduct in VBA, but not able to use it. can any one tell how to use it. Shailaja
Hi everyone! Can please someone help and guide me on how to export image from vb6 to excel. I found some codes here but doesnt work well when i tried it. I will use an existing excel file then i will export the image probably from the picture box located …
hi what is the advantage of vb.net to vb6?
Well i'm really in need of urgent help. I've created a program (in Visual Basic Express 2012) that seeks the computer for information using WMI, like processor, graphics card, etc. Inside the IDE of Visual Basic everything goes by the book ... but the produced EXE when i try to …
Hey guys does anyone here knows what is the code for inserting the current day in a form? I'm creating an Employee Monitoring System. I have here a part of the codes of my program Private Sub Command1_Click() If Text1.Text = "2036251" Then Adodc1.RecordSource = "select * from Table4 where …
how to convert the for loop to while loop
Hello fellow code enthusiasts. I am currently trying to figure out how to retrieve text from pdf images submitted to my MS office inbox and put them into an excel spread sheet. At the moment, I plan on using Tesseract as a library (well reference) to do this. Is there …
The End.