It might be an idea to have a noob forum where newbies like me don't feel like an idiot for asking simple questions.

It could have stickies for the most common questions.

The top sticky would have to be froum rules: search before you ask, what info should be in question etc...

A sticky for normaliSation. Most noobs (me included) feel it's just something for power users, but it's at the root of A LOT of noob questions. It's heavy reading for a noob, so explaining it in layman's term would be very useful.

As this is a UK forum, a sticky on the pitfalls of using UK format short dates in VBA would be usefull. As problems of this nature are hard to diagnose, it causes alot of problems with no clear answer.

I understand where you are coming from, but believe me, you will always be learning with MS Access, it is layer upon layer of learning when you have conquered one area or one level of expertise there is always another one waiting for you in the wings. In other words we are all "New" (beginners) at some level.

its true just the other day i thought 'hey im not all that bad in access now' 10 mins later my boss comes up to me with a new db he needs.. a complicated one! & bammmm 'I realise im rubbish again! Access put me in my place :(

Even if we knew everything about Access, Microsoft would come along with a new version so we would have to start over.:mad::(

YIKES Access2007 and then along came Vista and IE7 - we must be more cleaverer than we thought!:eek:

if we master those, then i think they have something to say. both of em are nightmares!!!

if we master those, then i think they have something to say. both of em are nightmares!!!

If there is such a change then they need a separate forum area so that antiques like me don't waste everybodies time with nonesensical answers.

Brian

If there is such a change then they need a separate forum area so that antiques like me don't waste everybodies time with nonesensical answers.

BrianDon't be so hard on youself. You have the wisdom of the ages and the sense not to post unless you know the answer. If only some others would do the same:)

Don't be so hard on youself. You have the wisdom of the ages and the sense not to post unless you know the answer. If only some others would do the same:)

I wish i would know when to do that!!:p:p

Even if we knew everything about Access, Microsoft would come along with a new version so we would have to start over.:mad::(


I hate to tell you this but the signs are that Microsoft are encouraging VBA developers to look at .net Link (http://channel9.msdn.com/Showpost.aspx?postid=306413)

I hate to tell you this but the signs are that Microsoft are encouraging VBA developers to look at .net Link (http://channel9.msdn.com/Showpost.aspx?postid=306413)
Another day another challenge:)

Whether or not we create a new forum, I think the suggested stickies are an excellent idea for the forum overall. It's hard to fault people for breaking 'rules' when no rules are posted.
A sticky for normaliSation

Kraj wrote a tutorial on the topic that is helpful for explaining the concepts. Maybe that would be a good thing to add to any such sticky.

http://www.access-programmers.co.uk/forums/showpost.php?p=479789&postcount=18

Kraj wrote a tutorial on the topic that is helpful for explaining the concepts. Maybe that would be a good thing to add to any such sticky.

http://www.access-programmers.co.uk/forums/showpost.php?p=479789&postcount=18

I’m sorry, but this article is about something called “normalization” :confused:

I meant a sticky on “normalisation” :D

Well, why not list both? We'll put a link to the vaporware helpful tutorial written by someone from pommie-land and put a link to the actual contribution of the yanks instead. Leave it up to the reader to decide which is more helpful shall we? ;)

... someone from pommie-land [''';)

Hey its the aussie B£$£$%$£ who call us pommies, you yanks stick to limies (that doesn't look right :confused:). :D

Brian

Who says I'm a yank? :D I'll moidah 'em!

Sorry yes your the Aussie who couldn't find his way home.

I must be more carefull
I must be more carefull
I must be more carefull
I must be more carefull
*100

Brian :o

Sorry yes your the Aussie who couldn't find his way home.

I must be more carefull
I must be more carefull
I must be more carefull
I must be more carefull
*100

Brian :o

oh man...what a spelling nightmare!!!

Sorry yes your the Aussie ...

Ouch! No need to get nasty ;)

Ouch! No need to get nasty ;)

Oh Bugger, sorry ladies, but just checked Craig's profile he's a Kiwi, actually I didn't know Kiwis also called us pomms.

Brian

oh man...what a spelling nightmare!!!

I just so wanted to be full of care. :eek:

Brian

actually I didn't know Kiwis also called us pomms.

'fraid so. :)

I recently completed the finishing touches on a database. Database resides on my physical hd. I then emailed an employee that will be completing the data entry the database that I was working on.

I then attempted to open the file again and all I get is a grey'd out screen and all my work seems to have been lost.

Any help would be greatly appreciated.

Thank you.

I hate to tell you this but the signs are that Microsoft are encouraging VBA developers to look at .net Link (http://channel9.msdn.com/Showpost.aspx?postid=306413)

I hope not, I just started learning VBA.

I’m sorry, but this article is about something called “normalization”

I meant a sticky on “normalisation”

I actually laughed out loud at this. Thank you.

I recently completed the finishing touches on a database. Database resides on my physical hd. I then emailed an employee that will be completing the data entry the database that I was working on.

I then attempted to open the file again and all I get is a grey'd out screen and all my work seems to have been lost.

Any help would be greatly appreciated.

Thank you.


I dont know whether to laugh at this guy, or laugh at myself for posting in a thread that is a year old.
:p

You keep blinking... Maybe something was in your eyes...:p

FWIW,

I think there's quite a wall of separation between the articles, faqs and the actual posts. I don't think many people even know of articles that exists on this site and IINM, they're not referenced from this board directly so when a kid comes here, all he see is a bunch of posts rambling about a problem that is not His™ or Her™ problem at all.

There's only a link on the navigation bar which points to generic vBulletin FAQ, but not the FAQ forum, which is further down the screen.

So, the way I see it is more of an issue of mapping and explicitly referencing the articles and FAQs among with vBulletin, which I'm pretty sure can be done using the same layout. With a better layout, everyone will be able to find the FAQ® a bit easily.

I hate to tell you this but the signs are that Microsoft are encouraging VBA developers to look at .net Link (http://channel9.msdn.com/Showpost.aspx?postid=306413)

I can has try/catch block?

I can has try/catch block?


?

(This is to meet 10 character minimum. Please ignore. :D)

The below code are for illustrative purposes. Actual syntaxes may differ.

VBA's fugly error handling:
Private Sub foo()

Dim bar As Variant
Dim baz As Object
Dim iter As String

On Error Goto geewhiz

bar= 1/0

With baz
End With

iter=Null

ExitSub:

Set baz = Nothing

Exit Sub

geewhiz:

Select Case Err.Number
Case 11
Msgbox "You just did a stupid thing."
Resume Next
Case 91
Msgbox "You schmuck. You didn't set the object variable."
Set baz = New Object
Resume
Case Else
Msgbox "You've got me beaten. I give up."
Goto ExitSub
End Select

End Sub

Try/Catch in VBA.NET
Private Sub foo()

Dim bar As Variant
Dim baz As Object
Dim iter As String

Try
bar = 1/0

With baz
End With

iter = Null

Catch ex As DivisionByZeroException
Return 0
Catch ex As ObjectNotSetException
Set bar = New Object
Catch ex As NullException
Return ""
Catch ex As Exception
Messagebox "Okay, I'm stumped now."

Finally
Set baz = Nothing

End Try

End Sub


And here's a cheeseburger!
http://www.appscout.com/images/i-can-has-cheezburger.jpg

I hate to tell you this but the signs are that Microsoft are encouraging VBA developers to look at .net Link (http://channel9.msdn.com/Showpost.aspx?postid=306413)

Are companies really going to buy visual studio licenses just to extend vba? It might be tempting for people who make a living developing VBA but despite the size of the company I work for, >60,000 employees, I wouldn't ever see them paying for VS licenses for people who work with VBA.

Like Jesus from a cave.

@Banana-This site doesnt have much of a faq.

Oh, yeah, it does have lot of FAQs.

It's just not immediately clear and there are two different FAQs; one on navigation bar which takes you to vBulletin FAQ (big whoopee), and a forum for FAQ, which you need scroll when you're viewing the page that lists all forums (e.g. General, Forms, Queries, Reports... Access FAQS).

It might be an idea to have a noob forum where newbies like me don't feel like an idiot for asking simple questions.
.

I agree with that! I am new and I am already lost!

I think the problem with a noobies forum would be just that - it might well end up being frequented only by noobies or kind-hearted people who want to help noobies.

At least with the current system, it's fairly obvious where to post your question most of the time, and you know what kind of things to expect when looking in a particular forum - eg stuff on queries in the queries forum, stuff on reports in reports forum etc.

A noobies forum would end up as a "free for all" with topics on all questions, which doesn't help others who might be looking for the answer to a question on queries in the "queries" forum, when the answer is in the "noobies" forum. This would rely on the search system which isn't always that wonderful ;)

Just my opinion, feel free to shoot me down in flames (bearing in mind I too am a noobie and I can figure out the system just about!)

Ruth