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

Sorry.... I guess I am confusing the terminology in my description. However, my conrols are named the same as my fields. For example, I have a field in my query that is named "status"... the text box in the report is also named "status" But I see what you are saying regarding the custom...

I actually just figured this out today. I am not sure if this is the best way to handle it, however, it does work. In the grouping footer (basegroupstatus) I added a field that has the following control source: =iif([basegroupstatus]="basegroup",sum(sumofstartingmembers]) This field is named...

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 always learn something from you.... thanks so much PHV .. I really appreciate it !!!! FRed

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

thanks so much Remou.... I tried that but I had left the ..,30)" at the end. I appreciate it!!! Joe, thanks for the reply. I do realize this. Thanks again!!! Fred

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 got it- .... ActiveSheet.Shapes("SussexData").Select Selection.Text = Range("Data!C22").Value Thanks!!!

Hi Glenn - thanks for the help!! The tutorial does not say you can add text.... I have come to the conclusion that what I need to do is just add text boxes that refer to my cells with the data. Can you tell me what the code is to refer to a text box (my textbox is named 'SussexData') in...

Thanks for responding Glenn. Here is the code: For i = 25 To 45 Range("actcounty").Value = Range("Data!C" & i).Value ActiveSheet.Shapes(Range("actcounty").Value).Select Selection.ShapeRange.Fill.ForeColor.RGB = Range(Range("ActCountyCode").Value).Interior.Color...

Forgot to mention that I am talking about excel.

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

Thanks so much for the help!!! I am not sure why I did not think that would work since I use dlookup all the time. Thanks again, I appreciate it!!!! Here is what I ended up with: Me.financefilemembers.Value = DSum("[Members]", "FinanceFile") Fred

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