Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: neilmcmor
  • Order by date
  1. neilmcmor

    forms

    Is it possible, in a continuous form, to have the blank record, (next available record), to appear at the top of the records when opening the form.
  2. neilmcmor

    Non-enabled form setting

    Nevertheless thnaks to all.
  3. neilmcmor

    Access crashing

    I have a form that when a new record is added works fine. However when an existing record is edited the whole program folds, (the usaul microsoft message about sending error details occurs then program shuts down.) I have tired Compact and Repair but to no avail. The form was working well until...
  4. neilmcmor

    Non-enabled form setting

    The form is based directly on a table Missinglinq. But thanks ZmrAbdulla you solution worked it appears.
  5. neilmcmor

    Search Criteria

    I have a button that when clicked on the form allows the user to type a surname and searc the database. however at present the full surname must be typed correctly. I would like for it to be able to search with only part of the surname being entered. How could I change the following code to...
  6. neilmcmor

    Non-enabled form setting

    I have a form with all fields enabled option set to No. The user must be allowed to click a delete button to delete a record but cannot edit or add records. Is it possible to prevent the fields from greying out in this situation. I have tried by enabling the fields and instead setting the forms...
  7. neilmcmor

    Access dates

    I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?
  8. neilmcmor

    Form error trapping

    Thanks guys. sorted now
  9. neilmcmor

    Form error trapping

    I am struggling to get my head around error trapping. I stuck this bit of code in the Forms VBA to get error codes but get nothing returned. The form is called Prisoner_Details. Can anyone help Public Sub Form_Error(DataErr As Integer, Resonse As Integer) MsgBox DataErr End Sub
  10. neilmcmor

    VBA help

    Excellent. thank you
  11. neilmcmor

    VBA help

    I am a complete novice at VBA. I have a command button on a form, (PrisonersBySurname), that has the following code attached which opens a new form, (Prisoner_Details). would like to add code that closes the original form when the new form opens. Any ideas? Private Sub...
  12. neilmcmor

    Access Form resize problem

    Firstly is it possible to open 2 forms by clicking one button on another form. Secondly is it possible to open the 2 forms so they do not maximise and instead sit side by side to be viewed at the same time. I use a macro on the OnLoad event of the parent from to maximise it when it opens.
  13. neilmcmor

    string manipulation

    Thanks genomon.
  14. neilmcmor

    string manipulation

    I have a field in a table that contains postal codes in the uk in the form ab39 9. I would like to be able to trim the space from the record so it reads ab393. The space is not always the fourth character though. Any ideas?
  15. neilmcmor

    Form fields

    Well missingling over and over we hear the piece of advice “Don’t make assumptions!” What a grossly over-simplistic piece of trite. We all make assumptions every second of every day. If we had to test every single assumption, we would be rendered hopeless. Is that really your boss, or is it an...
  16. neilmcmor

    Form fields

    I have a form of clients details. Each client has a Client Number. When I open the form it is designed to open blank in all fields. However if I type in an existing Client Number the rest of his details do not automatically fill the fields. I assumed they would do. Can anyone explain why? The...
  17. neilmcmor

    Help with form event

    Otherway around Lespaul. Exit the form and go to the sub
  18. neilmcmor

    Help with form event

    I have a Form that uses a BeforeUpdate event to offer the user the chance to undo changes before saving. The code below works however I do not wish the form to clear its contents once the user clicks yes as I would like the user to have the ability to then go onto add data into the subform...
  19. neilmcmor

    Missing Link

    Can someone explain to me as I seem to be the missing link. I open a form which is linked to 1 table. The primary field is named Spin. My form opens blank which suits me. However I thought if I entered the spin vlaue for an existing record the rest of the fileds would automatically fill out on...
  20. neilmcmor

    Calendar

    Thanks both PHV & PoppaSmurf

Part and Inventory Search

Back
Top