• 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:
  • Access Form Printing Problem

    I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can't get these two forms to print in total? Thanks

    Ranfoster5 pointsBadges:
  • MS Access – Create Median Aggregate Function

    Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I'm using 2007)? In particular, I want to create "Group By" queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it...

    Cantrell10 pointsBadges:
  • VB

    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:
  • Master/Child Link problem in Subform

    Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...

    Dataempress115 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • Access for Windows 5.4

    On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.

    plaporte55 pointsBadges:
  • How do I set decimal places with VB Access

    I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

    Reject5 pointsBadges:
  • Date problem with Delphi 7

    I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ;  qrydate.Active := false ;  qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...

    Marieps5 pointsBadges:
  • Write Recordset to MSAccess(mdb) using VB6.0

    How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance.

    Nikhildhar35 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