Search results

In my reading I see that they have done away with user-level security in Access 2010 (stupid idea!). What I need to do is limit ENTRY access while giving view-only access to the database. However I also need to grant entry access to 2 forms for everyone. Is there any way to do this?

Figured out how this works. The code for auto updating the fields if "UniversityID" was yes needed to go under the University field after update and not the yes/no UniID field.

I have the correct fields showing and hiding based on the selection in a checkbox. The problem is that I would like to use the same address fields When the checkbox is yes they fill from the University combo field, but when the checkbox is no, they are open for entry. The code is...

Well I am advancing a little bit but still getting an error, though a different one. I have included a graphic with the code, where it is hanging and the error. Code using is Private Sub Institutions_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset(Institutions...

I am attempting to fill fields in the Recomm form (to Recomm table) from the Institutions table. I only need to fill certain fields on the form if the record is contained in the institution table (See attached graphic) I am not sure that I am doing this right (do I need to add the beginning...

I tried the code you left but it keeps hanging. I do not want anything other than this information to fill Private Sub Institutions_Click() 'To open the institutions table and select one to fill Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset(Institutions, dbOpenSnapshot)...

I have a table (Institutions) that is filled from a link in the PS form. On my Recomm form, see attached graphic, I have a link (institutions) that opens the table and I would like to be able to fill some of the Recomm fields based on if an entry in the table matches my data need by selecting...

I am trying to make a report pull information from the same table Year status = Graduated dType = MPH and MidC = 1 and then give me the % of MPH that has midC=1 I need to do this for every year recorded in the MPH Year field then a secondary Year status = Graduated dType = CPH...

Yes it worked for the single forms, but not for the split forms.

I created several froms and I can't control how some display. The size of one of the forms is 7"width by 9" height yet when it is displayed it fills the screen completely. The single forms stay fit to size. The split forms do not. The fit to screen and autoresize are set to "No", center in...

I am trying to build a report that looks like this. I need it to go through each year for each type and put the total per year for each type degree and then what % (there is a field to track this) and then the totals based on the information above. It need to track only "graduated" and not...

Not sure, it was added to the form by selecting check box and then pulling in the field from the Add existing field sheet

What criteria should i use to look for transactions for whole year of ? and repeat the data for every year there is an entry. The Year field is set with just a year and not the entire date.

I have an option button that when checked opens two fields. That is working. However when you leave the record the check is not holding although the data in the fields stay you have to recheck to make the fields open again. How do I make the option when check stay checked and the fields...

The options frames I do not want to move. What I would like to do is move the CPH graduate frames (they are positioned directly above the option frames) to the bottom of the upper list of fields when activated. Right now there is a big space when they become visible due to the MPH frames being...

What I have is a large gap when fields are hidden.

What I would like to do is move some fields up on the form (when other fields above are hidden) and then have them move down when the other fields become visible. The hidden fields are based on 'Current' and then show on entry in a specific field 'After Update' I am a new user to Access...

That was it. Thanks for the help.

I created a single report "GType" so far, everything is working OK except now when I open the database from windows (using my AutoExec macro) this View Reports Form opens, along with the main form that was set to open. If you shut all forms down and then excute the AutoExec from inside...

I did. I tried sending you a note but it would not let me. Thanks for all your help.