Search results

If anyone fionds an answer please can they post it, as I have just come across the same problem. Thanks

Try Choose([Select 1: Core Stock 2: Not Core Stock : ],"Core Stock","<>'Core Stock'")

This sets the field BO2 to zero if BO1 is zero, IIF( IIf(IsNull([BOI]),0,[BOI])=0,0,[BO2] ) This sets the field BO3 to zero if BO2 is zero and BO2 to zero if BO1 is zero, IIF( IIF( IIf(IsNull([BOI]),0,[BOI])=0,0,[BO2] )=0,0,[BO3] ) The " in the code my set the filed to a string so check if...

I shoulsd have said the before update event is on the lookup control not the District!

I have never tried this but it should do what you want. neileg is correct in both his last comments. In the lookup. Rowsource "Select zip, district from tblLookupZips" Column Widths 1.5cm;0cm Bound Column 1 On the Before Update event District.SetFocus District.Locked = False...

I think the code is probably beyond my 10 years experience!!! If you can add a range for each Group so that you can link where Handicap between MinRange and MaxRange that will help! SELECT tPlayers.Name, tPlayers.HCap, tGroups.group FROM tPlayers, tGroups where tPlayers.HCap between...

I understand your reluctance to get into a rewrite of security on workgroups. It is bad enough on the first time around! I am still unsure why you can't lock the lookups to the tables as uneditable. I have an application with workgroup securtiy which has lookups which cannot be edited by anyone...

post your queries and we can look at them.

The problem lies in the lookups on your front end. It is there that you can dictate what can be edited or locked.

Grouping You need to add grouping to your first query but port it so we can look at it, more closely.

Think Backwards In the code build a recordset RS with this query Select * from tGrades order by tGradeName desc This will give you D,32 as the first record. You need to add a field for grade to the player to make it simple; pGrade Then run a commad to update the pgrade for the players and...

In your query add for each result prior to summing a catch for null vales. NZ(Variant, reslt if null)

In the form properties set Auto Center = True Auto Resize = False If you make the forms all the same size then they will appear in the same place on screen for each user.

Missing an else Not sure if it is relevant but If you have an If...then then I think it is always wise to have an Else before the final End if You are missing one. This shouldn't matter but I as a possible it may fail there. The other suggestion is that after you have set the new focus the...

Inside your letter add a word mergefield { IF { MERGEFIELD CCFieldName }<>"" "Satement Here" ""}

Master to Child Essentially you need to bind the subform to a query on the main data. You can then link the form to Form1 with Master and Child. Does Form1 have just 1 record from the Table1 or if is there more than 1 record returned, why do you not bind it to a query? This way you won't need...

ActiveReport From my reading I think there is a way to Export the ActiveReport to a snapshot file. You would do this immediateley after the OpenReport bit. BUT I have no idea how to do it. Sorry, but I'll track this as I could do with knowing!

Link Master to Child Have you linked the forms with CustomerID (NB Text box Name not fieldname)

Thanks Thanks for the help. Treason - Yours works fine for text only but this is an HTM document. TPKStock - Yes HTML tags get printed, with Traeson's the send keys bit is an option, but ugly. GHudson - API looks perfect and I'll try it it. I, of course cheated, and used Word...

Gave up Used this instead Select EventID from Events where CDATE(Format(EventDate,'dd/mm/yyyy')) Between CDate([forms]![frmSearchEvents]![StartDate]) And CDate([forms]![frmSearchEvents]![EndDate]) as trhe queryDef.SQL