#Type! Error in Form

[vbaInet]

* Don't save calculated values in the MonthName, YearName and QuarterName fields.

My first point was that those values should not be saved. It violates normalisation rules. Format/calculate it when you need it.

 

[Mahendra]

How to overcome this issue?

We have a datasheet in access with same kind of stuff..

When front end user modifies the end date then the access sutomaticall calculates the remaining columns like quarter, year and month. It won't be saved back in the table..... Alass...... what's the best possible solution now.

Eventhough I use your queries as control source to enddate for month and year by formating it to mmmm and yyyy too the database is not updating in the backend with the columns

 

[vbaInet]

What is the connection between your Excel and Access applications?

 

[Mahendra]

What is the connection between your Excel and Access applications?

Sorry, It's a typo error in a rush to solve this issue as soon as possible :banghead:..... It's an access table

 

[Mahendra]

Reposting my db

 

[vbaInet]

I've mentioned it a few times already, it should not be saved in the table. Format it every time you want to use it. Makes sense?

 

[CJ_London]

you have your answer here to one of your earlier posts

http://www.access-programmers.co.uk/forums/showthread.php?t=278781