Search results

Hi there, I am making a db that will store complaints for an institution. I currently have a Complaint ID field, however I want to append the current year to the Compalitn ID field. i tried the following: Me.f00 = Year(Now()) & f00, but got an error. Any suggestions.

Hi there I am trying to display the value of a field on a report. This field exists in a query. This is what I have right now: =[UnitConcernCount]![Ash 1] but I keep getting a #NAME whenever I run the report. Any idea on what I am doing wrong? Thanks

Hi there, I currently have a chart that displays stats (# of incidents in a hospital per ward). Currently there are 10 wards in the hospital, but I only show 8 of them in the chart. What I want to do is have a little table beside the chart that shows the name of the ward as well the percentage...

Hi there, I have a date field in my table with the following format mm/dd/yyyy. The dates in my table vary from all the way back from 1994 to today. What I am trying to do is count the number of records in each year. So have it output something like this Year Number of Records 1994...

Hi there, I have a field called Unit in my table. That field references another table which has about 5 entries. The user can select one on the form. What I want to do is count how many times each one has been selected so that i can create a chart. The unit names are: North, West, East, South...

hi there, I have been struggling over this the past few days and get no where. I am trying to count the number of times Yes appears in a few fields. This is what I have right now in design view: Field1YesCount: Count(IIF([Field1] = True,1,0)) Field2YesCount: Count(IIF([Field2] = True,1,0))...

hi there, I have been struggling over this the past few days and get no where. I am trying to count the number of times Yes appears in a few fields. This is what I have right now in design view: Field1YesCount: Count(IIF([Field1] = True,1,0)) Field2YesCount: Count(IIF([Field2] = True,1,0))...

I am having a problem doing the IIF statment. Is there anyway that I can avoid the else part of the IIF statment from being executed. I am genterating a report based on what a user selects on a combo box from a form. There are about five options to pick from so this is what I want...

Hi there, I currently am trying to generate a report. I have a bunch of option buttons on my form. What I am tryign to do is generate a list of each option selected. So a list of how many times each option is selected. Sicne each option has its own field in the table i'm having trouble...

Hi, I am trying to display a default value of 06 followed by 3 digits, that the user would enter in. Would this be done in the Input Mask, if so how? Thanks

Hi, I am trying to display a default value of 06 followed by 3 digits, that the user would enter in. Would this be done in the Input Mask, if so how? Thanks

Hi there i am building a search form and I want it to be able to display results from multiple criteria......Currently I am able to display results in a listbox, whenever the user types in a id number in a text box. So if a user types 63 in the ID text box the record with and ID of 63 will...

Hi there I currently have a DB with a ton of records. What I want to do is have a search box pop up when the user presses a button on the main form. When this search box comes up there is a list box with all the records. The user will then double click a record on the List box and it should...

Hi there, I currently have a search subform that will search for a specific record based on an ID or Name. However I do not want all the records to be filtered. I still want the user to be able to traverse through the other records. Is there any way that I can disable the filtering? thanks

Hi, I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank. Any thoughts? Thanks

Hi all, I was wondering how would we change the forms row source everytime a new new item is selected in a combo box. For instance here is a table: ID Name Status 1 Joe Active 2 Fred Inactive 3 Sam Inactive So if the names were to be...

Hey all, I am trying to link a option group to a combo box. The combo box has a list of employee names. The option group has two options Active and Inactive. All I want the user to be able to do is check the current status of an employee (as active or inactive) and to be able to change their...

Hi there, I am new to access and this question be a no brainer for you access gurus. What I currently have is a form with one combo box and two radio buttons. Staff and Status The staff combo box is a drop down menu of all staff members and is derived from a table called Employees. The two...

Hi Does anyone know how to remove the "Record ID" from the record selector? I want to be able to traverse from one record to the next, however I do not want the field representing what record it is on showing up ( if that makes any sense). Thanks

Hi there I am new to Access and I am currently modifying an existing DB. Currently this DB has a main table which holds a bunch of Patient info such as: Name Age AssignedStaff Condition etc.... The assigned staff field is populated from another table (Staff), which holds all the staff members...