Search results for query: *

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

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

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

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

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

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

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

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

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

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