Visual Basic :: Most Basic Of Questions

A Few Very Basic Questions?
Please forgive my ignorance of macros and VB, but I am trying to learn as fast as I can.

first off, I have a workbook that I was trying to use some macros in. I still have a bit of work to do on the workbook, and I thought I deleted all the failed attempts to write working macros. However, when I open the workbook, it prompts me to enable macros... how can I delete all the macros and start over on them fresh? (I have a ton of formulas and calculations on several sheets and dont want to have to redo all of them by copying them into a brand new workbook)

2) I am separating a list on one worksheet into 2 lists (on seperate sheets) based on the cell values in a column. The two smaller lists will have additional calculations done, and then I will need to recombine the 2 lists back into a single list. At that point I will need to sort the comprehensive list. What would be the best way to go about this?
I have thought about trying to sort (descending) to get all of the blanks at the bottom, and then using a count or range to grab the rows with values in the first column. But even then, I am not sure how to bring the 2 lists together without overwriting.

3) I know there is a automatic macro run command for when you open a workbook, but is there one for when you change sheets?

Thank you so much for your patience and any assistance you can give me with this! I think I may have bit off more than I was ready for on this project and am scrambling trying to learn as much as I can, as fast as I can.

Some Basic Questions
Edit by Moderator: Please do not respond to threads over 1 month (this one was 5 years) old as per our Posting Guidelines. By all means start your own thread and reference another if appropriate, as I have done this time for you. Thanks
Re: http://www.xtremevbtalk.com/showthread.php?t=18695
. . . some -- maybe most -- of us aren't professional programmers, but I don't understand why more experienced people shrug off basic questions.

I've been looking for an answer to a simple question -- What is "dim" and what exactly does it do? I read a horrible text on VBA that assumes I already know what it means, and online I found, at most, a site that will explain it if i fork over money. Ha.

The author of this thread asked the question; the respondent did nothing more than to suggest something else. The question was put in another thread in this forum, and the response was something like "you'd better go read up on your basics." That's condescending and perhaps self-gratifying, but it does not solve a problem.

So what does "dim" mean? What does it do? Is someone willing to break the bubble of secrecy and just provide straight answers?

Very Basic Questions
What do these logical operators do if they are used in numerical calculations

Why:
Not 20 = -21
3 Or 9 = 11
4 And 20 = 4
10 Xor 5 = 15

I know this is very basic,
I asked people and Searched the web,
But I still can't find the answer
Thanks

Basic VB Questions...
In the VB Book, it says to explain the differences between these two:

Input #1, var1, var2
Picture1.print var1 + var2

And

Input #1, var1
Input #1, var2
Picture1.print var1 + var2

Is there any difference at all? Wont they each read the first and second variables, then add them?

Some Very Basic SQL Questions
Hi,
I have been working on Oralce for more than 4 years and now, first time Im working on SQL server for small project. I have some very basic questions

Que 1
In Oracle there are some easy function available for Date formating
1. To_char
2. To_date

Like wise is there any functions available in SQL server 2000 ???

Que 2
In Which Format SQL server is storing the Date ?

Que 3
Is SQL server Date format is depends on the Systemdate format ?

Pls advice me

