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

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

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

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

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

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

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

What's your advice? I am currently using Access 2000. How much of a difference would it be if I updated it to 2007. Would I experience a lot of problems? Would this not be a good idea? Will users that DO NOT have the updated version have problems opening it? And if I wanted to, how would I go...

Hi. I hope this is really easy. I can't seem to find a solution. I have an unbound field used for searching records on a form. I would like to specify the unbound field to allow only 10 number entries..... meaning the person entering data into this unbound field would not be allowed to enter...

Hello. I wanted to write a code for disabling a control if another control has a value in it. For example, I have two controls, cntrlBlue & cntrlGreen that are not disabled on form load. If I enter data into cntrlBlue then cntrolGreen is automatically disabled, vice versa if I enter data into...

Hi. I hope this is an easy one, I just can't figure out how to do it. I have four controls that are used for entering text. TWO of the controls [controlA and controlB] are kept visible and TWO of the others are not. What I want to happen is when I type in data for EITHER controlA OR controlB...

nevermind, somehow I got it to work :) HOWEVER... there is one simple syntax that I am messing up on. I put [Forms]![this is where I put the name of my form]![cboDiagnosis] in the criteria section of the Query Builder grid and it works fine if I ONLY open up that one form [Diagnosis], BUT...

Hi. I have a search form for patients. Once I find the patient I need, there's a command button that would direct me to their record on a different form. The problem is that when I click on the button and open the form containing the record for that patient, the form only contains that one...

Hi. I'm fairly new to Access and have very limited knowledge about Access coding. I have a database that I need to create queries for. Using the Access' wizard works out fine, but becomes irritating. Also, the people that would need to use the database would like it to just have a search form...

Is it possible to create an action in Acces like this: If control1 is null then error pop-up message appears .... when you try to click anywhere else on the form HOWEVER If control1 is NOT null (has data in it) then the error pop-up message would NOT appear when you click anywhere on the form...

Hi. I have a main form and a sub form. In my mainfrm I have a text field that is REQUIRED before I can enter any data into the subfrm. Can anyone help me with this code and how I would relate the two? I know how to do it when all the controls (text fields) are on the same form, but when it's a...

How do I disable all the fields on my form until one of the field has data entered into it? For example, Field 1 is NOT disable Field 2 Field 3 Field 4 Field 5 are all disabled until data is entered into Field 1 and then the rest of the Fields AUTOMATICALLY becomes ENABLED. Can someone help...

Is there anyway to make a field on a form required BEFORE any data can be entered into the other fields? I've been having a pop-up message as a reminder, but that gets really annoying because it pops up EVERYTIME I open the form. Ex. I have a database based on Patients, Patient Visit Date, and...

Hi! I have a combo box 1 with a list of choices let's say: Blue Green Red Purple are my choices What I want to happen is when I choose a certain choice in combo box 1, have another combo box 2 appear with more choices. Example, when I choose Blue in combo box 1, automatically another combo...