• In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

    How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

    2010475 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • Linking Fields from different tables (one table empty)

    So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table...

    JRob15 pointsBadges:
  • Wireless Access Point

    My Organisation is looking for some software or a way to monitor our open wireless network. We have a few access points spread around the building and we woud like a method of tracking and keeping a record of IP addresses leased and associated Mac addresses for at least 10 days.  Any suggestions...

    Barcagunner5 pointsBadges:
  • How do I upload an image or images at runtime in Visual Basic 6

    I have designed an interface by which users are soppose to UPLOAD their thier pictures but they cannot do that at RUN TIME. Please help me with the CODE. am using VB6. It is a library registration form with Name, Index, Picture. we are able to update the name and index but unable to UPDATE the...

    Okappaw55 pointsBadges:
  • ODBC connection and IP address

    Is there a way to get the IP address of a client/server job attached to QZDASOINIT?  I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process. ...

    BISHT321245 pointsBadges:
  • Daylight Savings Time Change

    Does anyone know how the daylight savings time change works on the AS400 in V5R3? I changed the required system values, etc and the time changed on our system just fine...but I thought the time was supposed to gradually speed up/slow down (depending on the time change) until the desired time was...

    Crazyrosie0 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

    We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

    MelanieYarbrough6,345 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • Failover clustering in windows 2003 environment.

    A SearchStorage.com reader recently asked: I want to test a failover clustering in windows 2003 environment. As am doing this at home, I don't have a SAN or Shared SCSI with me. Am struck at Shared Quorum. If am using Majority Node Cluster, is it possible to test with the IDE hard disks of these...

    Andrew Burton220 pointsBadges:
  • oracle 10g v sybase ase 15

    what are the differences between the two products relating to cost, integration, database size, number of concurrent users, performance and features

    La bodington5 pointsBadges:
  • Password in Delete Button in MS Access 2007

    How to set a password in command button "Delete" in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !! :)

    Tipsdawn10 pointsBadges:
  • How to count data in Access 2003 stored database

    hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you

    Tlosom55 pointsBadges:
  • Open IT Forum: Security Worst-Cases

    Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the...

    MelanieYarbrough6,345 pointsBadges:
  • Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

    How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

    MLM10 pointsBadges:
  • Designing a single query using SPUFI

    Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my TL told me to design a single query.How to execute the query in SQL execution engine SPUFI??? Please tell the steps involved in creating a dataset & import the results?

    Ajsjanani5 pointsBadges:
  • Contest Bounties: Last chance to win an iPad!

    The end of the iPad contest is drawing near - next Wednesday, February 16th to be exact - and we want to see more of you in the final drawing. In order to help push you over the 500 knowledge point requirement, we assembled some last chance bounties to get you in the running: 1. Tweet about...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server 2005 permissions required by public

    Our security madates that ALL object permissions be removed from"public". After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?

    VelameLaCosa110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following