2 Questions, 1 SQL, 1 Basic
Ok, first off: I'm trying to pull my own query from an Access database. Now the query is already made, and i've tried "SELECT * FROM query_name" but that doesn't work. Doesn't seem to want to let me pull from a query, which is fine. (Unless there is a way to do this. I'd much rather do it this way.)

As I tried to work around it I found the SQL syntax from Access and plugged it in to my execute command like so:

Set dbConn1 = CreateObject("ADODB.Connection"): dbConn1.Open "MRP", "", ""
Set dbrs = dbConn1.Execute("SELECT ServiceOrders.ServiceOrder, ServiceOrders.JobNo, Orders.OrderDate, Customers.ContactFirstName, Customers.ContactLastName, Orders.[Job Address], Orders.Street, ServiceOrders.Occupied, Customers.PhoneNumber " & _
"FROM Purchase Orders INNER JOIN Customers INNER JOIN Orders ON Customers.AccountNumber = Orders.[Account No] INNER JOIN ServiceOrders ON Orders.[Lighthouse Job No] = ServiceOrders.JobNo AND Orders.[Lighthouse Job No] = ServiceOrders.JobNo ON [Purchase Orders].JobNumber = Orders.[Lighthouse Job No] " & _
"WHERE ((([Purchase Orders].Closed)=0));")

And that gives me an error on the inner From clause. I originally had parenthesis around the inner join parts, and that generated an error in the Inner Join statements. Here is the SQL directly from Access:

SELECT ServiceOrders.ServiceOrder, ServiceOrders.JobNo, Orders.OrderDate, Customers.ContactFirstName, Customers.ContactLastName, Orders.[Job Address], Orders.Street, ServiceOrders.Occupied, Customers.PhoneNumber
FROM [Purchase Orders] INNER JOIN ((Customers INNER JOIN Orders ON Customers.AccountNumber = Orders.[Account No]) INNER JOIN ServiceOrders ON (Orders.[Lighthouse Job No] = ServiceOrders.JobNo) AND (Orders.[Lighthouse Job No] = ServiceOrders.JobNo)) ON [Purchase Orders].JobNumber = Orders.[Lighthouse Job No]
WHERE ((([Purchase Orders].Closed)=0));

Any help would be GREATLY appreciated.

Also, I want to display and print reports from the results of these recordsets. What would be the best way to go about this? Recordsets could be as large as 1,000 records or more, but will usually hover around the 200-500 mark.

Thank you all for your time.

Basic Questions?
Dear Team,
Please explain the purpose of "HasDC" Property in Picture Box.?

Basic Questions
Whtas the difference between a New function and a new sub?
can both have return statements?

Also for some reason I am not able to get my return statement to work,

for example when I type

Return blah

it says, Compile error, expected end of statement

Two Basic Questions
Hi everyone,

A couple of questions...

1. How do you get an input box to load in the centre of the form window. It loads on the X and Y position of the screen whenever I set where I want it.

2. When I unload a form, and then show it it jumps the entire window about 200 x 200 pixels. Does anybody know why? And is there a better way I can just restart the form?

Thanks. Much appreciated.

T.

Three Basic Questions
Just a few questions I ran into while making an app.
Thanks fer lookin!

1. There are a few character that I don't want my text box to print. Lets say there is a | Can I make it so rather then printing a | on my text box it won't print anything at all? Or maybe youd know how to do this, which is the same thing... While Im printing "n" can I make it so rather then printing the letter "n" it would print "O" or something like that...

2. If anyone knows WinSocks:I have a basic client/server applicaton set up. First I turn on my server to listen to the port and if a connection is trying to come I close the port and reopen it, letting connection pass. Sorry if it isn't too clear, im on a different computer now then the one that has the code so...well anyway this idea should work, but instead It says something like "Connection forcefully rejected" So I turn them both off. I run my server quickly, and again try to connect, this time round it connects and everything works fine.

3.If anyone knows WinSockS:Can a server send a command to a client? Like if I send "run" as Data to the client it'll RUN notepad.exe As Shell or something like if i send "exit" to it as data it will then unload form...

Im might run into sommore questions so ill still them here,

Thanks for all your help!!

2 Very Basic Questions
Ummmm... I may seem dumb for asking these but I really need to know how to do both things. First off, I have a check box called "chkBold". How do I make it so when the user clicks a button (cmdButton) it can tell me if the checkbox (chkBold) is checked or not? Second, how can I make a statement print quotes without it thinking that means it's the end of what I want it to print. For example:

text1.text = "The man said, "blah blah blah", and was happy"

but it thinks that the quotes surronding what the man said means that it's the end of what to print, when really I want it to print the quotes with the words. How can I fix that? Thanks for your time and any responce is appreciated. Later,

-zer0 flaw

Some Basic Questions
Hi there!
Can you please tell me the answers to the following Questions?

Maximum Number of Forms allowed in a project?
Maximum Number of Controls allowed in a form?
Maximum Number of Users(Clients) supported by Ms-Access database?
Maximum Number of characters allowed in the 'Tag' property of a control/form?
Thanks in Advance.

Basic SQL Questions
I've created a few queries. I want to know which are the most efficient or what i could do to make them MORE efficient. I'm using MS Access at the present. I will attach a copy of the DB schema to this message. Thanks!

This is the first query. It selects all the questions with one or more wrong answers chosen.
Code:

SELECT cq.cqid, cq.qid, q.question, r.responseid, r.answerid

FROM     employeetests et,
completed_categories cc,
completed_questions cq,
questions q,
responses r,
answers a

WHERE     et.employeetestid=cc.employeetestid
AND cc.ccid = cq.ccid
AND cq.qid = q.qid
AND cq.cqid = r.cqid
AND r.answerid= a.answerid
AND et.empid = 57
AND cc.categoryid = 2
AND a.correct = no

I think this above query is more efficient than the following query which was my original. My guess is that the above one is better because the following query has a subquery which means the DB is being queried twice instead of once. Both seem to return the same results.

Code:
SELECT     cq.cqid,
cq.qid,
q.question,
r.responseid,
r.answerid

FROM     employeetests et,
completed_categories cc,
completed_questions cq,
questions q,
responses r

WHERE     et.employeetestid=cc.employeetestid
AND cc.ccid = cq.ccid
AND cq.qid = q.qid
AND cq.cqid = r.cqid
AND et.empid = 56
AND cc.categoryid = 6
AND r.answerid IN (

SELECT     a.answerid

FROM     tests t,
categories c,
questions q,
answers a

WHERE     t.testid=c.testid
AND c.categoryid = q.categoryid
AND q.qid = a.qid
AND a.correct = no
AND c.categoryid = 6
AND t.testid = 1)

Here is the second set of queries.

Since the application based on these queries allows more than one right answer, there is a chance a user will not select all of the possible right answers or even no answers at all. Thus I developed some queries that would capture the results i need.

These two queries are similar but don't produce the same results. Which is the most efficient and why?

Code:
SELECT    cq.cqid,
cq.qid,
q.question

FROM    employeetests et,
completed_categories cc,
completed_questions cq,
questions q

WHERE    et.employeetestid = cc.employeetestid
AND cc.ccid = cq.ccid
AND cq.qid = q.qid
AND et.empid = 56
AND cc.categoryid = 7
AND cq.qid IN (

.............SELECT    q.qid

.............FROM    categories c,
.............questions q,
.............answers a

.............WHERE    c.categoryid = q.categoryid
.............AND q.qid = a.qid
.............AND q.categoryid = 7
.............AND a.correct = yes
.............AND a.answerid NOT IN (

..........................SELECT    r.answerid

..........................FROM     employeetests et,
..........................completed_categories cc,
..........................completed_questions cq,
..........................responses r

..........................WHERE    et.employeetestid = cc.employeetestid
..........................AND cc.ccid = cq.ccid
..........................AND cq.cqid = r.cqid
..........................AND cc.categoryid = 7
..........................AND et.empid = 56))

Here is the second query of this set. While the above query was a nested query inside another nested query. This one represents two subqueries inside the main query.
Code:
SELECT q.qid,
q.question

FROM categories c,
questions q,
answers a

WHERE c.categoryid=q.categoryid
and q.qid=a.qid
and q.categoryid=7
and a.correct=yes
and a.answerid not in (

.............SELECT r.answerid
.............FROM employeetests et,
.............completed_categories cc,
.............completed_questions cq,
.............responses r

.............WHERE et.employeetestid=cc.employeetestid
.............and cc.ccid=cq.ccid
.............and cq.cqid=r.cqid
.............and cc.categoryid=7
.............and et.empid=56)

and q.qid in (

.............SELECT cq.qid

.............FROM employeetests et,
.............completed_categories cc,
.............completed_questions cq

.............WHERE et.employeetestid=cc.employeetestid
.............and cc.ccid=cq.ccid
.............and cc.categoryid=7
.............and et.empid=56)

Basic Questions On VB && ADO
My knowledge on ADO connections and usage is limited. I hope the answers to the following questions will leap me forward.

In a current project, I use one Access table for the whole form, but I'm manipulating it several times. Basically it's a name and address form.

The first thing I do in the form is click on the Initial of the last name I want to edit (using 26 controls A thru Z).

Then I select the name out of the combobox that I wish to edit.

The form is filled with current info and the database is updated.

(Process repeats)

Now the real question:
Why wouldn't you open a connection/recordset in the Form Load() and Close it on exiting? If someone could explain the logic for repeatedly opening and closing within each event, I would greatly appreciate it.

Basic Tileing Questions
1. whats the more common size for tiles? I've heard a size thats evenly divisible into both the dimensions of the screen resolution is best. 16 and 32 I think fit into the standard 640x480.

I ask this mainly because I keep seeing people saying "Oh god, don't waste your time on making your own tiling engine! its been done to death a thousand times".

First off, I've seen a few. I don't know what size tiles they use and unless its customizable, then you pretty much have to find the one you need.

Secondly, I don't fully understand Tiling. I know you make up preset tiles, I know you have a program that can load 'pallets' of tiles onto a canvas/map and can often set certain triggers, like passable/non passable, encounter probability, damage taken, etc. But how is it done?

I'm more likely to make a tiling engine just to understand how its done and whats going on. I assume its not just making a .bmp, its a .map usually, which seems to be a custom file type having images and holding the values. Is it just like an input file telling the game where the tiles are located and which ones go in which coordinates and what triggers there are? or is it a dual picture file with properties.

I don't honestly think anything wants to go into this sort of detail explaining anything to me (unless they really enjoy this aspect of games), but if anyone knows any short answers and/or links to good tutorials that would explain the entire process, then I'd be greatful.

2. Yeah I know, 1 was pretty long. But anywho, if you were to scan your own tiles as a .bmp, is there a way to force the resolution to be exactly what you want, ie, every tile is 16x16 or 32x32? Or can you scan at a higher resolution and then scale it down using sofware without loosing all of the detail?

This question comes from two places. First I have board games that I can scan to get some basic tiles. Second, I've seen tiles on the internet, but they come in all sizes.

Thank you for any help answering these really basic questions

Some Basic D3d (8) Questions For My Game ;)
Hello ppl,

