vba x 200

12,155 Topics

Member Avatar for
Member Avatar for zebnoon

I have prob. with my printer my printer is Mini Dot Impact Matrix Printer. model AB 300 Kc. how to setting paper for this printer?

0
87
Member Avatar for agent_x

Hi, i really need help making this program: Write a program that will ask a teacher to enter his 4 digit password. The program gives three tries for the password. If the teacher fails in three tries, the program displays the message, “you are not eligible to enter the grades”. …

Member Avatar for debasisdas
0
210
Member Avatar for saddas

just wondering if there was any way to disable some values in the combobox or at least grey them out. i populate the combo box from the database: rs.MoveLast With Me.Combo1 .Clear Do .AddItem rs.Fields("CustomerFirstName") rs.MoveNext Loop Until rs.EOF End With once one value has been selected, is there a …

Member Avatar for htmlCoder101
0
108
Member Avatar for StephNicolaou

Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things …

Member Avatar for StephNicolaou
0
939
Member Avatar for Sturdy

Hi masters, I try to write and read file into txt file but i dont know how to do it. Anyone know how to achieve this? Please help me. any help will appreciated much. Best Regards

Member Avatar for Jx_Man
0
309
Member Avatar for telkomek

I put this code to button_event: [CODE]01 On Error GoTo ErrT 02 If mValidateControl.Validate(txtKode0, txtKode0.Text <> "") = True Then 03 MsgBox "Kode Bahasa belum diisi" 04 Else 05 Rs.MoveFirst 06 If Not (Rs.EOF = True And Rs.EOF = True) Then 07 While Not Rs.EOF 08 If Rs("kdBhs") = txtKode0.Text …

Member Avatar for Jx_Man
0
218
Member Avatar for ladydivine

How to display the field in text box using combo box. When the user click the combo box, two fields will be displayed, the first field will be displayed in 1st text box1 and 2nd field in text box2. These are my codes. Can you help me how? Dim cmdoff …

Member Avatar for Jx_Man
0
420
Member Avatar for ToucheAmore

so im a noob at coding just started yesterday. I bought a visual basic 2010 guide book and i am working on my first example/practis program. I keep getting this error in my code before i go to try to test it out. 'picShowPicture' is not declared. It may be …

Member Avatar for Thijk
0
156
Member Avatar for Davidasmithpe

I have a problem with Excel 2003. Every time I open the program I get a MS Visual Basic Error that says: Compile error in hidden module: AutoExecNew (when i open it) Compile error in hidden module: DistMon (when i close it) I installed MS Office 2003 Professional on my …

Member Avatar for Davidasmithpe
0
243
Member Avatar for kewal sharma

sir i have vb6.0 with crystal 10 with oracle 9i but when form is run it giving strange run-time error'424' object required. but later ver.(crystal 7) same report running file. pls.help me. kewal sharma

Member Avatar for debasisdas
0
34
Member Avatar for Thinka

Hi there, i get the following error message every time i open and close Microsoft Word and Excel For Microsoft Word: Microsoft Visual Basic Compile Error in hidden module: Auto Exec and for Excel: Microsoft Visual Basic Compile error in hidden module: AutoExecNew (when i open it) Compile error in …

Member Avatar for jingda
0
639
Member Avatar for deadelgabar

im using the dlookup() to prievew password at a unbound textbox within a criteria that the username and security question that are entered matches the database. Ex: user forget password. he enters his user name, and select the security question, and answer the question. if these data match the data …

Member Avatar for BitBlt
-1
120
Member Avatar for deadelgabar

