Search results for query: *

I would like to use a formula that will count the number of cells (within a range) that have text. For example, cell B2 = "Pineapple", cell B3 = "Word", cell B4 = null. I would like the resulting count to be 2. This is what I tried: =COUNT(IF(LEN(B2:B19) > 0, 1, 0)) But the result is 0...

I'm having problems with the following query: SELECT gcNo, yes_memberName, SUM(IIf(yes_memberName <> null,1,0)) as total_yes FROM ballotReportData Group by gcNo, yes_memberName; I want to display the total amount of yes_memberNames that aren't null for each gcNo. For example, I want the...

Hello, I created an report in access which uses the following query as the Record Source: SELECT candidate.*, sys_gcdepts.name_e AS dept, enrolment.target FROM sys_gcdepts INNER JOIN (candidate INNER JOIN enrolment ON candidate.file_no=enrolment.file_no) ON...

Is there a way to call a specific procedure when a cell formatted as date is clicked?

I developed an Access DB which was running fine on Win 98/2K. Now one of our employees had Win XP installed and she is getting the a 3421 data conversion type error. I don't know why it won't work on Win XP. Here's some more info to help anyone who can resolve this issue: - Using the...

I am having problems making the following query work the way I intend it to work: SELECT serie_no AS sn, STR((SELECT COUNT(standard_id) FROM standard WHERE is_pdf=True AND is_current=True AND serie_no = sn))+'/'+STR((SELECT COUNT(standard_id) FROM standard WHERE is_current=True AND serie_no =...

I am using a continuous form to display data like a datagrid would. All of the text boxes and checkboxes are disable when the form opens. At the end of each row, I have an "Edit" button. I want this button to enable the textboxes and checkboxes on its relative row. However, when I click the...

I created a function which will go through every cell in column B to replace "bad" strings with "good" strings. Below is what I have come up with. My problem is that the Replace and InStr functions do not seem to work. My variable strPos is always 0. Replace never replaces the string even when...

Hi, I have a Recorset in Access which uses the following query: SELECT course.course_name, candidate_course.status, candidate_course.year, candidate_course.quarter, candidate_course.file_no FROM course LEFT JOIN candidate_course ON (course.course_id =...

My form uses the SQL statement below to populate itsfields: SELECT course.course_name, candidate_course.status, candidate_course.year, candidate_course.quarter, candidate_course.file_no FROM course LEFT JOIN candidate_course ON (course.course_id = candidate_course.course_id...

I have a sub form which opens in datasheet view. When the user updates a value in one of the rows, I want another value in the same row to grab value from a text box on the parent form. Currently I have this Private Sub Status_AfterUpdate() txtFileNo = Parent!txtFileNo End Sub But this...

I have a bound list box. It lists a value called "file_no". When a new record is saved, I want it to requery, and automatically select the new "file_no". Any ideas?

I have a list box which displays "file_no" from a table. My module requeries the list box after a new record has been added to the table. I would like the new record's "file_no" to be selected after the list box is requeried. Please let me know if this is unclear, I'm not sure if I'm...

I would like to know how I can determine the currently selected tab so that I can call different functions based on the tab the user is on. Please help.

Hi, I have a combox box (selStatus) with the following values: Yes No Pending This combo box appears on a form which uses a query as it's record source. Here is my query: SELECT [course].[course_name], [candidate_course].[status] AS status, [candidate_course].[year]...

Hi, I have two combo boxes on my form whose value cannot be changed. If I copy these boxes to another form, they work! If I take a working combo box from another form, and insert into this form, it no longer works. I think the problem might be with my SQL query. However, if I open the query...

Hi, I have two combo boxes on my form whose value cannot be changed. If I copy these boxes to another form, they work! If I take a working combo box from another form, and insert into this form, it no longer works. I think the problem might be with my SQL query. However, if I open the query...