How many rows will a FETCH statement return in an explicit cursor operation?
HOW many rows will a FETCH statement return in an explicit cursor operation?

Answer Question   |  December 28, 2009  3:15 AM
Cursor operation, Explicit cursors, FETCH statement

Career and certifications on Microsoft Platform
I am CCNA, MCP certified and doing MCSE. I am looking forward for SMS and Exchange Certifications. Please advise on what should I do for the best in career? any other course recommendations

Answer Question   |  June 15, 2009  3:01 AM
CCNA, Certifications, Exchange certifications, IT careers, MCP, MCSE, Micrsoft Certifications, Networking certifications, SBS certifications

Storing image in Oracle 9i
how to store and retrieve image having size more than 1 GB in oracle 9i

Answer Question   |  June 15, 2009  11:30 AM
BLOB, Oracle 9i, Oracle image storage

Access database table linked to Excel file question
Can multiple instances of the same access database be open when linked to same excel file?

Answer Question   |  June 24, 2009  7:38 PM
Access 2007, Access Database, Excel worksheets, Microsoft Access, Microsoft Excel

How to use an form field in a SQL from a combobox
I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field [...]

Answer Question   |  June 12, 2009  5:45 PM
Access 2003, Microsoft Access, SQL Forms

Update Microsoft Access database from VB6
Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and [...]

Answer Question   |  June 24, 2009  10:44 PM
Database connectivity, Database programming, Microsoft Access, VB 6, Visual Basic 6

Becoming a networking or database admin with a business information systems degree
I have a bachelor’s degree in Business Information Systems. I can’t seem to find a job in IT. I graduated in 2002. I worked as a security officer while going to college. I’m interested in networking or database administration. If you were me what would you next?

Answer Question   |  June 11, 2009  6:52 PM
Careers, Careers in networking, Database administration, Database Administrator, Degree, Job training, Networking, Networking careers

enter key behavior on forms
when my user hits the enter key, i want it to return to the first field (which is hte id entry key).

Answer Question   |  June 24, 2009  6:46 PM
Access forms, Microsoft Access

Duplicating Form FieldsAccess 2007
I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.

Answer Question   |  June 10, 2009  4:03 PM
Access 2007, Access forms, Microsoft Access

Excel to Access conversion
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be “moved” into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would not merely be a matter [...]

Answer Question   |  August 12, 2009  3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel

How do I restore a copy of the database
How do I restore a copy of the database

Answer Question   |  June 9, 2009  12:30 PM
Database, Database Recovery

Toggle button in Microsoft Access form
Hi, in an access form I have included a Toggle button which when “on click” imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won’t import the same database. Thanks

Answer Question   |  June 25, 2009  10:20 PM
Database programming, Microsoft Access, Microsoft Access forms

jsp–param and sql:update
Hello, Could anyone tell me if I need to do something special to use a param value as an sql insert statement in <sql:update>? The param value displays fine if I use <c:out>, but the value doesn’t get inserted in a table by an insert statement.

Answer Question   |  June 9, 2009  9:37 PM
INSERT statement, JSP, SQL

How to get data from a Web-installed Microsoft Access database from VB6
I have an Access 2003 database installed in the database folder on our web site. How can I best modify my VB6 program to obtain the data from this file instead of from C:/ drive?

Answer Question   |  June 8, 2009  3:12 PM
Database connectivity, Database-driven website, Microsoft Access 2003, VB6, Visual Basic 6, Web development

how to recover database if it is deleted
How can I recover the database if it is deleted?

Answer Question   |  June 22, 2012  12:08 PM
Backup & recovery, Database Recovery

Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

Answer Question   |  June 4, 2009  9:01 AM
DELETE statement, SQL, SQL variables, SQLRPG

Access Subform Repeating Data
I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn’t repeat – what do I need to do to sort this?

Answer Question   |  June 3, 2009  8:10 PM
Microsoft Access, Microsoft Access subforms

What are core areas IT hiring managers are looking for?
I’ve completed A+, and I’m about to take my Network+ test in a 2 weeks. If you were a hiring manager that took notice to my A+ and Network+, what are 3-4 of the “most current core areas” and “strong technical gifts” that you would use to rate me as an asset to your team [...]

Answer Question   |  August 26, 2009  8:37 PM
A+, Certifications, IT careers, IT jobs, Network+

Grouping Query
I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 850,000 I need to write a query to pull this data and put into usage bands and count how [...]

Answer Question   |  June 25, 2009  6:18 PM
Access query, Microsoft Access, Microsoft Access query

CallManager and SQL Queries
I need to gather some data from our call manager and the reporting tool that comes packaged with the server is horrible! We have Call Manager version 6.1. Is there anyway query the call detail records other then using the reporting tool? If so, please advise me. Thanks

Answer Question   |  June 4, 2009  2:09 PM
CallManager, Cisco CallManager, Cisco CallManager 6.1, SQL queries