Recent content by DrMaestro

Hi edtab, Thank you very much for your answer. It works very well.

Hi, I created a form (frmPatient) which contains patient ID information and demographics. A pateint can have multiple mammographies on different dates. I have a button on frmPatient to open the mammographic findings form (frmMammo) and enter mammographic findings for a certain examination date...

Hi MicroE, I tried your solution and it works just as I wanted. Thank you very much....:)

Hi, I have a date field and a phone field with input masks. What I want to achieve is when someone clicks the fields, I want the cursor to go to the beginning (the leftmost) of the field. Actually, when you click a field, the cursor appears just at the spot you clicked, which can be the middle...

Hi, I tried listcount -1 in my formula. When you start the database the textbox states correctly that there are no records. But when you search and find records the number given is 1 less than the actual number. I think I have found a workaround and wanted to share it with you (well it is no...

Hi RuralGuy, Thanks for your answer. The columnheads property is already set to No. There probably is another solution. (When the listbox is empty, I can click on the first row and it is selected. So, the listbox has a selectable empty line, which is counted as a record. I tried to set the...

Hi, I have a listbox which displays the results of a query activated by a button click. I also have a textbox. I want the textbox to display the number of records found (like "X records exist." where X is the number of records). I set the textbox's control source to the ListCount value of the...

Hi, I'd like to ask two questions. I have a simple form which contains an identification number, patient name and patient surname.I also have a combobox to select a search criteria (which can be the ID numberi patşent name and surname) , a search button and a listbox to show the search results...

I checked the office update site. Had a few new updates. Downloaded and installed all of them and restarted the computer as required. I tried to run the database again but I still get the same result. (very depressing)

Hi, I unchecked OLE automation and the Active X reference, recompiled and ran again but I still get the same error. They are unchecked right now. boblarson, thanks for the clarification. The 2 files mentioned were in windows' system32 directory. I downloaded their latest version from...

Hi RuralGuy and boblarson, Thank you very much for your answers. I did as you advised. The same error still happens. As I mentioned previously, there is no reference marked as missing in references window. So I have no idea which file to browse for. Thanks..

Hi, Thanks for your replys. I went to the link you provided and read the information. I tried the reference wizard database and it didn't give me any errors. Apparently there aren't any problems with missing references (i tried all of the suggested methods at the link...

Hi, Thanks for your reply. I did as you advised. I don't see any reference marked "missing" in the references window. The options checked are as follows: *Visual Basic for applications *Microsoft Access 11.0 Object Library *OLE Automation *Microsoft DAO 3.6 object library *Microsoft ActiveX...

Hi, I have the follwing problem: I created a form which has a button. When pressed (onclick) it searches a table to find the requested entry. I started to create the database using Access 2000. A collegue helped me with it at work using Access 2003. When I try to run it (click it) on Access...

Hi, The calendar code is written by Allen Browne. I found it at: http://allenbrowne.com/ser-51.html