Incrementing a key field without autonumber
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
Suggested contacts
How do I turn on suggested contacts?
Answer Question
| January 10, 2013 10:28 AM
Microsoft Outlook 2011, Microsoft Outlook contacts
How do I turn on suggested contacts?
Answer Question
| January 10, 2013 10:28 AM
Microsoft Outlook 2011, Microsoft Outlook contacts
MIMIX DB Error clearing
Hi, How to clear the DB error in MIMIX Replication. I got some error in the DB option. Can anyone tell me how to clear that error? -Karuna
Answer Question
| January 10, 2013 9:49 AM
AS/400, MIMIX
Hi, How to clear the DB error in MIMIX Replication. I got some error in the DB option. Can anyone tell me how to clear that error? -Karuna
Answer Question
| January 10, 2013 9:49 AM
AS/400, MIMIX
MS Excel Macro imput
How to pause Macro execution for input of e.g. a Range to go to after resume?
Answer Question
| January 10, 2013 8:20 AM
Microsoft Excel, Microsoft Office
How to pause Macro execution for input of e.g. a Range to go to after resume?
Answer Question
| January 10, 2013 8:20 AM
Microsoft Excel, Microsoft Office
1 gigabyte = ? megabytes
1 gigabyte = ? megabytes
Answer Question
| January 10, 2013 7:48 AM
Gigabyte, Megabyte
1 gigabyte = ? megabytes
Answer Question
| January 10, 2013 7:48 AM
Gigabyte, Megabyte
Need to print PDF of length 198 generated by spool of same size
Earlier length of printer file was 132.Now some more fields are added and hence I have increase size till 198. After program execution, spool is being generated fine, but when converting it to PDF, the extra fields are being cropped. How can I generate PDF till length at least to 160 length. What extra setting [...]
Answer Question
| January 10, 2013 7:12 AM
AS/400, RPG, Spool file
Earlier length of printer file was 132.Now some more fields are added and hence I have increase size till 198. After program execution, spool is being generated fine, but when converting it to PDF, the extra fields are being cropped. How can I generate PDF till length at least to 160 length. What extra setting [...]
Answer Question
| January 10, 2013 7:12 AM
AS/400, RPG, Spool file
How to know whether the CSV extraction to PF happened today
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
Outlook calendar appointments
When I put an appointment in Outlook calendar and set the start time, it says AM then the finishing time is PM but it defaults to AM.
Answer Question
| January 10, 2013 6:20 AM
Microsoft Outlook, Microsoft Outlook Calendar
When I put an appointment in Outlook calendar and set the start time, it says AM then the finishing time is PM but it defaults to AM.
Answer Question
| January 10, 2013 6:20 AM
Microsoft Outlook, Microsoft Outlook Calendar
Converting julian date with CL on the AS400
Can anyone help me with correcting the following code? I believe the error is in the /* CONVERT TO 30 DAYS AGO */ area, but I can’t see it. ********************************************************************************* DCL &TODAY *CHAR 6 DCL &LESS30 *CHAR 6 DCL &MBRDATE *CHAR 5 DCL VAR(&MBRDAT2) TYPE(*DEC) LEN(5 0) /* CONVERT TODAY’S DATE TO JULIAN */ RTVSYSVAL [...]
Answer Question
| January 10, 2013 1:47 AM
AS/400, CL
Can anyone help me with correcting the following code? I believe the error is in the /* CONVERT TO 30 DAYS AGO */ area, but I can’t see it. ********************************************************************************* DCL &TODAY *CHAR 6 DCL &LESS30 *CHAR 6 DCL &MBRDATE *CHAR 5 DCL VAR(&MBRDAT2) TYPE(*DEC) LEN(5 0) /* CONVERT TODAY’S DATE TO JULIAN */ RTVSYSVAL [...]
Answer Question
| January 10, 2013 1:47 AM
AS/400, CL
Outlook 2010 Conference Room Calendar
How can I make it so that everyone within our company can see who booked the conference room?? It shows free/busy times, but not who booked it.
Answer Question
| January 9, 2013 10:20 PM
Microsoft Outlook, Microsoft Outlook Calendar
How can I make it so that everyone within our company can see who booked the conference room?? It shows free/busy times, but not who booked it.
Answer Question
| January 9, 2013 10:20 PM
Microsoft Outlook, Microsoft Outlook Calendar
Hyperion Clustering
Hello, I work for a company and we use Hyperion Version 9.3.1.1.6. Every night we go in and create a blank dummy account and refresh the database. We call this “Clustering”. The next day we will delete the dummy account we created and set up a new one. We use the current date to track. [...]
Answer Question
| January 9, 2013 8:56 PM
Hyperion 9
Hello, I work for a company and we use Hyperion Version 9.3.1.1.6. Every night we go in and create a blank dummy account and refresh the database. We call this “Clustering”. The next day we will delete the dummy account we created and set up a new one. We use the current date to track. [...]
Answer Question
| January 9, 2013 8:56 PM
Hyperion 9
Access to printer in AS/400
Users are complaining that they are getting unwanted print outs from their printer. I want to know which all users are using that particular printer.
Answer Question
| January 9, 2013 6:15 PM
AS/400, AS/400 printers
Users are complaining that they are getting unwanted print outs from their printer. I want to know which all users are using that particular printer.
Answer Question
| January 9, 2013 6:15 PM
AS/400, AS/400 printers
User space size
Hi, is the size of user space auto resizable? I tested creating a user space with the initial length to 1 QUSCRTUS(userSpace, /* User space name and library */ “temporal “, /* Extended attribute (QUSLOBJ) */ 1, /* Size of the user space */ &spaceInit, /* Space initialization */ “*ALL “, /* Public authority to [...]
Answer Question
| January 9, 2013 4:38 PM
AS/400, iSeries, QUSCRTUS
Hi, is the size of user space auto resizable? I tested creating a user space with the initial length to 1 QUSCRTUS(userSpace, /* User space name and library */ “temporal “, /* Extended attribute (QUSLOBJ) */ 1, /* Size of the user space */ &spaceInit, /* Space initialization */ “*ALL “, /* Public authority to [...]
Answer Question
| January 9, 2013 4:38 PM
AS/400, iSeries, QUSCRTUS
Requirements for DR testing in a hosted data center
We own the data center and host application for our other agencies, along with housing some of their equipment. We also have a secondary data center for redundancy and disaster recovery purposes. I am looking for a set of requirements that the agencies must follow prior to using the facilities. Example – they must have [...]
Answer Question
| January 9, 2013 4:37 PM
Hosted servers, Hosted services, testing requirements
We own the data center and host application for our other agencies, along with housing some of their equipment. We also have a secondary data center for redundancy and disaster recovery purposes. I am looking for a set of requirements that the agencies must follow prior to using the facilities. Example – they must have [...]
Answer Question
| January 9, 2013 4:37 PM
Hosted servers, Hosted services, testing requirements
What has caught your eye at 2013 International CES?
Some pretty cool devices were rolled out this week at the 2013 International CES including a 27-inch convertible tablet from Lenovo and an “invisible TV” from Hisense. As the show comes to a close, what new tech gadget has caught your eye?
Answer Question
| January 17, 2013 4:28 PM
CES International, lenovo, Tablet
Some pretty cool devices were rolled out this week at the 2013 International CES including a 27-inch convertible tablet from Lenovo and an “invisible TV” from Hisense. As the show comes to a close, what new tech gadget has caught your eye?
Answer Question
| January 17, 2013 4:28 PM
CES International, lenovo, Tablet
I found old E00000 log files
Hello – I found a folder on my Exchange server that contains about 1 year’s worth of log files dated July 2010 through June 2011. The folder is 5GB in size and I’d love to delete it. I have 2 questions. 1. Is there any reason to keep these log files? 2. Where in EMC [...]
Answer Question
| January 9, 2013 4:04 PM
Log files, Microsoft Exchange
Hello – I found a folder on my Exchange server that contains about 1 year’s worth of log files dated July 2010 through June 2011. The folder is 5GB in size and I’d love to delete it. I have 2 questions. 1. Is there any reason to keep these log files? 2. Where in EMC [...]
Answer Question
| January 9, 2013 4:04 PM
Log files, Microsoft Exchange
How to use ‘Create index’ statement in iSeries Navigator
Hi, I’m having trouble when I’m using the iSeries navigator to run statements for creating indexes on a table. The create table statements work fine but when I try to create an index for the same table, I get errors and can’t seem to find out why. However, if I paste the same command on [...]
Answer Question
| January 9, 2013 2:11 PM
AS/400, iSeries Navigator
Hi, I’m having trouble when I’m using the iSeries navigator to run statements for creating indexes on a table. The create table statements work fine but when I try to create an index for the same table, I get errors and can’t seem to find out why. However, if I paste the same command on [...]
Answer Question
| January 9, 2013 2:11 PM
AS/400, iSeries Navigator
vCenter Server – Physical or Virtual
What is the best practice to install VC 5.x … Physical machine or Virtual machine? What are their respective advantages/disadvantages?
Answer Question
| January 9, 2013 1:52 PM
ESXi5, Virtual Center, vSphere 5
What is the best practice to install VC 5.x … Physical machine or Virtual machine? What are their respective advantages/disadvantages?
Answer Question
| January 9, 2013 1:52 PM
ESXi5, Virtual Center, vSphere 5
Database
Special database object can not be located?
Answer Question
| January 9, 2013 11:09 AM
Database, Database objects
Special database object can not be located?
Answer Question
| January 9, 2013 11:09 AM
Database, Database objects
About database connection
How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?
Answer Question
| January 9, 2013 10:25 AM
ACCDB file, Microsoft Access, Visual Basic 6.0
How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?
Answer Question
| January 9, 2013 10:25 AM
ACCDB file, Microsoft Access, Visual Basic 6.0
