Search:

I realize this is an old thread ... however for future viewers, I found the contents very enlightening. For a complete description of my flicker problem and how I solved it (using some of the tricks...

That's what I am hoping for ... someone (maybe even MS) has something that can be added in the project so the end user doesn't need the full install of Excel/MS Office.

.
Thank you for your answers so far.

SECOND QUESTION:

(dilettante you touched on this). Without installing EXCEL itself, doesn't Microsoft have something that allows the end user (who does not...

.
I have a small database project in VB6 that creates an Access database sheet and an Excel worksheet - both used as depositories for the data entered via the VB6 form interface. Everything works...

.
VB5 is all I have at the moment. Haven't given much thought to upgrading but that could be an alternative.

There are lots of examples on the NET concerning VB5 and Excel but they seem to be...

Is there a method to load an Excel 2013 worksheet into a UserForm in VB5 ?

Or is there a method to open an Excel 2013 worksheet and populate it with Text File entries from VB5 ?

Example code ?...

.
dilettante

Thank you. Yes, VB5 is about as legacy as DOS at this point. I too haven't dealt with it for along while.

Thank you for your input. Cheers.

.
Ok ... that made progress ..

Now, receiving error message on :



Private Sub Form_Load()
Set rsTableCommand = NumbersDE.rsTableCommand
RebindGrid

.
Added these two references :


Microsoft FlexGrid Control 5.0

Microsoft ActiveX Data Objects Recordsset 6.0 Library

Still same errors.

.

Chris E : Thank you for your response. As you can see from my comments below .... I am lost. I'm also receiving lots of error messages with you project. Something wrong on my side.

...

.
I located the attached project online and want to make a change to the project. It presently utilizes a Listbox for displaying NAME INFO. I want to replace the Listbox with the Flexgrid or similar...

.
Thank you for the pointers.

.
After doing some more digging .... in the Properties window, VB says txtOrderID is not a valid name and wants to name the text box tctOrderID.

So, I've tried changing the name to txtOrderId and...

.
Thank you for your input. It is very much appreciated.

One of the problems I have experienced my whole life is the inability to learn strictly through 'book learning'. I am not discounting your...

.
jmcilhinney (& others) :

Thank you for responding to my requests for assistance. I truly appreciate your time and input. For various reasons I have concluded that my efforts to date demonstrate...

.
jmcilhinney :

If you are referring to this URL : http://www.vbforums.com/showthread.php?469872-Retrieving-and-Saving-Data-in-Databases&highlight=

I skimmed over it. Looks to be informative...

.
Re your post #4 .. No

I'm trying to learn with Vb .Net Community Edition 2017. Previously I've used VB5 and most recently VBA for Excel. This learning curve is huge, even with the...

.
wes4dbt

Thank you for your insight. I believe the"online instruction course" I am referencing is not what it claims to be. There is too much left out in the instruction .. either the author has...

.
Ok ... I've been able to correct a few other mistakes I wasn't aware of but the error posted in #1 is still there when I try to upate a record.



Private Sub btnUpdate_Click(sender As Object,...

.
I don't understand the error. Anyone ?

Also, why does VB .NET give correction suggestions for other errors but not this one ? Did I miss a setting during the setup procedure ?

Thank you !
...

.
Thank you si ! As is the usual here, these eyes didn't read everything in the course code. Hmmmm ......

.
Here is my first coding issue starting with VB .NET.

The errors in the below code are indicated with the LESS THAN symbol. <<<<<<<<<<<<<<<<<<<<<<<<
I've tried editing the code per the...

.
I don't envision folks being really interested in getting to the source code. My "paranoia" lies in the fact of how weak and open Excel VBA is. I need to get over my fears and move forward.
...

.
4x2y

Good suggestion !

Perhaps MS will include the personal display option in a future release ....

.
I did review the second URL previously (https://www.techrepublic.com/blog/10...cess-database/). Other websites give the same recommendations for protecting the code. Most all of the instructions...

.
If I start a new project, the PROPERTIES window / panel is in a horizontal position behind or in front of the FORM window / panel. If I arrange the PROPERTIES window / panel to a vertical...

Ha ! Ha ! :wave:

I'm really not old ... just retired two years ago. But don't tell anyone! If everyone thinks I'm on my way out maybe they will share their deepest programming secrets with me.

I understand ... and thank you.

Thank you for the tip. Ironically, "Enable xp visual styles" was already engaged. I unchecked it and viola ! The look I was seeking.

Thank you !

.
I am seeking better security for the coding. Excel provides no security at all. VB5 was given serious consideration but I have to wonder how much longer a 30 year old 32 bit product compiled...

.
"I can't believe it's not 1991" Windows 3.1 style?"

I don't care what you say ... NOW THAT'S FUNNY ! :lol:

Why can't I have my cake and eat it too ? I'm old and really beginning to get set...

Thank you for the encouragement !

(Perhaps this Geritol pill will help ...)

.
I apologize for the simplistic nature of this question but I have been searching the internet and VB .NET for several hours without success. :mad:

When you start the Community Edition of VB...

.
I have a current completed project in VBA/EXCEL.The records are stored in the spreadsheet.

A quick review of .NET documentation seems to indicate I can transition to .NET with an ACCESS style...

.
I'm transitioning from VB/VBA to VB.NET ...

Are all command buttons in .NET flat looking without depth ? VB5 / VBA command buttons have rounded edges and contours.

Is it possible to make a...

.
Phew ! Perhaps I should stick with VB5 and only "Option Explicit". Certainly not as much to keep up with.

:eek:

Microsoft doesn't understand how feeble my mind really is .....

.
Yes. Good suggestion. VB and VBA both have "Option Explicit" which has always been 'On' in my workbooks. You are absolutely correct, it makes coding A LOT easier !

I'll get it activated.
...

.
Thank you sir ! Took a glance at it. Looks promising.

Been playing with the first link you suggested. Exactly what I was looking for. The projects are really basic but the purpose here is to...

.
Thank you sir. I truly appreciate your willingness to assist in this regard.

Your comments again sounds a lot like learning VBA ... precisely how I started there. Then I moved to the various...

.
Greetings

First off .. if this is the wrong place for this thread, please advise. Thank you.

Request:

I am seeking online resources (free) that will teach a newbie like me how to use the...