I'd like to use some d3d to spice up my game a little.

so here's a few question that i would very appreciate being answered.

Can I combine d3d with the GDI eg. just using d3d to 'render' a model in a picturebox or similar?

How can i make .x files (lol) of 3d studio max models and how do i use them in d3d apps?

Some example/tutorial/sourcecode of a very basic d3d app which can handle a model, a light, and a fps counter?

As you can see, i am very new to directx programming and i have been making all my 'game like' games with the built-in vb options, now i want to go a little bit further and utilize dx8.

So if you could try to explain everything in detail i would very much appreciate it.

besides: i've already searched the web and forums and i've come across the directx4vb and other sites but i the only things i've accomplished so far is opening a dx screen, so i've not learned really much.

when replying, please try to speak to me as if i was someone who has never used vb, because i have learned vb by myself with vb5 fiddling around with the assistants, changing values, and searching the vb5 help for hours

so thx very much in advance for everyone who makes the great effort and replies to this thread, you will be sure mentioned when the game enters beta testing

btw, about the game: if you know about that onlinebrowsergames where you build and research in realtime you will get an idea of what its about, only that mine will be multi-language and client/server architecture, you can get some idea of it by looking at the screens here: http://www.perseus-game.net/screens/
these are taken of the experimental client which was written in vb6 and worked for building, scrolling the map, and writing messages to other players by communicating with the self-written server through winsock. you may notice the 'birth of the federation' look cause it was this game which inspired pretty much of mine. at this time i'm at completely re-conceptuating the whole thing cause at first i wanted to make the whole game by myself but i realized it got too huge with all the things i wanted to built in. so now i've gathered a team and doing it again from the beginning, and it will really be a great thing, i cannot wait myself to play it.

