Combining fields to create a unique ID in Microsoft Access
I have been working on a database for my research job.For our research purposes we are trying to create a unique identifier that tells us 4 things: 1) what study they are a part of, [this will be “QQQ” for EVERYONE] 2) what group they are in, [this will be a four digit number, such [...]

Answer Question   |  March 5, 2009  6:53 PM
Microsoft Access, Microsoft Access Unique ID

MS Access Tools References…
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]

Answer Question   |  March 4, 2009  5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA

How do I display a clickable link from database in table using PHP?
I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print “<b>Here is my Information on you. <br><br>E-Mail me with any changes.</b><P>”; [...]

Answer Question   |  March 4, 2009  3:44 PM
Database, Display File, PHP, table

Database Connection Error
When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant) ODBC Oracle 8 Driver ORA-06550:Line1,Column8,PLS-00201:identifier’xxx.PRC_RI_REPORT’Must be Declared ORA-06550:line1, column 8: pl/sql Statement ignored Error Detected by Database DLL And,Database Connection Error

Answer Question   |  March 4, 2009  2:09 PM
Crystal Reports, Crystal Reports Database, Crystal Reports error messages, Database Connection Error

How to install the MySQL JDBC connector?
Can anybody tell me how to install the MYSQL JDBC connector. I am getting error “java.sql.SQLException: No suitable driver “. I placed the driver in the java-jrelib folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

Answer Question   |  March 4, 2009  6:32 AM
Apache Tomcat, Database connectivity, Java, Java Database Connectivity, java.sql.SQLException, JDBC, JSP, Linux hosting, MySQL, Tomcat hosting, Web developers, Web development

Database connectivity between Microsoft Access and C++
how can i give database connectivity in code of c++, and my database is stored in ms-access?

Answer Question   |  March 4, 2009  6:24 AM
C, database connnectivity, Database programming, Microsoft Access

Correct database format for Rich Text/HTML?
I’m new to SQL and am creating a new database and I am wondering what format would work best. I am looking for the query results to be formatted (specifically hyperlinks and paragraphs). I am thinking that I need to go with XML to get this type of formatting. Is this the way to go? [...]

Answer Question   |  March 4, 2009  3:07 AM
Database Data Types, Rich text, SQL Data Types

How to implement One-to-One and One-to-Many class associations using VB.NET 2005?
I have designed a solutions for a Student and Employee Management system using Object Oriented concepts and techniques. I’m doing this management system as a Graduate Project. Now I’m stuck in implementing the association relationships. Can anyone help me on this. Answers using code examples would be great. Thanks, From Lahiru.

Answer Question   |  March 23, 2009  12:10 AM
class associations, Data modeling, Object-oriented programming, One-to-Many Relationships, One-to-One Relationships, VB.NET 2005, VB.NET classes

Formatting a subform for printing in access 2000
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]

Answer Question   |  March 9, 2009  8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms

What language “Next” from RPG(LE)
Hi everyone; I took a hiatus as a stay-at-home mom and am just back into the programming world. 13 years experience – 8 year break – back 1 year. Pure AS400 (can’t say iSeries yet) do use RPGLE (thankfully) understand free – used to be MAPICS guru (can’t say Infor either). Do any of you [...]

Answer Question   |  March 9, 2009  4:10 PM
AS/400 careers, IT careers, Programming Languages, RPG, RPGLE

New Access user!
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there’s about 12 -15 copies. [...]

Answer Question   |  March 4, 2009  2:04 PM
Access Database, Microsoft Access

Access 2003 using IIf statement on a form
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]

Answer Question   |  March 5, 2009  9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access

MS Access 2007 Author credit
I’m designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

Answer Question   |  March 3, 2009  8:12 PM
Access 2007, Access Database, Microsoft Access

access 03 sending emails
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]

Answer Question   |  March 2, 2009  4:31 PM
Access 2003, Access Database, Microsoft Access

Prospects for Java developers?
Now ,I am studying Java programming J2SE. How do u think of this language? Should I continue to study? Can I stand as Java Professional. Most people says that Java is difficult and there is few jobs . And another question is How can I run Java RMI.

Answer Question   |  March 9, 2009  12:28 PM
IT careers, IT Job Market, J2SE, Java developers, Java Remote Method Invocation, Java RMI

Macromedia Dreamweaver Dataset problem
Hi, I’m new to web development and I’m working my way through the Dreamweaver manual (also in the PDF). It was going well well until I hit the wall in “Chapter 5 Developing a Web Application” (Page 69-82). My problem…. I can’t seem to get “Live Data View” to work (bottom of P.66 in the [...]

Answer Question   |  March 2, 2009  2:44 AM
.NET Framework 1.1, Database connectivity, Dataset, Dreamweaver, Dreamweaver MX 6.1, Macromedia, Macromedia Dreamweaver, Web development, Windows XP

Dynamic/Data-driven page creation and content
Hello! Sort of a “newbie”, so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information – storeable/retrievable as a “unit”, representing a particular “view” of a model/data in a database. For example, I have a database [...]

Answer Question   |  March 2, 2009  9:00 PM
Ajax, ASP, CSS, Data-driven, Database connectivity, Database-driven website, DHTML, Dynamic content, dynamic controls, Dynamic HTML, Silverlight, Web development, Windows Forms

Looping Queries in Oracle using data from SQL Server
I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = ’0′ CONNECT BY PRIOR a.parentid = a.sid’ Where I have ’0′ in the query above, should take all the values from PID. Is there a easy way [...]

Answer Question   |  March 2, 2009  4:05 PM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity

Converting data to SQL Server data with the DTS wizard
I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records. When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type “money” was not correctly transferred. For an example, the value 9700.00 was [...]

Answer Question   |  February 27, 2009  3:41 PM
DTS Import/Export Wizard, DTS Wizard, SQL Server, Sybase

SQL Server 2005 database mirroring over a VPN router
Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

Answer Question   |  February 27, 2009  3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers