vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Member #506491

I am developing an inventory application. There is a form named frmInventory where material receipt has been done. Logic The logic is that First you Enter the Transaction no. in text box named TxtChalanNo Then a combobox named cmbval on flexgrid named mf1 will got focus then the user select …

Member Avatar for Member #506491
0
362
Member Avatar for kylix_jin

Good day Sir/Maam.. im new here. i have a project in MS Access 2003 that will tanslate numbers into words... is there a code using Asc? to this program... im sorry im newbie in programming.. thanks a lot..

Member Avatar for AndreRet
0
149
Member Avatar for abu taher

in a textbox I write 100000. I want another text show automatically "one lac". I mean it aumatically show the in word of that numeric number what I write. how it possible.

Member Avatar for debasisdas
0
431
Member Avatar for klegrand

I want to change to setting 'Deny access to this computer from the network'. This is under Local Security Settings. I need to remove the guest account from the list. Is this setting stored in the registry and can it be modified with VB script ? Thx, kurt

Member Avatar for klegrand
0
87
Member Avatar for ShadowScripter

I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how …

Member Avatar for ShadowScripter
0
398
Member Avatar for dibakarmishra

How to Covert a long name to short name??? for example: How to convert Visual Basic name into VB

Member Avatar for Pgmer
0
91
Member Avatar for prajana

Hi. Can anyone help me with this code? I have a form which takes subject name, semester and class. I put this data in a database tables using 2 ADODC’s and the connections are as follows: ADODC3- LecturesAttended (StudentID, RollNo, Name, SubjectName) ADODC4- Student (StudentID, RollNo, Name,Class) I take studentid,rollno,name …

Member Avatar for AndreRet
0
144
Member Avatar for RobinTheHood

Hi All, I'm trying to disply the last part of a hyperlink using the expression builder in access 2010 textbox. eg. #\\abc.org.uk\Root\OurSrevice\OurTeam\Peter\Dump\MyDoc.doc# #\\abc.org.uk\OurSrevice\Team2\Folder2\YetAnotherFlder\Dump\View\MyOtherDoc.doc# In the first example I want to display MyDoc.doc In the second example I want to display MyOtherDoc.doc I suspect I'll need to use the RIGHT and …

Member Avatar for debasisdas
0
133
Member Avatar for saratogacoach

Hi, I am a newbie (retired social worker) using Visual Basic 2010 Express edition and need some help with an animation for an eLearning lesson. The animation illustrates a type of white noise (like TV static) called dynamic visual noise. I've got much of the code worked out (with a …

0
64
Member Avatar for prajana

Hey!! I need help! My project in vb isn't opening! When trying to open my project its saying it is in binary format and cannot be loaded in VB6!!! I don't have backup of the changes i made today..!! Please help me! It happened due to power failure. But my …

Member Avatar for gooptek
0
128
Member Avatar for Swoop_GB

I need to be able to check if another user has an excel workbook open (from a network drive) from within another workbook. user 1 has workbook1 open and has a macro to open workbook2, paste some data in, save it and close it, I need to add code to …

Member Avatar for Swoop_GB
0
169
Member Avatar for MrConfused

I have VB 5 learning edition which has suited me fine thus far believe it or not! One thing has really been annoying me for quite some time. I can't find how to set the command buttons forecolor (at least with the VB version I have). Backcolor is no problem, …

Member Avatar for danomac
0
965
Member Avatar for bro3886

i want to develop a program using vb to lock the wondows which needs a user id and a password to logon. the user ids and passwords will be stored in a server machine's database. the clients requires the user id and password to logon the client m/c. so i …

Member Avatar for AndreRet
0
273
Member Avatar for Noorul Ariff

Dear friends... I need a urgent HELP... I applied for a job... They asked me to do a PROJECT, vb with access... In that they asked me to create INSTALLER file with 32bit & 64 bit support. I don't know how to do this... i have to finish it and …

Member Avatar for AndreRet
-1
437
Member Avatar for Smithers

What is the fasted way to delete rows based on a condition in Column A using VBA? Anybody have an example? Thanks.

Member Avatar for Smithers
0
167
Member Avatar for JD69

Hi im trying to write a program to automate a process but i cant get my program to click on this website's button Here's the website's button code: [CODE]<input type="button" class="w10pt" style="width:136px;display:block;font-weight:700;" value="Login" onclick="location.href='/start/login.htm?arg1=1'">[/CODE] i tried: [CODE] theElementCollection = WebBrowser1.Document.GetElementsByTagName("input") For Each curElement As HtmlElement In theElementCollection If curElement.GetAttribute("value").Equals("Login") Then …