phew, so far, thanks if you actually have read this whole thing and much more thanks if you actually reply. (btw ideas are also welcome)

Visual Basic 101 Questions
I'm really new when doing projects with visual basic. so please bear with me. I just work out my first project and it turned out really good but I have several questions.

1) I noticed all my macros/vb code ended up on the excel sheet and not a module is this good/bad? It works fine but This created a problem with size which was resolved by reducing lines of useless code.

How would I separate a Private/public sub into module format?
I've tried to separate the two items and put into a module but I haven't broken the code.
(Example this continuous string is all located on the sheet and nothing is in the modules) It happened by mistake but works very well.
Private Sub CommandButton23_Click()
' SISAC Import Utility
destfile = ActiveWorkbook.Name
' open file
inputfile = Application.Dialogs(xlDialogOpen).Show
If inputfile = False Then Exit Sub
inputfile = ActiveWorkbook.Name
ActiveSheet.Range("D1").Select
inputSISAC = Selection.Value
Select Case inputSISAC
Case "v2004a"
CS_SAC
Case Else
' this displays a message if the value of cell D1 is not v2004a.
MsgBox "The file you selected was not a valid SISAC v2004a input file."
End Select
End Sub

Public Sub CS_SAC()
Workbooks(inputfile).Sheets("areas").Range("B2").Copy
Workbooks(destfile).Sheets("SENIOR MEMBER NOTES").Range("b1").PasteSpecial Paste:=xlValues

2) It seems smarter to put items into the module to save and isolate different tasks. So if I put a macro into a module how do I call the module for tasking?

