Search results for query: *

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.

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.

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...

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, , ...

Imex, Your version works well also. Thank You!

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

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...

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...

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...

That works GREAT! Thanks Simi and bborissov.

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...

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...

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...

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

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...

It works! Thanks markros and bborissov

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...

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

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...

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...