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...
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("d",DateSerial(year(dbCurrentDate)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.