Search results for query: *

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

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

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

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

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

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