Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LittleNick

    Anyway to disable Quick Access Toolbar in Access 2010 with code?

    Good Morning, Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)? Thank you.
  2. LittleNick

    Can Quick Access Toolbar be disabled in Access 2010?

    Good Morning, Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)? Thank you.
  3. LittleNick

    Connection Failure

    Hello everyone, I have an Access 2003 adp and connected to SQl2005 server. It has been running fine but the last few months, I received a lot of message "Connection Failure" and I basically have to end task the database and restart it. I have checked the SQL server and the Access database and...
  4. LittleNick

    Server Filter in a Form

    Hi Everyone, I have a Main Customer form with a button when I click it, it will open another form, with code something like this when button is clicked: stDocName = "frmCustomerBillingInfo" stLinkCriteria = "[CustomerID] = " & Me![ID] DoCmd.OpenForm stDocName, , ...
  5. LittleNick

    Update a field usin count of another field of the same table

    Imex, Your version works well also. Thank You!
  6. LittleNick

    Update a field usin count of another field of the same table

    Thanks bborissov. That works! Thanks Imex for your help. I have not tried your solution yet but I will and will let you know. Thanks
  7. LittleNick

    Update a field usin count of another field of the same table

    Hi All, I have a table like this ID Item RcdCount 02 x 02 y 02 z 05 a 05 b 04 j And I want to update it to look like this ID Item RcdCount 02 x 3 (Because there are 3 records of ID 02) 02 y 3...
  8. LittleNick

    [b]Update a Field of table II[/b]

    Yes! That works Great! Thank You Simi! I have a process that does the calculation, but I was wondering if SQL can be programmed to update and calculate. For ex using tblOrder (updated): tblOrder (updated) (with calculation) OrderID Item Unit Match 01 Book 2...
  9. LittleNick

    [b]Update a Field of table II[/b]

    Hello Everyone, In an ealier post, I have 2 tables as below: tblOrder OrderID Item Unit Match 01 Book 2 01 DVD 4 01 Games 3 02 Book 5 02 DVD 6 03 DVD 7...
  10. LittleNick

    Update a field of table

    That works GREAT! Thanks Simi and bborissov.
  11. LittleNick

    Update a field of table

    OK. Sorry for the confusion. I actually have 2 tables, table tblOrder and table tblOrderDate more accurate. tblOrder OrderID Item Unit Match 01 Book 2 01 DVD 4 01 Games 3 02 Book 5 02...
  12. LittleNick

    Update a field of table

    Thanks bborissov for you help. The codes you have work great. Sorry, I actually forgot a second table with a date. If I have another table as tblDate OrderID Date 01 03/15/2010 02 05/01/2010 03 07/01/2010 And I want to update tblOrder with a date of...
  13. LittleNick

    Update a field of table

    Hi everyone. I have a table tblOrder OrderID Item Unit Match 01 Book 2 01 DVD 4 01 Games 3 02 Book 5 02 DVD 6 03 DVD 7 03 Games 8 I want to...
  14. LittleNick

    Update table using multiple tables

    Thanks djj for your advice. I combined some tables by creating view first then it became a lot easier.
  15. LittleNick

    Update table using multiple tables

    Hello everyone, Let say I have these several tables, tblCustomerTransaction, tblCustomerShip, tblItemsType, tblItemsCost as follow: tblCustomerTransaction ID Item Orderdate Unit UnitCost 02 Tool 01/01/10 10 02 ToolKit 01/01/10 10 02 Electro 01/01/10 5 05 Games 01/01/10 2...
  16. LittleNick

    Update a Null field to the value of the same field of the same group

    It works! Thanks markros and bborissov
  17. LittleNick

    Update a Null field to the value of the same field of the same group

    Hi Everyone, I have a table with a field that has null value that I wan to update. Let say I have a table tblCustomer: OrderID Customer# CustomerName 10890 2234 John Smith 10890 Null John Smith 10890 Null...
  18. LittleNick

    Select all data in one table that are not prsent in the second table?

    Thanks bborissov. That was what I needed. It works great. Thank you again.
  19. LittleNick

    Select all data in one table that are not prsent in the second table?

    Hi, I have two tables tblData1 and tblData2 with 3 columns Id, First, Last, on both. tbldata1 is the full table and tbldata2 consist of selected records of tbldata1. Now I need to filter all the data out in tblData1 that are in tblData2. for ex: tbl1 tbl2 1 3 2 5 3...
  20. LittleNick

    Temporary Table with Multiple users processing

    Sorry Duane, I did not notice your post after I read Randy and Golom post. Thanks for your and Andy replies. I was planning to do what Duane suggested, inserting a new userid field into the Temporary table, but did not get to test it yet. To answer Andy questions, when user A double click on a...

Part and Inventory Search

Back
Top