3) what is the difference between a private and public sub

Thanks

Some Questions In Visual Basic 6
Hello everyone,

I have a question in VB 6:

1.) Currently, I am working on an application, which has two textboxes and a button to "clear" them. However, I am not sure how I would go about coding the clear button to reset everything that the user would type in the textbox. Does anyone know how to do this??

If someone could answer this, it would be much appreciated

Just Want To Introduce Myself And Ask Some Basic Questions
Hello, My name is Chris, but i go by Speedingpenguin. I'm 14 years old and am in the 9th grade at highschool. I am taking a course called 'information systems' but that doesnt go near programing. My dads a computer programer and lately has been using Visual Basic for his project. I have always loved computers, and lately have started to really get into the whole thing. I just built a computer from scratch, AMD Athalon XP1600 on an Epox 8K3AE motherboard with 256MB of Samsung PC2700 memory. 60GB of Western Digital hard drive space gives me room to have alot of stuff.. My dad bought Visual Basic online a while ago and i'm not sure what verson it is, but it was the latest one at the time. I have fooled around with it , creating my first program. It was simple, just added 2 to any number...i got help from my dad but i want to be able to do it all myself. I have looked around online a little bit but havnt found what i need. I have NO programming experience whatsoever and want to start with VB. Could someone please recomend a good book or site where i could learn VB from absoloutly no experience with programming? Thank you all, and i'm glad to be part of this forum.

2 Questions On Visual Basic 6!!!
I have two questions to ask about form interactment and they are as follows;

1. How can you make a form the main form because im sick of having to go back to the start to access the form i want to preview in run mode. Then after i can change it back. Also how do you cut a form out of one project and put it in another project.

2. How can i create really good looking text and make it 3D and basically just make a title that stands out.

Thanks for your help!!!!!!!!

Visual Basic Questions!
Hey Everyone im back again now

Anyways i have two points really to ask. One point is very basic and im sure you can help me with but the other point im just curious about. Anyways

1. When i load forms up i use
load form1
form1.show

and when i close them down with a back button i use
Unload me

Whats the way to load a form and close the previous one leaving just the loaded form loaded.

2. Is it possible to have a button or something where when you leave the mouse over and it opens another part (Like windows does when you leave it over programs) and then you can click on those selections that have opened up.

Thanks

Couple Very Basic Questions. :|
Alright, I have a couple very basic questions that I would like to figure out how to do.

1) How can I count the Items in a List?

2) How can I do something with each Item in a list?

3) Is there a way to create something like a 'progressive item' array? What I would basically like to do, is have an array, something like [i]Numbers(1,3,4,5,8,9,13,16,18), and when a certain Sub was called, it would cycle to the next one. If it was at the end one, it would return to the first. Any way to do this?

That's it. Thanks.

From Access 2 SQL ~ Basic Questions
Hello,
I have a decent amount experience using Vb with Access. I'm converting my latest project from an Access DB to an SQL Server.

In Access, I autonumbered my data.
a) How do you use autonumbers in SQL Server?
b) What is does the SQL Identity box do?
c) Is there an easy way to convert my 3 Access tables in SQL tables?
d) How does one set a primary key in SQL Server?
thx,
Anakin

Basic MySQL Questions
Hello everyone,

I've just started VB 6.0, i have experiance in PHP and C++ (Slightly), but i'm a little stuck on connecting to the mySQL servers using vb 6.0. I've downloaded some files from the internet and followed some tutorials but i just cannot get my program to connect to the mySQL server.

What commands work and what do i have to use to activate them? Because there was a slight chance these files was .net not vb 6.0, but it said nether, so i don't know.

Thanks,
Mime.

Very New To Visual Basic And I Have Some Questions
I'm very new to visual basic and I'm trying to create a program which will view a specified website when the URL is typed in the Textbox and Button is clicked.

Once the website is opened. I want my program to search that website for a specific HTML string (ex; <img src="images/ex.gif"> ). If it finds that specified string, it will do a popup notice and say "String Found". If it doesn't find it, It will refresh each 3-5 seconds until that image is found in the source code (the page is a PHP page and it dynamically changes).

Can anyone help me with this?

Basic DataGrid Questions
I have a DataGrid and it is connected to MS Access. What I want to happen is to be able to double-click any cell within the DataGrid just like a button wherein I could assign a code for each cell. How do I do that? Thanks.

Edited:

