DoMenuItem Error   

I am getting an error similar to the error where me and another user are 
modifying the same record.  But there was noone else modifying the record.

Below is the code where the error came from:

       DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, , 
A_MENU_VER20  -->> (this is where the error pops out...)
       DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_DELETE_V2, , A_MENU_VER20
       DoCmd.GoToControl "Date Received"

A little history about the application:

    a. originally written in Access 97, but I have modified the application 
several times until its current version which is Access 2003
    b. the current version of our access based application runs in MS Access 
as the front-end application and the back-end is in SQL Server 2005

More information about the problem:

    a. the current version of the MS Access-based front-end worked fine 
until we upgraded our SQL Server service pack from 1 to 2
    b. the early errors that came out after the server patch upgrade were 
from embedded queries performing updates, inserts, and deletes
    c. I solved the above problems by calling server stored procedures
    c. now the confusing error is this latest error where at the 
DoCmd.DoMenuItem line it caused a referential integrity check message
    d. i tried to update the DoMenuItem line to use the updated programming 
code but I still got the same error

Let me know if you guys/gals have some feedbackc.


Thanks,

Be

date: Tue, 8 Jul 2008 18:09:12 -0700   author:   Ben

Why is Access' tab transparent property not working in Vista?   

I have a form I'm working on at home on vista and in the office on Xp.  The 
Tab Control shows gray in the office but white at home.  In the office I 
switched it to transparent and set the detail color to a company color.  At 
home it's not transparent!  Also, there's no way to set the tabs background 
color!

date: Tue, 8 Jul 2008 19:08:00 -0700   author:   IMGuido

Re: Why is Access' tab transparent property not working in Vista?   

Is there a difference between these 2 machines in the Use Themed Controls 
setting?

It's under:
    Tools | Options | Forms/Report.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"IMGuido"  wrote in message
news:3033759C-BA2D-4188-AF94-20CF46483CA6@microsoft.com...
>I have a form I'm working on at home on vista and in the office on Xp.  The
> Tab Control shows gray in the office but white at home.  In the office I
> switched it to transparent and set the detail color to a company color. 
> At
> home it's not transparent!  Also, there's no way to set the tabs 
> background
> color!

date: Wed, 9 Jul 2008 12:48:58 +0800   author:   Allen Browne lid

Re: Why is Access' tab transparent property not working in Vista?   

That fixed it!  You the man!!!!  Thanks!  If you're ever in Washington DC, 
remind me I owe you a beer!

Mark Ginesi

"Allen Browne" wrote:

> Is there a difference between these 2 machines in the Use Themed Controls 
> setting?
> 
> It's under:
>     Tools | Options | Forms/Report.
> 
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> 
> "IMGuido"  wrote in message
> news:3033759C-BA2D-4188-AF94-20CF46483CA6@microsoft.com...
> >I have a form I'm working on at home on vista and in the office on Xp.  The
> > Tab Control shows gray in the office but white at home.  In the office I
> > switched it to transparent and set the detail color to a company color. 
> > At
> > home it's not transparent!  Also, there's no way to set the tabs 
> > background
> > color! 
> 
>

date: Wed, 9 Jul 2008 05:58:01 -0700   author:   IMGuido