Search results

  1. C

    Error 2585 on closing a form

    Worked it out now! Had a look through a book and a quick google to find the ascii code for enter and I have it! Private Sub List_All_Contacts_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then Cmd_Open_Contact_Click Else Exit Sub End If End Sub I should have...
  2. C

    Error 2585 on closing a form

    Bob, Thanks for the reply. This is where I've got confused! On my list box as well as the button / double click opening the record I want an 'enter'or 'return' to select a record if they decide to use the keyboard to scroll down using there arrow keys. In my lack of knowledge with Access I...
  3. C

    Error 2585 on closing a form

    Yep, just tried it again as I've added the 'doEvents' since I tried that one. Its strange that it only happens on the 'on enter' event for the list box but 'double click' event works fine?
  4. C

    Error 2585 on closing a form

    I have a list box (In a pop up form) where I can select a record and open it in the management form for viewing / editing / etc. Below is the code thats works for the double click event (on the list box) and a command button I've added to the form. Dim strWhere As String If...
  5. C

    Filter a listbox in pop-up form from another form

    Thanks for the help, Its opened a whole new world of searching / filtering! will also make my life easier too :) I think I'll be using the queries option for now until I get me SQL up to scratch! Thanks Gents.
  6. C

    Filter a listbox in pop-up form from another form

    I've done it with a query now! works a treat Thanks Mr. B
  7. C

    Filter a listbox in pop-up form from another form

    Thanks for that, I've tried to do it that way now using a SQL statement but I'm not sure if I've got the 'formatting' correct for referencing a field on a different form? Heres the statement: SELECT AE_EmailAddress, AE_BusinessID FROM tbl_AdditionalEmails ORDER BY AE_EmailAddress Where...
  8. C

    Filter a listbox in pop-up form from another form

    I have a form where I enter in either Contact or business details, I can then add multiple email addresses to contact or business by updating a table with the additional email addresses and using the contact or business 'ID' of the record to associate them to email. (I hope I explained that...
  9. C

    Save Button Not working as planned

    Thanks I'll give it a try...
  10. C

    Save Button Not working as planned

    The form this is running from is a data input form for a single table, there's no links / queries to other table. I'm just trying to do a one form to do 'all' for my contacts, either add a new contact or update / view contacts. With your If Me.NewRecord then... Would that replace the "If...
  11. C

    Save Button Not working as planned

    Tried again with out the dirty save and if I edit / save its fine. If I'm adding a new record I get a error: Error 3021, no current record. Private Sub cmd_Save_Click() Dim Response, Msg, Style, Title Dim myLine Msg = "Once Saved Contact will be read-only to edit again you must click edit...
  12. C

    Save Button Not working as planned

    Did not realise that, Never used recordset bookmark before! I'll try to remove the 'dirty' Parts!
  13. C

    Save Button Not working as planned

    Nearly works, if I click on my add new button to add a new contact then click the save button it saves then goes to the first record instead of showing the current record just added. If I edit then save it works fine. I'm trying to get a single form to Add, edit, view contacts.
  14. C

    Save Button Not working as planned

    So Close!, On a normal save it worked (i.e. I opened the record, clicked Edit, made a change then clicked Save then Yes). If I was creating a new record it failed. I'm guessing that as the record had not been save it could not 'bookmark' it. Just so you can see what I did here's the code...
  15. C

    Save Button Not working as planned

    It Works! but How do i set the record to being read only so they can not make further changes? Just so your aware, I'm trying to open the forms as read-only so to edit it the have to actual 'click a button' so they are aware they are changing it! then once ave returning to read only so they...
  16. C

    Save Button Not working as planned

    Moved the 4 line to after the Me.Dirty = False part but it still goes back to the first record?
  17. C

    Save Button Not working as planned

    True... I'll adjust that part of the code. Thanks
  18. C

    Save Button Not working as planned

    Below is my code for a 'save' button. It works except for one element, When I click the button the message appears as expected, then saves the record as directed but when it returns to the form it goes to the first record? Private Sub cmd_Save_Click() Dim Response, Msg, Style, Title Msg...
  19. C

    Auto-Merge from Access to Word

    DaveN, This will be a little late for you I'm guessing but I have done the following on code, to be added to a button 'on click'. the word template has been set up for merging from the source db with relevent fields in the correct place. Private Sub Cmd_merge_to_word_Click() Dim strBusID As...
  20. C

    Table with links to other key ID fields?

    I have a working knowledge but in the past have always had other to do the work for me so I have a theory knowledge, I'm trying to gain best practice with-in access so I don't re-invent the wheel. I've taken a look at some of the examples but did not find one that meet what I was trying to do...
Back
Top Bottom