Search results

Hi, everyone, i am a Chinese user of Windows Server 2008 R2. And i noticed the auto-reboot of this server on around 8:45 am everyday recently. This server is for file-serving for my company and for financial database too. The event log of this auto-reboot is as follows: Log Name...

Hi, Caferacer, Try to add 2 lines below to your duplicate button code: DoCmd.Requery DoCmd.RunCommand acCmdRecordsGoToLast For example, the code of duplicate button is like this: Private Sub duplicate_record_Click() On Error GoTo Err_duplicate_record_Click DoCmd.DoMenuItem acFormBar...

Hi, Caferacer, What i am using is Access 2003 not Access 2010 you are using. Also its version is Chinese. I would download an English version right now. But your question is something I was encountered before. From your description, I think you use a duplication button to duplicate record when...

Yes, Japanese politics has been changed much from WWII and the major power has changed to Prime Minister not the Emperor any more. And I also don't know if Japanese will still do kamikaze practices today. And I totally agree with Galaxiom that the Emperor should have been tried for war crimes...

hi, Mihail No, your English is good and I can understand your meaning. You have not offended to our culture indeed but are curious about Chinese culture or Japanese culture. The kamikazes or seppuku practice you mentioned above especially exists in Japan. Chinese rarely do these practices. Maybe...

hi, Mihail, Thank you for your interesting in Buddha. Buddhism was originated from India and introduced to China at about 67 AD due to the communication from monks in both countries. Nowadays most Chinese people have no relief in fact, but the Buddhism is admired by most Chinese because it was...

I chosen to 2 and have just seen the poll results that most people believe in God. Maybe the answer I chosen is weak for my belief is uncertain. Yes, I have confused by this for a long time. As I grew up in China, my original belief is Buddha which is ashiest and I loved the ways of thinking in...

Thank you dfenton. In doing so really may generate new problems. The design of table fields needs to be considered thoroughly.

Thank you The Doc Man. Yes, the error message was translated from Chinese that made confusing. Hehe.

I have solved the problem. The solution is to make the rule of allowing blank string to YES. As there are many blank strings which are needed to be updated, so it violates the rule of not allowing blank string. Actually the problem was solved several days ago after I posted both in this site and...

Hi all! I use ASP webpage to update records in background access table and get problems. The SQL statement is just as common as others. UPDATE table1 SET contact_status='new', contact_date='2009-11-9', company='someone', quote='0' WHERE ID=763 I have omitted certain SQL statements since...

My colleague fills records by using quering. This is not a splitted model as dfenton said. It is better for me to use splitted access app.

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