• Access Calculations

    Recently made database table in acces. Then made a form from the fields in this table. Data entered into from appears in database table. Added calculations to form, calculated results appear in access form but not in related fields in access database table.

    Greenenergy5 pointsBadges:
  • Create a querry to select certain records from a Acess Table

    I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks...

    Stevek4910 pointsBadges:
  • find min/max date in access which also return their value for each record

    I have a table with more date per record (ID1 thru ID10) and the each date have a score, I want to select from each record of their min date and max date with their score (the score is not the min/max score), the data set is: ID    Date              Score 1     12/03/2003    ...

    Find5 pointsBadges:
  • Diplaying Records From Table In A Form Without Having To Use A Query

    I have a program on the shared drive. I have a user ID & Password Form and table, Production Form and table. I would like to know how to write a macro or program a command button when selected would allow the indivdual based upon their user ID/Password to go to the production table and display all...

    Mecervenka5 pointsBadges:
  • Role of Excel/Access in SQL Server 2008 R2

    What is the role of Excel / Access in SQL Server 2008 R2?

    ITKE371,900 pointsBadges:
  • Transposing data in Access table

    I have a Access table with 2 cols - Mothers Name and Childrens Date of Birth. Table contains about 20k records and Mothers Name is repeated for as many children she has (i.e., Mary, 03/09/1992, Mary 05/21/1996, Mary, 12/13/2002). My goal is to have an Excel spreadsheet with cols as Mothers Name,...

    Dcathib5 pointsBadges:
  • AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • Access form -updating details for Not in list

    I have created a form "Transactions" for data entry. One field, "Account", selects from an existing list, but can accept new Accounts. When I accept a new account, I would like to be prompted to go to the "Account" form and fill in the Account description on 4 additional fields (Title, Category,...

    FsAccess5 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 pointsBadges:
  • Remove Q in Microsoft Access

    I have a form that I scan a barcode with quantity and barcode has Q20. I need it to record on table with 20. Removing the Q. Can this be done on a numeric filed or does it have to be done on a text field. Is there a code to eliminate the q from the field when the barcode is scanned.

    Danielsang15 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • Generating Contracts Documents Automatically in Microsoft Access

    I am in a project that is expected to build a Contracts system.. The idea is that because of standard format of contracts documents (Schedules , amendment, letter.. etc), the system is supposed to use these standards documents to generate customized contracts, edit them, provide choices of some...

    MuathBinhussain10 pointsBadges:
  • 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:
  • 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:

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.