vba x 200

12,155 Topics

Member Avatar for
Member Avatar for sean.downes.96

Hi, im using Visual Basic 2010, I don't have any sort of database i.e. from Access or anything im literally using VB and thats it. I want to create an automated reference number for my system so every time the user press's 'Create New Log' the form opens and it …

Member Avatar for Reverend Jim
0
219
Member Avatar for siddd

how do i import my externanal contact in my ms outlook by using classic asp vb script programatically

0
52
Member Avatar for thiemebr

Anyone has any idea why this error is happening? The weird thing is that this page works in one server but not in another. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about …

Member Avatar for thiemebr
0
527
Member Avatar for nquadr

# What's wrong with this code? # Hi I have defined wb1 as a Workbook. I am trying to run this code `wb1.ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Select` It is supposed to select the last row in a cell, however it gives me an error Run-time error '1004' Application-defined or object-defined error. I am …

Member Avatar for samsylvestertty
0
120
Member Avatar for Techiz123

I want to Inject Scripts inside VBScript.dll site, so that the scripts are available to different COM interface which have implemented the Windows Script Interfaces(or Active Script Interfaces). Thanks

0
66
Member Avatar for tikoti

Hi all, I am currently trying to remove the zeros from a string the code I have tried is as follows but it does not seem to work propperly Dim code code=request("code") 'here there is a string like 0000045 ' I want to remove the zeros Dim c1 c1 = …

Member Avatar for SudoWin
0
305
Member Avatar for shahriar2403

How can i open acces file using a command button in vb. What should b da reference? what should b da code? Same question for opening pdf file. help me plz.

Member Avatar for sridinesh
1
409
Member Avatar for Member #893201

Does anyone know how to use icacls in .vbs? With variables for the directory and the user?

Member Avatar for SudoWin
0
122
Member Avatar for me_coolvibes

Hi, I need to use MATLAB for some statistical analysis in my VB application.Is it possible to call MATLAB functions in VB6. And if possible...then how is it to be done? Thanks!

Member Avatar for SudoWin
0
82
Member Avatar for Siberian

Anyone fimilar with VB scripting with Windows Task Scheduler ? I'm hoping someone can create a custom script when my task is executed. At present, my task runs the program, that's all it does.

Member Avatar for Siberian
0
114
Member Avatar for harsh01ajmera

How to create a website which i want to create by using a vb srcipt and also i want to make a use of java script in this.pls help me out..give me suggestions regarding this.

Member Avatar for madelinekim
0
130
Member Avatar for PinoyDev

Good day Gentl'men! I just need a little help for date manipulation.here is the criteria.. I have **two date picker, dtfrom.value & dt2.value, and a variable called "viewtype".. ** **if viewtype="monthly"**, I want to create a listview column base on fromdate.value & todate.value..Example, if **fromdate.value="12/24/2012" and to.value="06/31/2013"**, I want to …

Member Avatar for PinoyDev
-1
215
Member Avatar for johndmingione

Dear Reader, I would like to be educated on how to open an Excel Worksheet within a VSFlexGrid OR MSFlexGrid. The reason I give both as an option is because I want to explore which option is best, so if you have input on the Pros and Cons of using …

0
168
Member Avatar for elico

Hi all Is VB6 a good tool for developning database apps for the XP and beyond OS ? I am especially intrested in sma; datyabases like coin collectors databases . Thanks Elico

Member Avatar for madelinekim
0
109
Member Avatar for PM312

i have programe where i use serial number for each document number. now i want to start serial number with one againe in new financial year, but restarting number with one result in duplication of reference number in database. how to get this.

Member Avatar for PM312
0
164
Member Avatar for Skate Bart

Okay, so here's my problem. I have a MS Hierarchical Flex Gird Control [fgdCompany] which is used to display records that are taken from a database. Everything works great but not the Delete button. What the delete button is supposed to do is when a record is selected in fgdCompany, …

Member Avatar for Skate Bart
0
245
Member Avatar for Skate Bart

hey there, Here's my complete code for a delete button that deletes a record in a Heirachical Flex Grid. Dim rsTour As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & App.Path & "\Luckshan Tours & Travels.mdb;" & _ "Persist …

Member Avatar for Skate Bart
0
424
Member Avatar for newbie26

