Search results

Hi Marco, well, I've got sometimes problems with DLookup, if it the search-string isn't found and so DLookup returns "NULL". So I use myString = Nz(DLookup("FieldName","Tablename","Field2='" & var & "'"),"empty") So myString = "empty", if DLookup is Null. Maybe that helps. Regards, Mary H.

Access2002 Bug? 2nd-form-command crashes report Hi Pat, thank you so much for your hints. But as I have encountered now, the problem is somewhere else. The fact is, if I open a form (here:the switchboard) and on a button_click a second form (switchboard still open), Access2002 (remember...

Hello Pat, it seems our systems are different. I am working with a german version. I have just that list of ca 40 references which I can check or uncheck. I only get an error message if I uncheck i.e. 'Visial Basic for Applications', saying that this reference can't be unchecked as it is in...

Hi Pat, thank you for your reply. I checked all references and had the same as in Access2000. But can I then be sure that no one is missing. And if one is missing, how should I know which one, I've at least 40 references in my list (oh god I am blond :-) Would be very greatful, if you could...

Hello, I've a database compiling statistical Data which will then be displayed in a diagramm, which is a OLEunbound object in a report. My code works fine in Access2000 but gives an Error in Access2002 when processing following line: DoCmd.OpenReport stDocName, acPreview Has anybody an idea...

Thank you so much, Bert. It's so easy but not mentioned in my numerous Access Books, or at least I didn't find. Anyway, that's it.

Hello, I want to hide (change to asterisc) what a user types into a textbox in a form. The form asks for a login and password. And as usual the password shall not appear in real letters but as *****. Please can someone help here. It doesn't seem to complicated first to me, but I can't think of...

Hi DBL, it' a long time ago you posted that message about setting passwords with a piece of code you were sending the requester. With a forum search I came across this posts and would be now also very interested in this code. Are you still having it and could you please send it to me as well...