Create table by comparising 2 tables

I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow tasks that are dates. I need a...

Gooies5 pointsBadges:

Error: method or datamember not found

i want to get data (liftno,model)etc in a subform by selecting a combo in main form .the subform data is from another table and in the main form cc field is from other table LiftNo.RecordSource = "SELECT Proj_d.LiftNo, Proj_d.Model, Proj_d.Capacity, Proj_d.Capacity, Proj_d.Speed, Proj_d.Stops FROM...

1234a10 pointsBadges:

Insert superscript text into Oracle database

how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

Rosealzubi115 pointsBadges:

Webpage and SQL interaction

The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

Katy20 pointsBadges:

Trend Micro ScanMail for Exchange 2007 – Virtual Lab

Need to eval. TrendMicro's Scanmail but do not have a lab environment setup that matches our prod. environment of Exchange 2007. Are there any virtual labs out there that may help or any other suggestions for getting the feel for Scanmail?

DewIT20 pointsBadges:

About UPDATE query

hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand("update device set manu='" + mtxt.Text + "',desc='" + dtxt.Text + "',model='" + mdtxt.Text + "',pdate='" + prodate.Text + "',price='" + ptxt.Text +...

Ashar5 pointsBadges:

Galelio

can you tell what steps to take when installing galelio.

Tshwarelo35 pointsBadges:

Issue SQL Query with Localized String through PowerShell

Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following...

Bgsullivan15 pointsBadges:

Application using VB6 & SQL

Dear sir, I am computer data entry operator, i would like to make one simple application reg Payroll using VB6 and SQL. I know only some basic commands in both but i dont know what are the steps taken first what we have to do (crating forms in vb or creating tables in sql or other i dont know...

Lahari5 pointsBadges:

SQL Server 2008

How to format crlf inside a field text

2601515 pointsBadges:

SQL proceedure to join header and detail file

I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

AS400 - Ask the Expert485 pointsBadges:

Database design schema for Test Data Management?

For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.

Saimadhu455 pointsBadges:

Efficient way of testing multiple character set support in your application

If we need to test the localization/ internationalization support of an application (i.e, supporting ascii, german, japanese characters etc) then how to perform this testing efficiently?

Saimadhu455 pointsBadges:

ABT database backup from SQL Server 2000

hi please tell me that, if i am using vb as front end and sql server 2000 as backend then for giving the facility of implicit periodical data backup at project, how can i go......through vb coding...

Nileshmahadik5 pointsBadges:

SQL help

hiow to pick only alphbets in a string or a column using sql

Ecsbc35 pointsBadges:

Visual FoxPro Help

I have a large scale desktop application written in VFP 9 and I want to enable it to run on the web. I've looked everywhere to find info on how to do this and I can't find any. Can anyone point me in the right direction or provide any info? Thanks! Angel McCollum

Oransoft5 pointsBadges:

Invalid Format Error when Opening/Saving in Visual Studio 2008.

Hi I'm creating a professional Text Editor with usage of RichTextBox control, and I have inserted some common controls such as SaveFileDialog and Load File Dialolg, and I basically want to be able to load files of all types (i.e Word Documents) the only documents I can open are RTF. I tried to...

Ppp5 pointsBadges:

Not allowed to edit Microsoft Access forms

A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...

Donnerblue5 pointsBadges:

Is SharePoint considered a collaboration service, content management service or other?

I am trying to define the service that MS Sharepoint "fits into". Inother words, one could say that weblogic offers a "hosting service" J2EE middleware offers answers to "messaging" services. Does Sharepoint offer an answer to "collaboration" services, "content managment" or something else?

Molftho5 pointsBadges:

Difference between Service Registry and Service Repository in SOA

I don't understand difference Registry and Repository. Maybe I couldn't get concept of them. Anyone please answer this question. Thank you

WillyInNZ5 pointsBadges: