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