Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: georgp
  • Order by date
  1. georgp

    Combobox list

    Hi Aceman1, thanks for your interest. I do not want to hide anything, but my tables deal with chemicals, actually polymers and their brand names, and I believe it is pretty confusing if I disclose the details. Basically there are many vendors for the same chemical product, but they sell it...
  2. georgp

    Combobox list

    Hi everybody, i have two comboboxes. One pulls out a list with company names, and the second pulls out a product name list. Many of these companies have the same products but with different names. I would like to have the second combobox list first to show the product names of the company...
  3. georgp

    Saving Report As PDF

    Many thanks for the code update. Does the new code also run for older windows/office versions? How would I test for the windows and office versions? georgp
  4. georgp

    Find Confusion

    I'd like to add, if somebody has a working code example for these find, findfirst, etc, I would appreciate the posting of it. Thanks, georgp
  5. georgp

    Find Confusion

    Hi, I have behind butons code to "find" certain recordsets, the code is almost the same for find, findfirst, findnext, findlast. To make things easier to explain, I copy the 'findlast' code and describe (one of) the problem(s): Private Sub btn_LastRec_Click() 'Purpose: Find the last matching...
  6. georgp

    Combo Box - Last entered Item as default

    WELCOME... and thanks for the star GEORG
  7. georgp

    MS Access VB

    F. Scott Barker "Access 2000 Power Programming" and Allison Balter "Access 2000 Development" from SAMS are also ok. And then there is O'Reilly's "Access Cookbook" from Getz, Litwin & Co. You will like to read it in the bathtub together with a cold beer. georgp
  8. georgp

    Bad records

    Jaymunda, certainly. Make a copy of your db and delete the relationship of this particular table. I am sure you can then delete your records and eventually re-create the relationship, but - as mentioned - make sure to have a copy because you may have destroyed some integrity rules of the db...
  9. georgp

    Combo Box - Last entered Item as default

    Hi tstowe, sorry for answering late. I am not sure, if you are familiar with VBA, but if you are a little bit serious about Access you should start to learn it. That's the real fun part and it will allow you to do anything you want (with few exceptions). Sooner or later, you will want to do...
  10. georgp

    Combo Box - Last entered Item as default

    Hi, many possibilities. Starting e.g. with creation of a look-up table or even easier save the last entry to the tag of the control, and make it the defaultvalue. Hope that helps, georgp
  11. georgp

    Bad records

    Jaymunda, you may have a linked table with referential integrity and the message that you cannot delete the record has been suppressed by the programmer. Hope that helps, georgp
  12. georgp

    "record has been changed by another user ..." no it hasn't!

    Islwyn, if you have controls which are updated e.g. by your code this may happen. At least this was the culprit, when I received the same message. Hope that helps. Best, georgp
  13. georgp

    Form Add or Edit Mode

    Dixxy: I did it the following way: I have users who can only read and users who can edit and add. Then I have supervisors who can edit special fields, if the editor is in their group. Those with write permission can only write their own records but can see all records. I decide between reader...
  14. georgp

    Wild Combobox?

    Roy, I believe the code for tab, enter und esc (undo, if NewRecord) is required. In addition, I have trapped the Null case, and now I think this works quite well (let's see how it works tomorrow!!!): Private Sub ucbo_Starter_Enter() 'Purpose: Make sure that critical fields are supplied If...
  15. georgp

    Wild Combobox?

    Roy, competent as always... Thanks a lot. Georg
  16. georgp

    Wild Combobox?

    Hi, I have a form with several comboboxes which should only accept values from the list. I have set the NotInList event, but in addition I added these two modules, which should fire on entering the combobox and on Keypress: Private Sub ucbo_Starter_Enter() sOldValue = ucbo_Starter If...
  17. georgp

    Beyond Access

    Hi, I wonder if this is possible from Access: I open a specific webpage (yes,followhyperlink) http://appft1.uspto.gov/netahtml/PTO/search-adv.html This is the US patent database webpage. 1. Step Now I want to run specific queries which are stored as strings in my database which have to be...
  18. georgp

    Combobox list update

    Hello, how do I get the new value just entered into a combobox control ('ucbo_System', linked to a table field) show up after the control has been updated but without record change in the dropdown list? I tried the requery method in the controls after_update event, but it doesn't work, neither...
  19. georgp

    Lightweight or Code?

    Hi, if I recall correctly, I have seen people saying in various unrelated threads that light weight forms (i.e. put everything into the property box) work better than those with VBA code behind, but others say the opposite, such as Bill P. I really wonder which is better, or if one or the other...
  20. georgp

    Form rocks....

    Gus, thanks a lot. In fact,I (have) use(d) this kind of code, but it did not help - neither in the Form_Current nor in the cmd_Next (etc) modules. In my 'spreadsheet' part I make calculations which will change the values, the backcolor and the lock status of approx. 30 tet and combobox controls...

Part and Inventory Search

Back
Top