Search results

  1. V

    reset autonumber

    i did search the post and I could not find exactly what I was looking for. the autonumber does not really make a difference, it would just be nice to have if they were in sequence. Thanks for the link though. :)
  2. V

    reset autonumber

    just a small question. I have a database that assigns a unique 'audit id' to each entry. the ID is in the form of : DEA-[client prefix]-autonumber. Everything is working fine except the autonumber part. I have gaps in the numeric sequence. Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-8, DEA-ABC17...
  3. V

    Creating an input mask for a currency field.

    if you set the field properly in your table and the display on your form then they could enter in 125.145638547893 for all you care, access will round up or down accordingly. in the above case, the field in the form and in the table will show $125.15. This will be done right after they enter in...
  4. V

    simple record navigation problem

    Hello, I have a little problem and do require help in fixing it. I am only 3% away from finishing the database (due today) but have a little bit of a problem on my hands. here it is: I have a counter on my form that tracks which record is currently being viewed. the code for the counter is...
  5. V

    delete problem

    well, I am off work now so if I do not reply do not take it personally. I will try to check the forums from home, otherwise, I will be back tomorrow morning. THANKS
  6. V

    delete problem

    I will. If you are looking through entires for a client, who has five different entries in my database (1 client, 5 facilities) and you realize that you need to get rid of one of those facilities then you would use the delete button. The delete button DOES work but when it gets rid of the...
  7. V

    Records incorrect when new records added in other form

    your best bet would be to throw in a refresh or me.requery command into your code...probably upon close. I cannot be too sure of where you would put it because I need to see your database to do so. Your problem is that the data is not writing to the table right away. try putting in a refresh...
  8. V

    delete problem

    Well, last really means the last audit that was before the one that got deleted. I don't really care which one shows, as long as I get any audit that belongs to that client (in this example MICROSOFT). If there was only ONE facility for microsoft and that was deleted (making the database...
  9. V

    Creating an input mask for a currency field.

    if you set the field properly in your table and the display on your form then they could enter in 214.145698547893 for all you care, access will round up or down accordingly. in the above case, the field in the form and in the table will show $214.15. This will be done right after they enter...
  10. V

    delete problem

    well, new york would appear since it is now the 'last' facility for that client. I don't really care about which one would appear (whether it would be the first one, california; or the NEW last one, NY). As long as it shows ANY facility for that client, then I am happy. I really appreciate...
  11. V

    delete problem

    Ok, now I see why you were misunderstanding me I have a client that has 5 facilities, when I hit the delete button, I want one of the other facilities to appear, not a blank form. In a nutshell, the way the database works is as follows: There is a main form called "audit info" this form...
  12. V

    delete problem

    well, I took the code that you gave me and implemented it into the command button. The button still deletes records. (so that is ok) Here is an example of the porblem at hand: I have a client that has 5 records, I use my 'search form' to go to that clients records and look through them...
  13. V

    delete problem

    thank you for your response and for all of your trouble. IT STILL DOES NOT WANT TO WORK :cool: Its these little things that really get to me. it seems like such a simple problem. If you are deleting the last record, do not show an empty one, show the preious one for that client. if the...
  14. V

    delete problem

    the form name is "Audit Info" and it is bound to a table named "audit info"
  15. V

    delete problem

    unfortunatley I cannot upload the database online. Sorry about that. I am now trying to do the following: DELETE BUTTON: Private Sub command271_Click() On Error GoTo Err_cmdDelete_Click Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "[client name]=" & "'"...
  16. V

    delete problem

    I am sorry, can you please elaborate
  17. V

    delete problem

    thanks that works quite well. There is one more problem that I did realize though, I was hoping you can help me out with it. WHen you are deleting the last record (ex: 3 of 3) it does not cycle back to record 2 of 2 (or know as 2 of 3 before the deletion). I am trying to code it in such a...
  18. V

    delete problem

    Am I doing something wrong... Is my code wrong or is it just a stupid problem. The error that I get when you delete the last record is 'no current record to display' or something of that sort. Is there a way for me to tell the program that when the last record is deleted, go to main menu or...
  19. V

    delete problem

    any ideas???
  20. V

    delete problem

    delete code: Private Sub command271_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Are you sure you want to delete this Audit and its associated measures?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand...
Back
Top Bottom