Search results

I have a form with a sub form the sub form has multi records ie: Main form Client details x 1 Sub form Client orders x 20 At the moment when i click next record it just goes to the next sub record and doesnt seem to go anywhere until i click 20 times on the next button on the main form, this...

I have a present a Toggle button that changes from AT RISK to NOT AT RISK using the following VB =========================== Private Sub Form_Current() If Me.At_Risk_Register.Value = True Then Me.At_Risk_Register.Caption = "AT RISK" Else Me.At_Risk_Register.Caption = "NOT AT RISK" End If End...

The VB closes the form and opens another, but I have a ID on the form [frm_HDUITU_followup]I am Closing. I want to go straight to the same ID on the form [frm_MainDischarge] that I am opening. ============================================ Private Sub DISCHARGE_Click()...

I have tried this but come up with an error 2501 every time.......... Any Ideas Private Sub Print_Record_Click() Dim strDocName As String Dim strWhere As String strDocName = "Rpt_followup_visit_small" strWhere = "[OutreachID]=" & Me!OutReachID DoCmd.OpenReport strDocName...

I am trying to get a button to exit a form then open another form at the same time change a yes/no toggle. Is this done in the query and from or just in the form. [This message has been edited by johnhobbis (edited 04-15-2001).]

I have a subform with a field called "Visit_Number" the subform has a related childfield to the masterform OutreachID Master(autonumber) OutreachID child. I need to add a record to the subform that keeps the current OutreachID (master) this works ok. BUT I need the Visit_Number field to...

ABBY Can you send me the examples again, with them attached. Got your mail but no attachment? Regards john@hobbis.karoo.co.uk

I have a print button on a SubForm and when pressed it prints all the Records in the subform... Any idea who to resolve this. John H.

Understand how to post now. lol.

ABBY - Thanks for that little Pearl........ Only Problem is that when I go back to the record the button is blank and doesnt display the AT RISK or NOT AT RISK ? and the each record in the form has the same state AT RISK or NOT AT RISK Do you Know how you can change the background colour of...

Hi I am trying to toggle a Yes/No state, so that Yes has text "AT RISK" on the toggle and NO has "NOT AT RISK" text I have done this Expression: which looks at the state and show a box when YES and disappears when NO: Private Sub At_Risk_Register_Click() If Me.At_Risk_Register.Value = True...

Printing a Record from a Sub form with the standard Print Record Button, Prints all the Records not just the current one. Can Anyone give me a hand... ??

HELP PLEASE -- Mr Novice. 1.....I have a True/False field that I need to change on a form to be a Red Button (text) or Background ON TRUE Green Button (text) or Background On False. The Action of changing the state of the True/False statement to automatically a report of records with a TRUE...

Hi i hope someone may be able to help I have field called Discharge time which needs to be [Discharge time] hh::mm dd/mm/yyyy in a table called TABLE1 then an other field called [Time used] hh:mm dd/mm/yyyy in a different table called TABLE2 I need to pass the "time difference" between the 2...