Search results

  1. R

    exporting access 2007 to excel 2007

    Hi all I have my database working correctly. I would like the user after entering all data into the form and viewing the report. Export it to excel and then to delete all data from the form in order to start entering new information. Is this possible to do Cheers rob
  2. R

    Using the same value in a field

    Sorry to be a pain, but now the user is enable to alter the combo box. I need the user to be allowed to add to the combobox, as there will be locations that are not on the list.
  3. R

    Using the same value in a field

    Thanks for the help, i've cracked it using table query. Thanks Rob
  4. R

    Using the same value in a field

    I have looked at both threads, and copied the text into my form, but still the fields are not continuing to display the text. I have attached my Database, please tell me what im doing wrong
  5. R

    Using the same value in a field

    Thanks really appreciate it
  6. R

    Using the same value in a field

    Here is my Database if it helps
  7. R

    Using the same value in a field

    Tried this and it still does not work Private Sub LOCATION_AfterUpdate() Me.LOCATION.DefaultValue = """" & Me.LOCATION & """" End Sub
  8. R

    Using the same value in a field

    This is what I entered, but it didn't work Private Sub LOCATION_AfterUpdate() Me.LOCATION.DefaultValue = Me.LOCATION End Sub Any ideas
  9. R

    Using the same value in a field

    I put the code in the combobox afterupdate section, but on running form view the field remains blank after entering the first location. I would like the value to remain in the combo box until the user changes the locatio. Thus reducing the amount of data to be entered by the user. Thanks
  10. R

    Using the same value in a field

    Unfortunately this doesn't seem to work. Any other ideas
  11. R

    Using the same value in a field

    Hi I have a database where the user enters the location from a combo box, but when the user goes to enter the next record the location is blank. How do I get the field to show the previous location until a new one is selected then that becomes the default. Thanks Rob
  12. R

    Incrementing a field

    Thankyou Thats was driving me mad, so many people telling me different things. Thanks Again Rob
  13. R

    Incrementing a field

    Hi I have a field in my Table called EQUIPMENTNO and I would like the user to enter a number in the form field EQUIPMENTNUMBER. After all the associated dater is enter the user presses new record and I would like the Equipment number be incremented by one and displayed in the form so the user...
Back
Top Bottom