Search results

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...

Poppa, I just did the same on my computer with your brilliant idea! Thanks a lot for your support. I really appreciate. What I tried to do before is something like to create a dynamic recordset which I couldn't manage. But creating a temporary table also works fine.Thanks! For the users who...

Yes exactly correct. The InventoryT can't be updated. That is why i created virtual stock (virtualstock = STOCK!Stock_Qty) And statement virtualstock = virtualstock-WP!Required is to deduct qty from stock quantity virtualy. Lets say you have Material1 Required 3 pcs. for the first structure.You...

Sorry for the lack of explanation.InventoryT is a table which holds material transactions.It shows what have been received to warehouse and what have been issued from the warehouse. The purpose of StructureT is to show engineer, which structures can be fabricated with the remaining materials in...

Thanks a lot Poppa. I am checking now. But actually nothing should be changed in InventoryT through this screen.Because this screen is only to show user the availability of the materials to build structures. InventoryT is getting updated through other screens as per the materials receipt and...

Poppa Smurf I prepared small database for you. Please open StructureT, select 12DUMMY-1 from structure_NO click add to work pack. After this select 130-TP-001 click to add 5 times and click run allocation. You will see its not allocating correctly. You can watch required qty versus stock qty...