Search results

Ignore Previous Message PLEASE IGNORE THE THREAD, JUST SUSSED IT OUT - SSOOOO EASY! -NEIL

Hi. I am trying to use the treeview control in Access 2000 on a form. I have created the tree, nodes, bound to image list, etc, all this is fine. I need each node to make a different hidden subform visible when clicked. I can see no-where that I can put the code for this, like the onclick...

Yep, got it. I know exactly what you mean, and it makes sense to me. Thanks for putting me in the right direction with this! -NEIL

Thanks for that, but can you explain please?

Hi. Here is an expression in my query: incident: IIf([tbl_attendance].[att_st]=-1,"Street",IIf([tbl_attendance].[att_wk]=-1,"work",IIf([tbl_attendance].[att_illness]=-1,"Illness",IIf([tbl_attendance].[att_sport]=-1,"Sport",IIf([tbl_attendance].[att_si]=-1,"Self...

AfterUpdate : If Me. [TickBox] = True THEN Me.[DateField] = Now() Else If Me.[TickBox]=false THEN Me.[DateField]=null End If End If Me.Refresh The refresh is the key here I think. I think that the code above is the sort of way that it should work. Hope this helps!

Email me this and I'll have a look

If you want to set the value to a field in datasheet view, why not set the default value on the field property?

Instead of having a default scroll bar on a form (Horizontal), has anybody ever come across if it is possible to have two small command buttons (<) and (>) on the form in order to scroll left and right? If so, how did you do it? Thanks in advance, -NEIL

If you are getting 'Recordset Not Updateable', are you sure that the control source is not a query?

Hi again. Thanks for all your help, I have got it sorted now. I have done a query to do the calculation then 'DSUM''d an unbound text box and it works a treat. Thanks again, -NEIL

Thanks for your info. Is it possible for the DSUM function to calculate from 2 domains? The fields I need to calculate together are from two totals queries.

Hi. I have a function that runs a SQL SCRIPT to calculate a value from two other scripts: Public Function sql_risk_rating() Dim sql1 As String sql1 = "SELECT qry_cf_value.device, [cm_value]*[cf_value] AS Risk_value" & _ "FROM qry_cf_value INNER JOIN qry_cm_value ON qry_cf_value.device...

Hi and thankd for the reply. After looking around various sites, the problem is the dreaded 'carriage return', which creates a new line on the csv file when the data is exported. I am not sure what the Db is at the other end, most likely SQL. I have everything in place except for the export...

I am having probs in exporting a table as a CSV file. The file will be uploaded to a National Database. I am having problems that the National Database identifies when the user attempts the upload. The problem is that one of the fields in the table is a memo field. When the user who enters the...