• How to update a row in grid view?

    how to update a row in grid view when changes made to database..

    Santu1015255 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • Exceeding maximum record locks in Access

    i have written code to import information from several text files into a linked table. It works fine for a while, but eventually I always get an error about exceeding the maximum allowed locks. I do not want to change the registry - i would rather just not have any locks (because I don't need them).

    Rampagingpigeon25 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • 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:

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