Search results

Actually it's page 212 in App.1 :

Eeeehhh ? :confused::confused:

I told you Bob, make a back up first before changing from DAO to DOA !! :p

You might change your windows settings : settings > configuration > country. Set both the standard and location to French-Canada and dates in Access will be in the french language. Hth

ISO 9001 2000 is all about managing processes. Now for each process in your organization , there should be one (or more) persons responsible for the management of that process. So I would say, why not allow each process manager to make the necessary changes in the relevant process and have...

Or put this on the on open property of the form : Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub

Agree Jal. Found this : http://www.access-programmers.co.uk/forums/showthread.php?p=799516 and appearantly this issue can't be resolved. Sorry for not being any kind of help.

I thought you were copying data from one field to another. Doing this with qdef.parameters could give an error, since qdef.parameters data is read only. Hope that makes sense. Anyway, what happens if you change : qdef.Parameters("@Explanation").Value = txtExplanation.Value to...

As far as I know the qdef.parameters is read only. That's maybe why you're getting the error. From access help :

I sure do, but I'm struggling with this : :rolleyes: Anyay, thanks all for the good wishes. Cheers, Ron

Thanks guys. Yes had a good day, except that I lost yesterdays game that I played with the local rugby club, but hey beer and foie gras enough, so I can't complain. ;) Cheers, Ron

Why not a global language and ask Colin to be the guardian of the monster ;)

Well done RG. You are certainly an asset to this forum. Congrats. Ron

Van harte gefeliciteerd Mile-O. Looks like the weather in Glasgow isn't that good today. Just finished Carmen's Rust ( Ana del Rio) and loved the book. Haven't seen you for ages around here. Cheers, Ron

You might try a search on Conditional format. Guess that's what you're looking for . Hth

OK, what if you try this : IIf([Forms]![FST_main]![OG_status]=1,true,[Forms]![FST_main]![Sel_st])

You could try changing it to : IIf([Forms]![FST_main]![OG_status]=1,"0",[Forms]![FST_main]![Sel_st]) Hth

Or try : =DSum("[Expr2]";"Query1";"[Expr8] like 'USD*'")

Definitely NOT recommended, but here's some guidelines : http://articles.techrepublic.com.com/5100-22_11-5928902.html

I would say : Import the excel data in a new table ( e.g. Table1). Table1 has 5 fields. Make a query based on table1 which looks something like : SELECT Table1.[Field1], Table1.[Field2], Table1.[Field3], Table1.[Field4], Table1.[Field5], ([Field2] & " " & [Field3] & " " & [Field4] & " " &...