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!

Recent content by paty

  1. paty

    How to create report with varying parameters

    Thanks. I will try this!
  2. paty

    Keeping the Caption when using SQL

    Hi, I thought about doing this but I dismissed it because I thought this would make the field name in the new table Last Name. If I were to go into the design of the new table, I would like the field name to still be 'LastName' but the caption to be 'Last Name'. I will try it anyway but if...
  3. paty

    Keeping the Caption when using SQL

    In a database I am creating, I constantly create tables using SQL (through VBA) that I subsequently want to use in reports. In some tables, I want the name of the field that prints on the report to be different than the field name so I have specified a caption for those fields. However, when I...
  4. paty

    How to create report with varying parameters

    Thanks for your response, it's a good thought. But since the record source of the form that I am displaying is always changing (and the form has a fixed number of text boxes), when the user has summarized over a parameter, the text box on the form based on that parameter returns the value...
  5. paty

    How to create report with varying parameters

    Hello, I have built a very complicated database for a client in which the user can, among other things, summarize over fields (I am using Visual Basic and SQL to summarize over the data by basically selecting all other parameters except for the one the user has selected to use as a...
  6. paty

    Using SELECT DISTINCT (when memo fields are involved)

    Thanks for responding. Yes, I am absolutely certain that some PC's can handle it. Mine handles it just fine (I know, this is odd). There are two computers with (I think) Windows NT that are getting the error. The rest of them do not get an error and "seem" to run the query just...
  7. paty

    Using SELECT DISTINCT (when memo fields are involved)

    I am developing a database and one of my queries uses the DISTINCT keyword. Some of the fields that I am selecting are memo fields. While trying to run the query, some of the users are getting "RUNTIME ERROR 3114", which indicates that you cannot select distinct values when memo...
See more

Part and Inventory Search

Back
Top