Recent content by ytorres

Thanks for your reply... I think I didnt explain the problem too well. (sorry...) Anyway, the problem we were having is that we were using on Oracle 9i the old way of writing outer joins (+) and now its completely different. I did found a thread here with an example but its a bit too simple...

Hi! We are wprking with a script and we are using sub selects (a select withing a main select) and the outer joins in this sub select are not working properly... It is still ignoring some records that should be included in the output if the outer joins worked properly. Do you know if there is...

Now the error i mentioned on the previous post is not coming up, added some code to prevent the application from verifying a field that at the time was being deleted... When i run it step by step, after the delete runs and its the turn of the form requerey it goes first to the subform Current...

OK, I placed the break-point where you suggested. I now know that when after the delete occurs and then the form requeries it first goes to the OnCurrent event of the subform. There it freezes. I tried eliminating some of the conditions that the application checks for in that event and this...

Yes, but it won't let me debug... if freezes, perhaps i am setting the break point in the incorrect part of the code. I just deactivated the OnCurrent code of the form and the Delete worked perfectly. It seems like there is something there that is causing the application to halt and crash...

Yes, I just ran Compact and Repair Database. Th OnCurrent of the form where the delete is ocurring only does certain field checks in order to enable or disable fields... It also contains a subform but I disabled the OnCurrent code on that one and the problem still occured. Any other...

Hi! Thanks so much! Your suggestion worked! BUT... after the delete action is completed, it still freezes and then the application closes completely... Any suggestions as to what could cause a database to close by itself? Thanks! Yolanda

Hi! I have a delete code that runs on the OnClick of a command button. For some reason, in my computer, the application is freezes and then closes when i am running this code... I have no idea of what could be causining this. I tried the application at my home computer and there if worked...

Thanks for your reply. I needed for you knowledgable programmers to help me understand this thing. The candidate key doesn't apply in this situation. I have a table called FollowUps with a primary key composed of FollowUp No (code generated), Action No (the number of the corrective or...

Is there such thing as an alternate primary key for access tables? My boss insists there is and I have searched to find nothing on this. What my boss is sugesting is that depending from with form I am reading or entering data that the primary key changes accordingly to allow for creating new...

Wow! Okay so I guess I have to the Navigation Buttons, :) Thanks for all the replies! Torres

Thanks but I tried that and what it does it that it doesn't allow any new records and I need to be able to create new records but not with the next record button...

Hi, I have a pop up form in which I am using the record navigation buttons. They read the correct amount of records there are in the form's query but the next button never turns gray when you reach the last record. If you click it again it tries to go to a record that still doesn't exists and...