Search results

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.

That's correct.

Ok. This has nothing to do with Access, but I couldn't find a website that would give me fast feedback on this problem. I am trying to open a file in Microsoft Word, but it says I need to install a Microsoft Office Words converter. Anyone know where I can download this ONLINE?? I have version...

Thank you so much for your suggestion!!!.... BUT I over-looked something in the customize toolbars window... and now I got it back. Weird how I didn't see this till I posted the thread. I have been trying to get it back for 20 min! Well thank you again.

Database view This is a more of a Microsoft Product issue, in general. I have no idea what I did and how this happened but I no longer can see the toolbar in Microsoft Access that contains: File, View, Edit, Tools, Format, Help, etc.. THE MENU BAR that is.. . . This view has occurred for all...

hrms, THANKS Bob for the website and the missinglinq for the advice. One thing I have on my database is Access' built-in security and noticed that THAT portion of Access is no longer useable in the new version... I'm a novice to Access, so... it's PROBABLY BEST I not update right away. I'll...