How do I create an OEM-style bootable recovery partition?
I should I stated, this restoration is based on the fact that the hard drive is still functioning and the user may not have access to an FTP site or multi-cast environment to get another image sent to them. ======================================================================= ======================================================================= Tools needed: 1) Partition software – open source or commercial (e.g. http://partimage.org/Main_Page/) 2) Cloning [...]
View Answer
| March 10, 2010 9:30 PM
Bootable CD, clone, ghost and windows 98 without cd rom, Ghost image, image, Restore
I should I stated, this restoration is based on the fact that the hard drive is still functioning and the user may not have access to an FTP site or multi-cast environment to get another image sent to them. ======================================================================= ======================================================================= Tools needed: 1) Partition software – open source or commercial (e.g. http://partimage.org/Main_Page/) 2) Cloning [...]
View Answer
| March 10, 2010 9:30 PM
Bootable CD, clone, ghost and windows 98 without cd rom, Ghost image, image, Restore
MS access 2007 about field names?
Create table1 with UID, last name and telephone create a uniqur index on UID Create table 2 with OSID and OSName. It will have rows that look like OSID OSName 1 Windows 2 Linux 3 mac create a unique index on OSID Create table3 that has MID, UID and OSID They have foreign keys point [...]
View Answer
| March 7, 2010 4:57 PM
Field names, Microsoft Access
Create table1 with UID, last name and telephone create a uniqur index on UID Create table 2 with OSID and OSName. It will have rows that look like OSID OSName 1 Windows 2 Linux 3 mac create a unique index on OSID Create table3 that has MID, UID and OSID They have foreign keys point [...]
View Answer
| March 7, 2010 4:57 PM
Field names, Microsoft Access
Can System Center manage applications like MySQL running on Windows or Linux?
Yes, System Center has a variety of capabilities to manage heterogeneous environments including a variety of Unix based operating systems and applications, as well as VMware virtualized environments. Information on Operations Manager’s capabilities for this can be found here – <a href=”http://www.microsoft.com/systemcenter/operationsmanager/en/us/whats-new.aspx”>microsoft.com/systemcenter/operationsmanager/en/us/whats-new.aspx</a> and Virtual Machine Manager’s information can be found here – <a href=”http://www.microsoft.com/systemcenter/virtualmachinemanager/en/us/features.aspx”>microsoft.com/systemcenter/virtualmachinemanager/en/us/features.aspx</a>.
View Answer
| March 4, 2010 2:37 PM
Linux, Microsoft System Center, MySQL, System Center, Windows
Yes, System Center has a variety of capabilities to manage heterogeneous environments including a variety of Unix based operating systems and applications, as well as VMware virtualized environments. Information on Operations Manager’s capabilities for this can be found here – <a href=”http://www.microsoft.com/systemcenter/operationsmanager/en/us/whats-new.aspx”>microsoft.com/systemcenter/operationsmanager/en/us/whats-new.aspx</a> and Virtual Machine Manager’s information can be found here – <a href=”http://www.microsoft.com/systemcenter/virtualmachinemanager/en/us/features.aspx”>microsoft.com/systemcenter/virtualmachinemanager/en/us/features.aspx</a>.
View Answer
| March 4, 2010 2:37 PM
Linux, Microsoft System Center, MySQL, System Center, Windows
merging of two files in foxpro2.6
Open a file, and use append from command to merge 2nd file’s data in the opened file. Ensure that the field names are similar in the two files as closely as possible else you will have to map the two files fields.
View Answer
| March 2, 2010 4:12 AM
FoxPro, FoxPro 2.6
Open a file, and use append from command to merge 2nd file’s data in the opened file. Ensure that the field names are similar in the two files as closely as possible else you will have to map the two files fields.
View Answer
| March 2, 2010 4:12 AM
FoxPro, FoxPro 2.6
Microsoft Access counting part of a field
Thank you all for your time, I did eventually figure out what it was I needed to show. This is the statement that gave me the ability to show both critieria that resulted in a “1″; KC_NumCount: IIf([Key_Cntl_Num] Not Like “#.#” And [Key_Cntl_Num] Not Like “#.##”,”1″,”0″). With this I am able to count only the [...]
View Answer
| March 1, 2010 5:02 AM
Microsoft Access
Thank you all for your time, I did eventually figure out what it was I needed to show. This is the statement that gave me the ability to show both critieria that resulted in a “1″; KC_NumCount: IIf([Key_Cntl_Num] Not Like “#.#” And [Key_Cntl_Num] Not Like “#.##”,”1″,”0″). With this I am able to count only the [...]
View Answer
| March 1, 2010 5:02 AM
Microsoft Access
SQL for Microsoft Access
You might need to use parenthesis to group all your ‘OR’ conditions. When you use the OR logical operator, if one of the conditions is met, the result will be true whether the other condition is met or not. Something like this: <pre>Where <b>(</b>INMSP100.MSCLS =’72′ or MSCLS = ’73′… MSCLC = ’79′<b>)</b> AND INMSP100.MSRDTY = [...]
View Answer
| February 27, 2010 7:03 AM
Microsoft Access, SQL
You might need to use parenthesis to group all your ‘OR’ conditions. When you use the OR logical operator, if one of the conditions is met, the result will be true whether the other condition is met or not. Something like this: <pre>Where <b>(</b>INMSP100.MSCLS =’72′ or MSCLS = ’73′… MSCLC = ’79′<b>)</b> AND INMSP100.MSRDTY = [...]
View Answer
| February 27, 2010 7:03 AM
Microsoft Access, SQL
How to delete a database – MS Access 2007
I’m using Office 2010 but you should be able to adapt this answer Open Regedit and go to “HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0AccessFile MRU” You will see the list of recently used files. Delete the ones you don’t want. The list will get updated when you open new files and eventually your deleted files will drop off the list. [...]
View Answer
| February 26, 2010 11:51 PM
Access 2007, Access Database, Microsoft Access
I’m using Office 2010 but you should be able to adapt this answer Open Regedit and go to “HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0AccessFile MRU” You will see the list of recently used files. Delete the ones you don’t want. The list will get updated when you open new files and eventually your deleted files will drop off the list. [...]
View Answer
| February 26, 2010 11:51 PM
Access 2007, Access Database, Microsoft Access
Sql Query For My sql
Something like this should work: <pre>SELECT empid,name FROM employee e WHERE NOT EXISTS ( SELECT 1 FROM salary WHERE empid = e.empid AND month = ‘$month’ AND year = ‘$year’);</pre> -CarlosDL
View Answer
| February 23, 2010 1:31 PM
MySQL, SQL Query
Something like this should work: <pre>SELECT empid,name FROM employee e WHERE NOT EXISTS ( SELECT 1 FROM salary WHERE empid = e.empid AND month = ‘$month’ AND year = ‘$year’);</pre> -CarlosDL
View Answer
| February 23, 2010 1:31 PM
MySQL, SQL Query
SQLRPGLE – Result Set
As Tom write, PGMA need to access PGMB result set values . This is usually done by PGMB passing the result to PGMA by parameter or store the result in an object (workfile, data queue…) that PGMA can access. Using parameters you have 2 choices : passing parameter by value or by reference. In your [...]
View Answer
| February 22, 2010 10:06 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE
As Tom write, PGMA need to access PGMB result set values . This is usually done by PGMB passing the result to PGMA by parameter or store the result in an object (workfile, data queue…) that PGMA can access. Using parameters you have 2 choices : passing parameter by value or by reference. In your [...]
View Answer
| February 22, 2010 10:06 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE
Database Track Payment Information
Why not create it on the System i?
View Answer
| February 16, 2010 5:26 PM
AS/400, Database, Microsoft Access 20007
Why not create it on the System i?
View Answer
| February 16, 2010 5:26 PM
AS/400, Database, Microsoft Access 20007
SQL Access Query
I spelled the work update incorrectly in the question but in the statement it is spelled correctly.
View Answer
| February 16, 2010 11:02 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
I spelled the work update incorrectly in the question but in the statement it is spelled correctly.
View Answer
| February 16, 2010 11:02 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
Still having trouble with IIF in Access 2007
you see the fields may have someting typed in it like “chief” or “captain” or “president”. there are many positions that someone can hold. if a person holds any position then they get 25 point so if the field is blank then they get nothing. If I type in the criteria block Is Not Null [...]
View Answer
| February 15, 2010 6:22 PM
Access 2007, Data base design, IIF, IIF function, IIF statement
you see the fields may have someting typed in it like “chief” or “captain” or “president”. there are many positions that someone can hold. if a person holds any position then they get 25 point so if the field is blank then they get nothing. If I type in the criteria block Is Not Null [...]
View Answer
| February 15, 2010 6:22 PM
Access 2007, Data base design, IIF, IIF function, IIF statement
Trouble with IFF MS Access 2007
If I understand correctly, <pre>=IIf([1st Position Held Elected or Appointed]=25,’25′,’not 25′)</pre>
View Answer
| February 15, 2010 5:02 PM
Access 2007, IIF function, Microsoft Access
If I understand correctly, <pre>=IIf([1st Position Held Elected or Appointed]=25,’25′,’not 25′)</pre>
View Answer
| February 15, 2010 5:02 PM
Access 2007, IIF function, Microsoft Access
How To Train For Help Desk Role?
In my career I had lots of good ops people transition into a variety of other IT roles, even help desk support. Have you considered finding an ops position in a company that has such succession plans in place? This might be a transition you need to make “within” a company. Leverage the skills you [...]
View Answer
| February 15, 2010 3:38 PM
Careers, Helpdesk training, IT careers, IT Help Desk, IT training
In my career I had lots of good ops people transition into a variety of other IT roles, even help desk support. Have you considered finding an ops position in a company that has such succession plans in place? This might be a transition you need to make “within” a company. Leverage the skills you [...]
View Answer
| February 15, 2010 3:38 PM
Careers, Helpdesk training, IT careers, IT Help Desk, IT training
MS Access 2007, IIF and Null expressions
You could use the IsNull Function. Something like this: <pre>IIf(<b>IsNull</b>([1st Position Held Elected or Appointed]),<something else>,"25")</pre>
View Answer
| May 9, 2013 2:08 PM
Access 2007, IIF, Microsoft Access, Null Expressions
You could use the IsNull Function. Something like this: <pre>IIf(<b>IsNull</b>([1st Position Held Elected or Appointed]),<something else>,"25")</pre>
View Answer
| May 9, 2013 2:08 PM
Access 2007, IIF, Microsoft Access, Null Expressions
Career Path
In my opinion a house gives you more verity in most cases. Whereas a industry you might work on the same project(s) a lot. This doesn’t always hold true. Benefits and compensation can be different between the two as well. Research is your best friend. Think about what you really want to do and what [...]
View Answer
| February 12, 2010 5:47 PM
Careers, Certifications, IT careers
In my opinion a house gives you more verity in most cases. Whereas a industry you might work on the same project(s) a lot. This doesn’t always hold true. Benefits and compensation can be different between the two as well. Research is your best friend. Think about what you really want to do and what [...]
View Answer
| February 12, 2010 5:47 PM
Careers, Certifications, IT careers
MS Access Networking
Access isn’t a client server application like a SQL Server or an Oracle database. All traffic from the Access application which is opened on the client computer to the machine which hold’s the mdb file with the database will be sent over the standard SMB network ports which are TCP 135 and TCP 445. However [...]
View Answer
| February 12, 2010 7:58 AM
Microsoft Access, TCP Ports, WAN
Access isn’t a client server application like a SQL Server or an Oracle database. All traffic from the Access application which is opened on the client computer to the machine which hold’s the mdb file with the database will be sent over the standard SMB network ports which are TCP 135 and TCP 445. However [...]
View Answer
| February 12, 2010 7:58 AM
Microsoft Access, TCP Ports, WAN
Wrkqry for join files
don’t include these fields in the join rules, if you have other join rules put them in or enter *all for the join rules. This will join every record in file 1 with file 2. Then use the select record to code FieldA = SUBSTR(FieldB,1,9) .. maybe you’ll have to create the 9 char field [...]
View Answer
| February 11, 2010 2:33 AM
JOIN statement, WRKQRY
don’t include these fields in the join rules, if you have other join rules put them in or enter *all for the join rules. This will join every record in file 1 with file 2. Then use the select record to code FieldA = SUBSTR(FieldB,1,9) .. maybe you’ll have to create the 9 char field [...]
View Answer
| February 11, 2010 2:33 AM
JOIN statement, WRKQRY
Link between Access & Crystal
http://www.ehow.com/how_4479367_access-database-crystal-reports-xi.html
View Answer
| February 10, 2010 5:11 PM
Crystal Reports, Microsoft Access
http://www.ehow.com/how_4479367_access-database-crystal-reports-xi.html
View Answer
| February 10, 2010 5:11 PM
Crystal Reports, Microsoft Access
.nsf file error
when U say, U ran fixup and all, was that on the server? if so, that won’t likely do anything as the replication page is for local replicas. U want to run fixup, et al, locally, as this is likely a local database with the issue. it is possible it is your bookmark.nsf, desktop.ndk, or [...]
View Answer
| February 9, 2010 6:25 PM
.NSF files, Database replication, Lotus 7.0.2
when U say, U ran fixup and all, was that on the server? if so, that won’t likely do anything as the replication page is for local replicas. U want to run fixup, et al, locally, as this is likely a local database with the issue. it is possible it is your bookmark.nsf, desktop.ndk, or [...]
View Answer
| February 9, 2010 6:25 PM
.NSF files, Database replication, Lotus 7.0.2
