Search results

Yes, I can make a copy to instead the replication,but since replication can also achieve the same goal why I do not use it. The database design is simple, my colleagues don't need replication to work together, so it is just a tool to be used to share database records to asp apps. It is not the...

The situation is like this: my boss use access to deal with customer relationships and the original database design is just one big table. I am programming asp webpages to show queries in this database. My colleague is using access to fill records. Therefore I met the problem that if I retrieve...

yes, gemma-the-husky, it would be trouble if the number is used as a foreign key in other tables. It is lucky for me to do it since my database design is so simple that there is only one main big table. hehe.

Thank you all for your quick response. Yes, the original table design of ID is incremental and not radom. After I made replicaiton the property of ID is changed to random and that is why it shows so strange. The solution is just as branston said, delete this column and re-enter it with same...

:)Hi! everbody, I made a replica of my original access database. However, when I add records in a table in my original database, the auto-incrementing ID field becomes a very big or small radom number. Here is: 2377 2378 2379 2380 1242611267 (auto incrementing)...

Thank you so much HiTechCoach! You are right. When I put my code into the current event handler it works. As msdn says: "This event occurs both when a form is opened and whenever the focus leaves one record and moves to another." I just want to change the subform to be visible and invisible when...

Ok. I am just working for my community to repair PCs for my neighbours. I attach my database here so you can check it.

What I want to do is to show how many PC configurations when I open a form. I am working to solve PC problems for my neighbours. So I decide to make an access database to collect all the informaton, including customers, their PC configurations and the solutions I did, to the database. Each time...

Hi! I made a access database for recording PC repairing information for my neighbours. I use a form named Customer to store my neighbours' information while use its subform named Problem_Solving to store maintenance records. What I want to do is to show the subform, Old_PC_Configuration_x and...