Home > Visual Basic Programming
Visual Basic Programming
Visual Basic Programming forum discussing coding strategies, development and techniques. Go from prototype to product quickly using this robust platform.
Problem with SQL "LIKE"
Hi!
I've created this function with the purpose to take all the values in the db that start with the '1' character ...
Quote:
Set rs = New ADODB.Recordset
rs.Open "SELECT CodProd FROM Prodotto WHERE CodProd LIKE '1*'", cn,...
answer(2) view(341) status(

)
Checking object exists Using Adodb
I am using adodb and i am trying to check if a query is dynamically created so that i can delete it
Does anyone know how to check it
I am using an access table and the queries are stored in access
Thanking you in advance
Macc
answer(0) view(264) status(

)
Disk or network error ** HELP **
Hi
I have developed an application running on XP clients. The mdb database runs on a win 2000 machine. When I try to access the database from the XP clients, the error "disk or network error" appears.
The app works fine on t...
answer(0) view(588) status(

)
How to remove from a position on a user-defined list
Hi there,
Hope someone can help me.
I've got a program which simulates a lift going up and down, adding and removing passengers from queues as it traverses the floors.
Lift moves up and down - works fine.
Customer details are added to a dyn...
answer(0) view(204) status(

)
Want the textfields to be blank when a form is loaded
Hi All,
I have a form which has bound textfields on it. When the form is displayed for the first time, it shows the
data from the tables in the textfields. But I want the textfields to be blank when they first appear.
Whenever I do sth...
answer(1) view(328) status(

)
answer(0) view(889) status(

)
problems running copied vba code
I copied all the objects from one db to another. in the new db i get a compile error in my vba code. this is strange since it runs fine in the original db on the same machine. it is almost as if by copying over the objects (using "get...
answer(4) view(566) status(

)
answer(2) view(734) status(

)
answer(1) view(778) status(

)
File I/O and String Manupulation
5241.1 To all VB PRogrammers
Need some kind asistance on coding on string manupulation and file I/O procedure i'm working on.
I 've a master file that i need to read and extract out all lines that contain the char ARC and output it to a ...
answer(1) view(206) status(

)
New to VB. a question about global level variables
I am just starting in VB. I do not understand what a "global level variable" has to do with the modules window? and why should it only be included in 1 module? I hope I do not get flamed for this post.
Rich
answer(2) view(990) status(

)
VB and HTML buttons
Hello all, first time poster...was hoping someone could help me out.....basically I've been writing this VB program that will automatically log into a website and download/upload files. I've got the download part to work, but the upload is...
answer(5) view(452) status(

)
Reports
Hi,
I'm building a program that will print a checklist. I have a database setup, and works, but I want to reproduce this in VB.
The DB has 4 jobroles, and I want to be able to select which jobrole is printed by selecting it from a dro...
answer(0) view(356) status(

)
comparing two fields from different forms
I have two forms in which I want to compare a field from each. The two forms are linked through an ID #. The problem is that I have no idea on how to compare the two. I am fairly new to programming with VB and have been referring to example...
answer(0) view(503) status(

)
GoToRecord ... and then ?
Hi,
I'm completely new in this area, so sorry if this is common stuff, stupid or not to be posted in this forum.
I'm using the command DoCmd.GoToRecord to select a certain record in a Table of an MS Access Database.
But how do you retr...
answer(0) view(786) status(

)
Import multiple excel files
Can someone tell me how to import multiple excel files into an access database. I have over 100 fiels that I need to import. Thanks.
answer(1) view(743) status(

)
HELP - TextWriter.Insert
Hi,
With VS 2003 and VB .NET I am trying to add a dateTime to every line in a text file - and while the following code displays the results I expect on the console - it does not actually make the changes to the textFile. So my question i...
answer(2) view(755) status(

)
answer(1) view(424) status(

)
How to separate words in a string
I am writing a program, to read a txt file, and display it in a spreadsheet.
The txt files contains these lines, and they are numbers:
0 400 9.42 0.00 4.4 2.20 0.61 420
54 790 8.84 2.38 9.3 1.69 1.06 880
144 1930 1.06 10.6 17.7 0...
answer(1) view(241) status(

)
howto connect 2 hosts with Winsock
I've tried my software with me like the server and I didn't receive the Connection Request from the client ...
the IP address used by the client is exact, I think there's something wrong with the ports ...
both server and client must use ...
answer(0) view(215) status(

)
connecting to a remote ms-access database
hi ppl,
i'm new to this group and new to vb too.this might sound dumb, but here goes anywz.
i'v been tryin to connect to a remote Ms-Access database using the m/c's IP address. i tried using the IP address in the connection string. it ai...
answer(0) view(48) status(

)
Manipulating a Crystal Report within VB
I am using VB 6 and Crystal Reports 10.
I want to be able to send a .pdf version of the report to an e-mail address(es).
So far I have the following.
Global crxApplication As New CRAXDRT.Application
Global crxReport As CRAXDRT.Report
S...
answer(2) view(689) status(

)
Stylebutton
Is it possible for a stylebutton to have systemcolors?
I can磘 make them to have systemcolors
answer(1) view(872) status(

)
Sending email through specific server
Hiya
I am trying to send mails from a website that has been set up
for a project. The emails will not send to outside of the network
because of the firewall.
The code is as follows:
If Len(HRM & "") > 0 then
Set Mail...
answer(0) view(276) status(

)
Autosize label height
Is it possible to have a labels width fixed (1335 twips) and have it磗 height autosized?
I want the labels height to change dynamicly at runtime. I磛e tried all kinds of solutions, but nothing seems to work for me.
answer(2) view(912) status(

)
answer(1) view(763) status(

)
... a small problem ...
Hi!
I've got a textbox and I need to able te user to insert the point char or the komma char, but only 1 time, and fi the point is yet in the textbox the user can't insert the komma and viceversa ...
asc(",") = 188
asc("...
answer(0) view(408) status(

)
DBF->SQL and SQL -> DBF
Dear all,
I want to make program using vb .
The input is DBF file, SQL server (text: Server Name)
the process is importing dbf file (input file) to sql server name (server input)
I usually using wizard from sql enterprise. Is using DT...
answer(0) view(460) status(

)
Printing Using Report Document ERROR..!
WHen i uses the default Print button in the crystal report viewer, printing is accordingly wat is shown in the viewer... But when i specify my own printing button USING REPORT DOCUMENT Printing... The reports comes out differently as what i...
answer(1) view(385) status(

)
Execute macro to run automatically
Hi,
I have created a macro that i want to automatically execute everyday. But for some reason when i run the below code to execute that macro it does not work. My macro name is imanimport. What i want is to open a excel spread sheet and ...
answer(2) view(851) status(

)