• SQL for MS Access Syntex issue

    I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the ON section...

    CompEng1,185 pointsBadges:
  • Access 2007 form creation

    Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i'm not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button a message...

    Kvs35 pointsBadges:
  • connectivy between C++ and MS Access

    hi, i have problem releted with ms acess and c++ programming languge sir cant get any information about connection between ms acess and c++ programming languge give me steps to connect ms acess and c++

    AMOL1210 pointsBadges:
  • PICTURE STORE IN ACCESS 2007 DATABASE THROUGH VB

    KINDLY TELL ME HOW I STORE PICTURE/IMAGE IN ACCESS 2007 DATABASE THROUGH VB CODE     ANANDA DEBNATH INDIA, DELHI  

    AnandaDebnath280 pointsBadges:
  • COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS

    HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT...

    AnandaDebnath280 pointsBadges:
  • Migration from Paradox to MS Access or VB.Net/MS SQL

    We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

    ScotE45 pointsBadges:
  • PHP and MS Access Database

    I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...

    TCF5 pointsBadges:
  • export VB6 report in pdf format.

    i am making a project in vb 6 using ms access as a database. i am making report in crystal report and want to export that repot in pdf format.

    Ambastha5 pointsBadges:
  • How do I place duplicate directly below the copied record?

    I have code (below) which works perfectly today attached to a button to copy a record in a form. But, it inserts the new record at the bottom of the form, I would like to make it past the new record immediately below the copied record. Is there a way to do this? Private Sub Duplicate_Record_Click()...

    Klemieux5 pointsBadges:
  • Bluetooth History List/Device List

    How to tabulate (say in excell spreadsheet or better in Access databases table.) all slaves Bluetooth devices of Master Bluetooth device (in my case Laptop)? I have to refresh Bluetooth devices (F5) at fixed interval of say every minute as in my Access application a Macro is activated at interval...

    Apcalogic50 pointsBadges:
  • Database being auto duplicate when exit.

    hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...

    Nurul29815 pointsBadges:
  • convert from msaccess to sql2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • resize contol in Access print view

    [table style="border-collapse: collapse; width: 347pt;" border="0" cellpadding="0" cellspacing="0" width="462"> [col style="width: 347pt;" width="462">[/cOLIST] [tr style="height: 69pt;" height="92"> [td class="xl63" style="height: 69pt; width: 347pt;" height="92" width="462">I am using ms access...

    Deepakpleo5 pointsBadges:
  • insert an access image into a crystal report

    A .bmp in a field on my access db; I want to display the image in my crystal report. I've looked at some forums but the suggestions don't getg me anywhere. any help would be much appreciated. Thank you

    Kims2125 pointsBadges:
  • Edit .accdb from multiple workstations

    How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp Sp2 machine ?

    Tdizzle34230 pointsBadges:
  • Hiding the system views table from Microsoft Access

    How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Best way to create a large access databases.

    I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live with it.

    Opus35 pointsBadges:
  • Microsoft Access Report

    I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane

    Mcrisok5 pointsBadges:
  • To trap the item name of more than one item selected in list control

    1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...

    MBAinsystems5 pointsBadges:
  • Erro in Subform in Ms Access Reports

    Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...

    Rahmedarain200510 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