Search results for query: *

The files are in this link: http://www.box.net/shared/rbi9gebnhg Thanks, Victor

The data from group1 dissapears, seems like adding group 2 with group 1 causes the report not to work. For example: group 1 GM Ford Group 2 Red Green Group 1 is not linking with group 2. Victor

Hello, I don't have an SQL, in the tables are linked through the relatioship section of access. table 1 Id is linked to Make_ID field in Link_Table (1 to many) table 2 Id is linked to Colour_ID field in Link_Table (1 to many) Tables are also linked the same in the link section of crystal...

Hello, Table 1 contains ID Make 1 GM 2 Ford 3 Chrysler Table 2 contains ID Colour 1 Red 2 White 3 Blue LinkTable contains ID Make_ID Colour_ID 1 1 1 (GM Red) 2 2 1 (Ford Red) 3 1 3...

Hello, I think I need to add other columns in Tables 1 and 2 because if I only use the ID columns from both tables, I will only link to table 2 where the ID columns match in both tables. I want to be able to see multiple records in table 2 that applies to a record in table 1. For example when...

Hello, I am having difficulties designing a database with data from table 1 referencing multiple data in table 2. For example: Table 1 includes: id Title 1 105MM 2 155MM Table 2 includes: id Country 1 BEL 2 CAN 3 FRA 4. ITA How do I design both Tables...

It worked Thank You.

Hello, What is the proper syntax for searching using the NOT IN command?, the IN sybtax works, but the NOT IN is not the proper syntax. IN Syntax: myaop29report.RecordSelectionFormula = "{AOP29.field2}in [ " & xyz & "]" NOT IN Syntax: Error Message (boolean or string expected)...

Hello, How do you automatically launch crystal report 2008 .msi file with the VS2008 setup project. The .msi file is included in my project as a separate folder, but when I run the VS2008 setup project the crystal report doesn't automatically launch. Thanks, Victor

The data in the text file is in the following format: aaaaaaaaa bbbbbbbbb ccccccccc ddddddddd eeeeeeeee what SQL commands would read every line and search against the database? Thanks

Hello, I have a text file with a column of data. How do I search for matching records against a database field? Thanks, Victor

Hello, I'm getting the followwing error at the cmd.ExecuteNonQuery() line: No value given for one or more required parameters. I can't see what's causing the error. Thhanks, Victor

Hello again, I tried the same code to transfer data from a diferent table, but I am getting the following error: "No value given for one or more required parameters", at the cmd.ExecuteNonQuery() line, given my code can you help me determine the cause of this error. Thanks, Code: Dim...

it's working ok :-) Thanks a million. How do we avoid duplicate hobies from matching field to be included in the IDENTIFICATION_DATA table? Thanks, Victor

Hello, This problem was resolved. Thanks for the code. Victor

I added: SQLStr += " WHERE IDENTIFICATION_DATA.NIIN = REFERENCE_NUMBER_DATA'" but I'm still getting the following error, the code field is definitely large enough to capture the data, any idea what's causing the error?. Error: The field is too small to accept the amount of data you attempted...

Hello, I'm getting the following error on line:cmd.ExecuteNonQuery It looks like the "'" don't match, I couldn't figure it out. Syntax error in string in query expression ''hockey,swimming,'. Can you please help me fix this error. Thanks, Code: Dim ConnectionString As String =...

Thank you, I will try it and get back to you. Victor

Hello, I got it to work with the following SQL: Dim mySQL_Statement As String = "UPDATE identification_data " & vbNewLine & _ " INNER JOIN " & vbNewLine & _ " reference_number_data " & vbNewLine & _ " ON identification_data.niin " & _ " = reference_number_data.niin " &...

Thank you for the code. Victor