vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Afghan2

when i click on a menu i should get a report for data but i just see the old report help???

Member Avatar for Afghan2
1
356
Member Avatar for Xiao_1
Member Avatar for hefaz
0
49
Member Avatar for _ MSCrafter2006
Member Avatar for hefaz
0
278
Member Avatar for altjen

Hi DW Im trying to make a webpage to microsoft word converter. Is a little project Im trying to finish. Started time ago, found it now but dont know how to do it. can you help me?

Member Avatar for mridul.ahuja
0
128
Member Avatar for Brian_15

i am failing to link v.b 6.1 program and database. it keeps posting the error "syntax error in FROM clause". how do i make it work because its the forth time i have restarted the project

Member Avatar for jhai_salvador
0
166
Member Avatar for Aziz_1

Well i'm trying to create a form in VB6 to control my database that was created by access, i did everything and everything went perfect,until i notice that if you enter the same "ID" i get an erreur from access that there is multiple Ids with the same number,since i …

Member Avatar for matoo
0
654
Member Avatar for Abu Thahir

My project have invoice no.I want to run the invoice no.in Auto Number.please help with the right code.

Member Avatar for matoo
0
527
Member Avatar for dahiya309

hi .. i am facing the problem during barcode reading from the barcode scanner. i am using the below mention code: Private Sub txtMessage_Change() If Len(txtMessage.Text) > 4 and Len(txtMessage.Text) < 13 Then txtMessage.SelStart = Len(txtMessage) in this code it accepts only 5 digit barcode value. veena madam kindly help …

Member Avatar for jhai_salvador
0
170
Member Avatar for somusas

i want a macro which can find the "$" select all the data and copy it to the next sheet The dollar symbols are dynamic so 1st and 4th dollar symbol will be copied sheet 1, data between 4th and 5th will be copied to sheet2,data between 2nd and 3rd …

0
130
Member Avatar for wargamer2004

Hello, I was offer a project to record Loan of equipment using a keyboard wedge Barcode scanner to scan ID barcode from the Equipment, But i had a hard time control the textBox of the Form for the barcode input, the Input keep jumping away from the textbox that set …

Member Avatar for dahiya309
0
1K
Member Avatar for Vidhi.Sharm

Hello, I am developing a system where in I want to use 2 USB Barcode Readers attached to a single PC. I want to capture input from both of the readers. When barcode is showed against a barcode reader, I want to store that value in a variable and then …

Member Avatar for dahiya309
0
1K
Member Avatar for milon.mahbub.1
Member Avatar for Da_Noles

Hi all, I am trying to create a script that I can run and edit a user's settings on their excel. IE: the script will edit the user's options by enabling macros and adding in the add-on. Anyone ever work on something like this?

0
98
Member Avatar for Saas2015
Member Avatar for djjeavons
0
52
Member Avatar for Yugavashini

Hi, I need to validate a text input with the rest of the data inside excel file. The following is my code. It just read the text input and only execute data in row 1 only instead of searching other model's data. Any suggestion where did the code goes wrong? …

Member Avatar for Yugavashini
0
452
Member Avatar for paul1145

I would like to assign a CTRL Q shortcut to the Quit submenuitem (filesubitem1) but can't find the right syntax. Any assistance will be greatly appreciated. Thank you. If user_wants_file_menu = True Then Dim fileItem As ToolStripMenuItem = New ToolStripMenuItem("File") Dim filesubitem1 As ToolStripMenuItem = New ToolStripMenuItem("Quit") filesubitem1.ShowShortcutKeys = True …

Member Avatar for djjeavons
0
563
Member Avatar for Nathan1

I'm sure there is a really simple solution for this matter, but I have tried all I know without success. I'm trying to modify this working SQL string to yield only the Top 25 results, not all results. "SELECT * FROM" & "data.CSV" & "ORDER BY " & "Elapsed" & …

Member Avatar for Nathan1
0
197
Member Avatar for Muhammad_85

