Recent content by Desperate

I checked references. Both were added. This is related with queries. How can I understand which are the new features? Can you please give one example? I know in 2007 there is calender option to enter dates easily but this is not in my fields. How to identify others ?

If size is not an issue, one of the most important question should be "Which one of these will provide better service with minimum problems in future?" So lets say if you are better at Ms access,it means you will do a better application and provide better support so you should go for it..

Well most of the queries are not working. I couldn't find the reason. Is it possible because of missing reference?

Thanks I have read the article. Well some of the forms and queries didn't get converted in to 2003. New featured may cause this as it says in the article. I will go in to details and try to find out. Secondly, It says there is a missing or broken reference for the file 'msador15.dll' version...

I have tried to convert it through Microsoft Office Button, and save database to Access 2003 Database. It takes all tables, forms, queries but none of the VBA codes and queries are working. Yes I tried and failed same as above. No it is not a split database.

Hello mates. As subject says I have a very detailed and complex access 2007 application with full of codes, queries etc. Normal convert fails for such an application and if I start to do it again in 2003 it will take a lot of time. So is there a way which I can convert my 2007 database to 2003...

I know this is very simple for most of you but it came to a nightmare for me! I have a query gets the total ordered quantity from "Orders" Table and another query gets the total received quantity from "Incoming" table. I just want to make a pie chart which shows what have been received and what...

My tables are not linked. Its very strange.When I don't split it works without any problem at all.

any ideas?

Below part is not working. Instead of "AVAILABLE" it gives "NOT AVAILABLE". But if I don't split it works without any problem If WP!Part_No = STOCK!Part_No Then If WP!Required <= STOCK!Stock_Qty Then WP.Edit...

Shall I try to change it from dao to ado?

Here is the code; Public Sub RunAllocation_Click() Dim db As DAO.Database Dim STOCK As DAO.Recordset Dim WP As DAO.Recordset Dim VirtualStock As Double DoCmd.SetWarnings False Set db = CurrentDb() Set STOCK = db.OpenRecordset("InventoryTempForAll") Set WP =...

As subject says, I have a vba code including 2 recordsets getting information from different tables and compare with each other. When I dont split the database it works perfect but when I run the code after splitting, values don't come up correctly. What can be the reason for this and how to fix it?

Solved! IIf(nz([AVAILABLE],0)=0 And nz([NOT AVAILABLE],0)<>0,"NONE",IIf(nz([AVAILABLE],0)<>0 And nz([NOT AVAILABLE],0)=0,"FULL",IIf(nz([AVAILABLE],0)<>0 And nz([NOT AVAILABLE],0)<>0,"PARTIAL"," ")))

Dear stopher Code works great. I just need a little more help from you. When there is no status mentioned in Table, OverallStatus of the qryResult is coming as "Partial". But if nothing is mentioned in status yet, overallStatus should also come as blank. I couldn't figure it out.Not to get any...