[CODE]Private Sub Command4_Click() Dim vPass As String If IsNull([usernametxt]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([answertxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" End If ' Evaluate filter before it is passed to DLookup function. strFilter = "[USERNAME]= '" & Me.usernametxt & …

Member Avatar for BitBlt
-1
227
Member Avatar for shena

Hi experts out there, I'm using a zebra printer, model TLP 2844Z. I need to print my company logo on a label. I've been trying this for the past two weeks and no idea what I'm doing wrong with the code below :( Other lines are printed except for the …

0
61
Member Avatar for EkoX

Hello All, As the title.. Does any one know how to find how many specific character in a text? Best Regard Eko.

Member Avatar for Jx_Man
0
170
Member Avatar for gingank

Dear All, Could someone can help me with this.... I need to extract file name example ABC-01.xls in to ABC-01 only what method i could use on this? Could anyone help me please!!! Thanks & Best Regards

Member Avatar for Jx_Man
0
107
Member Avatar for Jade_me
Member Avatar for v_sriram

Hi Everyone, I am trying to write a string variable containing XML in the form of text into an iframe such that it shows up as formatted XML with the expand(+) and collapse (-) options that default in IE when opening an XML file. The first thing I tried is …

Member Avatar for v_sriram
0
785
Member Avatar for deadelgabar

[CODE]Public Sub loginbtn_Click() If IsNull([usernamecbo]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([passwordtxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" Else If Me.passwordtxt.Value = DLookup("PASSWORD", "SYS_USER", "[SERIAL_NUMBER] = " & Me.usernamecbo.Value) Then strUser = Me.usernamecbo.Value strAccountType = DLookup("USER_TYPE", "SYS_USER", "[SERIAL_NUMBER] = " & …

Member Avatar for Ezzaral
0
165
Member Avatar for ryan311

i have a code in stored procedure like this [CODE]if exists (select code from dbo.tbl_product where code = @prodcode) Begin select 'Product Code Already Exist' as msg return End[/CODE] my problem is how can i show this msg in visual basic?

0
68
Member Avatar for zebnoon

Hye all I am developing a Shop Software i want to know what kind of Grid i have to use at Sale Form which will sum up and print bill?

Member Avatar for Jx_Man
0
112
Member Avatar for rheyn

needdd help...... how could i view remote database connection status using vb6? if the status currently connected or not to other user........ TY in advnce :)

Member Avatar for rheyn
0
61
Member Avatar for jemz

Hello, can you help me please,why is that if i insert picture on my listview and then if i have many data to display it.my listview will be destroy,it will not display properly the data.can you help me please why is this happen and how to fix this.Thank you in …

Member Avatar for dspnhn
0
89
Member Avatar for dreadfulalpha76
Member Avatar for spence89

Hi guys, I've just managed to get 99% of a script running for my website. I am creating a system where a user can create an invoice using our billing system, and then download it via PDF. I am using Persists PDF module and I have got it all working. …

Member Avatar for spence89
0
523
Member Avatar for romz

I have a project in VB6 and I need help in how to get the number of selected rows in a Datagrid.. I have already tried using datagrid1.selBookmarks.count but it doesnt seem to work.. i have set the marquee style property of the datagrid into highlight rows. Can someone give …

Member Avatar for Jx_Man
0
871
Member Avatar for gruffy321

[CODE] Private Sub Combo1_Change() With Me.Combo2.Enabled = False Select Case Me.Combo1 Case "bob" Me.Combo2.Enabled = True Case "carol" Me.Combo2.Enabled = True Case "jeff" Me.Combo2.Enabled = False Case "freeda" Me.Combo2.Enabled = false Else: Combo2.Enabled = False End Select End Sub[/CODE] Hi all , this code seems to be wrong as i …

Member Avatar for gruffy321
0
148
Member Avatar for akaban

i need a very simple coding of vb6 to control 8 leds connected with parallel port of my on-board parallel port. i need a little description with the coding to understand

Member Avatar for debasisdas
0
182
Member Avatar for Suchata Karmaka

i need a design of student profile system. And i am using Access for my backend and visual studio for front end. Plz plz plz help me. Its urgent

Member Avatar for debasisdas
0
49
Member Avatar for jfkennedy

Hello All, I am newbie and looking for a script to search for the following: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Windows XP\SP4\KBXXXXXX\Description HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\xxxxxxx\xxxxxxxxx I want to loop as I am trying to search for KB#'s under these folders Please advise as how i can go for writing this script. The script will eliminate the manual …

0
57
Member Avatar for bastardi

I've been using this technique in several of my programs now for quite a while and haven't had any kind of trouble with it until now. Granted now things have gotten a bit trickier but I'm still doing the same basic concept of search through a string looking for a …

Member Avatar for bastardi
0
338
Member Avatar for uselessninja

hi everyone i had a problem: my boss wants a program that can "determined a file if it is the beggining data or not(in the database)" and "calculate the time interval between the first data and the next data..and having an 10 minute interval before it proceeds to a next …

Member Avatar for uselessninja
0
105
Member Avatar for cmart

Can someone give some advice on this Tic tac toe game i'm trying to make with vb, it would be greatly appreciated. I am a total newb, and I know this code is probably terrible, I'm just trying to do what I know and see if I can make some …

Member Avatar for BitBlt
0
114
Member Avatar for vin24

Hi, i'm just wondering if there's any differnece between visual basic 6.0 and visual basic 2008?? Is visual basic 2008 compatible with the older versions of visual basic??? Please help.. Thank you in advance! :)

Member Avatar for debasisdas
0
162
Member Avatar for dnk

Hi All, I try to make my caption text scrolling. Actually, i already make it scrolling but after the last letter it would appear all of text and scrolling again. I want the text scrolling one by one, after the last letter it following by the first letter. How i …

Member Avatar for dnk
0
262
Member Avatar for jemz

hello... Can you help me please, how can i use the checkbox if i want to display on my listiew Active or not Active After clicking the addbutton. Example Jemz Gimz 123 then i will check the checkbox and click the Add button it should display on my listview Jemz …

Member Avatar for jemz
0
130
Member Avatar for Vega_Knight

Hi all, I am writing a program in VB6 where I need to determine the path for the system32 folder. I know the default path is c:\WINDOWS\Sytem32, but some people installed they windows in another drive. How i can get the path of system32 folder? Best Regards Vega

Member Avatar for Jx_Man
0
198
Member Avatar for gangemia

I'm using a single WSH script controlled by Microsoft Task Scheduler that calls a series of daily run batch files sequentially. However, some of these batch files only need to run on the first working day of each month. I don't want to create additional Task Scheduled events for these …

Member Avatar for TrustyTony
0
4K
Member Avatar for deadelgabar

hi, all im working in access 2007 vba, i write a code in the login screen, to check if the user name and password match with the corresponding username and password in the database. the problem im facing is if a user enters a usernam correct and a password which …

Member Avatar for Jx_Man
0
227
Member Avatar for ImKryz

Hello, I am interested in learning Visual Basic 2010 from scratch. I have no programming experience at all and I am looking for a good book that helps me grasp the concepts of programming as well as learn Visual Basic 2010 and the .NET framework. I would like a book …

Member Avatar for Luc001
0
124
Member Avatar for gingank

Could anyone help me using what method is the best to read the xml value below ? Example i want to read the Column & Row Value ? Columns = "82" Rows = 45 Here was the xml file content [CODE]- <Maps> - <Map xmlns:semi="http://www.XXX.org" FormatRevision="XXX G85-0703" SubstrateId="NA46696-19-E1" SubstarteType="Wafer"> - …

0
81
Member Avatar for dnk

Hi, I try to change all first letter of the words in the textbox to uppercase. THis how far i try to change it but just the first word not the entire words. [CODE] Private Sub txtQuote_Change() txtQuote.Text = UCase$(Left(txtQuote.Text, 1)) & LCase$(Mid$(txtQuote.Text, 2)) txtQuote.SelStart = Len(txtQuote.Text) End Sub [/CODE] …

Member Avatar for dnk
0
194
Member Avatar for PM312

i have Msflexgrid with two column (Invoice No and Amount) say 5 rows Invoice no column is left align and amount column is right align i want to transfer this 5 rows data to a single text box i.e entire grid data to single text box invoice no should be …

Member Avatar for Jx_Man
0
1K
Member Avatar for PM312

i want to change the font type to "Courier New" for my outlook message sent through VB [CODE]Dim oOApp As Outlook.Application Dim oOMail As Outlook.MailItem Set oOApp = CreateObject("Outlook.Application") Set oOMail = oOApp.CreateItem(olMailItem) MsgBox 2 With oOMail .To = Text1.Text .CC = Text2.Text & ";" & Text3.Text .Subject = Text4.Text …

Member Avatar for BitBlt
0
167
Member Avatar for zebnoon

hye here is my code but it is not working plz help me. [CODE] FRd = txtBCode.Text On Error Resume Next Set Mydb = OpenDatabase("E:\Projects\TS\database\MyDb.mdb") Set Myrs = Mydb.OpenRecordset("SELECT * FROM ItemEntry Where[Barcode]= "&FRd, dbOpenDynaset) ' other data have to retrive. If Not Myrs.EOF = True Then txtINameS.Text = Myrs("ItemNameSize").Value …

Member Avatar for P.manidas
0
154
Member Avatar for jmurph333

I am using Visual Studio 2010 Express Edition, and I am developing a basic game application. It involves a New Game button that is clearly named "NewGame" in 'Form1.cs'. But when I use this code: [CODE]NewGame.Click += new EventHandler(newGame);[/CODE] in 'Program.cs' I get the error message "Error 1 - The …

Member Avatar for jmurph333
0
2K
Member Avatar for alexaaxela

Hi guys, basically im writing a program where the user inputs the number of coffees they require from a number of drop down boxes, one for cappucino, espresso, iced coffee and latte. after this, there is a 'calculate' button which totals these up and displays them in a textbox. my …

Member Avatar for finito
0
152
Member Avatar for FanionGolfer

JUST NEED A LITTLE HELP... I am doing a project and need some kind of look for it... Anything will do. My project is a matching game and I have worked out all the details so it runs pretty much smoothly. But I was unable to make the week of …

Member Avatar for debasisdas
0
112
Member Avatar for jemz

Hello, can you help me please, how can be my newly added data to be selected in my listview after i clicked my Add button.Please help me. Thank you in advance hoping for your positive response. here is my code. [CODE] Private Sub cmdadd_Click() Dim Objlist as ListItem sql = …

Member Avatar for Jx_Man
0
717
Member Avatar for michaelzip

Hi. I just want to ask if it is possible to create a function that accepts an expression into its arguments. Just like what IIF do. Ex: [CODE]Dim strResponse as String = IIF(Msgbox("Select Yes or No", vbYesNo) = vbYes, "Yes", "No")[/CODE] I forgot the code, but its the thought that …

Member Avatar for michaelzip
0
187

The End.