Search results

It just displays name#, i have copied and pasted the text as written above ????

I would like to display a copyright message in the corner of a form, which will state Copyright Pb 2007 - "current year" so that i dont have to update the thing every 1st of January. Is this possible?

Thanks that works great

Ok have put that back now get an error message Next without For ?? This is the code i have in place Private Sub Toggle88_Click() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showx" Then ctl.Visible = Me.Toggle88 Next ctl End If End Sub Im pulling whats left of my hair out can...

i get the message Compile error For without next

Database too large to include even zipped . sorry

Have changed to a toggle button, can you tell me what the code should now read for the on click function I have tried Private Sub Toggle88_Click() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showx" Then ctl.Visible = Me.Toggle88 End If End Sub but it dosent work

I currently have a command button on my main form, and am trying to get a list of supplimentry questions to appear when i press the command button. Currently the code i use is Private Sub cmd_nds_Click() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showx" Then ctl.Visible =...

Thanks Chris that worked a treat

I have a table called weeknumber in which i have 3 fields. Field one is weeknumber and contains a list of numbers 1 - 52, field 2 is called fromdate and contains a date to define the start of a week, field 3 is called todate and contains the date that defines the end of the week. What i am...

I currently run a database which gets the name of logged on users using the following script. Option Compare Database Private Type USER_INFO_2 usri2_name As Long usri2_password As Long ' Null, only settable usri2_password_age As Long usri2_priv As Long usri2_home_dir...

The majority of records will have a null value for the check box and its is only occasionally that the supplimentry questions are needed. thast why they remain hidden until the check box is chosen. I dont understand why, by binding the box the system crashes.

I have a form which contains an unbound check box, when selected several hidden questions appear due to the code below : Private Sub Check58_AfterUpdate() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showd" Then ctl.Visible = Me.Check58 End If Next...

Thanks Bob that worked brilliantly, could not have done it without you

Thanks yet again one last probl;em to solve then i will leave you in peace i promise. If i tick the derailment box, the questions appear and the answers are saved, no problem. if I then go back into that record at a latter time, the tick i placed in the tick box has disappeared and the questions...

Thanks for that Bob, however i need to make it so that the questions from the subform only appear when the has there been a derailment box is ticked, is this possible?

Thanks, enclosed is the database as you will see from the neqw event button, you open the input sheet, there are two buttons on the derailment and points run through, these open subforms which are the ones giving me grief Thanks again

Thanks for that but as a relative novice, you have lost me, is there a laymans way of explaining how i put the controls on the main form?

I have created a form which when one particular box is ticked opens a subform, the subform has several tick boxes which can be populated depending on answers received. In the subform i have a command button which runs a macro that saves the record to the main table, this is where i think i am...

The subform has been designed but shows nothing, am happy to forward entire database, however not in the open forum as it does contain live information.