Replies

Sometimes the simple solutions are all it takes. That worked. Thank you Hans.

Sometimes the simple solutions are all it takes. That worked. Thank you Hans.

We have quit and restarted Access. Haven’t tried restarting the PC. Will try that now.

We have quit and restarted Access. Haven’t tried restarting the PC. Will try that now.

This looks familiar. I will try it, and get back to you.
Thank you for your prompt response.

This looks familiar. I will try it, and get back to you.
Thank you for your prompt response.

Ordinarily I would agree with this. Which is why I only asked for a hint. However, for this class — There are no lectures, there are no other students, the instructor responds little or not at all, (online class). Not all of the information needed is included in the assigned or previously assigned material. We are apparently supposed to research it and figure it out.
Besides, my friend, who is a supervisor at Microsoft (really), told me that this is the way programmers work in real life. They do what they know how to do, hit the books, and if they can’t find it there, ask other programmers. So I am not only learning VBA, I’m learning to work like a real programmer/
I’m apparently learning a little advanced rationalization as well.
Seriously, if my boss hadn’t let me take the Developers Handbook home, and I didn’t own one other reference besides the textbook, and if I hadn’t gotten serious hints and help from the lounge, this would have been total disaster.
Thanks guys, and Charlotte.

Ordinarily I would agree with this. Which is why I only asked for a hint. However, for this class — There are no lectures, there are no other students, the instructor responds little or not at all, (online class). Not all of the information needed is included in the assigned or previously assigned material. We are apparently supposed to research it and figure it out.
Besides, my friend, who is a supervisor at Microsoft (really), told me that this is the way programmers work in real life. They do what they know how to do, hit the books, and if they can’t find it there, ask other programmers. So I am not only learning VBA, I’m learning to work like a real programmer/
I’m apparently learning a little advanced rationalization as well.
Seriously, if my boss hadn’t let me take the Developers Handbook home, and I didn’t own one other reference besides the textbook, and if I hadn’t gotten serious hints and help from the lounge, this would have been total disaster.
Thanks guys, and Charlotte.

Hans darlin’
We aren’t talking about the real world. This is a class assignment. It is MOST desirable for me to be able to complete it. I have the code that will delete the table, and the code that would delete all records, but they fail because of the relationship, I really really need to break the relationship. Your absolutly correct – Microsoft DAO library and the CurrentDb is exactly what I’m using. — Wait a minute. You said CurrentDb Relations collection. — I’m off to research, Thank you.

Hans darlin’
We aren’t talking about the real world. This is a class assignment. It is MOST desirable for me to be able to complete it. I have the code that will delete the table, and the code that would delete all records, but they fail because of the relationship, I really really need to break the relationship. Your absolutly correct – Microsoft DAO library and the CurrentDb is exactly what I’m using. — Wait a minute. You said CurrentDb Relations collection. — I’m off to research, Thank you.

(Edited by charlotte on 17-Jun-04 12:57. Rule #10)

Ah ha! The light comes on. Looking back, I can now see where it is in the book. It doesn’t give you this, it just talks about pixels and – twixes?? I suppose all the information was there if I were brighter. Now — even though the credit is no longer on the table, I would still like to incorporate this in my final project, which my instructor has deemed ” a little strange, but well thought out.” All he asks for is that all the data in the tables be exported and the database shut down after 2 or 3 erroneous login attempts. I’m getting there.
I really would like to have the textboxes “float away” before the database closes. Just to show him I kept trying. I’m also going to attempt to have it turn bright red and beep. Just because I am a little strange.

I would also like to hear the long story about how you wound up in Dallas.

Thanks Drew

(Edited by charlotte on 17-Jun-04 12:57. Rule #10)

Ah ha! The light comes on. Looking back, I can now see where it is in the book. It doesn’t give you this, it just talks about pixels and – twixes?? I suppose all the information was there if I were brighter. Now — even though the credit is no longer on the table, I would still like to incorporate this in my final project, which my instructor has deemed ” a little strange, but well thought out.” All he asks for is that all the data in the tables be exported and the database shut down after 2 or 3 erroneous login attempts. I’m getting there.
I really would like to have the textboxes “float away” before the database closes. Just to show him I kept trying. I’m also going to attempt to have it turn bright red and beep. Just because I am a little strange.

I would also like to hear the long story about how you wound up in Dallas.

Thanks Drew

Twips. Twips! Yes, that was in the book. I didn’t make the connection. I’m not sure I could have figured it out if I did. Thanks for your help with a matter of no importance whatever, except to me.

Twips. Twips! Yes, that was in the book. I didn’t make the connection. I’m not sure I could have figured it out if I did. Thanks for your help with a matter of no importance whatever, except to me.

Hello Drew, fellow Dallasite
I haven’t seen your name for a while. Okay – change the left positions. And you would do that by —— ? Remember who your dealing with here. This is my first actual VBA course that I’m taking.