You are here:
Business Software/Scottgem
All Reviews from Users
Column Headings: K = Knowledgeability C = Clarity of Response T = Timeliness P = Politeness
N = Nominated for Expert of the Month
| Date | User | K | C | T | P | N | Comments |
|---|---|---|---|---|---|---|---|
| 2009-11-02 | henna | 10 | 10 | 10 | 10 | Yes | |
| 2009-10-15 | Stan | 8 | 10 | 10 | 10 | Yes | In this day and age I apprecaite anyone who would give of their time for someone else. I need to put forth more effort on my own to set a more difinative course. Thanks and God Bless! Stan |
| 2009-10-06 | Bobbie | 10 | 10 | 10 | 10 | Yes | Thanks Scott, you have always been a help when I ask! |
| 2009-09-15 | Karen | 8 | 10 | 10 | 10 | No | Thanks so much for the VERY fast reply! I really appreciate it! |
| 2009-09-15 | Alan | 10 | 10 | 10 | 10 | No | Thank you Scottgem! Regards, Alan |
| 2009-07-17 | Irina | 10 | 10 | 10 | 10 | No | Scott, you are the best!!! Thank you for helping! |
| 2009-07-13 | Max | 9 | 8 | 10 | 10 | No | Very quick response. What I did: I made a switchboard form with a button for each form that I have. I gave each button the action argument [new_record] at the "Where Condition". It works beautifully. Many thanks. |
| 2009-06-26 | Radu | 9 | 9 | 9 | 9 | No | |
| 2009-04-27 | A M | 10 | 10 | 10 | 10 | No | Thank you Scott, it helps indeed! |
| 2009-04-10 | Megan | 10 | 10 | 10 | 10 | No | |
| 2009-03-31 | am | 10 | 10 | 10 | 10 | Yes | |
| 2009-03-31 | Aditya | 7 | 9 | 9 | 10 | No | Thanks Scott for taking the time to answer. Luckily I found out the solution in a article from Microsoft. Below is the link:- http://office.microsoft.com/en-us/access/HA010345791033.aspx |
| 2009-03-24 | Henk | 8 | 8 | 10 | 8 | No | |
| 2009-03-11 | Peter | 10 | 10 | 10 | 10 | No | Thank you for your help. My final code works a treat Dim db As Database Dim qry As QueryDef Dim SQLstr As String Set db = CurrentDb() Set qry = db.QueryDefs("qryDatasheetPrintPreview") If Not IsNull(Forms![frmEntries].[sfrmTransactions].Form.RecordSource) And Forms![frmEntries].[sfrmTransactions].Form.RecordSource <> "" Then SQLstr = "SELECT * FROM " & Forms![frmEntries].[sfrmTransactions].Form.RecordSource End If If Not IsNull(Forms![frmEntries].[sfrmTransactions].Form.Filter) And Forms![frmEntries].[sfrmTransactions].Form.Filter <> "" Then SQLstr = SQLstr & " where " & Forms![frmEntries].[sfrmTransactions].Form.Filter End If If Not IsNull(Forms![frmEntries].[sfrmTransactions].Form.OrderBy) And Forms![frmEntries].[sfrmTransactions].Form.OrderBy <> "" Then SQLstr = SQLstr & " order by " & Forms![frmEntries].[sfrmTransactions].Form.OrderBy End If qry.SQL = SQLstr DoCmd.OpenQuery "qryDatasheetPrintPreview", acViewNormal, acReadOnly Set qry = Nothing Set db = Nothing |
| 2009-01-07 | Jennifer | 10 | 10 | 10 | 10 | Yes | Thank you very much! I knew it was something incredibly simple like that. I had tried several times to put the Report name into the code but I didn't know it needed the quotation marks. Now it works like a charm:) |
| 2008-11-22 | robin | 10 | 10 | 10 | 10 | No | |
| 2008-11-19 | Daniel | 8 | 8 | 10 | 10 | No | |
| 2008-11-18 | Jim | 10 | 10 | 10 | 10 | Yes | Thanks for your help. I'll have to research this further. |
| 2008-11-10 | John | 10 | 10 | 10 | 10 | Yes | Thank you |
| 2008-10-30 | Ty | 10 | 9 | 10 | 10 | Yes | Scott provided me with an extremely prompt answer and saved me from having to do more research on my Access issues! |
| 2008-10-04 | anne | 10 | 10 | 10 | 10 | Yes | thank you very much for your help its a thought to start my own but i dont know how to lol. |
| 2008-09-23 | Gary | 10 | 10 | 10 | 10 | No | Superb expert. Fast. Reliable and Very Helpful. Thank You |
| 2008-09-10 | sheri | 10 | 10 | 10 | 10 | Yes | Short sweet informative and lightening fast response. THANKS MUCH!! |
| 2008-09-09 | sheri | 10 | 10 | 10 | 10 | Yes | Thank you so much. This is just what I was looking for. Appreciate the lightening fast response. |
| 2008-08-25 | Brad | 10 | 10 | 10 | 10 | No | I was so pleased to stumble on to this site. What a great thing. This guy really knew his stuff and was prompt in his reply. |
| 2008-08-15 | chrstine | 10 | 10 | 10 | 10 | Yes | Thanks Scott - good to know I am not the only one!!!!! Thought it was me. As always grateful for your help. Ch |
| 2008-07-08 | Mark | 8 | 10 | 10 | 10 | No | Thanks! |
| 2008-07-06 | christine | 10 | 10 | 10 | 10 | Yes | as always very quick response and has completely solved my problem! Thanks |
| 2008-06-09 | Nil | 9 | 9 | 10 | 10 | No | Thanks. Can you reccomend a template to start with? Does an Access newbie like myself stand a chance? |
| 2008-05-29 | Nanci | 10 | 10 | 10 | 10 | Yes | Thanks very much Scott for your valuable time. As good as the answer is exactly where to go to find it. And an astonishingly quick response. cheers, Nanci |
Page: 1 | 2 | 3 | 4 | 5 | Next
Scottgem
Expertise
I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience
I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
©2009 About.com, a part of The New York Times Company. All rights reserved.