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: *

  1. btcomput

    User Selected Fields for Report

    Hi, I have written a routine in a VB program that allows users to select fields they want included in a report. I hand coded the report to include just those user-selected fields. Is there a way that I can create a report in Crystal Reports that will print just those fields that the user...
  2. btcomput

    Proper use of Left(.) and right(.)

    Hi, I haven't upgraded yet to VB6, so that's the reason for not using Replace. Thanks for letting me know about it though. Next, I have realized all along that my code would not handle multiple occurances of the apostrophe. I've looked at a couple users' databases, and apostrophes occur...
  3. btcomput

    Proper use of Left(.) and right(.)

    I think I finally have it working! The code I ended up with is based on the {field} [ 3 to 6] format. The code isn't pretty, but it works. Basicaly the code works this way: If InStr(1, cmbclub.Text, "'") > 0 Then spot = InStr(1, cmbclub.Text, "'") clublen =...
  4. btcomput

    Proper use of Left(.) and right(.)

    What this all boils down to is that I do not know, in advance, what string the user will be searching for. The program reads records from the user's database and plugs a list of clubs into a drop-down combo box, "cmbclub". Some of those club names MAY contain an apostrophe, most will...
  5. btcomput

    Proper use of Left(.) and right(.)

    Ken, I don't have it working yet. The following code: fmlatext = "'" & cmbclub.Text & "' in {result.club}" produces: "'Fred's Bass Club' in {result.club}" and looks like it should work, but doesn't. It DOES work if the string does not contain an apostrophe, such...
  6. btcomput

    Proper use of Left(.) and right(.)

    Thanks Ken, I am wrinting the code within a VB program, and using the code: report1.SelectionFormula = fmlatext to send it to CR. The code displayed in my original post works fine if the string does not include an apostrophe, otherwise I get "formula error" messages. Elsewhere...
  7. btcomput

    Proper use of Left(.) and right(.)

    Hi, I'm trying to develop a recordselection formula in a VB program to search for all records with the string: Fred's Bass Club in a field called "club" within a table called "results" The problem is that in this case, the string has an apostrophe in it. I have tried the...
  8. btcomput

    Formula Help

    Hi, I have set up this formula: TrimRight ({Roster.Last})+ ", " + TrimRight ({Roster.First}) + " " + {Roster.MI} to display first last and MI fields in a "Name" column. As long as all three fields are NOT null, I get: Name: Jones, Fred P Smith, Nancy A Timmons...
  9. btcomput

    Putting values into text boxes

    Hi, How can I write code to put values of variables into text boxes in a form on an ASP page? Any help would be appreciated. Thanks
  10. btcomput

    Current month

    Try this:<br><br>To get the date:<br>Dim dbCurrentDate<br>dbCurrentDate = Date()<br><br>to get number of the month:<br>Dim NumofMonth<br>NumofMonth = Month(dbCurrentDate)<br><br>To get number of days in the month:<br>Dim iDaysinMonth = DatePart(&quot;d&quot;,DateSerial(year(dbCurrentDate)...

Part and Inventory Search

Back
Top