This page has 3 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl blogs written by Andrew Gould (page 2 of 3)

Showing blogs 21-40 (out of 42)

Flappy Bird in Excel VBA Part 7 - Creating Sprites

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to draw simple images using a worksheet as the canvas. You'll also see how to include the images in the game.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 6 - Detecting Player Input

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to respond to keys pressed by the player. You'll learn about the Application.OnKey method and the GetAsyncKeyState Windows API function.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 5 - Starting and Ending the Game

Posted by Andrew Gould on 11 April 2014

This part of the tutorial adds a basic menu system with ActiveX command buttons to start and stop the game.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 4 - The Game Timing Loop

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to set up a timing loop which allows the game to update continuously.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 3 - Windows API Functions

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to make use of Windows API functions to extend the power of Excel VBA.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 2 - Basic Workbook Setup

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to setup a basic workbook ready for you to start coding the Flappy Owl game.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA Part 1 - Introduction

Posted by Andrew Gould on 11 April 2014

This part of the Flappy Bird in Excel VBA Tutorial introduces you to the Flappy Owl game and provides download links and instructions to get it running in Excel on your machine.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Flappy Bird in Excel VBA - Tutorial Index

Posted by Andrew Gould on 11 April 2014

This is the main index page for the Flappy Bird in Excel VBA tutorial. Here you can find links to all of the articles which comprise the tutorial.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

Problems with Shared Datasets and Subreports in SSRS

Posted by Andrew Gould on 23 April 2013

If you're using shared datasets to populate subreports in Reporting Services you might have encountered an error when you preview your reports. This short blog explains what the problem is and offers a few simple suggestions to work around the issue.

Tags:
SSRS > Lists, subreports

Using Excel VBA to Label Multiple Series in a Chart

Posted by Andrew Gould on 30 May 2012

This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.

Tags:
VBA macros > Working with charts Writing VBA > Other

Controlling the number of rows per page in Reporting Services

Posted by Andrew Gould on 11 May 2012

Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!

Tags:
SSRS > Tables SSRS > Designing reports

Protecting Worksheets and Workbooks in Excel

Posted by Andrew Gould on 28 February 2012

If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!

Tags:
Excel > Validation, protection

Using Data Validation in Microsoft Excel

Posted by Andrew Gould on 28 February 2012

If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.

Tags:
Excel > Validation, protection

Scheduling Data Imports in SQL Server

Posted by Andrew Gould on 02 August 2023

If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!

Tags:
SQL > Tables and columns T-SQL > Other

Using Scenarios in Microsoft Excel

Posted by Andrew Gould on 27 February 2012

Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!

Tags:
Excel > What-if analysis

Goal Seeking in Microsoft Excel

Posted by Andrew Gould on 24 February 2012

Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!

Tags:
Excel > What-if analysis

Using Styles in Microsoft Excel

Posted by Andrew Gould on 24 February 2012

Constantly formatting cells in the same way can be one of the most tedious and time-consuming tasks in Excel. This blog teaches you how to use styles so that you can quickly apply consistent formatting across a range of cells.

Tags:
Excel > Formatting

How to Edit all Records in a SQL Server 2008 Table

Posted by Andrew Gould on 16 February 2012

This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.

Tags:
SQL > Tables and columns T-SQL > Other

Using Fractions in Microsoft Excel

Posted by Andrew Gould on 03 October 2011

If you've ever tried to enter fractions in Microsoft Excel you'll probably have become frustrated when Excel insists on converting them into dates! Read this blog to see how to prevent this from happening.

Tags:
Excel > Formatting

Using the VLOOKUP Function in Excel to Calculate Exam Grades

Posted by Andrew Gould on 22 August 2011

The VLOOKUP function in Excel is perfect for categorising a continuous range of numbers. This topical example shows you how to calculate an exam grade based on a numerical score.

Tags:
Excel > Excel functions

This page has 3 threads

Add a new post

From:	biulanar
When:	30 Oct 19 at 18:05

Hi. Did you figure out the flickering FlappyBirds problem?

From:	Andrew G
When:	01 Nov 19 at 13:55

I'm afraid that I didn't! I spent a little time investigating and then simply decided that Excel is a terrible choice for a game engine and moved on to XNA, GameMaker then Unity!

From:	H Randolph
When:	15 Apr 19 at 02:18

In need to add more than one line to a few rows in my database table.. Could I make the row length longer and wrap the data?

I work on a database to compare congressman's, work district and other information. Some table row has data that needs lines

I am not a coder, but with all the help you have given me with your video. I have built a database one. People who have some of it thank its great. That it would be useful.

Thanks you all your help

From:	Andrew G
When:	15 Apr 19 at 13:51

Hi Henry,

If you want to provide any kind of formatting for your users you really need to be using some form of reporting tool. This could be Excel, Reporting Services, Power BI or a number of other tools. Anything but SQL Server Management Studio!

From:	H Randolph
When:	14 Mar 18 at 00:52

I am trying to build a SQL data base. Who do I enter line of data in a tablein the the data base.Please help me

thank H Randolph

From:	Andrew G
When:	14 Mar 18 at 07:07

Hi Henry, we have a video which explains how to design and build a simple database (including how to enter data into tables) here

https://www.wiseowl.co.uk/videos/sql2016/design-relational-database.htm

I hope that helps!

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl blogs written by Andrew Gould (page 2 of 3)

Flappy Bird in Excel VBA Part 7 - Creating Sprites

Flappy Bird in Excel VBA Part 6 - Detecting Player Input

Flappy Bird in Excel VBA Part 5 - Starting and Ending the Game

Flappy Bird in Excel VBA Part 4 - The Game Timing Loop

Flappy Bird in Excel VBA Part 3 - Windows API Functions

Flappy Bird in Excel VBA Part 2 - Basic Workbook Setup

Flappy Bird in Excel VBA Part 1 - Introduction

Flappy Bird in Excel VBA - Tutorial Index

Problems with Shared Datasets and Subreports in SSRS

Using Excel VBA to Label Multiple Series in a Chart

Controlling the number of rows per page in Reporting Services

Protecting Worksheets and Workbooks in Excel

Using Data Validation in Microsoft Excel

Scheduling Data Imports in SQL Server

Using Scenarios in Microsoft Excel

Goal Seeking in Microsoft Excel

Using Styles in Microsoft Excel

How to Edit all Records in a SQL Server 2008 Table

Using Fractions in Microsoft Excel

Using the VLOOKUP Function in Excel to Calculate Exam Grades

Head office

London

Manchester