• Sort Access Query From Variable

    I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it's sorted by the field name I type in the text box. Any help would be greatly appreciated.

    RoadDust390 pointsBadges:
  • Transition From Workgroup to Domain During Building Transition

    My company presently occupies 2 buildings in the same city with a third smaller building on the same lot as the main office. The main office houses 51 XP workstations networked through Cisco switches on static IP addresses. We have 2 databases that interlink for maintaining customer data and...

    SBIT40 pointsBadges:
  • Community Update: New Member Contest – Earn Knowledge Points and win!!

    Get some Amazon.com gift cards for your holiday shopping. Now is your chance to win an Amazon gift certificate based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. The top 10 most active...

    ITKE54,905 pointsBadges:
  • Adding new entries to a table via a combo box in a form

    I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. I...

    Danielgroot5 pointsBadges:
  • Export Attachmets

    How do you export all attachments for all records from Access 2007 database?

    Angellja5 pointsBadges:
  • Update help needed

    I need to perform an update as follows... Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = '', DXDAD1 = '', DXDAD2 = '', DXDAD3 = '', DXDAD4 = '', DXDPCD = '', DXINVN = 0 Where SDIECD = 'SO' And SDCDAT <...

    SBatSI415 pointsBadges:
  • Database design

    Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10...

    Elham10 pointsBadges:
  • FOXPRO ERROR

    Trying to open a program and get this: Foxpro caused a general protection failure in module FOXSQZ.FLL@0001:6875 HELP

    Perless5 pointsBadges:
  • Appeon for PowerBuilder on Linux

    I've installed Appeon for Powerbuilder on win2000 server, and I'm trying to access it from linux with Ies4linux, but it doesn't work, my page is blank ( I've install wine,cabextraxt & Ies4linux ), why it happen, have I lost my steps ?

    Dodol5 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • iSeries RPG Embedded SQL Performance

    Hi, I'm trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I've already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when...

    Gilly40023,730 pointsBadges:
  • Updating the database using information_schema

    I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000

    Mcm5 pointsBadges:
  • Trying To Make A pop up on MS access to come up every time a client needs to pay me..

    So I have a table full of details of my clients.. including when they have to pay me (the date) and how much they have to pay me.. Im not an expert at MS access. i know how to make forms and all that but not this.. can somebody tell me how to get a pop up to come up every three months saying the...

    Helpwithmsaccess5 pointsBadges:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ODBC connectivity to Oracle 10g database from an Oracle 6i client

    Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.

    Ronneyrajapathirana5 pointsBadges:
  • How to order a list?

    i have a list from a text file in this format: Wence Rollins Hernandez Perry Rollins Dai Holzapfel Hernandez Perry Stelzer Adhikari Darrow Heafey Harmon Dai Steenbock Darrow Bell Steenbock Adhikari Bell Holzapfel Stelzer Heafey i have to put in in a format like this: Wence, Rollins, Dai, Steenbock,...

    Adhikarisubodh5 pointsBadges:
  • AS400 ODBC

    Are the permissions for ODBC authority viewable. I am able to view the users that have the ability to perform odbc, but how do I view whether they have read, write, and delete capabilities. Thanks.

    Mramos110 pointsBadges:
  • How can we automate the DB2/400 used in AS/400 through QTP?

    We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.

    DBconnectivitywithQTP5 pointsBadges:
  • How to perform efficient testing of the Data Base Fail over (DBFO) mechanism?

    We have Server connected to Primary, Secondary DB instance. If any of these DB instance is shutdown, forced to shutdown, network disconnected etc, then server will failover to the secondary db and viceversa. We want to test the 'DB Connection Pooling' feature involved in the DBFO mechanism. Also,...

    Saimadhu455 pointsBadges:
  • Replication history

    Hi there, 1) I try to replicate a database from our sister company plant via VPN, but the problem is the replication cannot started and an error message prompted -> "Unable to locate program : nwrdaemn.dll". 2) I also cannot open the database using Notes Server id even though the server ID has...

    Anevil140 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