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

    help with stored procedure

    patricheck: You could add another JOIN using a "derived" table, but since you're new to this, it's easier to change your WHERE and use a subquery. It's easier to see what's happening. ALTER PROCEDURE dbo.FilmStatusQuery AS SELECT t.Date, t.Type, t.Status, t.Notes, c.FirstName, c.LastName...
  2. jiqjaq

    Query to display only duplicate entries

    The type of duplication you're looking for determines how the query needs to be written. Are you trying to list out the order dates for members who have placed multiple orders? This is not quite the same as listing out orders from members whose names are the same. In the first case, people...
  3. jiqjaq

    not sure of options

    Based on our description, it sounds like you are what is often termed a "business analyst". You map out the flow of data within a company and then determine how to make it flow easier and smoothly. Programming skills, while certainly helpful, are not always needed for this. Since you've been...
  4. jiqjaq

    Sorting By a Sum Field

    Because you've grouped by company, then county, Access is going to list the detail records in that order. If you're just trying to get the companies to list in order of their sums, you'd be better off calculating those sums before you assign the recordsource of the report. By that, I mean that...
  5. jiqjaq

    Leaving out blank fields

    In the VBA code for the section where these fields print (e.g. Detail_Format): (where PunchIn is the name of the field) Me.PunchIn.Visible = (NZ(Me.PunchIn,"")<> "") The NZ will force a "" value if that field is null. Then the visible property will be set based on that value. If it's not ""...
  6. jiqjaq

    Can't build a link between unbound forms???

    If you're going to use the link fields properties, you need to have reports that have fields bound to the data. The ControlSource property must be set to the name of the field or SQL statement which provides this data. Similarly, the RecordSource needs to be set either in the property window or...
  7. jiqjaq

    Sorting By a Sum Field

    Since the Group Header is printed before the Detail, placing the Sum in the header won't get you anywhere. The records you're trying to sum haven't been read yet, at the time the header is being printed. Access only sort the input. The output is based on the groupings but is still dependent on...
  8. jiqjaq

    Does detail section contain records??

    Sounds like, you have no records left to print, but you're getting an extra page. This can only happen if the detail section itself, or some section physically after it, couldn't fit on the same page with the last record. Access then forces another page to print anything remaining. Rather than...
  9. jiqjaq

    Does detail section contain records??

    Access repeats the detail section for each record, so you're always going to have 1 record in that section. Are you referring to the number of records which fit on the printed page?
  10. jiqjaq

    ErrMsg = No Original Data to Access

    This doesn't seem like a message from SQL Server as much as it does the VB program trying to interpret the error. If you're using ADO to connect to SQL, be sure to check the ADO errors collection and not the VB error object for proper text of the returned code.
  11. jiqjaq

    summary table with counts

    Due to your Group By, you're getting a count of male students for every course returned in the subquery. You need to add a WHERE clause to the Update and link/repeat the fields in that clause to those in the subquery, so they're referencing the same course and gender. You'd be better off...
  12. jiqjaq

    Problem with corelated subquery

    You're returning multiple values because all the employees Meal Breaks from every day at work are being included. Your subquery also need to include: AND B.EventDate = mytable.EventDate
  13. jiqjaq

    Several Forms with same button with same code opening same form

    Since all you're doing on the click of the more button is opening another form, why bother creating a separate function? You can open the form in the same line it takes to do the call, plus you'll actually be in the original form to pass the field, so you won't need all those references. You're...
  14. jiqjaq

    having-where

    Aggregate functions are intended for use in the HAVING clause, not the WHERE. Other than the aggregate functions, the key difference between the two is when they are applied. The WHERE conditions are applied for each row of original data, as they are read, before the selected fields are...
  15. jiqjaq

    COUNT NUMBER OF ITEM IN TABLE

    This is the wrong forum for this question. Please post in Access Queries and JetSQL. Also, your question is not clear. You don't explain what Under Price and Over Price are. Which price are you talking about?
  16. jiqjaq

    Subclassing : After MsgBox Display

    I subclassed a window and displayed a MsgBox to warn the user when the X was used to close it, rather than the provided Close button. The problem is that the MsgBox only displays the first time this happens. Subsequent times the message seems to be captured and ignored, just no MsgBox. What do...
  17. jiqjaq

    Saving Report As PDF

    We were using similar code to change the bExecViewer registry key with Win XP and Access97. Now that we've upgraded to Adobe 6, it no longer does the trick. Version 6 uses a different printer name (Adobe PDF) and the settings are now part of the printer properties rather than just registry...
  18. jiqjaq

    Print to File

    Version 6 uses &quot;Adobe PDF&quot; as the PDF printer. The settings can be changed by selecting that printer and changing it's properties (on the Ports tab), the way you would with any other printer. Keep in mind that this will apply to all uses of Acrobat, so if you don't want this setting...
  19. jiqjaq

    Print to Acrobat Prof 6.0

    Are you printing directly to the Adobe 6 printer, &quot;Adobe PDF&quot;? If you set the printer preferences by selecting the check boxes that appear on the left side (Display, Prompt for Filename, etc) they should set the options for that printer. If you print via the Distiller rather than...
  20. jiqjaq

    Access 2000 Reports - Print Landscape (Summary/Thoughts/Questions)

    The orientation values are stored in the PrtDevMode structure along with the report. When printing occurs, any settings from the report are merged with the regular system settings to determine how the report will print. If you've set a report to print in landscape, it should overwrite any...

Part and Inventory Search

Back
Top