Recent content by liddlem

  1. L

    Reference fields on a form using a variable

    Ah - after some testing, I found that its not about the variable, but rather about the values in the fields. If I change my code to this, then I am getting the expected result. For i = 1 To 6 CritFld = "Criterion" & i MaxFld = "Max" & i ' ####### THE FOLLOWING LINE WAS CHANGED...
  2. L

    Reference fields on a form using a variable

    I have a form that contains fields named Crition1, Criterion 2 .. up to .....Criterion 6 (And also Max1 to Max 6 The form is being used in continuous form mode. In the records Before_Update event, I want to ensure that IF the user has typed text in the Criterion field, then there must be a...
  3. L

    Pass subform reference to a module

    Thanks ArnelGP- Thas EXACTLY what I was looking for. My mistake is that I was not using 'With FORMS' With Forms![navigation form]![navigationsubform] ![Label0].Caption = lbl1 ![Label1].Caption = lbl2 ![Label2].Caption = lbl3 End With Thanks for your assistance.
  4. L

    Pass subform reference to a module

    Thanks for your replies. I am only working on my DB over week-end, hence my late response. Pat: My function is in a module apart from the form, so 'Me.' should not apply? I have tried to update a caption in my form as follows' FrmName![Label2].Caption = fPath But I'm still getting a 2465...
  5. L

    Pass subform reference to a module

    I have a few Navigation forms - which obviously have subforms in them Each subform processes data and I want to update each subform in a similar way.(but contained within a Navigation form) To do this, I have put common code into a function and then have the function update the relevant subform...
  6. L

    Activating a tab in a navigation subform

    Nice try arnelgp - that's and angle that I hadn't thought of. Unfortunately, the solution hasn't worked either. Sorry = arnelgp, it seems I lied to you. The code work, provided that I am not in the editor and trying to debug it. If I am in the editor, then the sendkey line inserts another blank...
  7. L

    Activating a tab in a navigation subform

    I am busy creating a bespoke markbook for a school. I have a form (Called Frm_SubjectSetup) On Frm_SubjectSetup is a navigation subform (Default name of NavigationSubform) Each of the tabs is named 'Term 1', 'Term 2', 'Term 3' and 'Term 4' respectively And naturally, each tab has its own...
  8. L

    Wait for query to complete

    I am trying to update my address table using four separate queries. I call each query from a docmd......thus DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_001" DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_002" DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_003" DoCmd.OpenQuery...
  9. L

    Using SQL and Stored Procedures

    Hi All - Thanks for the input. Let me try answer each of your comments in order. Ranman256 : For me, this exercise is about 2 things. 1. Learning how to use SP's (and functions) on a SQL server. (I presume that if/when I convert my front end to a web platform, that I will need this skill?) 2...
  10. L

    Using SQL and Stored Procedures

    Hi Pbaldy - Thanks for the suggestion, but I don't know how to return the records for an SP. can you point me in the right direction please.
  11. L

    Using SQL and Stored Procedures

    Hi All I am trying to get my head around using stored procedures in SQL Server On my form, I have a button that SHOULD add students from a specified formid(which is a combobox) The following is the underlying code. Private Sub Btn_Add_Studs_By_Form_Click() Dim qdef As DAO.QueryDef Dim err_msg...
  12. L

    synchronised movements

    Ahh - I found it DoCmd.GoToRecord acDataForm, "B", acNext
  13. L

    synchronised movements

    Hi all I am converting data from one (badly designed) db to a new structure. I have two forms that SHOULD represent the same data (but in a different format/structure)....however, I have either created new records somewhere or I am missing some records from my source for some reason I...
  14. L

    Form locked while running code

    Hi All I have a button on a form that runs a series of queries when pushed. I would like to display to the user which query is currently being run. Just before each query is run, I issue a me.Info = QryName The problem is that the form 'greys out' shortly after the process begins and the textbox...
  15. L

    Set BackColour using dynamic fieldname

    Thanks for your concern Mark_ The NEW system will require the legal names that (once the record is saved) will be set in stone. The PREF names and SKIN names will be available to change as they wish. Furthermore : 1. Users will not be able to DELETE records. They can only mark them as obsolete...
Top Bottom