This isn't a programming question....I hope...

[Duncan Edwards Jones]

words of wisdom (ish) : build the model / data classes first before you event vaguely get started on the UI as it is too difficult to do massive change to the bindings later on.

[Ennis Ray Lynch Jr]

Dump Access. SQL Server is equally as easy once you get past the separation of Data Storage/Retrieval and UI and the change will immediately put you in a different class of developer. WPF sucks, Start with Win Forms to learn the fundamentals of saving and retrieving data so you are comfortable before you move to WPF and do everything Bass Ackwards.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch

[Jorgen Andersson]

That wisdom is generally applicable.

Wrong is evil and must be defeated. - Jeff Ello[^]

[Lost User]

Sorry but I've got to disagree, if you use MVVM and keep things separate then changing bindings is simple, I admit the initial learning curve is steep but there are a lot of good tutorials on CP.

One day I aspire to having a signature.

[Casey Sheridan]

The initial learning curve for WPF is pretty steep but having a book should give you a jump-start. After that, it's all fun and games ;)

[kmoorevs]

I have the same book from 2007. (3.0) I only got through the second chapter before losing interest. One of these days I do intend to try it again. At least now MS includes the designer with VS. Good luck! There's nothing wrong with using Access for small and simple applications particularly for single-user apps...unless you already have SQL Server installed that is. :)

"Go forth into the source" - Neal Morse

[Marc Clifton]

1.21 Gigawatts wrote:

So, I've just bought "WPF 4.5 Unleashed" by Adam Nathan,

Waste of money :) , as I think there are some really excellent series here on CP regarding WPF. Not saying the book is bad or anything.

1.21 Gigawatts wrote:

WPF 4.5 Unleashed

I'd put it back on the leash, get out the shotgun and kill it. ;) Marc

[1 21 Gigawatts]

Yeah, I've played with SQL Server before. I had built myself a little website with SQL Server 2000 as the backend and implemented CRUD Data Access layer to/from the DB, using Stored Procedures etc. However, that was a while ago, so I'll have to do a bit of re-learning!! :)

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

[1 21 Gigawatts]

Baahhhaaa!! Yeah - that's why I haven't started learning it before now! :)

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

[1 21 Gigawatts]

Ahh!! Don;t say that! The book got recommendations from our own Sacha Baber and Pete O'Hanlon - so I thought it must be a good start!! (But I will venture into CP articles I'm sure when something doesn't quite gel in me noggin!!

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

[1 21 Gigawatts]

kmoorevs wrote:

There's nothing wrong with using Access for small and simple applications

Indeed - it is quite a powerful tool, although it is far too easy to produce VBA spaghetti code and the lack of certain controls as standard (like a List View) is a bit annoying. Going from coding up an Access Form to developing a little App in C# was just a world of difference, C# allows you to be so neat and concise!

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

[Marc Clifton]

1.21 Gigawatts wrote:

The book got recommendations from our own Sacha Baber and Pete O'Hanlon

Like I said, I wasn't diss'ing the book at all. Just poking at you. ;) Marc

[1 21 Gigawatts]

I know I know! The articles on Code Project have always helped and amazed me over the years - so many talented and dedicated people! :)

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

[Lost User]

I would strongly recommend WPF: A Beginner's Guide - Part 1 of n[^] and the rest of the series, and in fact, any of Sacha's brilliant articles.

[PIEBALDconsult]

1.21 Gigawatts wrote:

I'll have to do a bit of re un-learning!!

FTFY.

You'll never get very far if all you do is follow instructions.

[David ONeil]

Is there an easy way to create reports as powerfully as you can using Access/Word combo? Using stuff like the following it was very simple to create/open Word documents and get customized printouts quickly. Opening an existing Word document with bookmarks in it allowed the creation of customized letters/reports per individual which was quite impressive by my standards, and I've never seen anything to indicate it is that easy in SQL.

     'Fill in the address block:
     Dim BMRange As Range
     Set BMRange = wordApp.ActiveDocument.Bookmarks("AddressBlock").Range
     BMRange.text = addressBlock

Using this approach in a Physical Therapy staffing company I made reports per therapist of all the documentation they needed, and work they needed to get done, and filled in anything that could be automated. It was an impressive single-button paper shooter-outer! Sorry for the programming question, but you opened up my curiosity again and it has bugged me for a while.

My website :: My book revealing the forgotten astronomy of our ancestors.

[Kevin Marois]

Ennis Ray Lynch, Jr. wrote:

WPF sucks, Start with Win Forms to learn the fundamentals of saving and retrieving data so you are comfortable before you move to WPF and do everything Bass Ackwards.

You can't be serious!! I did WinForms for 25 years, and WPF for the last 5, and I will NEVER again touch WinForms. It's archaic, outdated, and everything you want to do is a PITA compared to WPF. WPF is hands down a much better tool than WinForms. I design UI's now that I could only dream about back then. As far as "learning the fundamentals" - fundamentals of what? Programming? You don't need WinForms or WPF for that. "before you move to WPF and do everything Bass Ackwards." - What in WPF is backwards??

If it's not broken, fix it until it is

[Ennis Ray Lynch Jr]

Yes, there are easy ways to create report. DevExpress is a lot better than Crystal Reports. Unf. the situation your described is not easy at all! You have created a fragile system that "works" and required institutional knowledge. 1) Is Word Installed 2) Is it the correct version or Work 3) Did Word Hang 4) The user changed all of the Book Marks and it doesn't work anymore 5) etc. The visual design of the reporting is easily able to be accomplished via reporting tools, SSRS, Crystal, xtraReports but has the benefit of being managed within the environment and through Source and Version management. A one-owner shop that never has to worry about someone else changing something is a lot different from designing a report in a company with 15,000 employees that rotates employees more often than I rotate my sheets. In all honesty, the toughest question to answer is: Can this be maintained. Not how many lines of code did it take? It is really hard to write up any appropriate thesis with a defense against Access and Word in the space of a comment but I have used Access and Word in the before the before and I don't know so that is probably defense enough.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch

[Ennis Ray Lynch Jr]

When I say learning the fundamentals, there are a lot of "user interaction" type items that are far more simple in Windows Forms. It is the simplicity of the tool that I like. WPF adds, complexity, which for certain individuals on certain mindsets may be great. But for a user that designed a system in Access I would never recommend WPF as the next step.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch

[Kevin Marois]

So you would recommend he step back instead of forward? Learn an outdated tool that is no longer mainstream and he wouldn't find a job in instead of a modern more capable tool that is widely used? There is zero logic in this.

If it's not broken, fix it until it is