hi.. im trying to export crystal report to excel. the export toolbar already appears.the crsytal report viewer is working properly.i can generate the report i want. but when i opened the excel file being exported,it shows blank worksheet, no data is being displayed.even headers and footers. im using cr 8 …

Member Avatar for hemant3080
0
71
Member Avatar for hassan980

Hello, Im trying to design a module in which, using an equation, x and y coordinates are found and i want to display them in a list box. The general idea in my mind is that the program asks the user to enter the length and number of divisions (lets …

Member Avatar for hassan980
0
245
Member Avatar for zilonox

I have a DataGridView that is attached to a BindingSource that gets data from a SQL Server database. I can populate the DataGridView without a problem. I can even insert/update it without issue if I run the update code from a click event of a button. But where I run …

Member Avatar for zilonox
0
1K
Member Avatar for me_coolvibes

Hi, I am working on a project in VB6 and trying to call the objects of the statistical language R from my application. I have installed the R(D)COM server which is required for the purpose. My application can serve as a COM client and I can then work with the …

0
65
Member Avatar for Nole_diver

I am trying to created a comparison script to compare 2 dynamic arrays and then input a into a cell. So i would pull from column D and E and put information from Column F with a number added onto it. So the example of my process is: Load column …

Member Avatar for Stuugie
0
165
Member Avatar for Pilot122x

Help me please my name is micheal Minner and I am a flight simulator enthusiast and I am attempting to put together a little progran but I need your help its just three questions and all three I wouldn't consider advanced Briefing: I have a login screen connected to a …

0
64
Member Avatar for SudoWin

Hi guys so here is the deal. I am writing a small VB program that will shell CMD and run a command. The problem is that the program being called in CMD needs some enviroment variables. I have set these and they are showing up correctly if I open CMD …

Member Avatar for SudoWin
0
444
Member Avatar for zilonox

Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to …

Member Avatar for zilonox
0
2K
Member Avatar for ranjitgupta
Member Avatar for firdousahmad
0
140
Member Avatar for sgunnery

Hi Guys [B]I must ask everyone bear with me regarding my idea it needs a bit of explaining before it makes sense[/B] to start this is totally a project in my own time for my own learning and development in programming it is being done for my employer but I …

Member Avatar for sgunnery
0
218
Member Avatar for pandeysk_13

hello world, i am trying this from last 2 days but unsuccessful . i am trying to make a project in visual basic 2010 which is connected with ms access 2010 database. the database having 4 tables i.e. tblsession, tblcourse, tbllevel, tblstudentregistration. tblsession data: column name column data sessionID -- …

Member Avatar for G_Waddell
0
730
Member Avatar for ulrichrandom

how do i freeze a form? scenario: i'm working currently on a form (running program). i'll click a button which will direct me to another form. input info and then back to the previous form. So, how do i freeze the previous form without using unload, and the data in …

Member Avatar for jhai_salvador
0
170
Member Avatar for super-duper

Hey, everyone. I am writing a batch script (.bat program) to automate some tasks. And when that certain task is complete, I would like it to send an email to the admin saying if the task was completed successfully or it failed. It will figure out if the task was …

Member Avatar for Habitual
0
179
Member Avatar for riztra

I created a simple program for animation direction in visual basic. but as I can is clockwise. then how do I make it in the counter clockwise ? this my listing program : Private Sub Command3_Click() 'animasi searah jarum jam Cls Form1.DrawWidth = 30 For i = 1 To 5 …

Member Avatar for Nitesh Katia
1
250
Member Avatar for super-duper

Hey everyone, I am working on this huge excel sheet, actually 2-3 sheets. I am trying to make a master list of everything. Let's say Sheet-1 has columns "Name", "Description". I have to go and look at the "Name" column, copy the row under "Description" column, and put it under …

0
84
Member Avatar for rokokmalboro

Hello all programmers .... need some tips which i have some issue down here... I got test the (sql1) and then the result for the records is zero (0) ...when it's run for "check manager gender" , the error appears... give me some help and i will owe u guyz …

Member Avatar for samsylvestertty
0
139
Member Avatar for anoojmutt

I am having trouble creating a program that finds the maximum number out of an input set of numbers. Any help?

Member Avatar for samsylvestertty
0
129
Member Avatar for Staples1311

I am creating a project for school that I have a database in in and it will give you a list of the top 5 most fuel efficent cars per class. So I have all the database done now I just need examples for coding. I have check circles (sory …

0
75
Member Avatar for ShaggyDogg

I would apprecaite any assistance with this task.. SourceForm.aspx contains a databound gridview which I have added a checkbox column for multiple row selection. OnClick of a button I want to display any selected rows on another page, Target.aspx So far I have successfully captured textbox input properites using PostBackUrl …

Member Avatar for kvprajapati
0
937
Member Avatar for Maj.Clac
Member Avatar for debasisdas
0
170
Member Avatar for PinoyDev

Good day g'Men! I just needs some advise or code about positioning the recorset after requery! I have 20 records in a table, I am on record no 10 and deleted it and pull movenext. The record to be view is record no 11. but a get the last record …

Member Avatar for PinoyDev
0
433
Member Avatar for jamesbeat64

Hello Forum Members, I am fairly new to programming in general and am just learning VBA for Excel and Access. I currently have a work project that involves producing a SQL query from our internal database system based on VBA procedures in an Excel template. Most of the code was …

Member Avatar for adam_k
0
476
Member Avatar for Mike Bishop

I have the following code Dim adoCN As ADODB.Connection Dim sConnString As String Dim sSQL As String Dim lRow As Long, lCol As Long sConnString = "Provider=sqloledb;Server=MonsterSQ1;Database=AmiCatSQL;User Id=SA;Password=123456" Set adoCN = CreateObject("ADODB.Connection") adoCN.Open sConnString 'Assumes that you have Field1, Field2 and Field3 in columns A, B and C 'For this …

Member Avatar for QVeen72
0
141
Member Avatar for sanket044

i have binded one textbox at design time to adodc control... and haveing one number field in database... now problem is that, if their is a blank value in database adodc is showing 0 in that field.. can anyone help me, i want to show it as blank if it …

Member Avatar for AndreRet
0
112
Member Avatar for lbgladson

I am in a capstone programming class where I have to create my own program. The instructor is not giving us any help and told us it was our responsibility to find our own help in creating this program. What I want to do is have the user click on …

Member Avatar for AndreRet
0
116
Member Avatar for technogeek_42

i had a problem how can i download music to my project and what is that command and who can give me a sample of a project that is like a media player or mp3 player. thnx to all

Member Avatar for AndreRet
0
3K
Member Avatar for brainthomas33

I am struggling to do a project in Visual Basic 2010, I need to make a replication of the New Years Eve ball droping in New York City. The balls has to drop for 30 seconds and can be stoped at any time, it also must include a timer starting …

Member Avatar for Doogledude123
0
175
Member Avatar for abu taher
Member Avatar for Doogledude123
0
78
Member Avatar for mandar2886

I'm developing a medical software & I want to make an exe of this project. Pls tell me how to proceed. I have no idea about this

Member Avatar for IconKana
-2
317
Member Avatar for idomarko

hey! i need a quick answer.... how can i move the letters so that they will start from right to left and ***not*** from left to right? i writing in hebrew and i looks weird if it start from left to write! for example: that how it should start: שלום …

Member Avatar for ChrisPadgham
0
341
Member Avatar for nquadr

# Excel VBA Lookup Help # Hi I am having trouble with my VBA Lookup function. I have created 2 workbooks which I have instantiated to wbOld and wbNew. I am taking a column from wbOld and comparing with a range in wbNew. I want it to return the second …

Member Avatar for nquadr
0
144
Member Avatar for pandeysk_13

**hello all, i am creating a programme for my institute which helps in their administrative process. i am using visual studio(basic) 2010. which is connected with ms access database (abcdata.accdb) the database is having table called session with columns sessionID,sessioncode,sessionname. * sessionID data = 1,2,3,4 * sessioncode data = 13,14,15,16 …

Member Avatar for pandeysk_13
0
230
Member Avatar for sanket044

I have created one report in crystal report... i want to filter that report in vb6 with different conditions... i have created selection formula, like, str = "isnull({Prescriptions.RecDateR})" Report.RecordSelectionFormula = str but while running this it gives error that " SERVER HAS NOT YET BEEN OPNED"... if i remove the …

Member Avatar for sanket044
0
133

The End.