Search results for query: *

hI MajP, thank you for your post. I feel rather silly, I should have known better. You are right I was attempting to open multiple instances of the same form at once and modify properties of the controls on that form. I like your first suggestion I am assuming the code you are suggesting...

Hi there, hope everyone had a good weekend! for both MajP and TheAceMan1 I was able to get permission to post a cleaned up version of the system, it has very limited test data in the system so hopefully it will not be an impediment to figuring this out TheAceMan1 I am glad you said...

Thank you MajP for your comments and suggestions, I did add DoEvents as you suggested, (I copied and pasted your code into my Case Statement) and it did indeed return False. I amy be a bit dense on event based programming because I am not sure how it helps... TheAceMan1. Thanks for your...

I have done some further testing on this problem and it seems I can refer to the 'Value' of the text box and successfully update it with a new value, but as soon as I try to change a property, in this case disable the textbox nothing happens, or I get an inconsistent result as described above...

I may have spoken too soon. the demon is back and I am not sure why...I will update with more information soon. Polnichek

Hi MajP thank you again for your post. I like your debugging ideas and I will use them in future. Well....there was another possibility...I call them SAT's...short for Stupid Access Tricks. I exported the contents of the application to a new database container (.mdb file) and it works fine...

TheAceMan1 I can upload but I have to clean it first, I work for governement and I cant send out anything I want to! I will try and send up a version that security will be happy with by tomorrow. Polnichek Polnichek

Hi MajP so right, your suggestion is not going to help unfortunately..I am beginning to hate the tab control structure... David Polnichek

thanks MajP, I will give your suggestions a try tomorrow (have to run right now!) and let you know. I reviewed some of the adjustments you made to my basic structure and they make sense. Polnichek

thank you again, I did as you suggested....I misunderstood what you had said initially about having three sub forms with the same name. I did have only one instance of the sub form but I had wondered if perhaps the tab control may have interpreted it as having three instances of a single form...

Hi TheAceMan1! thanks for your reply, Yes you are correct all thrre tabls would have the same sub form name (frmPurchReq_Sub) the three different data entry screens have almost identical data to be entered depending on the three different ways the Purchase Department can buy goods and...

I have a Main Form called frmPurchaseRequest that has a tab control (TabCtl0) on it with three tabs. Each tab uses the same sub form to capture data entry (context oriented each tab represents a different way of acquiring goods and services). the intention is to have a client click on a tab...

I want to populate a combo box with the results of a selection from a preceeding combo box. My front end is in Visual Studio 2005 and my database is SqlServer 2005. To use an example from the 'pubs' database I would like to slelect An "Author Name" from one list, and then in the next combo box...

Thank you Zion! It finally works! You were right there was a problem with the name of the relationship, I had misunderstood this part of the code, I had thought it should be a table name for some reason. There was also a foreign key/primary key mixup too. The odd part is I expected the...

Thank you for sending that very useful bit of code that displays the relationships in the immediate window. I tested the application using your code and I had the following results: Before link code is run: 2004_2005Company, TABLE CompanyName PrimaryKey Comp_Id 2004_2005MainTable, TABLE...

Thank you Zion I will try that and let you know how it works. Polnichek

I tried the Show all relationships and it does not show any unfortunately. I can make your Query suggestion work so I may go that way and just base all of my reports on the query's, since being an archived database the records will be Read Only therefore Referential Integrity will ot be as big...

Thank you again for replying Zion your help is greatly appreciated! I ran my old code once again to find the error handler number to replace the one you said I had to fix. I tried your error handler again but in a new form and the error messages disappeared. The problem now is it does not...

I tried Zion's fix of adding the error handler to my code but I still do not get the desired result. I am able to keep the prgram from crashing but I wind up in and endless loop of error messages (the error handlers msg box statements). Perhaps I should give a full account of what I am...

Thank you Zion for posting this hint. I will give this a try and see if I can get it to work. Polnichek Polnichek