• 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:
  • Exclusive access to Access 2003 database

    I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message "You do not have exlucive access to this database at this time." It pops up 4 to 6 times...

    Ryker5 pointsBadges:
  • How to search for Access 2003 record using VB6

    How can I search for the last updated record in my Access 2003 database from VB 6, the code I'm using only returns the first record on the database. On Error GoTo err: Dim sql As String Set con = New ADODB.Connection con.CursorLocation = adUseClient con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

    Josemw10 pointsBadges:
  • Access 2003 SQL sub-query within query

    I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database. So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However where it...

    JimiLotus15 pointsBadges:
  • Domino Initialize The System cannot find the file specified

    When I initialize a Domino session in Microsoft Access VBA (2003) running on Win7 box I get "The system cannot find the file specified" error. After ok is clicked the process succeeds anyway. Same code ran fine on Windows XP. This is Lotus Notes 7. If Lotus Notes is running, I do not get the error.

    UPSFreight5 pointsBadges:
  • Relational Database

    What kind of tables are used in a membership database other than name & address.

    4jab15 pointsBadges:
  • Forms

    I have a form (frmInvoices) used to enter new invoice data. It's control source is tblInvoices. But on my form, I have 3 fields to pull data from: (tblcustomer.customerid) and (tblnewinvoices.id; customerid; and datecreated) I can't figure out how to populate datecreated and id from tblnewinvoices...

    Noreene5 pointsBadges:
  • Access 2003 parameter query bollixed

    The query searches a table looking for three fields, one of which is the Year. The year parameter request works just fine [Year as yyyy]. The query then goes on and asks for a second parameter for a field that was not included as a requested field. Any hints given are appreciated - thank you wem3rd

    wem3rd65 pointsBadges:
  • Teacher’s salaries

    I created a database for contracts using Access 2003. I changed a calculation in a form that was created and it works on the form, but when I open a query it's still displaying the old totals from the old calculation method. What do I need to do to make it change in the query also?

    Smith35 pointsBadges:
  • How to create Access 2003 MDB file using VB 6.0

    I am developing a VB 6.0 application that uses Ms-Access 2003 as back end and I want create a Access 2003 database file if  does not exist. I can only create a Access 2000 database file, not an Access 2003 database (.MDB) file.

    ssddssdd12310 pointsBadges:
  • Access 2003 changing the company name

    I am working in a 2003 access db that was set up by someone else. the Company name has changed. How do I change the company name so it prints out correctly on our work orders?

    bathgenie5 pointsBadges:
  • Access reports dropping data included in query

    My primary key for my database is based on phone numbers. I have created a query which includes anyone that has an outstanding balance. The query includes last names that are the same which I see. I have 3 people with the last name of Thomas, all have different first names. I created a report from...

    osbornisle5940 pointsBadges:
  • Date format in table

    I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show the age at death from...

    LostSpring5 pointsBadges:
  • MS Access query

    I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which...

    kgonzales20 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 pointsBadges:
  • How to combine 2 linked Excel tables in access 2003 with same field names, using query?

    I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

    Accesstables5 pointsBadges:
  • Count characters for each string in a column of data

    Within MS Access 2003 I want to create a column of data containing the results of a count. The count needs to tell me the string length of each data element in an adjacent Field. So, if for example I had a Field containing people's surnames, and I want to see, for each surname, the string length...

    AADataExec5 pointsBadges:
  • Late Bound Listview in Access

    Not sure if this will make sense, but here goes: I have several forms built which include listview controls on them. I am currently using early binding to manipulate them, but one of my user's workstations is having an issue reading the ref lib. I'm assuming there is a program on that system that...

    McNitro255 pointsBadges:
  • Getting last 6 entries for each person

    Hi everyone, I am trying to create a query that pulls the last 6 exam scores for each of the operators at the plant I work at.  I have a table that has the last 2-3 years worth of data.  The current query I have just organizes the data without filtering the last 6 entries, and I cannot figure out...

    DASiuda25 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