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

    How to populate multi-column combo box from deliminated string?

    Thanks for your reply! I found the way around my issue, and as usual it was rediculously simple. Yet another case of trying to to pound a nail with an anvil. If the combobox is already bound to a query, programmatically setting it's value to one of the currently bound values causes the box...
  2. teddyatjorundotnet

    Report on Form

    A report is not so very different from a form. It's simply read only. I would create a subform and drop the elements of your "report" into it. Set the background to white. The user can't tell the difference..
  3. teddyatjorundotnet

    Delete a column

    Explicitly define the columns you would like for the listbox. This is exactly the same as any other query, simply build the datasource to include only the fields you would like.
  4. teddyatjorundotnet

    How to populate multi-column combo box from deliminated string?

    Howdy folks, I'm in a bit of a quandry trying to figure this one out. Basically I have a comma deliminated string that I need to use to populate a multi-column combobox. I'm confused because passing a comma deliminated string works properly for populating a listbox, and combo boxes are...
  5. teddyatjorundotnet

    Change format of access -> excel import.

    Howdy folks, I have an issue that's been raking me over the coals for a few hours now. Basically I'm trying to export an access report to an excel spreadsheet. The issue I'm having is excel is very picky about the format of the data. In the report, I have one group header and a detail band...
  6. teddyatjorundotnet

    Stopping formula from returning DIV/0 or #Num! error

    =([UnitsSold]-[PrevTotSold])/iif([PrevTotSold] = 0 , 1, [PrevTotSold])
  7. teddyatjorundotnet

    Here's a tough one.....

    Will you ever have more then two entries for the same studio? If not I can see quick fix. Something to the effect of: SELECT [id], [name], MIN(end date), MAX(beg date), DATEDIFF(day, edate, sdate) FROM tblA INNER JOIN tblB ON tblA.id = tblB.id If you need it dynamic, then I'd have to put...
  8. teddyatjorundotnet

    i want to make a report that sorts

    The sort order of the underlying query does have an effect on the output of the data, provided you have not set an overriding condition in the report itself. For instance, take a report with grouping levels consisting of: Parent Company ____Company ________Employees Sorting by Parent Company...
  9. teddyatjorundotnet

    Looping through queries to build a continious report

    YOu may be able to do this with an OR operator in your where clause. SELECT [2003].Manger FROM 2003 WHERE (([2003].Investor=fncGetInvestor) AND ([2003].["One on One" Manager Meetings])>0) OR ([2003].[Capital Introductions Event "Manager Sessions" Attended])>0) OR...
  10. teddyatjorundotnet

    Extra Blank pages when Printing a Report

    Make sure the report isn't carrying over into the waste area of the report. This is much the same as excel printing additional horizontal cells on the following page. I believe the cut off for a default portrait report is "6.5" according to the in-line ruler during design time.
  11. teddyatjorundotnet

    Page header visibility in a report

    If it only appears at the top of the first page, then you would be better off using the report header.
  12. teddyatjorundotnet

    How to exit access app when exiting switchboard?

    Are you absolutely sure the command is being triggered in the first place? Perhaps you could post the sub that you're stepping through. You may want to consider throwing a debug messagebox before and after the DoCmd.Quit, just to make sure it is indeed failing.
  13. teddyatjorundotnet

    Triggering Report from Form in Project

    I think you're on the right track with setting the "filter" in the Report_Open event. Why not flat out set the record source though? Essentially you could do something along the lines of: Dim frm As Form Dim Src As String Dim WhrClause As String Set frm = Forms!yourForm Src =...
  14. teddyatjorundotnet

    Help with report please!!!

    Actually, you won't return anything for an agent, not even null. SQL constructs the dataset from the join statement first. If a value does not appear in one table, it is assigned null at that time. The problem you may run into is that if the broker has any sales at all, then they do in fact...

Part and Inventory Search

Back
Top