Member Avatar for AndreRet
0
91
Member Avatar for blueciel

please help me. anyone know a way to make words from numbers in Access or VB? > Example: 45 = forty five > Example: 167 = one hundred sixty seven > > I would like to have a program that reads the number and turns it into words. I have …

Member Avatar for AndreRet
0
157
Member Avatar for ammwebmaster2

I don't understand why this is happening or how to explain it but here goes: I have an asp page that uses lots of layers and in Mozilla when I click on a link it is supposed to bring up and image and slide it into position. But when I …

Member Avatar for ArtistScope
0
108
Member Avatar for stimp80

I'm working on a Windows Form Application in Visual Studio 2010. I have a Database that I am using to pull data to dynamically create checkboxes inside a loop. In between each of these, I'm creating a child loop to create more checkboxes from a sorted DataSet. At the end …

0
60
Member Avatar for skalra63

i am currently using the following code so that when the cursor is over an object, it displays a description. [CODE]Private Sub txtSearchbox_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) frmeObjectDescription.Visible = True lblSearchCriteria.Visible = True End Sub[/CODE] however, i dont know how to make it …

Member Avatar for AndreRet
0
146
Member Avatar for jeffrey4u

My chat application have icon at the taskbar which displays messages as balloon text for the user when the application is minimized. My problem is when the message contain smiley or emotion like this ':D:D:)' the smiley does not display in the balloon text. Any help on how to add …

Member Avatar for AndreRet
0
187
Member Avatar for hajjo

[CODE]Imports System Imports System.Drawing Imports System.Windows.Forms Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub End Class[/CODE] Hello, I have a textbox and I have a button. Okey, when the button is clicked I want my mouse to go and click a …

Member Avatar for josephbeluan
0
974
Member Avatar for JCWatson

Hello, I am new to daniweb. I am a student in my first coding class and I am stuck trying to figure out one of my projects. My teacher wants me to have a text box that you can type a number in, then add it to a list box …

Member Avatar for debasisdas
0
122
Member Avatar for hoong

hello all, i need some help on writing VB6 code to access to a modem API in order to grab the data such as RSSI etc....your concern on this matter is sincerely appreciated, thanks in advance

0
58
Member Avatar for frankge973

My program uses MS Access as DB and Visual Basic 6. I've experienced an issue loading a recordset with about 300000 records, some fields indexed, when I place a SELECT SELECT * from Materials m INNER JOIN Quantity s ON m.code=s.materialcode ORDER BY code in a ADO recordset with the …

Member Avatar for frankge973
0
1K
Member Avatar for mugged ur mom

Hey guys I’m trying to export data from a access form into an excel sheet when it is clicked by a particular button... but the VB code I’m using for the button will not work. Here is my current code: Private Sub Command12_Click() DoCmd.OutputTo acOutputForm, "frmExport", acFormatXLSX, "h:\mydocu~1\exports\F_assignments.xlsx", True End …

Member Avatar for AndreRet
0
514
Member Avatar for Shodow

invalid use of property [CODE] Dim search As String search = Trim(txtSearch.Text) Select Case cmbSearch Case "By: Customer Name": Call DataGrid("select * from list1 where CustomerName like '" & search & "%'") Case "By: Date": Call DataGrid("select * from list1 where Date like '" & search & "%'") Case "By: …

Member Avatar for AndreRet
0
237
Member Avatar for obicerno

hello guys, can any one know how to extract an amount for an instance.. this was in access data. i just picking up some sample.. a given amount to be extracted was 50,000.00 kilos i have to table 1 is the master and the other was the list of pickup …

Member Avatar for AndreRet
0
107
Member Avatar for junjun61991
Member Avatar for debasisdas
0
155
Member Avatar for Jade_me
Member Avatar for AndreRet
0
324
Member Avatar for obicerno
Member Avatar for AndreRet
0
105
Member Avatar for freedom-impulse

im having a problem in connecting data access with vb 6 enterprise edition i dont know how to connect trough ADO

Member Avatar for AndreRet
0
115
Member Avatar for jeffrey4u

I have chat application which am using webbrowser to display the chat session. I want to give the user the chance to save the chat session so i used the codes below which is working fine but i have realised is that when the webbrowser contain smiley or emotions it …

Member Avatar for AndreRet
0
160
Member Avatar for danattheville

