Search results

Hi! A form is based on query which is based on a table. The table is splitted into 2, then the form has a "recordset not updatable" error... does anyone have any idea on this? thanks very much

thanks for your reply, but the 2 tables (creared by splitting) has got no relationship at all as they store info of 2 totally different products. do I still make one between them? after splitting, i updated the design of the query to get fields from both the 2 tables, but the form has still got...

nobody has any idea about it?

hi! i got a table containing info of 2 different products. and now i would like to split it so that each table only for 1 product. but there is query based on the original table, the question is after splitting, and updating the query, the form doesn't work properly any longer... a bigger...

Hi! if a query is based on 2 linked tables, and 1 of the table is then splited into 2. then the form based on the query has now a "record not updatable" anyone has any ideas about this error? thanks in advance

If a query is created based on a table, and then there is a form created based on that query. now i split the table into 2 tables, as the original table contains info of 2 different products. so wanting to have 1 table for 1 product... Question: after spliting table, do I need to recreate the...

I am sorry, but the problem is your solution is obviously wrong... why would I want to link 2 unrelated table together? just to solve the bug is not a sufficient reason...

Hi! The structure is like: C query is based on 2 tables, A and B. Then D form is created based on query C. What I did: Now I split table A to 2 tables, A1 and A2 which are indepandant from each other, and I updated query C to retrive data from A1 and A2. Problem: Then the form D which is...

Hi! The structure is like: C query is based on 2 tables, A and B. Then D form is created based on query C. What I did: Now I split table A to 2 tables, A1 and A2, which are independant from each other, and I updated query C to retrive data from A1 and A2. Problem: Then the form D which...

thansk for your reply A1 and A2 are independant totally, not link between them

Hi! The structure is like: C query is based on 2 tables, A and B. Then D form is created based on query C. What I did: Now I split table A to 2 tables, A1 and A2, and I updated query C to retrive data from A1 and A2. Problem: Then the form D which is based on C doesn't work properly...

"member already exists in an object module from which this module derives" error occurs at execution of every single function in a form underlying moduel written in VBA. Can anyone tell me what could possibly cause this error? The module is not derived from anyother module... thanks very much

When I was developing a form with its underlying module written in VBA dealing with calculations. This error occurs at execution of every single function, "Member already exists in an object module from which this module derives" The form is based on a query without underlying VBA functions...