Recent content by vX987

Hi. I have major problem I have been avoiding just because it's not a problem for me, but because I will be leaving my position soon, I need to know if it's possible at all for me to delete the User-Level-Security that is bounded to my database at all? When I started this a couple years ago I...

OK, I finally figured out HOW to do this! :) thanks for the suggestion!

Hi. I am trying to create an AGE field for my database, but I'm not quite sure as how to have it update automatically once I input a date into my BIRTHDAY field. I need age to be a field in my tables because I plan on using it in queries. I use to have it just in my forms and changed the...

simple, EASY .. no complicated codings! Works great, thanks!

Ooo awesome! I should've thought of that :) Thank you .. I will test it out.

Hi. I'm not sure if this is possible, but ... I'd like to create a form (MAIN FORM) where I'll have two command buttons labeled FORM 1 and FORM 2 and then a wide empty space below it. What I want to happen is: everytime I open the MAIN FORM, FORM 1 will be visible in that empty space (as a...

Brian, OK it worked by trying what you suggested in your last message .. but weirdly .. I am missing one patient and I checked that pt. and he fulfills both diagnosis1 and diagnosis2, but does not show up with the other patients .... hmmm I'll try to see what the problem is. THANK YOU!!!!

Thanks for your reply Brian. umm, well there is a separate table for patientinfo and another one titled ptdiagnosis because a patient can have more than one diagnosis. I'm just using the simple "query by design" and i just need to view all patients who have BOTH diagnosis1 and diagnosis2...

Hello! I would like to query some data of patients that have TWO certain diagnosis. I only need the ones that have those TWO diagnosis and NOT also the ones that may have one or the other. How would I do this? Do I put "Diagnosis1 And Diagnosis2" in the criteria section? I tried that and it...

Thank you!!!!

Ok, this is definitely a beginners thing, as I AM A BEGINNER :) I'm just looking for a useful technical trick. I want to select all the fields on a table to query and sometimes I have a whole long list of fields. I know there is a way, but I just can't remember. You know, instead of having to...

Hello. I have a MAIN form with some patient records in it. What I want to do is insert a command button into this MAIN form that will result in adding a new record to that form (MAIN). HOWEVER, what I want to happen FIRST before I am even directed to creating a new record is...... to have it...

For future references 1. Open Access. 2. Hit "ctrl G". This should open Visual Basic and the "Immediate" window (it's at the bottom of the screen in VB for me). 3. In the Immediate window type "commandbars("menu bar").Enabled = true" and hit enter. 4. Close Visual Basic. The menu bar...

For some odd reason I'm experiencing this same problem again. It might have been because I was viewing some databases in the "Sample Databases" section of this website while having my own database opened as well??? I don't know. *When I open my forms, I can no longer minimize them. I can't view...

Thank you for your help Ray. Works great now.