• SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • What is the procedure for Deployment in VB6.0

    Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2.  It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available. Please...

    SailajaConsultancy5 pointsBadges:
  • Combine (concatenate?) in Access~special circumstances

    Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below... In the samples below, Account code is in Field 1... String(s) to be added are in Field 2. Then in Field 3...

    Matchmole5 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?

    nyaga135 pointsBadges:
  • Can’t change Navigation Button Caption for subform

    I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

    Bets5 pointsBadges:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • Access form to link to Google Maps

    I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base

    Agma1020 pointsBadges:
  • Changing Access form properties within your program.

    I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.

    AOMCprog5 pointsBadges:
  • Hide print page that is blank in Access 2003

    I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

    Richpax5 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • How to delete a database – MS Access 2007

    I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

    NLC30 pointsBadges:
  • Export AS/400 to MS Access

    My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

    Dowagiac5 pointsBadges:
  • MS Access DATABASE and combobox in VB6.0

    hellooo plz i need help  i am new to VB6.0 and i've learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the combobox i want...

    Ahedfares895 pointsBadges:
  • convert string to double in Access 2003

    Hi - I'm trying to convert a string into a double using this expression in Access Expression builder: Field1: CDbl(string) It's not working. does anyone know why? thanks...

    Contactesa5 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • connectivity 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++

    Hmaria5 pointsBadges:
  • How to Set Active Period in a Table

    There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this...

    Abdul30dec80 pointsBadges:
  • How to Set Active Period in a table

    I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time

    Abdul30dec80 pointsBadges:
  • Access restrictions based on MAC

    I have developed a dbase system using MS Access and .net which is a multi-user system, database being intsalled in primary server. I would like to restrict access / usage by applying MAC address. Plz advise on steps and codes. Thank you.

    Ravindranpk10 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