I changed the title because I might ask several things about the DataGrid Component.

Some Basic Questions A Newbie Needs Help With.
1) what code do i use to save a file? so far i have this:

Quote:

Private Sub SaveAs_Click()
With CommonDialog1
.DialogTitle = "Save character"
.DefaultExt = ".tch"
.Filter = "Character File (.tch)|*.tch|"
.ShowSave
End With

End Sub

but that only shows the save dialog box. how do i get all the info the user entered in the textbxes then save them as a .tch file (tch is a file for my program, none of u probly know this file extension)

2) how do i use the browse thingies? so the user clicks browse it appears with a dialog box, they select a .prg file and it places the name of the file into a text box when they click the button to add the file.

3) how do i change the icon in the top left corner of the dialog boxes? ive made my icons (16x16) and tried to put em into the icon but it says "invalid property value"

4) how do i make it so when the user enters something in a textbox then clicks create files button, it will create 5 new folders in the programs folder, one called, Programs, one caleld scenes, one called characters, one called enemies and one called Images.
and also it will save a file with the name they typed in into a different folder called Main.

Basic Excel Questions...
Let's say you've got an Excel file that consists of three sheets.
The first one has some content, the second one is empty
and the third one also has some content...

1. How can I figure out if a sheet is empty or not

--> This is the primary question.

Let's say now that the first sheet has content from cell
"A1" to "E5" and down to "A10"...

2. How can I display that content only in a DataGrid?

Any ideas/suggestions?

thx!

A Couple Basic Questions
Question 1:
In Qbasic there was a command

Shell a$

Where a$ contain a dos command and shell would execute it.
Is there any equivilant command for vb?

Question2:
Is there any way to add scroll bars to a list window?

if not

How do I add scroll bars to a textbox? or text window or something.

BAsic Questions From A Newbie....
Hello All,

I have a few very basic (I think) questions that some of you might be able to help me with. I run an engineering firm. We have a software program that we would like to have developed. We have laid out exactly what it should do and how it should work. Now we need to find someone to create it for us. Before I look into it further though, I'd like to have a basic understanding of what the best way to go about creating the program is. I am very familiar with web development, including ASP using VBscript, but I am not at all familiar with programming stand-alone applications.

The program that we are going to create needs to take in maybe 20 pieces of info from a user. These will be a combination of text boxes and pull-down menus. It then needs to reformat these inputs into a format that we have set up. In this format a number of pictures will need to be located correctly along with the rest of the information. The user then needs to be able to save, open, and most importantly, print the resulting file.

What is the proper method of doing this? From what I've seen, the printing aspect seems to be the most difficult to handle. Isn't there a system that makes this easy?

Also, the program can save the info to an internal database, but it would be much more preferable for it to save the info as separate files.

The format that we have lends itself nicely to using tables, if that helps. Also, depending on the amount of information entered, we will need to go to multiple pages. On these pages, only the information in the body of the printed document will change, the headers and footers will remain the same for each.

Does anyone have any tips for me on how this type of system would be best created? Also, are there any websites or books that you might be able to recommend for further info? Can anyone recommend a programmer in the Midwest area?

Thanks in advance for all of your help.

Regards,
--Josh

Visual Basic 6 Questions
I'm trying to make a CSS generator, so bare with me here.

How can I make a button that will save the contents of a label to a text file? Either that, or copy it to the clipboard.

And is it possible to make a label pop-up in a new window (full screen) with that button to save/copy it?

Another question, I set up a list thing, now I want it when they click a list item, a frame will appear, such as they click body, and the frame called Body will appear and replace the frame that was there already. Say, Links frame was open, and I want the Body frame to take it's place when body is clicked in the list. Is this possible, where each frame has it's own buttons, inputs, variables, and commands?

One more, I don't know how to put this in question form, so say I have a combpbox, that looks like this:
-Option1
-Option2
-Option3
I want the user to select one, and then be able to output the choice, say they choose Option2, when the click the generate button, Option2's value would show.

Few Basic SQL Server Questions
Guys my company has agreed to purchase SQL Server 2000 using one processor for an app i'm creating. this i hear is better than using MS Access.

Here are a few questions.

1) Does SQL Server Standard Edition only allow for 10 simultaneous users?

2) Is programming using ADO different from using MS Access? I have no experience with SQL Server and I will be doing all the work myself.

3) Will setting up the database be different from the basics I'm used to with MS Access? I will have to create the normalized database myself.

4) Can i install the software on my workstation to test before goign live?

