• 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: 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:
  • 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:
  • What is the code that links VB 6.0 to MS Access and how to go about it?

    What is the code that links VB 6.0 to MS Access and how to go about it?

    nyaga140 pointsBadges:
  • Code for combo in VB 6.0

    Hi Experts, In VB 6.0, please tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question: Please give any idea for VB 6.0 Combo --- so when...

    AnandaDebnath280 pointsBadges:
  • Passing parameters in Access into VB 6.0

    How to pass parameters in MS Access into VB 6.0 and get the results through a record set?

    Bijaybehera2915 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • copy 1.2 GB mdb from pc to network

    When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?

    Snow12345115 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