Skip to primary content
Skip to secondary content

My Excel Database

My VBA codes history

My Excel Database

Main menu

  • Home
  • Posts’ list
  • Other
    • VB.net
    • VB
    • WordPress
    • Others
  • Contact
  • About me
  • Log In

Category Archives: Others

Others posts not related with Excel and VBA.

MySQL: query with joining two tables

Posted on 7 December 2017 by pawel
52

In my last project had to compare two different tables. Table ‘itemsaldo’ contained whole warehouse stock and in table ‘holdlist’ were products blocked by Quality Department.

Continue reading →

Posted in Others | Tagged JOIN, MySQL, WHERE | 52 Replies

Creation installation file in Inno Setup

Posted on 29 November 2017 by pawel
49

In Visual Studio Express Edition there is no possibility to create instalation file for our projects. There is not such a function? In order to create exe file help us Inno Setup Compiler. This is free tool to create installation files.

Continue reading →

Posted in Others | Tagged Inno Setup | 49 Replies

Remote connection to MySQL

Posted on 24 August 2017 by pawel
860

Few months ago I’ve tested connection between Excel and MySQL database on local computer. Test hasn’t been performed with database located on external server – I think it should works too.

Continue reading →

Posted in Others, VBA | Tagged Excel Connection String, MySQL, Remote Connection | 860 Replies

Language

English Polski

About website

Website showing coding examples found in internet and  used by me. Was created in order to find working code in new projects. This is a source for my future applications to find needed code fast and easily.

Video presentation (PL)

https://www.youtube.com/watch?v=ysJDqAbEOSQ

Visual Basic .NET

  • UnobtrusiveValidationMode jquery w VS for Web

    I’ve wanted to add login control to my test website... Read more →

  • Connection string encryption in VB.Net

    After hours of tests I’ve succeeded in ConnectionString encryption in... Read more →

  • Filling and centering GridView in VB.NET

    GridView in VB.NET is the same control as DataGridView in... Read more →

  • ConnectionString for MySQL w VB.NET

    ConnectionString for MySQL w VB.NET For now I’ve only tested... Read more →

Visual Basic

  • Text value dividing

    Something we have to divide some text value for two... Read more →

    Something we have to divide some text value for two separated elements. VBA code contained to this post show how to do this. Of course shown code is quite simple – it has to be rebuilt for yours needs.

    (more…)

  • Item removing from MySQL via Visual Basic

    In the project I still making I’m using MySQL database... Read more →

    In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?

    (more…)

Recent Posts

  • VBA not recognizing polish letters
  • Checking if another Worksheet is opened and its opening or closing
  • Folder creation
  • Removing duplicates in collection
  • Creating HTM file via Excel VBA

Recent Comments

  • 토토 on Remote connection to MySQL
  • kawerf.iwopop.com on Filling and centering GridView in VB.NET
  • canadian drugs on Get SAP format date
  • cleantalkorg2.ru on Connection string encryption in VB.Net
  • cleantalkorg2.ru on File Picker

Categories

  • Excel
  • Others
  • Power Query
  • VB
  • VB.net
  • VBA
Proudly powered by WordPress