Changing VAT rate from 15% to 17.5%.

[Arkle]

Hi everyone I'm a new UK member.

Last year I easily changed the Vat rate from 17.5% to 15% on our Access dbase.

However, since upgrading from Office 2003 to Office 2007 a few months ago I don't know my way around this software as well as I used to.

It used to be just a case of going into the system parameters and chaning from there but now I can't seem to make the % change work..

Any help greatly appreciated.

TIA.

Paul.

 

[jdraw]

Hi everyone I'm a new UK member.

Last year I easily changed the Vat rate from 17.5% to 15% on our Access dbase.

However, since upgrading from Office 2003 to Office 2007 a few months ago I don't know my way around this software as well as I used to.

It used to be just a case of going into the system parameters and chaning from there but now I can't seem to make the % change work..

Any help greatly appreciated.

TIA.

Paul.

What process did you use in the old database? Query, form ???

When you updated/converted to 2007, did you convert the query, form?

It's hard for us to guess what you're looking for.

 

[Arkle]

Hi, thanks for the reply.

As you can probably tell I'm no expert with access.

If I recall correctly, on office 2003 I went into the parameters and changed from 17.5% to 15% and the job was done.

I have been trying to do this again and now have one record showing 0% VAT and another showing 750% VAT so I am accessing the system but without much success.

Yeah... I know..

All previous records at 17.5% and 15% are okay.

 

[Arkle]

If I re-install office 2003 (I'm familiar with this version) and make the change I need and then re-install office 2007 will this do the trick?

 

[jdraw]

If I re-install office 2003 (I'm familiar with this version) and make the change I need and then re-install office 2007 will this do the trick?

I think reinstalling 2003 would be a drastic move. If you have converted the application to 2007, then - it would seem -adjusting the value in a table would be the appropriate action.

However, as mentioned in earlier posts, we have no idea of the code or table or process involved. Can you show some code? Describe the tables and exactly what you're trying to accomplish?

I don't have 2007, but if I had gone thru the trouble of converting to 2007, I wouldn't be thinking of reinstalling 2003.

 

[Arkle]

I think reinstalling 2003 would be a drastic move. If you have converted the application to 2007, then - it would seem -adjusting the value in a table would be the appropriate action.

However, as mentioned in earlier posts, we have no idea of the code or table or process involved. Can you show some code? Describe the tables and exactly what you're trying to accomplish?

I don't have 2007, but if I had gone thru the trouble of converting to 2007, I wouldn't be thinking of reinstalling 2003.

Thanks jdraw.

The only other thing I can think that I am doing wrong is that the dbase perhaps needs to be stored to a safe location and until that is actioned I am perhaps unable to effect any changes.

I'm no computer wizard, I'm actually a one man band who works in the constuction industry which may explain why I'm struggling with this problem.

Regards,

Paul.

 

[georgedwilkinson]

Try this: http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

Though you haven't really told us, my guess is that your code is disabled, a common complaint when moving to Access 2007.

Just so you understand, there is no such thing as a VAT rate parameter in Access 2007. That has to be part of your application. As such, nobody here will be able to answer any questions about how to change that parameter without your database in front of them.

Hopefully though, enabling the code as explained in the above link will get you what you need.

 

[gemma-the-husky]

As George has said, I cant see that getting rates of 0% and 750% is connected with your VAT change - it sounds more like an application error

You should know what your app does, and clearly it worked OK in the past - However, depending on what your business is, then just having a single rate of VAT may not always work correctly - you may need some sort of mechanism to set the VAT rate correctly depending on the date entered, in which case your system would need to hold multiple VAT rates

 

[georgedwilkinson]

Hey did this ever get resolved?

 

[Arkle]

Hey did this ever get resolved?

Unfortunately not.

I have had someone from live expert that has been working on the problem and hopefully it will be solved soon.

Many Thanks,

Paul.

 

[georgedwilkinson]

Any resolution yet?

 

[gemma-the-husky]

something like that will 9nly get solved by a quite substantial system rewrite, I would think.

I was amazed to see that even Sage Line 50 only appears to hold a single active VAT rate.

 

[vbaInet]

It could be a Format problem as well! Export some of your data to confirm.

I remember trying to programatically change between Percentage and Currency and got odd results.

 

[SOS]

This is one of those cases where the rate could be saved with the record so it could be recalled whenever needed and then the active rate set in a table and when new records are created the active rate applied.

Of course you could also do something like what Bob Larson has on his website (his sample shows mileage rates but could be used for VAT rates instead). Although I think the saving of the rate with the record would be easier.