Search results

Thank you for the birthday message Tess. Been a while since I logged on here and only just got the message! Cheers

Thanks Bob, glad to pop in - have had a 'proper' job since Jan 06 and unfortunately have not had the reason to call in as my work time is now 100% hands on, hurting innocent individuals on the NHS, not much chance to 'play' with access! I still think that a Krypton Factor observation round...

Hi Guys, Bloody ages since I've been here - glad to see so many of you still holding the fort - Doc, Rich, SJ, Bob (rise to fame eh?) to name but a few. Also - still see the same basic questions repeated on the front page!!! so......... How bout an observation quiz for all to complete on...

Hi Ade, I'm not 100% clear what you are trying to do but can you not do this with a simple parameter append query?

It is still a bad idea as you can export the data via parameter queries. Just use either a lookup table to identify which record groups you want to filter on or hard code it. A lookup table would be better.

try Private Sub Combobox1_AfterUpdate() Me.Textbox1=me.Combobox1.Column(1) End Sub

Yes, sorry Pat. Reviewing the thread I realise I had actually said that the structure was ok but then redeemed myself in the data structure in the demo! Thanks for the correction :o

them upside down

If you are only using the join to filter by N-02 codes, make sure that the recordset only includes the fields that you want to update. You do not need to use a query in the main query as I'm sure you will be able to employ the same filtering by simply using the tables in the QBE grid. Can you...

rained so much

OK DAO Version (Still getting to grips with ADO :cool: ) Public Function fnTotalAlternates (strOddEven as String) as Double Dim MyDb as DAO.Database Dim MyRs as DAO.Recordset Set MyDb = currentDb() Set MyRs = MyDb.openrecordset(Your Recordsource) Select Case strOddEven Case "Odd" do...

up teaching at

In a nutshell: Create a functions, to sum your records eg fnTotalAlternates (strOddEven as String) Use a Select Case command to switch between odd/even. Create a recordset clone of the forms recordset step through every other record using the movenext method On Odds - move to the first...

Sorry, I misread your question and did not clarify my answer enough. The correct sytax would be =[Forms]![plainorderitemssubform].form![GrandTotal] - you don not need to sum this if you have already calculated this in the subform. Can you clarify what you are trying to show though as I'm a...

Do the totals calculation in the subform footer and then refer to this in the main report footer. ie Grand Total = Reports!MainReport!SubReport.Report!TotalsControl

ticklestick in hand

Try this =iif([net]>0,[net]*0.5,[net]*0.333)

Pat, from my impression, I think that mbentle wants the possibility of allowing people to take no only a course but selectively differing modules within that course structure. I agree that a junction table is necessary to establish a many-to-many relationship but how mbentle chooses to split...

Use the search and see what you come across - best way to learn new hints, tricks and tips. Get back if you are really stuck.

Providing you have a robunt link between your data and lookup tables, you could do this with a looping recordset to a) loop through all the counties b) use the county produced by this to power the criteria in your query c) Use and append query to add the data returned to the new table. Rather...