• 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:
  • 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,185 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:
  • 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:
  • 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:
  • MS-Access linked table to AS/400 file – can’t retreive field descriptions/headings

    I have created a linked table in MS-Access 2003 over an AS/400 file.  It works pretty well so far.  The problem I have is I only get field name and type.  I don't get any field description or heading information form the file. Any suggestions on how I can retrieve the descriptive info as well?

    MBERIC120 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,185 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:
  • Statement separator for multiple DLast statements – Access 2003

    MS Access I am trying to set defaults for selected fields in a form based on the previous (last) record. I can do this for a single field using the code below in Form Properties/BeforeInsert but I need to add three more fields. Is this possible and, if so, how should I phrase it and what separator...

    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