in Access 2003, adding data in a table affect queries?
I’m not sure I understand the question correctly. By “<i>I want to add a name of a location to a field that is a drop down list of locations</i>” you mean that you are going to INSERT a new record in the table that stores the location names ? Anyway, keep in mind that ‘queries’ [...]

View Answer   |  February 8, 2010  11:30 PM
Access 2003, Access Tables, Microsoft Access

Statement separator for multiple DLast statements – Access 2003
You just need to put each instruction in a new line: <pre>Private Sub Form_BeforeInsert(Cancel As Integer) Room = DLast(“Room”, Me.RecordSource) Name = DLast(“Name”, Me.RecordSource) OtherField = DLast(“OtherField”, Me.RecordSource) End Sub</pre>

View Answer   |  February 5, 2010  3:22 PM
Access 2003, Microsoft Access

SQL for MS Access Syntex issue
I don’t know much about MS Access, but I think some statements can only be executed through ADO, and will throw errors when trying to execute them from the SQL View user interface. So, I would try creating a module, with some code like this: <pre>Sub CreateTable() CurrentProject.Connection.Execute _ “CREATE TABLE Manufacturers” _ & “( [...]

View Answer   |  February 2, 2010  3:26 PM
Microsoft Access, SQL

DB2 (Oracle funtionality in)
DB/2 runs on three IBM “mainframes” but the instructions would be very different on each. What is your system i-series (AS/400), AIX, or a true mainframe? Phil

View Answer   |  February 2, 2010  2:36 AM
DB2, DB2 file system, File systems, Flat files

Coding career question
The best way to get better at something, including writing code, is to practice by doing, then have someone review your work and show you where you used the correct techniques and where you used the incorrect techniques.

View Answer   |  February 1, 2010  7:08 PM
Careers, Coding, IT careers, Programming, Programming Careers

How do I transfer 300 gigs of information?? Please Help!!
For what it’s worth, you may consider disabling any realtime virus protection during the copies.

View Answer   |  February 1, 2010  2:32 AM
File transfers, unstoppable copier, Very Large Databases, western digital

Hardware and Networking
Having been in the industry for the past two decades I’ve seen nothing but growth in these areas and I believe there are studies to back this up. Here are some <a href=”http://www.principlelogic.com/careers.html”>resources for setting goals and getting ahead in your IT career</a>.

View Answer   |  February 1, 2010  2:16 AM
Careers, IT careers, Networking careers, Routing and switching

DDL
well you cannot view the contents of a logical file of type *LF,but you can view the physical file for which that logical file belong. i suggest you , you write GO QUERY, and then write the name of the logical file and specify the library, and press F5 with no selection,

View Answer   |  January 31, 2010  7:52 PM
Data Definition Language, DDL, DDL Index

Telecommunication certifications
Telecommunication Certificates * TIA CTP: The Telecommunications Industry Association’s (TIA) Convergence Technologies Professional * TIA CCNT: Certified in Convergent Network Technologies

View Answer   |  January 30, 2010  8:35 AM
Careers, Certifications, IT careers, Telecom, Telecom Careers, Telecom certifications, Telecommunication certifications

Different results for embedded SQL
I doubt that’s happening..please show us both commands and the values ..it’s likely a difference in library list or a value in the where clause. Phil

View Answer   |  January 30, 2010  3:26 AM
Embedded SQL, RPG, SQL, STRSQL

SQLCOD = -7008 when doing an insert into file using SQLRPGLE
Hi I did not see the exact code in question but do you have a pgm described varaible as the “Library name”? <i>That is not allowed when SQL is embedded in RPGLE.</i> Jim …….. Yes, it is allowed. You just have to code it properly. — Tom Is commitment control on? If not, are you [...]

View Answer   |  January 29, 2010  2:40 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE

connectivy between C++ and MS Access
Here’s an example from the MSDN library (VS 6): <b>In the following example, an application allocates environment and connection handles. It then connects to the SalesOrders data source with the user ID JohnS and the password Sesame and processes data. When it has finished processing data, it disconnects from the data source and frees the [...]

View Answer   |  January 27, 2010  10:27 PM
C++, Microsoft Access, Turbo C++

Access 2007 form creation
<a href=”http://office.microsoft.com/en-us/access/HA010345481033.aspx”>Here</a> is info on how to create access forms. Once you got that down add code like <a href=”http://www.peterssoftware.com/c_emfa.htm”>this</a> to send out an emai. ————————————————————————————————————————— Hi there, First of all thanks for your help. The code that you provided was really working. Now that i have one problem here. When drafting email how do [...]

View Answer   |  January 26, 2010  8:09 AM
Access 2007, Access forms, Microsoft Access

Mainframe Careers
Goals…what are your goals? What do you want to do and where do you want to be in 1, 5, 10 years from now. Here are some<a href=”http://www.principlelogic.com/careers.html”> IT career resources</a> to help you get started.

View Answer   |  January 24, 2010  3:47 PM
Careers, IT careers, Mainframe, Mainframe careers

multi-use of the database
The fact that you are using XAMPP doesn’t matter. Once XAMPP is running it’s just like a regular server install. <a href=”http://dev.mysql.com/usingmysql/java/”>Here</a> is the documentation for using MySql from java.

View Answer   |  January 23, 2010  7:01 PM
Java Database Connectivity, MySQL, NetBeans, xampp

Constraints (MySql,tables,null,PK,FK etc)
I would take Carlosdl advise and read up. Here is how I would do this: CREATE TABLE department( departmentId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentNumber VARCHAR(16), departmentName VARCHAR(64) NOT NULL, isEnabled TINYINT NOT NULL ); CREATE TABLE course( courseId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentId INT NOT NULL, courseNumber VARCHAR(16), courseName VARCHAR(64) NOT [...]

View Answer   |  January 23, 2010  6:42 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables

export VB6 report in pdf format.
Your going to have to use a third party DLL. I would reccomend avoiding this all togetehr and instead installing something like: <a href=”http://sourceforge.net/projects/pdfcreator/”>PDFCreator</a> on the users computer so they can print the crystal report to pdf.

View Answer   |  January 21, 2010  8:59 PM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic

How do I place duplicate directly below the copied record?
A form is just a method of displaying the records, so it doesn’t go about ordering them in any way, unless you specify a sort order in your query. If the records have an id of some description that you can use to group them, then use that as the order by clause, and then [...]

View Answer   |  January 21, 2010  2:14 PM
Microsoft Access, Microsoft Access forms

Client Access Data Transfer
Create an empty Physical File with the name of your choice. Be sure the file record length matches the spool file width. (EX: 80 or 132 or someting else) Once the file has been built use the Command CPYSPLF to populate the Physical File. When copying the spool file specify *NONE for the Key Word [...]

View Answer   |  January 21, 2010  8:40 AM
AS/400, DB2 Universal Database

Software Testing as a career option.
I would say that almost every job position would require you to work as a part of a team, and would involve communication with other people to some degree. You could consider a service/help desk position if you want a more people-oriented job. The question is: do you like software testing ? Do you think [...]

View Answer   |  January 20, 2010  1:32 PM
Careers, IT careers, QA, Quality assurance, Quality Assurance Careers, Software testers, Software testing, Software Testing Certification