i am newer in visual basic 6 face some problem in crystal reporting. set oapp = new craxddrt.application set oreport = oapp.openreport(app.path & "c"\abc\report.rpt",1) oreport .databse.setdatasource rs,3,1 crviewer1.reportsource = oreport crview1.viewreport run time error appear '-2147206460(80043ac4) invalid directory but directory & file available in path what can i do..

Member Avatar for djjeavons
0
226
Member Avatar for Sicelo

HOW TO CODE FOR A SAVE,DELETE,EXIT BUTTONS IN VISUAL C++? PLZ HELP ME I REALLY WANT TO KNOW THIS PROGRAMMING LANGUAGE

Member Avatar for basit_3
0
69
Member Avatar for boblite2

I found that the following shell code worked for producing a list of all files in the directory and subdirectories of a program I am working on. The basic lesson I learned is not to try shelling out of VB6 to invoke a batch file containing a list of DOS …

0
112
Member Avatar for shimaibrahim

hi. Experts I'm developing a monitoring student in and out of residential college using RFID My problem is i can scan the RFID tag but i did not know how to save it into database access. here is the code i found on internet to connect detect rfid tag no …

Member Avatar for djjeavons
0
517
Member Avatar for weekendrockstar

I am brand new to Visual Studio so please forgive my current lack of knowledge but I've tried searching everywhere for this and am relatively surprised that I couldn't find something about this elsewhere. I am using a currently using an Openfiledialogue with multi-file selection allowed. It then adds the …

Member Avatar for Santanu.Das
0
424
Member Avatar for S-e-c-r-e-t

PLZ Don't make mistake about what i'm writing & if u dont understand dont answer plz. I need just a digital clock in C++ with gotoxy &print"****" &... i want to find the difference between this one & the others completely no different if any one just wrote with gotoxy …

Member Avatar for ddanbe
0
605
Member Avatar for basit_3

i want to get input from a textbox in visual c++ 2010 window form application i try this but it not work private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { std::string m; m==textBox1->Text; MessageBox::Show("developed by basit "); } }; help me plzz

Member Avatar for ddanbe
0
247
Member Avatar for carall

hi, i need some help! based on the image attached: I need to concatenate from APPLE to the last column in its row and down all the rows and columns UNTIL It sees APPLE again. My problem is that I am being able to concatenate but only the first row …

Member Avatar for carall
0
127
Member Avatar for Abdullahi_1

