Search results

  1. C

    how to

    Thanks for looking I have a main form
  2. C

    Cannot retrieve unique records

    the way i would do it is create an unbound form with a text box. the text box would be the information that i want updated. then on the update query make the update to section refer to the unbound form. put a control on the form that runs the update query. ash
  3. C

    Cannot retrieve unique records

    create an update query. To update multiple records at once. Ash
  4. C

    odd report problem with VBA

    Sounds to me it is a problem with sort fields on report. Have a look at the way the data is being sorted in the report. Ash
  5. C

    subforms and null records(ish)

    a parameter box is linked to an sql staemnet either in vba or the form is generated from a query. With the name field is it set to lookup a table that no longer exists or is the sql statement you are using have a criteria associated with it. Ash
  6. C

    Conflicting requirements between popup forms and main form's fields

    found easier way. Private Sub Form_BeforeUpdate() on error goto err_form_beforeupdate If IsNull(fieldname) Then x = MsgBox("fieldname is required") cancel = True Me.fieldname.SetFocus Else End If Err_form_BeforeUpdate: goto exit_form_beforeupdate exit_form_BeforeUpdate: Exit Sub...
  7. C

    Conflicting requirements between popup forms and main form's fields

    sorry i actually tested code and there is a problem. will get back to you. on form before update is record change. Ash
  8. C

    Update form everytime database is opened

    where do you want the current date displayed? Ash
  9. C

    Conflicting requirements between popup forms and main form's fields

    Change the required field to no. Then on form close and change_record events add a validation rule eg Private Sub form_Close() On Error GoTo Err_Form_Close Dim strTblName As String, strValidRule As String Dim strValidText As String Dim intX As Integer strTblName = "tablename"...
  10. C

    Bypass the OnOpen

    when you want to enter a ne3w record do you open that form form the switchboard. If so just set the properties on switchboard to open that form in addnew. And delete the on open event. If not you can use the is loaded function. eg on from_open () if isloaded (parentform) then...
  11. C

    Help with access form

    thats because you have set the command button event to click. Go to anyother form and you will notice that when you hit enter on a field it goes to the next field. To rectify this put the same code on password (enter event) as you have on the command button. That way no matter wether the user...
  12. C

    Updating Unbound textbox on form per record viewed

    sorry mad a mistake on text box properties set control to "=[firstname]&" "&[lastname]" don't useuotation marks Ash
  13. C

    Updating Unbound textbox on form per record viewed

    ok had a play and solverd prob. on text box properties set default value = [firstname]&" "&[lastname] it worked on my test. Ash
  14. C

    Continuous forms and querying another table

    does your form have the field id_componentName. If so make the where criteria [forms].[formname].[id_componentname]. It will fire the query based on form. Ash
  15. C

    no current record - close form

    if you zip the db and then go to advanced reply there you can attach the zip file. ash
  16. C

    no current record - close form

    post your db and i will have a look Ash
  17. C

    Getting Data from one Form to another

    You should search the forum to see if the question has been asked and answered. I found it here http://www.access-programmers.co.uk/forums/showthread.php?t=65398&highlight=input+data+calender Ash
  18. C

    Calulate Time on a Button Event

    You should search the forum this question has been asked and answered many times. Ash
  19. C

    Continuous forms and querying another table

    can you post your db so i can have a closer look. ash
  20. C

    Customer report, showing all orders by that customer

    set the sorting groups on the report you can do this through the wizard. It will even give examples. Ash
Back
Top Bottom