Combining Access 2003 Queries for Dates Criteria
I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a [...]

Answer Question   |  December 14, 2010  12:43 AM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3

Boomi using JDBC to access DB2 in AS/400
Want to use Boomi to access JDE DB2 What do I need to define on AS400?

Answer Question   |  December 11, 2010  6:46 PM
AS/400 administration, AS/400 DB2, Boomi, JDBC

Backup process for several IIS hosted website
Can we create an automated process for backing up several IIS hosted websites? We want 3 backups spread out over the course of the day and it should also include mySql backups as well.

Answer Question   |  December 13, 2010  3:25 PM
Backup and restore, IIS, IIS Server, MySQL, MySQL backup, Server Backup

Scope for sun solaris administrators
I am B.tech graduate and i am working in a BPO as a Tech Agent from 28 Months, i would like to join SUN SOLARIS certification course, i wanted to know howz scope for Solaris Administrators, was it really a good idea to join Sun Solaris ??? Can anyone help me out ????

Answer Question   |  June 26, 2012  6:44 AM
IT careers, Networking, Solaris, Sun Solaris

Does cellular routing technology exist?
What is the technology that would allow a call from a cell phone to be routed to a transmission device that triggers a loud beeping sound. For example, using a cell phone to call a number that calls a database, and then triggers an external receiver that is attached to one’s keychain for example?

Answer Question   |  March 25, 2011  5:36 AM
Cellular, Cellular networks, Database, Routing, Routing and Remote Access, SIP

Exclusive access to Access 2003 database
I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message “You do not have exlucive access to this database at this [...]

Answer Question   |  December 7, 2010  8:34 PM
Access 2003, Access Database, Access database permissions

Progressive Incident ID number in Access 2007
I have a db that records each security infraction at a library. The desired ID number for it is year/month/day/number of event that particular day (example, 2010/12/01-1 for the first event, 2010/12/01-2 for the second, etc.) My question: I have this — 0000/00/00-0;_;;_ — as the format for people to enter, but is there a [...]

Answer Question   |  December 3, 2010  9:36 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access Functions

Print Preview and Printing Drops Pages from Reports
WE have been using the same ACCESS Database for 7 years.  Suddenly, worksheets and reports that have always printed out perfectly are not dropping entire pages; for example, if there are five pages of information, it will drop page 2-3-4 but print page 1 and 5.  What would cause that?

Answer Question   |  December 2, 2010  6:37 PM
Access, Access Database, Access Database Design, Access Functions

SQL 2008 job problem
I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The [...]

Answer Question   |  December 3, 2010  3:28 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003

Create trigger using iSeries Navigator
I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it [...]

Answer Question   |  December 2, 2010  2:28 AM
AS/400 triggers, iSeries Navigator, SQL, Triggers

Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]

Answer Question   |  December 7, 2010  2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros

VBA to separate overlapping times
I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is [...]

Answer Question   |  December 1, 2010  5:46 PM
Excel 2007, Timestamp, VB codes, VBA

Free IT Book: Enterprise Web 2.0 Fundamentals
For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and provide a link to your answer in the discussion area [...]

Answer Question   |  December 6, 2010  4:13 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router

External Datastructure
Will level check occured on program when you changed the file mentioned in external data structure?

Answer Question   |  November 30, 2010  6:26 AM
AS/400, AS/400 database, External database, RPG ILE

How to pick a source for a subform in Access 2003?
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]

Answer Question   |  November 29, 2010  2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms

3rd party connectivity to SQL server through firewall
We need to allow a third party to connect to one of the SQL servers in our DMZ via an externally initiated SQL connection. What is the best approach and what are the risks?

Answer Question   |  November 29, 2010  11:59 AM
DMZ, Firewalls, SQL, SQL connectivity, SQL Server

How do I keep the original value of a field in Access 2010?
Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I’ve tried to do this with a datamacro and the “old” command, but every time i update the [...]

Answer Question   |  November 29, 2010  12:28 AM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010

Need project plan for Access 2007 database migration to SQL Server
project plan with steps outlined

Answer Question   |  January 12, 2011  5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration

reformatting a multi-tab spreadsheet and access 2003
Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]

Answer Question   |  December 1, 2010  2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier

Is there are way to shrink sybase database to reclaim physical space at OS?
We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?

Answer Question   |  November 24, 2010  9:59 AM
Data storage, Data storage management, Sybase, Sybase 12.5.0.2, Sybase Databases