Recent content by georgp

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...

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...

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

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

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...

WELCOME... and thanks for the star GEORG

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

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...

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...

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

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

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

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...

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...

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