Access Form Question
Foreign key does not matter. You mix the integrity issue with joining of two tables. You can link ANY column of one table (record source of the main form) with ANY column of compatible data type of another table (record source of subform).

View Answer   |  March 18, 2009  9:31 PM
Access forms, Microsoft Access

Storing and retrieving an image in SQL Server 2000
[kccrosser] I have to disagree with mrdenny – using SQL database table fields to store image blobs works quite well, and there are a lot of positive reasons to use this technique – not the least of which is the consistency of the database transactions and backups. As far as how to manipulate the data [...]

View Answer   |  March 18, 2009  8:18 PM
SQL Server 2000, SQL Server Image Store, Visual Basic 6.0

SQL to insert comma-delimited string value to table column
This question can’t be answered without more information. Which SQL server are you using? (MS SQL 2005, MySQL, SQLite, …) What platform is it running on? (PC, Linux, …) What application are you using to building your queries? (Visual Basic, C++, Access Query Builder, PHP, …) How is the string being stored? (Text file, Spread [...]

View Answer   |  March 18, 2009  5:21 PM
Comma-delimited, SQL, SQL queries, SQL Server development, SQL Server Query

Application.FileSearch no longer exists (in 2007)
You could use the old FileSystemObject. This way you could loop all folders with GetFolder method and all files contained with Files method of the Folder object.

View Answer   |  March 18, 2009  2:16 PM
Access 2007, Microsoft Access, Office 2007, VBA

Accessing AS/400 DB2 physical files with Java
Here is link to the Java toolbox for AS/400 JDBC page. From here, you should be able to answer your questions. I wrote about this stuff in 2002 and I think it is still valid so check www.itjungle.com for articles on the subject. select the AS/400 Guru newsletter and scroll to the bottom (not sure [...]

View Answer   |  March 17, 2009  2:36 PM
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File

OS Downgrading
1. This <a href=”http://www.geekzone.co.nz/forums.asp?ForumId=45&TopicId=12525″>forum page</a> tell you who to call to get XP. The basic jist of it is that you have to find a Windows XP CD from somewhere, then install. When you get to the activation screen you have to call Microsoft to get a key. You’ll need to give them your Windows [...]

View Answer   |  March 17, 2009  12:02 PM
Microsoft licensing, OS installation, Vista compatibility, Vista to XP downgrade, Visual Studio 2005, Visual Studio 6.0, Windows Vista, Windows XP

Error while referencing external assembly in SQL Server 2005.
Does the assembly exist at the path specified on the SQL Server? You’d be better off placing the assembly in the GAC then calling it from there. What is the end goal of this assembly?

View Answer   |  March 16, 2009  7:22 PM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary

Excel macros – code does not execute
If you remark out “On Error GoTo 0″ the error that is generated will probably give you a clue.

View Answer   |  March 16, 2009  3:41 PM
Excel macros, Microsoft Excel

Mobile application development
That would depend on what platforms you want your applications to run on. One option (among many others) is <a href=”http://www.android.com/”>Google’s Android</a>, a linux-based mobile OS, in which you develop applications using Java. ——————————————-

View Answer   |  March 16, 2009  1:36 PM
Mobile applications, Mobile development

My C++ compiler showing error UNABLE TO OPEN IOSTREAM.H and IOSTREAM
Your compiler needs to know where to look for the header files. How to configure the ‘include’ directories will be different depending on the compiler you are using. CIN and COUT are not being recognized because they are defined in iostream.h which your compiler has not been able to include. —————————– i think you want [...]

View Answer   |  March 16, 2009  1:20 PM
C, C compiler, Header files, IOstream, IOstream.h

Network Controller Driver missing, company not known
I was having wireless network problems and I accidently went to control panel and uninstalled the Broadcom Network Adapter. I soon found out that I had a missing driver for network controller. I found this out by going to control panel, new hardware and doing a search for new hardware. Then I was trying to [...]

View Answer   |  March 14, 2009  11:30 PM
Cabling, Hardware, Hubs, Interoperability, Networking, NIC, Routers, Software, Switches, Tech support

Possible to deploy 2005 report to sql 2000 RS?
I don’t think so. I believe that the RDL format changed between SQL 2000 and SQL 2005, and so the SQL 2000 server won’t know what to do with the SQL 2005 RDL file.

View Answer   |  March 14, 2009  6:26 AM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005

Device information with vb.net 2005
see <a href=”http://kellychronicles.spaces.live.com/blog/cns!A0D71E1614E8DBF8!382.entry”>here</a> Turn this into a windows service and any time it changes it can notify you.

View Answer   |  March 14, 2009  12:45 AM
VB.NET, VB.NET 2005

How to send mail different domain users in VB.NET
I need more information. Are the domains able to talk to each other?

View Answer   |  March 14, 2009  12:42 AM
SMTP server, VB.NET, Visual Basic, Visual Basic .NET

Converting Integer to Short in VB6
This <a href=”http://digiassn.blogspot.com/2006/04/visual-basic-integer-to-stringstring.html”>site</a> has some information on variable type conversion, as well as a conversation thread that exapands on the concept a bit. The page located <a href=”http://theopensourcery.com/vb06tut.htm”>here</a> also has some promising looking information on it. Good Luck! -Flame ————————– You will need to provide more information about your question and what exactly you want [...]

View Answer   |  March 13, 2009  5:10 PM
DataType, Integer, VB DataTypes, Visual Basic 6

How can I automate the signon of a user to a 5250 device at IPL
Hi, If these devices are some sort of PC, one option would be to use something like PC Anywhere to take control of them remotely to sign them on. Can you give us some more information about the devices? Regards, Martin Gilbert.<b> Hi Martin, Thanks for such a fast reply. These are Intermec Model 2481 [...]

View Answer   |  March 13, 2009  4:29 PM
IBM PC5250 Emulator, Intermec, Intermec Print Server, IPL, PC5250

I am unable to do my Import, when I run my macros I received two errors, running excel 2003
Hello everyone I have the answer to my problem now, I am posting this for those that don’t have an answered or are having the same problem I was having too for running this macro staff!! I started by trying and running through the following steps on your computer and see if that helps? Download [...]

View Answer   |  March 13, 2009  4:21 PM
Excel 2000, Excel error messages, Excel macros, Microsoft Excel

Code Complexity tool for AS400
None that I’m aware of, though i have analysis tools for RPG and 2e which I keep thinkinbg I’ll release to the community. – they’re not polished up enough to pass as a commercial tool though – they generate numbers I need.

View Answer   |  March 13, 2009  4:15 PM
COBOL, Code Complexity, Open source software, RPG, RPG/400

Abstract system date in C++
If you want to retrieve the current system date and time (and you are on a windows system), you could use the GetLocalTime function. Here is an example: <pre>SYSTEMTIME time; GetLocalTime (&time);</pre> The SYSTEMTIME structure represents a date and time using individual members for the month, day, year, weekday, hour, minute, second, and millisecond. <pre>typedef [...]

View Answer   |  March 13, 2009  2:51 PM
C, Java classes, VB 6, VB6.0, Visual Basic 6

ER Model
Plz check these links…will be helpful http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm www.sourcecodeonline.com/list?q=er_diagram_for_railway_reservation_system

View Answer   |  March 13, 2009  11:32 AM
Database programming, Entity-Relationship Model, ER Model