Search results for query: *

Greetings all, I have the following code in which I'm utilizing to export my results from a query to a user defined location: Dim strFilter As String Dim strInputFileName As String Dim strpath Dim strSQL strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName...

Afternoon all, I've got an interesting one here...I've got a form that is tied to query (very simple). On the header portion of the form I have a calculated field that sums one of the fields. Here is the problem I want to apply a filter and determine a % share (Sum of Calc Field filtered /...

Morning, Reading up on some information, I'm not sure I can do this with a simple loop...would a cursor be needed for this? Thanks

Afternoon all, I've been so far removed from SQL programming that, I know this is possible, however I cannot figure out how to do it. Here is the sample Table : Date - Code - Bill - UnitSold 10/3/2005 123456 4.99 100 10/10/2005 123456 4.99 200 10/17/2005 123456 300 10/25/2005 123456 5.99...

Afternoon All, I've been trying to get this DLookup to work on_update of one of my fields. However, each time the field updates, I get a "You cancelled the previous operation error". Any ideas? Here is the DLookup: [Old_Shelf] = DLookup("[SHELVES]", "tblAttribute", "[Category]=" &...

Greetings all, I have read many articles on tek-tips in regards to the access bug that switches the report page orientation from landscape to portrait...however, the fix that is most easily for me to implement (turn off the Auto-correct flags off in tools-general) to all users is just not...

Tom, Thanks for responding...that would work if my query was a "static query". The query is actually being created on the fly with my querydef. I have the user chosing from a list box which fields they want to view in the query. So one query may just be sales $, while that same query for...

Morning all, I currently have a form that allows for the user to choose from fields they would like to see in the query/report. Essentially, I have a list box of metrics (i.e. sales $, units, etc) that the user chooses from so they can customize what they would like to see. I am passing this...