I am trying to write a program that will allow a user to use a button to toggle the color or the text in a text box between blue and green. Any ideas? Here is what I have so far: [Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar for danattheville
0
155
Member Avatar for VasquezPL

Hi...I have a problem.. I need a function which is able to remove a word from string and replace it with other word (string).. I have nice working function in pure c++ but I dunno how to do that in visual c++ ;( 10x for help! [code] void FindAndReplace( std::string& …

Member Avatar for VasquezPL
0
199
Member Avatar for Martje

I have been trying to capture the enter key in a windows.net textbox but i have no idea how to do it, i googled searched but the only examples i find are visualbasic and c# ones and when i try to do thesame thing in c++ in doesnt work. I …

Member Avatar for Martje
0
502
Member Avatar for lakewriter

Greetings, I'm new here, and as mentioned, I'm starting to learn to work in FLASH. My background is VB6. I'm mainly using books to learn FLASH, but would love to occasionally have someone live to glance at what I've created, and point out what would work better, or have I …

Member Avatar for AndreRet
0
247
Member Avatar for bjc01010

Ok fairly new to this but the programming i am doing is for a "price list" of sorts, i have 3 buttons with 3 labels which work fine showing the label text when pressed, next i have a group box with one button, 2 radio buttons, and 2 labels, I …

Member Avatar for AndreRet
0
210
Member Avatar for zp18zp18

<sorry for thread hijack> My vb6 application opens the access data base with the vb6 database name property of the Data1 control. How can I change this to open with explicit coding in the vb coding so I can change the path in a single location?

Member Avatar for AndreRet
0
68
Member Avatar for MooGeek
Member Avatar for pmark019

What is wrong with this code of mine? [CODE]Private Sub btnPlus_Click() If counter = 0 Then savedNumber = Val(txtNumber) counter = 1 End If If counter <> 0 Then value = Val(txtNumber) End Sub[/CODE] [CODE]Private Sub btnEquals_Click() result = Val(savedNumber) + Val(value) txtNumber.Text = CStr(result) End Sub[/CODE] [CODE]Private Sub btnThree_Click() …

Member Avatar for AndreRet
0
110
Member Avatar for eukiandfhull

Hi, i have a problem in my database. how to sum the value of row into another value of row?.. i want to compute the total of Hoursworked.... this is my example table for the sum of row by row.. DTR Table EmpID TimeIn TimeOut HoursWorked Date 1 08:30 05:30 …

Member Avatar for eukiandfhull
0
96
Member Avatar for eclipse2012

Hi, I am a newbie to Visual C++ programming. I already have a code which I edited for my purpose. It is as below. [CODE]#include <stdafx.h> #include <stdio.h> #include <stdlib.h> #include <math.h> #include <string.h> #define FIL_LINES 17873 /* no. of lines in input datafile */ double t[FIL_LINES]; double x[FIL_LINES],y[FIL_LINES],z[FIL_LINES]; double …

Member Avatar for hag++
0
4K
Member Avatar for Shodow
Member Avatar for nickcoons

One of my clients has a software package that they use called Prelien2Lien, which has several thousand document templates. They'd like to be able to also use these templates outside of the software, but I haven't had any luck determining what file type they are. Ideally, I'd like to be …

Member Avatar for nickcoons
0
129
Member Avatar for neosonic

Hi, I have a vb6 program who access an 97 access database. everything works fine when I put the database files into the shared harddrive (we put it as Z:\) It is running very very slow... I dunno why is it happening, it works really fine if I put them …

Member Avatar for AndreRet
0
151
Member Avatar for aman rathi

first of all thanks to all for helping me from last 2 years. now a days i am learning Visual basic, i have one book that is for beginner. while studying that book i feel it is insufficient for me. so please can any one tell me a book which …

Member Avatar for debasisdas
1
118
Member Avatar for billly

hey everyone im a bit of a noob with programing because im only 16 so can you please explain your reply simply. im trying to make a batch file that asks for a password and opens a file and if the password is wrong displays a message i know how …

Member Avatar for sandeepparekh9
0
187
Member Avatar for dnk

how to clear all text box?? i always use this : [CODE]text1.text = "" text2.text = "" text3.text = "" ....[/CODE] but how about if i have many text box? there are an other way to do this??? Please help. ASAP. best regards

Member Avatar for the_h
0
123
Member Avatar for JD69

I have 1 form with the progress bar and 4 buttons with the following code. I would like to create another form that shows the same progress bar with the same progress. Please help Here's my code for progress bar [B]form load code is:[/B] [code] ProgressBar1.Minimum = 0 ProgressBar1.Maximum = …

Member Avatar for codeorder
0
173

The End.