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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CGSB

  1. CGSB

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

    Thank you! I never would have guessed it was that simple.
  2. 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...
  3. CGSB

    Problems displaying a SUM

    Thanks for the reply. My SQL query, as is, can determine whether the value is null or not. It just doesn't sum up all the null values for each "gcNo". I want to be able to determine the sums of "yes_memberName" for each individual "gcNo", not each individual "yes_memberName" like my query is...
  4. 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...
  5. CGSB

    Unwanted Grouping in Access Reports

    It is grouping on the dept field. Here is an example of the report that is being produced: name1 dept1 target1 name2 target2 name3 target3 name4 dept2 target4 name4 dept1 target4 In the above example, dept1 should be displayed once in the first 3 rows, but is only displayed in the...
  6. 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...
  7. CGSB

    Excel VBA - Detecting a cell's format

    Hi, thanks for the tip. I'm tried using the format number property but it didn't work. I made a mistake in my previous post. The cell is not formatted as a date, but rather its Category is set to Date in the Format Cells option. Now I need a way to open a form which contains a calendar whenever...
  8. 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?
  9. CGSB

    3421 data conversion type error on Win Xp machine

    The XP OS and the MS Access software on that specific machine is French. So when the boolean variable was set to "False" or "True", the system was dishing out "Faux" and "Vrai". I changed the boolean variable to a string and set the variable to "False" or "True" depending on the users choice...
  10. CGSB

    3421 data conversion type error on Win Xp machine

    Nevermind, I figured it out.
  11. 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...
  12. 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 =...
  13. CGSB

    &quot;Edit&quot; button on continuous form

    I disabled the fields because I don't trust my users with that much data. They could easily uncheck a checkbox or change a comboxes value by erroneously clicking somewhere on the screen. I'm surprised you've never seen this method of safeguarding data before. It's very common in ASP and ASP.NET...
  14. 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...
  15. CGSB

    String Functions Not Working?

    Thanks PVH! I forgot to add the space in the arrays' delimiter. That fixed it.
See more

Part and Inventory Search

Back
Top