Thanks guys. I hope this isn't taht difficult. I'm trying to reduce the learning curve as much as possible but hope to be able to expand my learning as time goes on.

Very Basic Questions From A Newie
this is a 4 part question
on a windows xp i downloaded & installed embedded vb3.0 along with sdk for pocket pc 2002 & smartphone 2002
1) every time i run a program and it 'uses' a control component (i.e. menubar or file system control) i get the 'control ... could not be created' application error on the emulator. even with the ce samples. now on a windows 2000 the samples & some of my code work. would i be correct in thinking i'm missing an 'addon' for xp or would i have to use api's in the programs to perform this work?
2)using the emulator in testing program - why can't i locate the files i created?
is it because i would have to run it on the handheld to view data in files? if that's the case would i have to msgbox data to validate data?
3)would i have to use a rapi to 'copy' files from 'handheld' to a folder on a network drive or would the filesystem control do the trick?
4)recommend site/books

as one can tell from these questions i'm a newie and from looking at all the ce sites, probably the only person in the world that does not know the answers

any help is much appreciated.

thanks,

noneleft

Couple Of Basic Questions
Two questions:

One: When querying a db (Access2000) using the Top predicate, is there a way to randomize the resultset? I have a table with many records alot will match my query but i want only 100, I want to get them from different locations in the table

Two: Can I dimension something with events, like

Dim rst as adodb.recordset with events

if it is possible do you need to ref. anything or do anything else.

thanks

DJ

Essential Questions About Vba And Visual Basic
Hi ^^. First time I am new using vba (thank you dear Boss) so please excuse me for what I will ask.

1. Is it possible to directly call vba functions from a visual basic form?
2. Practical question:

I have to write a program in visual basic 6.0 that checks each fields of a column in a .csv file and compare them to the information in another column in another file; to see if they are in. In fact I have to make an application with it because the people that will use it aren't familiar with using macros.

Until now, my boss used that macro:

Sub checkReceipts()
Range("I2").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-4],'[myreceipts.xls]Receipts'!C1:C2,1,FALSE)"
Range("I2:I65500").Select
Range("I65500").Activate

/* why can't we directly put something like Range("I2:I65500").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-4],'[myreceipts.xls]Receipts'!C1:C2,1,FALSE)"??? */

Selection.FillDown
Columns("I:I").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("A1").Select
Application.CutCopyMode = False

I don't really understand. Ok, the lookup functions seems to be used to check each field of my myreceipts.xls file but:

why when I am trying to do the same in visual basic 6.0 does it take like 15 times longer?I am probably doing the same the function does which is cheking the information by comparing two arrays...
Is there a function like VLOOKUP I could use directly from visual basic (for my application) that would be as efficient (fast) as this one?

I found something like this while browsing the net:

Dim Arg1 As Object
Dim Arg2 As Object
Dim Arg3 As Object
Dim Arg4 As Object
Dim returnValue As Object
Dim worksheetFunction1 As WorksheetFunction
returnValue = worksheetFunction1.VLookup(Arg1, Arg2, Arg3, Arg4)

But how do I use it? If I am right the returnValue should be my receipcolun I want to check if it is already in my receiptbook am I right?

so I should also make a second worksheetfunction for the .filldown right?

EDIT: Ok, first post AND in a wrong section >.< (I beg your pardon )

EDIT2: yeah, while reading me again it seems a bit confused, but my main question is why when I am cheking my receipts using the vb6 application I made which opens the 2 .csv file (1 with the list to check and the second with all the existing ones) and cheks for each of the new receipt if it is already in the receiptbook... just why does it takes so much longer than the macro my boss used to use?

Questions About Visual Basic In General
what i must knew if i want to be a master of vb, and they still made programs with visual basic now,or there are another thechnologie now.
i want to be adapted to the current technologies for creating a program!!

please your answer will be very very important to my heart!

thanks

Some Basis Questions Visual Basic
hi!
i have got some basic questions..

1)how to pass variables/object to a form? suppose i call the form
using load frmDA? or is there any otjher way?

2)how do i declare a object public (in a form) so that it is accessible to other form..
public a as calendar in the general declaration in the form did not work for me.
i had to add a new module, where i made the declaratiion and then it worked...

3)is it not possible for user defined object to be made public..? or is it that we have to declare all the public objects in a code module ?

thanking you in advance,

x11

Just A Couple Of Basic Form Questions
1 Concerning the Icon next to the Form caption How do you change it and what size pic is needed?

