• How to use the data from other table into the main table in Access 2003 and 2007

    I'm trying to use data from other tables to make a sum and then display the result in a "Total" text. For example: I have in table1 3 qty's, in table2 2 qty's and in table3 5 qty's. I want to sum all those qty's and display them into the Main Form. I use MS Access 03 and 07

    Eddy20 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • Replacing dictionaries on Windows XP SP3 with Outlook 2003 & Office 2003

    I want to replace the dictionaries on all of our windows xp sp3 with outlook 2003 and office 2003. I want to include the company name as well as last names of employees and push it out. How can I do this as easy as possible?

    ITKE56,495 pointsBadges:
  • Adding column to existing table in a database

    When I add column in existing table. it contains null values in older records. it is possible to assign a value when add column so older records are modified with value

    Shrirama25 pointsBadges:
  • Best practices involving admin rights for user on user system

    We are currently in the middle of figuring out the approach we are going to take in regard to a user having admin rights on their system. Typcially we set up a new user as an administrator on their system when they are logged into the domain. They don't have a local admin account on the system,...

    Kevins740 pointsBadges:
  • Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Keck5 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,020 pointsBadges:
  • Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?

    Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

    BCF5 pointsBadges:
  • SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • How do I duplicate or clone a dying SATA drive?

    If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

    ITKE56,495 pointsBadges:
  • What is the procedure for Deployment in VB6.0

    Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2.  It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available. Please...

    SailajaConsultancy5 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • CONNECTION VB WITH ACCESS

    how to connect visual basic 6 and msaccess 2003 by using connection string

    Yusuphsngoroge5 pointsBadges:
  • How to enter a field with number increments in Access 2007

    How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

    SatbirBlog15 pointsBadges:
  • Combine (concatenate?) in Access~special circumstances

    Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below... In the samples below, Account code is in Field 1... String(s) to be added are in Field 2. Then in Field 3...

    Matchmole5 pointsBadges:
  • odbc question

    what odbc driver you use to go from system-i to sql2005 i sue IBMDA400 but does not handle pack fields very well any suggestions?

    Colo20055 pointsBadges:
  • Access 2007: Create a form for both display and data entry purposes

    How can I create a form that is autofilled with data from a query (such as a client's ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a subform for the data entry but (a)...

    Deej185 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