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!

Register Log in
  • Congratulations derfloh 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: *

  1. dmeyring

    Run-time error 2448

    hi Missinglinq, no on the SP3 for myself and the rest of the users... hi Aceman, the error doesn't pop up when I compile, and then I save the code in the compiled state before distributing to the users. The error does not happen consistently, but I tend to see it when someone has had the...
  2. dmeyring

    Run-time error 2448

    Rut-row...deployed the fixes discussed above to all of my users yesterday, but we are still getting the same 2448 error message. The database is split, but could this still be some sort of multiple-user conflict? anything relating to the network set-up of my users? stumped :(
  3. dmeyring

    Run-time error 2448

    Doh! Thanks AceMan & genomon! I'm testing out both solutions starting with correcting the ME. Unfortunately my error is a bit slippery and doesn't consistently occur, but thank you both for the place to start!
  4. dmeyring

    Run-time error 2448

    I have a 20 user split database that is experiencing a problem with a line of code that previously worked well. The line appeared to be working, but since more users have been added it is triggering this error message when the form is opened: Run-time error '2448': You can't assign a value to...
  5. dmeyring

    Disable Default Access Form Error Messages

    Success with a little modification...I pasted what you haad above, but it was giving me additional Access error msgs after my error message would display. So I tried this and it worked: Private Sub btnClose_Click() Dim msg As String, Style As Integer, Title As String Dim nl As String, ctl As...
  6. dmeyring

    Disable Default Access Form Error Messages

    I'm pretty sure i've got the code right in Form_Load and in Form_Unload, but there may be something wrong with how I've got it implemented in btnClose_Click. (I use btn instead of cmd, but it's consistent through all the code) I'll paste all three below: Private Sub Form_Load() AllowClose...
  7. dmeyring

    Disable Default Access Form Error Messages

    Did exactly as you suggest, the only remaining issue is that now: user clicks close button, my custom error message is triggered, user clicks ok to that message, then the Access closes entirely and the incomplete entry is allowed to be recorded. It seems like there's got to be some sort of...
  8. dmeyring

    Disable Default Access Form Error Messages

    :) I just finished implementing that FAQ's solution, works great to close via my Close button and by no other method, but I'm still getting my custom error messge and then the Access error message after it
  9. dmeyring

    Disable Default Access Form Error Messages

    This is the code for the custom error messages, it is working well: (let me know if this is not the piece of code that you're looking for) Private Sub Form_BeforeUpdate(Cancel As Integer) Dim msg As String, Style As Integer, Title As String Dim nl As String, ctl As Control nl = vbNewLine...
  10. dmeyring

    Disable Default Access Form Error Messages

    Ok, so i changed this to: Private Sub Form_Error(DataErr As Integer, Response As Integer) Select Case DataErr Case 2169 Response = acDataErrContinue End Select End Sub I must definitely be missing something...This allows the user to click exit, shows my error...
  11. dmeyring

    Disable Default Access Form Error Messages

    Hello, I have a Access 2003 form that I've added some error handling code to the Form Before Update event that prevents the user from leaving required fields empty. The trouble is, when the user tries to exit Access while leaving a required field empty they receive two messages: The first =...
  12. dmeyring

    Performance question

    I have a database with 5 tables - there are no parent-child relationships between the tables, they all contain pieces of the same record. Each table has 10-20 fields. Is it better in terms of performance & understandability to keep them this way, or is there a better alternative? I could...
  13. dmeyring

    Vertical scroll bar for Memo field

    Thanks so much - was totally looking right past it!!
  14. dmeyring

    Vertical scroll bar for Memo field

    Hi there, On my form, I've got a text box "Other Services" which is a Memo field in my table. I would like the text box to display a vertical scroll bar so that the user can simply click on that to read through the displayed Memo field, rather than clicking inside the text box and using...
  15. dmeyring

    Multiple users updating a form concurrently

    I have 2-3 concurrent users, it is typically 2, but the possibility exists for 3.
  16. dmeyring

    Multiple users updating a form concurrently

    Is it possible to have multiple users in the same database updating the same form concurrently? What if the form uses auto-numbering? If this produces any type of error, is it possible to have a notify window pop-up if another user is already in the form?
  17. dmeyring

    Using If statement with Dlookup based on form entries

    Hmm, I think my problem may lie outside of the syntax. I have been testing the suggestions above, but am still getting no data when I only enter a SKU # Test 1- I started by going back to basics and changing all of the original Dlookups (based on two criteria) to the After Update event of the...
  18. dmeyring

    Using If statement with Dlookup based on form entries

    Also had a question for you on the Event type - would I put all of the Dlookups in the After Update event of the SKU field? We would want the field to autopopulate once SKU has been entered. I currently have this code in the On Exit of the SKU field, so that once SKU is updated and exited, it...
  19. dmeyring

    Using If statement with Dlookup based on form entries

    SKU is text, Sales Order is numeric. I get some compile errors with the first line of the If statement, by trial and error I am at: If (Trim(Sales_Order&("")) <> "") Then I receive a "Compile error: Type-declaration character does not match declared data type" which I'm guessing would refer...
  20. dmeyring

    Using If statement with Dlookup based on form entries

    I have a form that auto-populates 10 fields using a Dlookup in the got focus event of each field. The dlookup searches the "DNM TEST Form Query" query based on two criteria: Sales Order # and SKU. This works perfectly, but... the end user would also like 5 of the fields to autopopulate when...

Part and Inventory Search

Back
Top