Search results for query: *

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

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

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 have two tables with matching fields LAST: TABLE 1 (Records) LAST HOBBY charles Soccer TABLE 2 (Records) LAST INTEREST charles swimming charles basketball charles football I would like to have the following in TABLE 1 (Records) LAST HOBBY...

mySQL_Statement = "INSERT INTO IDENTIFICATION_DATA(code) (SELECT RN FROM REFERENCE_DATA(RN) WHERE IDENTIFICATION_DATA.NIIN = REFERENCE_DATA.NIIN)" Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\aopt2002orgorg.mdb;Persist Security...

Hello, I would like to join 3 tables based on a common field. Table 1 should always have data, but data from tables 2 and 3 will not always be available, can you please help me with the left outer join syntax for three tables, below is my code for joining two tables, but the and (after the IN...

Hello, I am using VB.NET 2005 and MS ACCESS 2003 My database contains data in the following format: 1305000248767 I need to insert "-" in several location to obtain the following format 1305-00-024-8767 How do I append the records to insert the "-" at these locations. Thanks, Victor

Hello, Hello, I have a text file with data for certain fileds that are in certain position, for example data for field1 is in yhe firts 5 spaces in each line, data for field2 is from the 7th space up to the 10th space, field3 from the 11th space to the 19 space etc..... I only know how to...

Hello, I'd like to create a database with VB.NET to distrbute via a CD, users will need to run the application either from the CD or the desktop. Can MS ACCESS (03/08) handle 300,000 records? Besides using a password, is there another way to protect the database?, can it be hidden in the...

Hello, I'm looking for an alternative to MS ACCESS, I'm building a database with over 300,000 records and was told ACCESS is not the best database, is filemaker the best alternative?. Can an ACCESS database be converted to filemaker? Thanks, Victor

Hello, I need help on how to search PDFs in a folder from text entered in a text box, list the PDF file names which contains the text in a list box and click on the filenames from the listbox to open the PDF. Can you please help me with the sample codes or links related to this topic. Thanks...