Results 1 to 10 of 10
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Case for in case field corrupt

    I have a situation where sometimes a field becomes corrupt (at least on the particular record anyway) and if it tries to execute code I get a bug error because the data is null I guess or can't write to it.

    Images to show:
    Click image for larger version. 

Name:	Capture1.PNG 
Views:	10 
Size:	6.3 KB 
ID:	17610

    Click image for larger version. 

Name:	Capture2.PNG 
Views:	10 
Size:	4.8 KB 
ID:	17611 <-The field


    Click image for larger version. 

Name:	Capture3.PNG 
Views:	10 
Size:	4.0 KB 
ID:	17612

    The bit of code that normally works is highlighted.

    I'm hoping in a situation like this (and this field does fruitcake a lot) can be avoided in VBA so if the error occurs I can move around it. Any suggestions?

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Check your Client Settings and see if it is set to Shared, Edited Record. Also, per form design, take a look at your record locks.

    HTH

  3. #3
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by burrina View Post
    Check your Client Settings and see if it is set to Shared, Edited Record. Also, per form design, take a look at your record locks.

    HTH
    It would be shared, sever people access it together - however occasionally I get a fault which causes problems when code tries to execute.

  4. #4
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	17.5 KB 
ID:	17637

    These are the current settings - not sure what I should be changing. There are more than 5 users at any one time accessing the same backend

  5. #5
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    What are the form settings where the error is occurring? Have you tried re-creating the form. NEVER copy and paste when debugging, you can copy over the error as well.

  6. #6
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by burrina View Post
    What are the form settings where the error is occurring? Have you tried re-creating the form. NEVER copy and paste when debugging, you can copy over the error as well.

    What form settings would I be looking for?

    Also I have changed the setting to "Edited Record" - is that ok?

  7. #7
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I don't have a clue, it's your db. Under what conditions does the error occur and can you duplicate it? Does the error happen for all users or just one?
    Debug, track it down.Form settings to check are of course under the data tab. Recordset Type, Record Locks

  8. #8
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by burrina View Post
    I don't have a clue, it's your db. Under what conditions does the error occur and can you duplicate it? Does the error happen for all users or just one?
    Debug, track it down.Form settings to check are of course under the data tab. Recordset Type, Record Locks
    Yeah I have been trying to track it down. It has one user with the common error too although I think she is using features the others aren't.

    To be clear the form opens as an instance of the original form - it works fine etc except for that error on that memo field.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	7 
Size:	10.3 KB 
ID:	17638

  9. #9
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    What are the additional features and does the error occur without the filter? Try one by one and rem out any possible offending code and or references.
    Unsure what you mean by an instance of the form? Is it the same form or another form?

    I have no further suggestions besides debugging.

  10. #10
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    I've found the fault - hopefully the debugging I have done will fix the problem however out of curiosity

    Setting "Edited Record" - leave it on this if there are multiple users with their own frontends??

Please reply to this thread with any new information or opinions.

Similar Threads

  1. CASE in SQL
    By alka in forum Access
    Replies: 12
    Last Post: 11-27-2013, 04:15 PM
  2. Replies: 2
    Last Post: 02-12-2013, 07:27 PM
  3. Replies: 5
    Last Post: 10-23-2012, 03:55 PM
  4. Select Case using query field
    By focosi in forum Programming
    Replies: 4
    Last Post: 08-15-2011, 11:00 AM
  5. Is there a way to force a field do be upper case?
    By newtoAccess in forum Access
    Replies: 1
    Last Post: 11-28-2010, 04:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums