Search results

Insane_ai, Do I need to change my field from Autonumber to number before I run your query?

sure buddy it repeats used number!

thanks guys! namliam, I don't know exactly what cause this problem since I can't replicate the error. The application runs normally vary from 1 day to 1 week before Autonumber corrupts. The version is as above which is version: 4.0.9511.0 I don't know if this's SP8 or not but it seem to be the...

Plus, This problem occure with my client system. I can ask someone to reset the seed (which will corruepted every 1-2 days). So, I think it's nice to put it in the front end code. CK

Hi Guys, I'm so desperate here! I've read through many threads about this corrupted Autonumber but after tried many solutions, I still cannot fix my case. The details of my case are: - Windows XP SP3, MS Access2003 with Msjet40.dll version: 4.0.9511.0 - There're ~8 users. - use one backend...

Now, I logged in another PC, load that file from the version cotrol and everything works just fine. There might be something wrong with my PC. Thanks any way !

Now I just try building a new mdb file and import everything from that corrupt one. But it's crash while doing import. I will try to log in on another PC in my office. My PC might have some funny version of dll files or something.

Ah sorry RG, I forget to mention that it's an mdb file. I did compact and repair but it doesn't help.

Hi guys, I use MS Access 2003 on XP. I got a problem with one of my project. When I'm in VBA and try to do Dim, the program crash and Access quit! What I did is typing: Dim strTest As And that's it. Soon I press spacebar after 'As' it crash and Access closes itself. The Error signature as...

datAdrenaline,Thanks very much for your time. Your info is very useful and clear enough to me. Then I have another question follow up to your description. Since the structure is as you described "Access Application -> Data Interface (DAO/ADO) -> Data Engine (JET)". Is it possible to has an...

Hi guys, I know that there're heap of this error posted on the web. I have read through some of them but still don't get it. My problem is I want to do: strQuery = "SELECT * INTO [tblExportTemp] FROM " & qryToExport.Name Debug.Print strQuery dbCode.Execute strQuery the qryToExport is a query...

MStef Thank you very very much. You're truely my life saver.

Hi guys, I don't know if my question is the silly problem. Well, my problem is just like the topic. The detail is that I have a form with 2 buttons. Button1 will do INSERT into a table and Button2 will just close the form by not delete anything in the table. What I want is when users click the...

Thanks so much Unclejoe! I'll try that. Back to my question. Are there any handy way to just bring back the original RecordSource? If there's, please let me know. Thank you very much.

ps. The link you provided, I'm not sure if it's about sorting or searching?

Hi Unclejoe, Your idea is right. Thank you for the link. But now I'm working on the existing project and just join the team. Form2 that I refered is a global form which can be called from many modules/forms. Form2 will manage to return SQL string, "SELECT column1, 2,... FROM RecordSource ORDER...

Hi Guys, I'm another newby to MS Access. Here is my story: I have Form1 with sort button. After clicking sort button, Form1 will send its RecordSource to Form2. Form2 provides sorting criteria and returns the SQL statement. Code below is in sort button in Form1: Private Sub btnSort_Click()...

In addition, what I'm thinking of now is doing the string manipulation to extract the original RecordSource out of the modified one. (if I can't find any better way).

Hi guys, I'm another newby to MS Access. Here I have the similar problem. In my case, I have a sort button in Form1. When the sort button is clicked. Form 2 pop up with sorting criteria. When Form2 close Form1 will display data in sorted order. I want to keep the original RecordSource and...