Log in

Visual Basic Community's Journal
[Most Recent Entries] [Calendar View] [Friends]

Below are the 20 most recent journal entries recorded in Visual Basic Community's LiveJournal:

[ << Previous 20 ]
Thursday, May 18th, 2006
11:05 am
VB 6.0 Data Environments/Reports
I'm using VB 6 with an Access Database (I know... I know...) and I'm trying to get it to generate a report based on user selected criteria.

Basically my database is full of contacts that can be involved in my company's programs. The user should be able to select a program from a dropdown and then print a report of all the contacts participating in that program.

I've been able to make it print every contact in every program, but not for a specific program only

Thursday, May 4th, 2006
1:11 pm
New To Community
Hey everyone. I'm new to this community, but I've been working with VB 6.0 for a few years now, but haven't done much with database programming. I'm working on a program that will allow a user to create and save databases, as well as switch between them whenever the user wants. I can switch the databases no problem...though it may not be the most effective way to do it (when a user clicks on a particular button, an Open dialogue box appears, they choose the database they want, the file name gets passed into a Global Variable, a Global Function is called, the original form is unloaded, then reloaded [via the global function] with the file name set to the data controls DatabaseName property).

Again, may not be the most effective way to do it, but it works. Now, since apparently databases within VB save on their own, I don't have to worry about a user clicking a "Save" button, but I do need the ability to let the user create a new database. This is where I'm hitting a snag, and none of my books seem to help...unless I'm really dense and just missing it.

Any help would be greatly appriciated. Thanks.
Wednesday, August 17th, 2005
4:56 pm
please help!
Hi. I'm trying to "beef up" one of the Access general templates for use, and I'm running into a problem.

Read more...Collapse )

x-post in sharonme
Friday, November 5th, 2004
5:28 am
S(n)/(1 - (1 + r)^-n)

I'm writing this loan code and thats the equation that has to be calculate.. I just don't understand how I would do it. Math is a struggle for me. p = rSn(subscript n) / 1 - (1 + r)-n (to the negative n or something like that)

http://www.sontek.net/equ.jpg is a picture of what the equation looks like.

I'm doing the code in Visual Basic.. I have everything setup I just don't know how to setup the equation in the code (I don't know that much math so that equation makes no sense to me at all)

p - is an equal periodic (monthly) payment
r - is interest rate stated as an annual interest rate
n - is the number of monthly payments over the life of the loan
Sn - is the amount of the loan

This is what I tried doing.. But its overflowing.. so if anyone has any ideas let me know

answer = ammount * (number) / (1 - (1 + interest) ^ number)
Friday, August 6th, 2004
10:21 am
Inno Setup Toolbar 1.0

Yet another application. This time, it's a Visual Basic IDE Add-in.

Its purpose is to connect to the freeware program called 'Inno Setup', an installation builder for application deployment. Your looking at the screenshot for version 1.0, that took about a day to design and implement - I was a bit surprised at how fast it went together. The main add-in consists of the three buttons viewed above, on a floating toolbar. The toolbar can be docked anywhere in the interface, and remain in its place even after you exit the program and restart it.

The three buttons work as follows:

Script Editor
Creates a default script with the project name plus .ISS, the default script extension, in your project directory. (IE: Project1.iss) It also adds the basic requirements to compile the setup script. After creating the script, the Inno Setup Editor is launched, allowing you to edit and maintain the script.

Compile Script
Starts the Inno Setup Compiler to run the script in the project directory. So basically, once your done writing the script in the script editor, you can - at any time - hit the 'Compile Script' button to repackage your application and prepare it for distribution and deployement. Obviously, this is the useful part.

Configure Toolbar
Brings up the lower window featured in the screenshot, so you can configure the program settings. All settings are stored in the registry, so it will always remember them. Normally, the toolbar will automatically locate the installation directory for Inno, but if for some reason it cannot or is finding the wrong version, you can force it to a different path from here.

Pretty swanky, huh.

Source Code for Toolbar Add-In:

Quick and Easy Installer for Toolbar Add-In:

Inno Setup Homepage:

Enjoy, and make sure to send any suggestions along to me.

Current Mood: accomplished
Monday, July 19th, 2004
2:45 pm
Microsoft Outlook has a type of list called Distribution Lists, but Outlook doesnt have any option to export into CSVs. Conventional wisdom says that this type of work is best left to visual baisc...but, I only know a tiny bit of Java, so does anyone have the heart to write me a conversion program? I know its a lot to ask, but I'm sure it cant be difficult. (or, could someone suggest a different option?)

thanks in advance...

Current Mood: desparate
Saturday, July 17th, 2004
4:52 pm
4:23 am
Ok i have an array with 75 elements called balls(74), for an automated bingo program.
The trouble is I am having a hell of a time randomizing the array so it does not have any visible pattern
(ie. 3 Bs in a row, which the odd are like 1 in 125 of normally happening, yet i get patterns like that occuring every game)

here is what im working with...

Dim i As Integer
Dim j As Integer
Dim tmp_value As String

For i = 0 To 74
j = Int((74 - i + 1) * Rnd() + i) 'finds random place in array
tmp_value = balls(i) 'assigns current position
balls(i) = balls(j) 'replaces current position
balls(j) = tmp_value 'assigned original position to replacement's index
Next i

any help would be appreciated
Saturday, June 26th, 2004
2:28 pm
Hi n all that jam....
Hi folks just joined, been mean to look for a VB community for a while but just found it a whole lot easier now I've got a paid account :)

I'm currently a VB / SQL server developer so if I can help any of you guys out let me know, 'cos I'm sure gonna be posting and asking for help as soon as I get something interesting to do at work :)

Thursday, June 17th, 2004
12:28 pm
weeeell no response so i guess y'all didnt have time to work it out or this wasnt the right place to ask.

But that's okay!

A friend emailed me a lovely little program which does exactly what I asked for - if anyone else would like to receive it (basically it's a web page with a bit of code behind it - you create a sub folder to your personal outlook calendar, set the page as the homepage and it works it all out for you) I'm happy to share.

Email tumblehometumtum@hotmail.com and I'll send it over

Monday, June 14th, 2004
3:37 pm
help with programming Outlook
My question is really an outlook one, which uses VBScript - and I've looked on MSN, and in books, but there's woefully little knowledge around outlook that i can get my hands on..!

I know this isn't strictly VB - but outlook uses VBScript & I'm finding it hard to get help elsewhere. if anyone can help I'll be soooo grateful...

Basically What I want to do is this:

I work in an office which has about 10 users on our server. I want to create a calendar folder in outlook, in the public folders list, called staff calendar, and write macro or a bit of code so that every time a member of staff puts an 'away from the office' meeting in their own calendar, it 'invites' the staff calendar.

If you have any other (simpler?) suggestion for how to create a calendar showing where users are when out of the office in an amalgamated way I'd be very happy to hear it!

I'm inexperienced with VB but know enough to paste code in to the right place..

If this is not your area of expertise/too much work please feel free to ignore this request - I'm asking entirely on the offchance.

Many thanks

Bella x
Thursday, May 27th, 2004
6:31 pm
Somebody help please!
I have a some MS Access data base project, but I'm not a programmer and dont know howto I can create form. If somebody
have a 10 minutes and can help, please knock to my ICQ 121142, and I say, what need do. Thank You!!!
Sunday, May 16th, 2004
11:35 pm
Has anyone used the calendar control in .NET? I would like to use the control to show ONLY the days of the current month, and not the trailing and leading days of the surrounding months. The calendar used in LJ only shows the current month's days, but I know that's not written in .NET. Any ideas, or do I have to write my own control?

Thanks. :)
Monday, April 5th, 2004
12:50 pm
MS Excel 2000 Macro
Would there be anyone out there who has any knowledge of Macros in Excel?

I need to come up with a very simple Macro.
Basically, I have 2 worksheets in 1 file. The first worksheet is a database of names, identification numbers, addresses, blah, blah, blah.

So in my 2nd worksheet, I want the Macro to display the name and contact number of the person when I key in the identification number. Simple right?

Comment on this and I'll probably give you my email address or something.
Wednesday, February 25th, 2004
2:32 pm
HELP ME! I am stuck with this and my brain has turned to mush!

I want the start, pause and exit buttons to do as they are meant to. I also need the left and right buttons to be activated by keystrokes (eg pressing z = left, pressing x = right) I also want to be able to have a points system, where if the "ball" hits the top of the playing area then 1 is added to the score. i.e. a points system.

Read more...Collapse )
Wednesday, November 19th, 2003
5:18 pm
A little help..?
Okey dokey.

