Help
in [Access]
|
ADO or DAO? Which one more readable? Dear Access experts, I have no experience writing ADO or DAO code but I am going to start soon. After reading up on ADO and DAO, it seems both can do the job for me. However, I do not know enough to know which one to choose. I am using Access2003 and the database will be used locally, not on a client-server en... 19 Jul 2010 21:16
A Totals query problem I have a totals query that is giving me incorrect results. The query is SELECT ForeignID, Last(StatusID) AS LastStatus, Last(StartTime) AS LastStart, Last(EndTime) AS LastEnd, Last(CounterId) AS LastCounter FROM BuildDeviceDetail GROUP BY ForeignID; CounterID is the autonumber field. ForeignID th... 15 Jul 2010 09:50
unable to undo delete on form that uses ADO recordset I am using a disconnected ADO recordset that I bind to my form in Access using VBA. I am able to edit existing records, but deleting them is causing a headache. When you delete record(s) either by clicking Delete Record button or highlighting the row and pressing Delete key, Access stored them in a buffer, then as... 14 Jul 2010 04:24
Cheap Wholesale Chanel Shoes heap Wholesale UGG Shoes (paypal payment) (http://www.brandtrade99.com/) Cheap Wholesale Ugg Boots (paypal payment) Cheap Wholesale Gucci Shoes (paypal payment) (http://www.brandtrade99.com/) Cheap Wholesale GUCCI Boots Cheap Wholesale Lacoste Shoes Cheap Wholesale LV Shoes (paypal payment) (http://www.brandtra... 13 Jul 2010 03:15
Network Workgroup File - Password in the "Clear"? I'm not sure if anyone has a definitive answer on this, but thought I would ask. If I establish a centrally located workgroup file on a network share, are the passwords stored in the workgroup file "sniffable" across the network? I have been running Wireshark while I access the application across the network and ... 13 Jul 2010 04:20
Getting Usenet headers into Access database Hi I have use various newsreaders which have features such as sorting the posts, defining filters etc, but it would be a lot easier if the headers were just in a table, then I could do whatever I want with them. Does anyone have any experience of this? ... 14 Jul 2010 18:43
Support contracts for my apps I have been developing in Access for many years and I am now looking to formalise the support I offer my clients. The problem is that the phone never stops ringing and my day is broken up so I become less and less productive. I was thinking of issuing a web based ticketing system along with voice mail where the cli... 19 Jul 2010 03:45
Help with Query Please I have a table with an address field. The data in this field for example is 1234 Main St.; 1234 Main Street. I want the data to be consistent, example, all "St. Should be "Street" and "Rd" should be "Road". Can anyone please help me with a query that will change all adresses ending with "Rd" to "Road" and so on? ... 13 Jul 2010 15:19
Problems with JOINs So simple, yet so puzzling. Searches have turned up nothing useful, so I hope someone here can provide some insights. This SQL statement: cJEnq = "SELECT Mem_ID, Model, Year FROM Cars WHERE Cars.Make = 'MG' AND Cars.Model = 'B' INNER JOIN Members ON Cars.Mem_ID = Members.Mem_ID" Results in this error: ... 9 Jul 2010 13:51
treeview question Hi, I'm working w/ data like this: parent: 1061001 child: 810 parent: 1061002 parent: 1067303 child: 809 parent: 1068201 child: 808 parent: 1068202 next child: 810 <--- breaks here saying 'key is not unique in collection'. So the parents are unique and the children are unique to the parent but not a... 9 Jul 2010 12:44 |