2. Skinng the Form, can you point me to a good example of skinning? or an example of some code!!!

vbMarkO

Visual Basic Interview Questions
where will i get sample Visual Basic Interview questions for referance.

vnm31

Basic ADSI And LDAP Questions
I have been learning how to do LDAP and ADSI queries for some basic Network Admin tasks. The scripts I have created thus far have really helped me out, but there are a few things I would like to know how to do to help make much more powerful scripts...

First, how do I search AD to see if a user account exists? When I do an LDAP query against AD for a user that does not exist, I get an immediate error. How Do I trap this error in an IF statement like the following? (I need to check user folders on our SAN to see if we have old folders out there that do not match up to current active accounts... I need to search for user names based off of these folder names and see which ones are no longer needed... Any suggestions?)

If strUserName does not exist in ("LDAP//cn=Blah......")
strBadUserNameList = strBadUserNameList & "," & strUserName
End IF

Second, where do I find a listing of available LDAP ADSI properties for users and/or groups? (When I do a SQL syntax ADSI query, what field types can I scan through by name - Which ones are strings that I can read?) For example, ADSpath, Name, CN, SamAccountName, etc...

Thanks ahead of time for any help you can lend...

Questions About Menus In Visual Basic
I need some help, could I get someone to describe the general process used to create menus in VB. Also could I get someone to explain the purpose of separator bars, checked items, and multi-level menus. Whats the difference between an access key and a shortcut key? What is a popup menu?

My Visual Basic 6 Questions And Problems
Good Day,

please forgive me if i post in wrong section. below are my problems regarding about visual basic 6.

what are the different between Modules and Class Modules?

what is Related documents? how to use it?

what is the importance of 'Modules', 'Class Modules' and 'Related Documents' in a vb project?

thanx

Few Very Basic Questions Need Quick Advice
I am kinda new in VB, appreciate somebody's advice on these few simple (may be idiot) questions.

1. How do trap user's input from common dialog box message? said user click a "Cancel" or "Yes" on the printing dialog, how could it trap the user's input and make decision accordingly?

2. I save some string onto text file in this way

Print #1, string1, string2, string3

I wish to read the string1, 2 and 3 back to string array individually with split function. What is the delimiter I should use? I used to use "Write", instead of "Print", the 3 strings was separated by "," This is easy to split with "," as the delimiter. But to make the output text file look better, I change to use "Print" instead, then the 3 strings became separated by some space/tab. I tried to use vbTab as the delimiter, but it seems does not work. Please help

3. This is an real idiot question, how do it print " You & Me" on the caption box? The "&" seems like a special character.

MOre Basic VB Questions - Text Box Control
Thanks to the VB GURUs for help on my previous text box question. Here is another one for ya! Say I have three text boxes that I input info into: A, B, and C. Say I also have three text boxes: 1, 2, and 3 that the info. I put in the first three goes into them as follows:
Input from A goes to 1
Input from B goes to 2
Input from C goes to 3

For the purposes of boxes B and 2, I am not doing anything, but taking input from B and putting it in 2. That works fine. My problems are with A and C and 1 and 3. The best way to illustrate is with an example:

Part A: input works
Every time I input new values for boxes A, B, and C, this new input should be generated on a new line in boxes 1, 2, and 3 as follows:

Text Boxes Text Boxes
A B C 1 2 3

input from me: 1 3 5 fills boxes: 1 3 5
input from me: 5 7 8 fills boxes: 5 7 8
input from me: 9 14 96 fills boxes 9 14 96

Part B: input problem
If a new line of input to A and C is like below (value in A matches what is in 1 but the value in C does not match what is in 3) or (value in C matches what is in 3 but the value in A does not match what is in 1), the followng below should happen:

Text Boxes Text Boxes
A B C 1 2 3

input from me: 1 3 5 fills boxes: 1 3 5
input from me: 5 7 8 fills boxes: 5 7 8
input from me: 4 7 8 Should produce error message
input from me: 5 7 12 Should produce error message

The first message should read: "Duplicate entry, the value of A <and it should pull out the value 5> exists on 8."

The second message should read: "Duplicate entry, the value of C <and it should pull out the value 8> exists on 5."

In both instances, these values are coming from boxes 1 and 3 which are what are getting filled by input from boxes A and C respectively.

I am using regular text boxes. Please help if you can.

Most Basic Of Questions - How To Obtain Basic 6.3