In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?
My recommendation would be to create a lookup table for categories, and alter your products table to add a new column for a category Id. Then you would need to show the information joining both tables (on the category Id). After adding the new column you would need to execute some UPDATEs on the products [...]
View Answer
| June 25, 2010 2:21 PM
Access 2003, Access Tables, IIF function, IIF statement, Microsoft Product ID
My recommendation would be to create a lookup table for categories, and alter your products table to add a new column for a category Id. Then you would need to show the information joining both tables (on the category Id). After adding the new column you would need to execute some UPDATEs on the products [...]
View Answer
| June 25, 2010 2:21 PM
Access 2003, Access Tables, IIF function, IIF statement, Microsoft Product ID
Tattoos in the IT workplace
There is no one answer to this question; it’s a matter of corporate policy & culture. Most IT work environments are accepting of tattoos <b>provided</b> they are not “obscene” or overtly sexual (a tattoo of a large-breasted woman, for example, might not be appropriate to female co-workers). The major exception would be if your IT [...]
View Answer
| June 24, 2010 6:43 PM
IT career planning, IT careers, IT professional
There is no one answer to this question; it’s a matter of corporate policy & culture. Most IT work environments are accepting of tattoos <b>provided</b> they are not “obscene” or overtly sexual (a tattoo of a large-breasted woman, for example, might not be appropriate to female co-workers). The major exception would be if your IT [...]
View Answer
| June 24, 2010 6:43 PM
IT career planning, IT careers, IT professional
Report Page Header tied to Field in a Make Table in Access 2000
Since you only enter one month, just have the unbound box display the month of the date of the first record in the report. Or, make the unbound box bound to the date of the detail records. It will only show once in the header.
View Answer
| June 24, 2010 4:42 PM
Access 2000, Access query, Access Tables
Since you only enter one month, just have the unbound box display the month of the date of the first record in the report. Or, make the unbound box bound to the date of the detail records. It will only show once in the header.
View Answer
| June 24, 2010 4:42 PM
Access 2000, Access query, Access Tables
Flat file or Physical file in as/400?
First of all, a FLAT file is a Physical file. I’m thinking your question is really “How do I know if a file is externally defined?” Using RTVMBRD, you can determine if it is a PF or LF. To deteremine if the file is externally defined, you could to do a DSPFFD to a work [...]
View Answer
| June 23, 2010 1:43 AM
AS/400, AS/400 flat file, CL/400, Flat files, Physical File
First of all, a FLAT file is a Physical file. I’m thinking your question is really “How do I know if a file is externally defined?” Using RTVMBRD, you can determine if it is a PF or LF. To deteremine if the file is externally defined, you could to do a DSPFFD to a work [...]
View Answer
| June 23, 2010 1:43 AM
AS/400, AS/400 flat file, CL/400, Flat files, Physical File
RPG with Embedded SQL needs journaling
When you compile the program, verify that the parm “COMMIT” is *NONE. CRTSQLRPG PGM(X) COMMIT(*NONE) <pre> Specify Value for Parameter COMMIT Type choice, press Enter. Commitment control . . . . . . . *CHG ………………………………………………………. *CHG : Commitment control (COMMIT) – Help : *ALL : : *CS : Specifies whether SQL statements in the [...]
View Answer
| June 17, 2010 11:49 PM
AS/400, Embedded SQL, iseries v5r4, RPG
When you compile the program, verify that the parm “COMMIT” is *NONE. CRTSQLRPG PGM(X) COMMIT(*NONE) <pre> Specify Value for Parameter COMMIT Type choice, press Enter. Commitment control . . . . . . . *CHG ………………………………………………………. *CHG : Commitment control (COMMIT) – Help : *ALL : : *CS : Specifies whether SQL statements in the [...]
View Answer
| June 17, 2010 11:49 PM
AS/400, Embedded SQL, iseries v5r4, RPG
Renames clause in cobol
Depending on which COBOL you are using, if you only use the field name it may default to the first one defined. However, virtually all flavors of COBOL support a qualification of COBOL field names and you probably want to use that syntax.. 01 IN-REC. 05 FIELDA PIC X. 05 FIELDB PIC X. 01 WORK. [...]
View Answer
| June 17, 2010 8:44 PM
COBOL, COBOL statements, Programming Languages, RENAME statement
Depending on which COBOL you are using, if you only use the field name it may default to the first one defined. However, virtually all flavors of COBOL support a qualification of COBOL field names and you probably want to use that syntax.. 01 IN-REC. 05 FIELDA PIC X. 05 FIELDB PIC X. 01 WORK. [...]
View Answer
| June 17, 2010 8:44 PM
COBOL, COBOL statements, Programming Languages, RENAME statement
Updates on BLOB Storage Using SharePoint 2010
RBS (Remote BLOB Storage) is the “answer” to that problem, and it’s straightforward to configure it to support the out-of-box FILESTREAM provider of SQL 2008, so you can pretty easily get document libraries moved into a folder on the SQL server. The process is multi-step (well documented on TechNet) but straightforward. In the end you [...]
View Answer
| June 17, 2010 7:48 PM
BLOB, BLOB Storage, MOSS 2007, Sharepoint 2010
RBS (Remote BLOB Storage) is the “answer” to that problem, and it’s straightforward to configure it to support the out-of-box FILESTREAM provider of SQL 2008, so you can pretty easily get document libraries moved into a folder on the SQL server. The process is multi-step (well documented on TechNet) but straightforward. In the end you [...]
View Answer
| June 17, 2010 7:48 PM
BLOB, BLOB Storage, MOSS 2007, Sharepoint 2010
procedure create with compilation error ora-6550
You are missing the ‘IS’ (or ‘AS’) keyword: <pre>create or replace procedure p1 (a in number,b in number) <b>is</b> begin insert into staff(fno,lno) values(a,b); end p1;</pre>
View Answer
| June 17, 2010 4:30 PM
CREATE TABLE statement, ora-6550, Oracle error messages, Syntax errors
You are missing the ‘IS’ (or ‘AS’) keyword: <pre>create or replace procedure p1 (a in number,b in number) <b>is</b> begin insert into staff(fno,lno) values(a,b); end p1;</pre>
View Answer
| June 17, 2010 4:30 PM
CREATE TABLE statement, ora-6550, Oracle error messages, Syntax errors
ABAP or BI?
Hi CV, for any module in sap , abap is advantage, 100% abap is useful to learn sap bi, sometimes it is mandatory to learn sap abap. dont look back. go a head. all the best
View Answer
| June 16, 2010 10:57 AM
ABAP certifications, career in SAP ABAP, IT career development, IT careers, IT certification and training
Hi CV, for any module in sap , abap is advantage, 100% abap is useful to learn sap bi, sometimes it is mandatory to learn sap abap. dont look back. go a head. all the best
View Answer
| June 16, 2010 10:57 AM
ABAP certifications, career in SAP ABAP, IT career development, IT careers, IT certification and training
Data warehouse vs Database
All data warehouses are databases, not all databases are data warehouses. Basically a database is any system which keeps data in a table format. Here’s the definition: “A computer database is a structured collection of records or data that is stored in a computer system so that a computer program or person using a query [...]
View Answer
| May 15, 2013 11:12 AM
Data base design, Data warehouse
All data warehouses are databases, not all databases are data warehouses. Basically a database is any system which keeps data in a table format. Here’s the definition: “A computer database is a structured collection of records or data that is stored in a computer system so that a computer program or person using a query [...]
View Answer
| May 15, 2013 11:12 AM
Data base design, Data warehouse
Career change from IT hardware/networking to software development
Twenty years is such a long time; my advice is that you take advantage of the vast experience that you have attained throughout that period. Just do software development as a side-dish. Since you are considering going in the direction of Microsoft, C# and VB.NET would be ideal for you.
View Answer
| June 10, 2010 7:13 AM
Career change, IT career planning, IT careers, Software development
Twenty years is such a long time; my advice is that you take advantage of the vast experience that you have attained throughout that period. Just do software development as a side-dish. Since you are considering going in the direction of Microsoft, C# and VB.NET would be ideal for you.
View Answer
| June 10, 2010 7:13 AM
Career change, IT career planning, IT careers, Software development
Search for Records Containing Word(s) in Textbox
Instead of the specific words, use this notation in the field criteria: <pre>[Forms]![YourFormName]![YourTextboxName]</pre>
View Answer
| June 9, 2010 6:40 PM
Access 2007, Access 2007 functions, Query, TextBox
Instead of the specific words, use this notation in the field criteria: <pre>[Forms]![YourFormName]![YourTextboxName]</pre>
View Answer
| June 9, 2010 6:40 PM
Access 2007, Access 2007 functions, Query, TextBox
To write a stored procedure
We might need a little more info on this. A stored procedure usually takes some input, applies some logic, and returns a result. If the second table already has Zipcode and Congressional District, why do you need to join them? Simply querying the second table would give the desired result. Making some assumptions… ZipCode table [...]
View Answer
| June 9, 2010 6:38 PM
Relational databases, SQL Server stored procedures, Stored Procedures
We might need a little more info on this. A stored procedure usually takes some input, applies some logic, and returns a result. If the second table already has Zipcode and Congressional District, why do you need to join them? Simply querying the second table would give the desired result. Making some assumptions… ZipCode table [...]
View Answer
| June 9, 2010 6:38 PM
Relational databases, SQL Server stored procedures, Stored Procedures
Database Design Help
in your DEAL table you will need to add ORGANIZATION ID LAWYER ID Or optionally you might have another table with DEAL ID ORG ID LAWYER ID that shows the connections. You might consider adding a sequence number to the DEAL ID in case the first lawyer drops out and you need a new lawyer [...]
View Answer
| June 9, 2010 2:22 PM
Database, Database design, Database optimization
in your DEAL table you will need to add ORGANIZATION ID LAWYER ID Or optionally you might have another table with DEAL ID ORG ID LAWYER ID that shows the connections. You might consider adding a sequence number to the DEAL ID in case the first lawyer drops out and you need a new lawyer [...]
View Answer
| June 9, 2010 2:22 PM
Database, Database design, Database optimization
How to validate 2 fields
You didn’t provide any details about the programming language and the database being used. In general, you could perform such validation in your application, or with a database check constraint.
View Answer
| June 9, 2010 1:49 PM
Database alerts, Form validations, trans
You didn’t provide any details about the programming language and the database being used. In general, you could perform such validation in your application, or with a database check constraint.
View Answer
| June 9, 2010 1:49 PM
Database alerts, Form validations, trans
ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
View Answer
| June 8, 2010 6:08 PM
Access errors, Microsoft Access, SQL, SQL Access
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
View Answer
| June 8, 2010 6:08 PM
Access errors, Microsoft Access, SQL, SQL Access
How to restore MDF file as backup database
An MDF file isn’t a backup file isn’t the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks [...]
View Answer
| April 18, 2013 10:44 AM
Backup, Database, MDF, Restore
An MDF file isn’t a backup file isn’t the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks [...]
View Answer
| April 18, 2013 10:44 AM
Backup, Database, MDF, Restore
MICROSOFT INTERCHANGABILITY
They work together, but they are not interchangeable. They each fulfill a different function.
View Answer
| May 27, 2010 8:36 PM
Interoperability, Microsoft Access, Microsoft Excel, Microsoft Word
They work together, but they are not interchangeable. They each fulfill a different function.
View Answer
| May 27, 2010 8:36 PM
Interoperability, Microsoft Access, Microsoft Excel, Microsoft Word
Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010
Ahh, it works something like Notes/Domino.
View Answer
| May 27, 2010 7:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Ahh, it works something like Notes/Domino.
View Answer
| May 27, 2010 7:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Lotus Notes mailfile database deleted automatically
I would hope you are backing up your Domino server. We use Symantec BackUp Exec and we have Transaction logs enabled on Domino, so we perform point-in-time restores. You should work with your Backup Administrator to get the file restored. Also, you should be looking in the Administration Requests DB, not the Server Log DB.
View Answer
| May 25, 2010 4:08 PM
Database Recovery, Lotus Notes 8.0.1, Lotus Notes errors, Lotus Notes Mail Backup, Lotus Notes Mail File
I would hope you are backing up your Domino server. We use Symantec BackUp Exec and we have Transaction logs enabled on Domino, so we perform point-in-time restores. You should work with your Backup Administrator to get the file restored. Also, you should be looking in the Administration Requests DB, not the Server Log DB.
View Answer
| May 25, 2010 4:08 PM
Database Recovery, Lotus Notes 8.0.1, Lotus Notes errors, Lotus Notes Mail Backup, Lotus Notes Mail File
