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
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
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
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
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
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
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
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
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
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
Answer Question | June 9, 2009 12:30 PM
Database, Database Recovery
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
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
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 can I recover the database if it is deleted?
Answer Question | June 22, 2012 12:08 PM
Backup & recovery, Database Recovery
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
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
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+
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
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