private void Form1_Closed(object sender, System.EventArgs e) { // Create a PDF document object PDFDocument doc = new PDFDocument(); // Creates a PDF page PDFPage page = new PDFPage(this.Width, this.Heigh,PDFMeasurementUnit.Points); page.MeasurementUnit = PDFMeasurementUnit.Points; // Parses controls on the form for (int i = 0; i < this.Controls.Count; i++) { Label label …

Member Avatar for JerrimePatient
-1
437
Member Avatar for Jano_1

Hi guys, as title says, i need to find first column with empty cell in every thrid row in my sheet. it looks like this ----------- --------- ------- ------ I need to write at each (third) row, new data from other sheet. that part of code is ok, i checked …

0
77
Member Avatar for webber2015

Hello, we have to create a football scoreboard in Visual Basic. Purpose: The application calculates the points scored during a football game by one team Requirements: 1. The user clicks the enter score button in an input box object to enter a score after the football team scores 1. Each …

Member Avatar for hericles
0
505
Member Avatar for webber2015

Little League Batting Average Windows Application: Finds the avg batting average of the starting line-up of nine little league baseball players. The user enters the present batting avg of each of the nine players to compute the team batting avg. 1.The user clicks the Enter Batting Averages button to enter …

Member Avatar for Reverend Jim
0
491
Member Avatar for Member #579261

Hi guys, I need help with some homework... hopefully this is the right forum. So my last project assignment is making a shopping cart and having the user add, remove items therefrom. I am having a problem adjusting the totals after the items get removed from the cart: Using Lists …

Member Avatar for Member #579261
0
743
Member Avatar for Abu Thahir

Hi iam new joined.And i started a retail store.I prepared a visual basic project. It will be good but I want to do it with print a Sales bill and product's barcode.please give me a right code.

Member Avatar for ddanbe
0
91
Member Avatar for marktwo

Hi, When I run it Dim A As Single A = 12.345 Debug.Print Round(12.345, 2) Debug.Print Round(A, 2) I got different results: 12.34 12.35 Can you tell me why?

Member Avatar for Reverend Jim
0
240
Member Avatar for bthorat22

I want to reload my form in Vb6 without closing it. I am sending a data through serial comm and receiving it. Now i want the repeat the procedure again without closing the Form. The problem is , I don't want to unload the form.It should get reloaded automatically

Member Avatar for bthorat22
0
4K
Member Avatar for Ishmam

i need to find the number of occurences of a specific word in a text but I don't know what to do. I've got the part where it searches and higlights the words but not how to count them, please help.

Member Avatar for ddanbe
0
114
Member Avatar for hiteshkumar_P

Public Class Form1 Private Function getCrc16(b() As Byte, nLen As Integer) As UInt16 {&H0, &H1189, &H2312, &H329B, &H4624, &H57AD, &H6536, &H74BF, _ &H8C48, &H9DC1, &HAF5A, &HBED3, &HCA6C, &HDBE5, &HE97E, &HF8F7, _ &H1081, &H108, &H3393, &H221A, &H56A5, &H472C, &H75B7, &H643E, _ &H9CC9, &H8D40, &HBFDB, &HAE52, &HDAED, &HCB64, &HF9FF, &HE876, _ &H2102, …

Member Avatar for hiteshkumar_P
0
528
Member Avatar for luckynisarg

i want to design a software for a robot. i want to use the arrow keys of keyboard to direct the robot. can any one tell me that how can i do coding of that?

Member Avatar for Sohail_4
0
2K
Member Avatar for Sarwat Zodiac

How can I take a copy of the text inside listbox to Excel Sheet or Word Page ? Thank you

0
120
Member Avatar for altjen

Im designing a app that after press a button textblock1.text goes with "YES" if press an other it goes "NO" how to make it save that text when close the app and show the some text when app load? and on visual basic

Member Avatar for DaveAmour
0
129
Member Avatar for krunal1986

Hello Everyone, is it possible to create excel file without excel installed on machine in vb6 code? is there any code, dll, link is available? Thanks.

Member Avatar for cuzintone
0
98
Member Avatar for Xiao_1

how do i record the the time to the access database on VB with the date when register in Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick lbltime.Text = "Time:" + TimeString End Sub End Class

Member Avatar for cuzintone
0
103
Member Avatar for tyronemiranda

Good Day! I would like to ask for any idea on how to record the time log using recordset. Can you please give me some ideas on how to do it? BTW im using vb 6.0 and access03 for my sources. my fields are EmployeeNo. EmployeeName. TimeIn. TimeOut. TimeIn(2). TimeOut(2) …

Member Avatar for cuzintone
0
127
Member Avatar for johans22

I am very new to vb6.0. I got these questions: in vba 6.0, how to check if time is between today 6:00 PM and next day 6:00 AM then do something. in vba 6.0, how to check if time is between today 1:00 AM and 6:00 AM then do something. …

Member Avatar for mlesniak
0
133
Member Avatar for Tomaž

I am computer technitian. Unfortunately deteriorating economic conditions prevent me from finding an employment that matches my education and I also am unable to afford any formal education, but I digress. I have mentioned my education to clarify that I already have some knowledge with programming languages forehand, however these …

0
123
Member Avatar for Linh_1

can someone show me how to do this please? I am new to programming languge? here is the requirement? Thanks. Create a database table with 10 records with the following fields: Lastname, FirstName, Phone Number, Street Address, City, State, Zipcode. The table name is: “User Info”. Please create the table …

Member Avatar for Aslam Mansoor
0
367
Member Avatar for Madhu_5

Plz tell step step procedure to play music in my Microsoft visual studio 2005 for my opengl projects

Member Avatar for djjeavons
0
235
Member Avatar for djjeavons

This snippet demonstrates how you can add VBA code to an Excel file at run time. **Prerequisites** In this snippet I am using Microsoft Excel 2013 with the Microsoft Excel 15.0 object library. Before you can use this code, you will have to change a setting within Microsoft Excel to …

0
2K
Member Avatar for ranilxmie

hi.. I want to create a similar loop, but what is need is to copy a range of data (example from A1:A10) for about 5 times. meaning, 1st copy, A1:A10 in B1:10, then copy A1:A10 again in B11:B20 and so on for 5 times.. any expert advise pls ?

0
119
Member Avatar for krish_1

Hi Dan, i am looking for something where i click on the button and the excel sheet opens. i have created buttons on the VB excel but i am looking for the coding about how should i link the excel sheet with the command button? please can you help? regards, …

Member Avatar for DaveAmour
0
213
Member Avatar for Mahantesh_1

Count Equal Numbers in Text box How ? Hey guys, I want to Know is there any way to Count Similar Numbers which entered in single textbox in VB6 as a example; i have textbox named txt1 in that user can type any value (2,12,23,2,34,12,2,2,23,54,12....) (separate the values by adding …

Member Avatar for Reverend Jim
0
387
Member Avatar for lyca

Please help me in solving this error of my project. This error appear when i enter this character [ it shows me that i enter an invalid string. where particularly is the error? does it concern with the keyascci? thanks for ur help.

Member Avatar for Minimalist
0
389

The End.