Search results for query: *

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...

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 :(

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!

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...

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...

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...

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...

:) 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

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...

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...

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 =...

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...

Thanks so much - was totally looking right past it!!

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...

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

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?

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...

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...

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...

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...