• SQL insert statement

    Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation...

    Sturdy2725 pointsBadges:
  • Microsoft Access export to Excel changes values

    I have a table populated through a form using lookup tables. When this table is exported using "right click,export" to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

    Lsegura12125 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 pointsBadges:
  • is there anything in SharePoint that we could use to exchange data or hook into Visual Source Safe 6.0?

    VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering - is there anything in SharePoint that we could use to exchange data or hook...

    ITKE350,945 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • Does a 802.11n access point or router offer an expanded range to 802.11g devices?

    Does a 802.11n access point or router offer an expanded range to 802.11g devices? Thanks.

    Networking Channel ATE30 pointsBadges:
  • How do I retrieve the most recent date from an access database

    I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

    TheMooseRI15 pointsBadges:
  • How to show list view in Microsoft Access report

    i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?

    Yeohcc10 pointsBadges:
  • how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.

    how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

    It doubts85 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • How Do I assign a value if a value in the field is empty

    In my script (that is not working yet) I want to make sure if "full_value" (a field) is empty in a particular record then the value zero will be inserted. This is working in Access, but I'm trying to rebuild the query in SQL. Thank you. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1,...

    Ilfoprog50 pointsBadges:
  • auto transfer of as400 to pc

    Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help

    Nikolai196030 pointsBadges:
  • MS Access Forms

    I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form and...

    Gaildean5 pointsBadges:
  • I want to return multiple value in the THEN clause of CASE statement

    I want to return multiple value in the THEN clause of CASE statement. SELECT c.company_code, c.com_inactive_flag, e.emp_no FROM company c, employees e WHERE c.com_code = e.com_code AND e.emp_status in ( (CASE c.com_inactive_flag WHEN 'N' THEN 'A' WHEN 'Y' THEN 'B,C' END) If the flag is N all those...

    Balcode5 pointsBadges:
  • job problem

    i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', job_action...

    Abdo5 pointsBadges:
  • Convert table entry from text to numeric

    I have generated a table that has a 4 char text field. I want add a column and convert this text field that is numbers to numeric so that both coexist.

    LHammer5 pointsBadges:
  • database form

    I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go...

    Sturdy2725 pointsBadges:
  • Date Ranges in Access 2000

    How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?

    LVogel5 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