I am really newbie when it comes to Visual Basic, but I am trying to making a little program in VB6. I only know what I bothered to listen to last year at college. Anyway, I have a question.. which is probably really stupid, but I couldn't find it everywhere else I looked.

Is there a way to get my application to be the only thing clickable? So, when it's run.. you can't click off onto something else, or change focus with alt+tab or something like that?

Anything that would help would be greatly appreciated as i'm totally stupid when it comes to things like this, heh. Also, this is crossposted to another community or two- so my apologies if you see it on your friends list more than once.

Current Mood: curious
Wednesday, November 5th, 2003
12:29 am
help a VB newbie with simple debugging
This is driving me nuts, not knowing why it doesn't work. I hope there's some kind soul in this com who can and will help me out. Not sure what the rules are, I checked the info, so I'll just put my code behind an LJ-cut. Hope this is ok, let me know if I did something wrong.

The problem: I cannot extract the customer_no and employee_no data out. Its all random what is returned onto my spreadsheet. I've been debugging for days and can't figure it out. Please please help?
the database can be found here fss2000.mdb

Code behind the cutCollapse )

Current Mood: aggravated
Wednesday, October 22nd, 2003
6:52 pm
Hey guys, Im new here so I thought I would introduce myself. Im 15 years old and I live in Glendale AZ. I taught myself VB6 from a Microsoft book about a year ago, I have forgotten most of it with school and all, but Im going to take another whack at it this weekend and see if it all comes back to me. Thanks!
Monday, October 13th, 2003
6:15 pm
I've been teaching myself VB6 for the past couple of weeks and I'm curous about something...

When adding a reference for regular expressions I notice there are two to chose from, both are titled "Microsoft VBScript Regular Expressions" but one is v1.0, the other 5.5.

What's the difference? they both seem to work well enough.

Current Mood: perplexed
Monday, September 22nd, 2003
3:31 pm
I've been having a discussion with my boss about moving to .NET.

His opinion is that it's not really been accepted by the industry. I disagree.

How many of you are using it? Is there any sites that show any statistics of what languages people are using, etc?

[ << Previous 20 ]
About LiveJournal.com