Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CGSB
  • Content: Threads
  • Order by date
  1. CGSB

    Excel: How to count the number of cells with a string

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

    Problems displaying a SUM

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

    Unwanted Grouping in Access Reports

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

    Excel VBA - Detecting a cell's format

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

    3421 data conversion type error on Win Xp machine

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

    Nested Queries

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

    &quot;Edit&quot; button on continuous form

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

    String Functions Not Working?

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

    SQL Query not updateable?

    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 =...
  10. CGSB

    This Recordset is not updateable error.

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

    How do I change a text box value in datasheet view for only one row?

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

    Update List Box

    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?
  13. CGSB

    Change List Box Selected Value to New Record

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

    How to determine which tab is currently selected?

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

    Cannot change a combo box's value

    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]...
  16. CGSB

    Combox Boxes not changing values

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

    Combo box value cannot be changed in form view

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

Part and Inventory Search

Back
Top