Syndicate content

drop

As I added more complexity to the Query Builder in MS-Access, my fields were detached!

As I was working on a new Report, I had two fields with computations.

These are easy to handle, for example, for a Total you write something like this:

=[Quantity]*[Price]

And you get a product of the quantity and the price.

That works great. At first I had a very simple query and it looked like there was a problem in computed field, but I still decided to first add the WHERE clause to allow the user to limit the data to a given set of dates:

WHERE (((Invoice.CreatedDate)>=[Enter start date:])
   AND ((Invoice.CreatedDate)<=[Enter end date:]))

Notice all the parenthesis. Also ...

Microsoft Word 2007 and Nested Lists

Today I decided to write a document for a customer about some work I have done for them.

I thought it would be a good idea to use Microsoft Word on the system I'm using for the development. It is from Office 2007.

Not too surprised that things look all different since I used MS-Access for a while now and it has this same new "weird" look.

What I ran into, however, is a wall when it came to creating styles with nested lists. You know, a usual document with points:

1.
1.1
1.2
1.2.1
1.2.2
2.
2.1
2.2
etc.

And I could create lists, but not nested lists. In other ...

ComboBox bug

I created a form in MS-Access and noticed, after a little while, that a ComboBox would not render properly.

The problem is pretty simple, I marked the combo box as having a Normal Back Style. When I first open the window or when I click in that ComboBox, it works and renders the specified Back Color. That's great, but that's not exactly the solution, is it?

The box has a Fore Color of Black (that's the color of the text). That Fore Color is used because the background is expected to be either gray or green. Either way, black shows pretty well.

Access 2007, or where are my menus?!

 

My Boring Story

Microsoft Office is making progress... or... is that really progress?!

I got a great little surprised when I met face to face with Access 2007 and all the menus were gone. I wasn't warned about that one! Not only are they gone, you MUST use little tiny icons in the place of menus so it takes you an awful long time to learn the icons, but not just that, YOU have to choose which icons will appear on your toolbar.

FTP not working?!

Well... I knew that a firewall could generate a few problems, but this one, I did not expect!

I just could not FTP anything from my FedoraCore box. I checked the source system firewall, tweaked all sorts of options in the vsftpd.conf file to no aval.

The error I was getting was this:

Welcome to The Linux Page


Fox Trot by Bill Amend. Click to enlarge.
Click to enlarge

This site is a collection of my own work with Linux. Certain things are easy, others take time to decipher and if I ever need to repeat the work (which usually happens!), then I need to remember everything by memory or... have a site with all the steps taken and to take again.

The following are my most recent posts:

Thank you for visiting my website, and don't hesitate to drop a comment on one of the pages. Thank you!

For a complete list, go here.

Syndicate content Syndicate content