• Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control

    How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource

    Pisceaneffect5 pointsBadges:
  • SQL for Microsoft Access

    I have crated the below SQL statement. I works fine. and it gives me the required "RTCDate" I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the "1" is those product line numbers that are active...

    CompEng1,240 pointsBadges:
  • Microsoft Access Query: Use a field value as year

    I work with MS Access 2003. I have a query with parameter to show all contracts in place of a single year, specified by the parameter. The name of this column with the years, i called "Contract Year". I wish to add a criteria that then shows cancelled contracts at the end of that specific year. I...

    Eveline5 pointsBadges:
  • Issue With Buttons in Access

    I'm building an Access DB and would like to have people interact with it through forms and command buttons.  Adding command buttons should be very straight forward with the wizard, and it is until I test the button - the buttons I create don't work and give me this error message: A problem...

    JTB15 pointsBadges:
  • MS Access 2002 Previously updated fields revert to previous values

    I have a single user application where I update a status table through VB code using DAO. This particular table has 1 record and 66 fields. As part of the processing, two of these fields are updated after which the table is closed. Later in the processing, I update a different field again for this...

    Rbrucejones60 pointsBadges:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • crystal report using parameter query

    i am doing one project using (vb6.0 + ms-access + crystal report 8.5) SELECT division_name, sum(Total_value) FROM segment_trans WHERE date between (Param1) And (Param2) GROUP BY division_name; this is my ms-access query (param1 and param2 thease two parameter value.) in crystal report i pass this...

    Srbatcha10 pointsBadges:
  • Update multiple tabs on an Access form on initial update

    I have 2 main tables, 1 main form and 4 subforms. The subforms all come from the same table. The subforms are in tabular format, and to fit all the fields I put each subform on a seperate Tabs. The Key Control Number ([Key Contl_Num]) is the Field that appears in each subform and on each tab. My...

    RKJohn95 pointsBadges:
  • Using Visual Basic and Access – having problems with other programs sharing memory

    Hi folks I have written a Point of Sale program which uses an access database. The program runs beautifully at sites where the the computers are dedicated specifically to running the software, but I am having nightmares at sites where the clients allow their staff to play games, download all sorts...

    JulianF25 pointsBadges:
  • MS access 2007 about field names?

    I'm making a very Simple database. its has ID, last name. telephone no. Type of OS (Windows/Linux/Mac). MY QUESTION IS, If a person has all the 3 OS, and some has 2 OS, other has 1 OS, How do i make only 1 field name for the the 3 selection, and make a database, a table and query where 1 person has...

    Voxli15 pointsBadges:
  • selecting a record from a table and printing ONE page report

    I have two tables that are joined in a query.  I have a form that points to one of the rows in the table.  I would like to print a single page report for the ONE row.  How do I do that from a multi-row form (with the appropriate row selected) into a MS Access Report?

    Michaeleemeyer15 pointsBadges:
  • VBA – Mail Merge Automation via Access

    Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter and <enter> as the...

    JK012450 pointsBadges:
  • Microsoft Access counting part of a field

    I have a field that I need to count per group. The field contains whole numbers and decemal numbers. I only want to count the whole numbers. The field is a text field, because there is a chance the actual text can be a value. I tried using IIf, but could only put one condition; the field is "[Key...

    RKJohn95 pointsBadges:
  • Auto-Populate an Access form using a table of values

    I'm having a little bit of a dilema. I don't even know if it can be done, but I thought I'd give it a shot. I'm pretty new to Access so I'll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding records. The master form has "Case...

    Jirges5 pointsBadges:
  • SQL Access Query

    I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word "Udate"     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL,...

    CompEng1,240 pointsBadges:
  • Trouble with IFF MS Access 2007

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe that I should be using the...

    Phil12550120 pointsBadges:
  • MS Access Networking

    Which TCP port(s) can I use to monitor access database queries over the WAN?

    Ganzit65 pointsBadges:
  • Link between Access & Crystal

    How do I link between Database and Crystal report to make a report paper?

    BIFT55 pointsBadges:
  • in Access 2003, adding data in a table affect queries?

    Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries linked to those tables, would the...

    Sujun5 pointsBadges:
  • Getting DLookup to refer to a previous record in a filter

    I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.   I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter....

    TRSJ45 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