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!

  • Congratulations TouchToneTommy 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: herbal
  • Content: Threads
  • Order by date
  1. herbal

    Changing color of row based on column value

    Can someone give me a quick rundown on how I would change the color of the text for a record if one column's value meets criteria? Example... My report contains Name, DOB, and Barred. Barred is the last column to be printed in a row(not sure if you needed to know this). If the value of...
  2. herbal

    String concatenation...should be an easy one..

    Hello. I have a label with the following string: The membership committee hereby approves these minutes as a summary of actions taken at the membership committee meeting on __________ as evidenced by the minute wraps filed on club premises. How do I replace the _________ with today's date? I...
  3. herbal

    Conditional report-dependant on Day of week....

    I have a report that requires the user to enter the date of a membership meeting. As it is currently, the report takes the date entered and subtracts 3 days and uses the two dates for the range. I'd like the report to make it subtract 3 days only if the date entered by the user is a Monday...
  4. herbal

    One more question about this report you folks built me :-)

    I need to just add a count of records by group. To be more specific I need a count of added records, and a count of expired records. Here's the SQL statement: SELECT 'Expired' As [Type], ExpiredMembers.FirstName, ExpiredMembers.MiddleName, ExpiredMembers.LastName, ExpiredMembers.DateUpdated...
  5. herbal

    Report thats way complex for me....

    I have a membership application that uses an access database. The DB has two tables, members and expiredMembers. When a member has expired the DB moves the record to the expiredMembers table and creates a new record in the members table. I need to make a report that will print both members...
  6. herbal

    Delegate/timing - WAY over my head...

    My app was throwing a no value at index 1 error that Microsoft told me was caused by a bug in the timing of the defaultview filter change. To fix this, they commented out the following: .DefaultView.RowFilter = "TDL = '" + scannedMember.TDL + "'" and replaced it with the...
  7. herbal

    Newbie guide for debugging????

    I'm having some problems that noone seems to have an answer for, so my question is does anyone know of a newbie guide for debugging VB code? I've got no clue and need something to get me started. Thanks Herbal
  8. herbal

    An unhandled exception of type 'System.IndexOutOfRangeException' occur

    An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.windows.forms.dll this is my error. It seems to me that this error originated when I added sorting to my datagrid with the following code: With DsMembers.Members .DefaultView.RowFilter = "TDL...
  9. herbal

    foundRow = Ds.Members.FindbyTDL(tdl) - help!

    I'm using the following code: foundRow = ds.Members.FindbyTDL(tdl) How would I go about checking to verify whether or not it found a row? Thanks Herbal
  10. herbal

    question for experienced....

    Is it possible to set up an app to detect a serial communication event like for instance the swiping of a magnetic stripe reader? So that your app senses a scan and acts accordingly? Thanks, Herbal
  11. herbal

    Simple question about findby<primarykey>

    My code looks like this: dim foundRow as datarow foundRow = dsMembers.Members.FindByTDL(05403690) Basically, I just need to know how I would check to see if it found a record or not. I can't think of a way to do it. Thanks in advance! Herbal

Part and Inventory Search

Back
Top