error message

[maximus]

were you able to sort data in the list box.

[ngeng4]

yes.. thank you...

[ngeng4]

is there any way the user can access this db without having ms access installed in their pc?

[maximus]

No as far as I know it is not possible. There is a software called MDB Viewer Plus but as the name implies it is just a viewer with limited editing capabilites, I must admit here I have never used it. My specilization is Object oriented and scripting languages and as for dbms I mostly work with mysql, postreSQL, and SQL Server, Oracle and IBM DB-2 and my knowledge about this is limited.I love working in Access and its a hobbie that I picked form my brother who had to build a simple accounting database when he was doing his CA course.

[ngeng4]

ooo okay.. yeah.. ive google for this thing.. n the result only for the MDB Viewer.. how old are u actually? and since when u r involve with this thing?

btw, wuts ur idea about the query?

[ngeng4]

another question is, as u can see in my db, in the project table, got a proj_link and also proj_id, i need to have these 2 because each project have their own id, but let say d 1st data is under the project id = 1, then of coz the proj_link will automatically 1, then next if the 2nd data is under the project id = 4, then if i key in the data, that details will not appear, or not be save. n also the product entered will turon blank in the list box. why?

[maximus]

I have been developing databases in access for about Four years. My Proficiency in access is largley due to the fact that I have a strong foundation in Visual Basic. My First database is a simple accounting database for my brother and my second database was a complex Inventory tracking database that I had to build as a project. Well I am 29yrs Old.

[ngeng4]

what shud i do with the query?

another question is, as u can see in my db, in the project table, got a proj_link and also proj_id, i need to have these 2 because each project have their own id, but let say d 1st data is under the project id = 1, then of coz the proj_link will automatically 1, then next if the 2nd data is under the project id = 4, then if i key in the data, that details will not appear, or not be save. n also the product entered will turon blank in the list box. why?

[maximus]

looking at the problem now.

[ngeng4]

thank you.. sorry repeating the ques..thought u didnt see the question since ive post so much question..

[ngeng4]

how? do u know how to solve it?

[ngeng4]

let say the proj_link which is autonumber is 4, but the new proj_id is 78, the data in the list box for product didnt appear. why is that thing happen?

[ngeng4]

uwaa.. how can i solve this thing?

[maximus]

Zip you data base let me see what the problem.

[ngeng4]

try to key in any number in the id, let say 20. then u will see that the product that had been selected from the combo box did not appear in the list box