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!

  • Congratulations SkipVought 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. boysrus

    Create new record from fields of existing record

    Hi, I would like to write code that copies all of the fields from one record, changes the key, and adds it in as a new record. The key for the 1st record is supplied by the user. The new key is an autonumber field. Would I use recordsets? If so, can you tell me how to do it? Or should I...
  2. boysrus

    Automate adding a Library in Tools ¦ Reference

    Hi, Is there anyway to automate the process of going into Tools | Reference and checking a library?
  3. boysrus

    How can I copy a linked table to another table, not just the link?

    My data is in a back-end database. I have a front-end database with all the code, forms, reports, etc. which is "linked" to the back-end. I have written code using the CreateDatabase command to create a new history database called "mmyyy". I would like to write code to...
  4. boysrus

    Caluclated Report Field based on subreport showing #ERROR

    The problem is that the query (in the sub-report) is a cross-tab based on a date selection criteria. It is possible, that there is no data for the dates chosen. So the cross-tab query comes back with zero records. Then the main report is trying to look for fields created by the cross-tab...
  5. boysrus

    Determine Record count of query to suppress #error msg in report

    I have a report that has a calculated field based on its sub-report. The sub-report is based on a query. When the query produces NO records, the calculated field in the main report shows #error. Couldn't I use code in the main report to determine if the query (within the sub-report) will...
  6. boysrus

    Caluclated Report Field based on subreport showing #ERROR

    I have a report that has a calculated field which is based on its subreport. The subreport is based on a query. If the query results in zero records, the subreport does not produce anything and the calculated field on the main record shows #error. How do I tell the main report to show a zero...
  7. boysrus

    Caluclated Report Field based on subreport showing #ERROR

    I have a calculated field on a report that adds up fields from its subreport. The subreport is based on a query. The report runs fine when the query produces records. But if the query does not contain any records, (and therefore the subreport is blank) the calcualted field on the main report...
  8. boysrus

    Nero 5 Error

    I have a demo version of NERO 5.5.2.4. It is suppose to expire on 7/31/01. I am trying to burn a mixed-mode CD. When I open the .nrm file, it tells me the demo has expired (even though it is not 7/31 yet). But it still opens the session. When I open the Write-CD-Dialog then click...
  9. boysrus

    Where can I get WinOnCD.

    Does anyone know where I get get WinOnCD?
  10. boysrus

    Can Music and Data go on 1 CD?

    I have a program (an exe file) that I would like to put on a CD along with music. I would like my friend to be able to copy the program to their own PC and the program will reference music tracks on the CD. Therefore I need to put the program and music on 1 CD. Is this possible? Can a CD...
  11. boysrus

    How do I put the result of a count query into a form?

    Works Great!!! Thanks.!!!
  12. boysrus

    How do I put the result of a count query into a form?

    I want to put a count value into a form. I have created a query called qryOutLoanerCount. There are no groupings so it comes up with 1 count field called [CountOfUnits]. I am trying to show the value of this count field on my form. On the form, I have a text box with the Control Source set...

Part and Inventory Search

Back
Top