• Microsoft Access joining tables

    I made a new table by doing group-by max from table-A, through Query design. Now I need to include a new column from table-A that matches the content in the Max column (which I already done max group-by). I try to do some ways but its picking the whole data in Table-A (but I need only matching...

    vinulopez015 pointsBadges:
  • VB6 and Access database combo box

    I have 2 combo boxes. In first combo box, I have district name from database table. If I select any one district, combo2 will display all schools in the concerned district from the access database table.

    shekarsuma5 pointsBadges:
  • Auto populating Excel fields from an Access query

    How do you auto populate an Excel report leveraging data computed in Access - is there a link function?

    Brigita5 pointsBadges:
  • Query for add, delete, update and insert using VB6 and Microsoft Access

    How can I query for add, delete, update and insert in Visual Basic 6.0 and MS Access?

    nagu7645 pointsBadges:
  • Error when truncating number field in Access

    I keep getting an error when truncating a number field in Access. What should I do?

    jonwagner5 pointsBadges:
  • Microsoft Access: Transpose multilple columns with single row into multiple rows single column

    I have 26 columns with a single row of totals. I would like the columns to be rows and a single column with the totals

    jshwltr97495 pointsBadges:
  • Expression incorrect or too complex in Access 2007

    I have two queries that are exactly the same, the first is based on September data, the second on December data. The first one runs correctly, the second one gives the following error message: This expression is typed incorrectly or it is too complex to be evaluated.

    ewillems5 pointsBadges:
  • Microsoft Access: Sum of duration from two different table

    In Access, how do I get the sum of duration from two different tables?

    AqilaNiazi5 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:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 pointsBadges:
  • Populate Access 2007 object in form

    I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

    OhioPat5 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • Time attendance in Microsoft Access

    How to access time attendance with MS Access?

    ZeyadZoear5 pointsBadges:
  • Porting MS Access database to SQL Server

    I've got a problem with porting my MS Access database to SQL Server. In my inventory database, I have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, I do with this kind of queries: a....

    Ipong40 pointsBadges:
  • Time limit for use of Access application

    Dear Sir, I have created a access application. Now I want that user should be able to use it for 15 days only. After that the application should say that your trial period is expired and get closed. Eagerly waiting for your reply. Thanks, Sandip

    Ssandbhor10 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • MS Access Tools References

    Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

    Rjwilcox45 pointsBadges:
  • Access Subform Blank

    Subform doesn't appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

    Billa15 pointsBadges:
  • Insert record through VBA into a Access table

    I get a duplicate index error message when I insert a record through VBA into a table. The table has nearly 1345 records. The same code had worked fine earlier and also works fine now with a blank copy of the same table. I understand that it is not an issue with the code or the data inserted. Can...

    SuderKody20 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