Search results for query: *

Is it possible to make fields read only to certain groups of user? I want to create a simple list for requests. Those that are requesting information from my team would only be able to read a few of the fields. Keep in mind that I do not have access to sharepoint designer. Thanks!!!

Hi - It has been a while since I have used Access but I know that with Access 2010, I can't use MDE's. I tried to create a simple list in sharepoint to manage report request in our department. I'm finding that I can't really use field level security in sharepoint 2010. I'm wondering if I will...

Hi - We are in the process of upgrading from Access 2003 to Access 2010. I was wondering if there are any major issues that I need to know about before making this change? I have a database with about 12 users.. the database has a lot of coding and macros. The front end is an mde. Any help...

I have a table that has a field named GroupNumber. There is an additional field named "funding" I want to create a query that will give me one group number for each row and concatenate all of the "funding" values into one field. For example, the data is: Group Funding 11111 Fully...

Is there a way to draw (either free-form or an object..circle,etc) in an email? We have 8.0... Thanks!!

I have a report that has a grouping based on a field named "BaseGroupStatus" The two values in this field are "basegroup" or "currentyearsale" Under the grouping there is another field named status which has a few different values and then I am totalling a field named "sumofstartingmembers"...

I am trying to create a tempoarary table which among other things takes the date that is entered on a form and adds that to the table. The field on the form is a combo box... the problem I am having is the data is not getting passed. When the table is created, it makes this field a binary. I...

I have some code that adds a field to a table. (see below) I am trying to figure out how to make the field an integer. Any help would be greatly appreciated!!! thanks!! Fred Dim db As Database Dim tbl As TableDef Dim fld As DAO.Field Dim finDate As String Dim filename As...

I have a sheet with a map on it ... on the map, I have several textboxes that point to values in another sheet. I added a combo box (cbodtapoint) that I want to use to alternate what data displays in the text boxes. I have that part working but after the update, the formatting of the textboxes...

I imported a county map of New Jersey and I am trying to populate the values on the map of each county. I have a listing of countys with a number County Members Atlantic 2179 Bergen 22209 I imported a wmf file and have all the counties named individually on the map. There is a...

I have an unbound form that I use to run reports. On that form, I have a field named financefilemembers. In this field I want to hold the total number of "members" from a table named tblfinancefile. I thought I could just put this in the open even of the form...

For some reason, I cannot move the report width over - THis report was previously used in landscape... I used it as a starting point for another report - I cannot drag from the right - I even selected all and deleted and still could not drag over ... any other ideas what could be wrong...

I have some code that I have used for a long time now for a report. The report totals opportunities by a category field and then uses hardcoded "months"that go accross the top of the report. The results look like this: Category January February March etc,etc Lost 1...

I tried searching but could not find an answer... I have a table that holds a primary key which is a text field. (opportunity ID) is the name of the PK. The data comes from an external source so I had no control over the format of it (it has numbers and text fields) I have a query that...

I have a form where I want to populate a list box (named region) from a table (named opportunities) I have not problem doing this by adding the following to the on open event of the form: Me.Region.RowSource = "SELECT DISTINCT [Opportunity Region] FROM Opportunities;" However, I would like to...

I have been importing data from a CRM database into Access to run some more complex reports than the CRM database will allow - The problem is that I don't want to import ALL of the data each week, only that data that has changed. The export feature of the CRM allows me to do this. However, I...

I have a database that has been up and running for a long time now - All of the sudden, one of the tables had records data in it for just 2 or 3 of the fields - the primary key fields also contained blank information. I tried many things but finally copied the data (except the corrupted rows)...

I am having a real hard time understanding how to make this work - I am getting the "query not updatable" error on the following UPDATE tblSmEmployerGrps INNER JOIN qrySmallEmployerGroups7 ON tblSmEmployerGrps.MAIN_GRP_ID = qrySmallEmployerGroups7.MAIN_GRP_ID SET...

I have users in two locations. Only the users in one location are unable to use command buttons that run reports. Two weeks ago all was fine. I really think this is a network issue since 1. two weeks ago the users were fine 2. the users in the other office are fine. Here is the code for the...

I have an existing database that tracks sales of external sales companies that we use to distribute our product. Historically, we have tracked these agencies using a field named "masterbrokerkey" However, one of the outside companies may actually be two companies that together make up one of...