Search results

I have a database I have the tables linked to SQL Server 2008. As going through my form updating the VBA errors I have two I can not figure out. The Index and Seek (highlighted in green) highligh it's self in yellow in the module. The primary key is set on ID_D. Have any ideas? Private...

I am trying to create a stored procedure that will allow me to search column named "AuditResults". As the StartDate and EndDate popsup to enter my date range, I would like the keyword search to popup as well so I can enter the keyword I am looking for in the "AuditResults" column. This is what I...

I need to set date parameters within Stored Procedures using a sql 2008 R2, with an access 2007 front end. The procedure needs to allow me to set parameters for a start date and an end date.

I want to populate two text fields from a combobox with a command button to enter into text boxes in my form. The combobox is getting it's info from tblcommitteeinfoentry. The two fields are PI and RDOfficeStudyNo. The form name is Frmconsenterror and to populate the table called...

I need to create a multi-user with user levels such as admin, and read only access database I created. I curently made a login with a password to get in the database but I want to only allow certain people to just have read-only access. I may have to discard the login I created that I found on...

I have a form I am trying to show the vacation time used. The table name is Timeoff, columns are: "Code" (shows Vacation and illness) and "Timeused" (Hrs used for vacation, example 8 hrs for the day) I would like to add the "Timeused" (8 hrs) that has the "code" (Vacation) to show in the...

In my query I need to show Oct - Dec as "1 Qtr 2010" Jan - Mar as "2 Qtr 2011" etc The code I am using now gives me 2010 as the fourth quarter. Here is the code I am using: Qtr: Format$([Dateofaudit],"q"" Qtr - ""yyyy",0,0) The return is: "1 Qtr - 2011" etc. I tried adding -1 at the end...

I want to count how many (FindingTotal) I have done by quarter (dateofaudit) in my report. I used this formula to get my numbers for the year: =Sum(IIf(Year([dateofaudit])=2011,[FindingTotal],Null)) Now I need to the same but break it down to quarters. How would I convert this to quarters. Thanks!

I created a query to pull information from my table. The query is a crosstab and I am getting <> in a cell that has no information. I know what the problem is but can't figure it out. Here is what I have in each of the crosstab: (Year([DateofAudit])*4+DatePart("q",[DateofAudit])-1) Group By...

I have a graph that is pulling data from a query. What I am trying to do is add a total for the year. I have two columns, one is, Dateofaudit and Total which shows the total number of findings for a particular finding that I enter myself. I tried using the sum and Total functions but can't get...

I am trying to create a query that will remove empty cells in all columns off of another query that collects the data from multiple tables. I like to combine the cells with data in a report. Example: Name Date Column1 Column2 Column3 etc Sally 10/01/10 Text no text text ..... Ted 10/02/10 no...

I am trying to create a percentage of the (yeses and N/A) / (No's). There are 22 column names from another query. This is what I have tried in my query by I should be in the high 90% range instead of 4%. Yes...

I am trying to add the Yeses and N/A's in a query from my table. I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column. I also need to add the No's separately from the others. Thanks!

I have a query that is used to pull data to the report by between dates to include writeups and yes, no, and N/A's per question (combobox). Works great. I created another query to pull the totals of yes, No, and N/A's by column off of that query. Here is one example of one of the questions...

I have a report where I am trying to count all the text boxes which comprises of about 8o. I want to separate them by Yes, No and N/A. I tried a few different options and none have worked in Control Source. Example1: =Count(IIf([RDStudyAuditSectionA.Doc #12-5]+[RDStudyAuditSectionA.Email...

I have a report that I can not collapes the blanks cells. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set to pull by Principal investigator. If you...

I have a report that I can not collapes the blanks. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set by Principal investigator. If you look at the...

I am creating a query with multiple tables. What I need is for the query not to pull what "Is Not Null" in column2 and column1 should not be pulled as well. 1=Yes, 2= No, 3 = NA Example: Column1 Column2 Doc #2 Com-Doc #2 2 Document is missing If (Com-Doc #2) is...

I am trying to filter a query to give me this. The filters below is what I am trying but Date 2 is still pulling dates that are less than june 1, 2009. Date1 is filtered like this: >#12/31/2007# Between [Enter: Start Date Like 05/31/09] And [Enter: End Date Like 06/01/10] Date2 is filtered...

I have a query that I want to be able to change my search criteria by keyword(s). I want it to be able to ask me to enter keyword to search for so I can filter it to a report. Here is what I have tried with no success: Search for Keyword: Enter Keyword [" "] Search for Keyword: Enter...