Search results for query: *

I have pop-up menus in my firework png file, that I export to html for use in DW. When I look at the html file and click on the menu items I get an error "Unterminated String Constant" This is just the code exported from Fireworks, before I have added to it. Can anyone give me some...

Good point, I don't usually use an actual string I ususally use a variable. Thanks for the suggestion. Roslyn

Thanks for the help guys, I figured out what is was, order is special word in SQL, can't use it as a variable. SQLText and SQLNumber change strings into text and number that are translated into readable code. Also harebrain, countrycode is a string not a variable containing a string, so it...

When I run the following code I get this error Syntax error (missing operator) in query expression 'validation='countryCode' AND'. I'm not sure what the problem is and therefore I'm not sure how to change this code. Thanks in advance for the help. Roslyn Private Sub Form_Load() lngCurrentID =...

Hi Again Here is my code, countryCode is a the text in a field in access now called fldvalidSection The code has changed a bit from before, trying to fix bug. Thanks roslyn Private Sub Form_Load() lngCurrentID = 1 strSql = "SELECT * FROM ValidationList WHERE fldvalidSection=" &...

countryCodes is the value in the field validation. I am running access2000 I'm not at my computer right now but I'll post more tonight if you could take a look then, i would really appricate it. Thanks Roslyn

I tried that also tried single quotes, both still came up withthe same error message. Any other suggestions. Roslyn

When I run the following code I get this error Syntax error (missing operator) in query expression 'validation='countryCode' AND'. Code: strSql = "SELECT * FROM ValidationList WHERE validation=" & SQLText("countryCode") & " AND order=" & SQLNumber("1")...

Thanks for the help. roslyn

Thanks synapsevampire, you've been a great help. Roslyn

Hi, I'm using a subreport in the group header. I want it to only display the records associated with that group. How can I do that? Right now it displays all of the records each time for each group. Thanks in advance. Roslyn

Thanks synapsevampire, It works great. One more question if you are up to it. Can it be done so that there aren't multiple strings. For example some of my possible fields are names of the people who have worked on the project but if they worked on more than one part then I only want to include...

Hi, I've only been using Crystal Reports for about a month now. I would like to display a list of strings, or a concat string that is all the values in a field. The problem is that I want to display them in the group header not in the details. I've looked at using a running total but think that...

Hi, I've only been using Crystal Reports for about a month now. I would like to display a list of strings, or a concat string that is all the values in a field. The problem is that I want to display them in the group header not in the details. I've looked at using a running total but think that...