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. Leaner79

    Creating a Parameter Query that works in SQL

    Hi, I have this problem. I have created a function query in my SQL database. However i want to filter the data that i see. For example, i want to have a form where i input a value that should be used for filtering. Or i can have a dialog box come up and in the dialog box i can have a combo box...
  2. Leaner79

    Upsizing database from MS Access 03 to SQL Server

    Hi, I have developed a database that i use for Inventory. I did it in MS Access 2003.. I tried ti upsize it to our SQL server but ran into some problems. 1. All my tables, links and forms were trasfered without a problem 2. None of my Append, Update, or Delete queries were upsized.. 3. How do i...
  3. Leaner79

    Help with RECORDSET Function

    Hi. I'd like help with recordset. I have a form that i use to capture data. When i click a button I would like to have a message box to be displayed, showing the last record i entered in a particullar field.
  4. Leaner79

    Help with recordest Function

    Hi. I'd like help with recordset. I have a form that i use to capture data. When i click a button I would like to have a message box to be displayed, showing the last record i entered in a particullar field.
  5. Leaner79

    List items on one line on a report...HELP

    Thanx, the FAQ:: FAQ703-3587 worked for me. i can get everything on to one line But is there a way to group by date?
  6. Leaner79

    Can Shrink and Can Grow Properties help

    Sorry, i made a mistake. I have subreports within my report. i've tried the can shrink property, but the space between the subreports is still too large
  7. Leaner79

    List Items on a subform in Acsending Order

    Hi, I have a form that has several subforms. I would like records in the subforms to be listed in acsending order. How do i set this Thanks
  8. Leaner79

    Calculate Age Automatically

    Thanx Zameer, I worked. i have 1 more question. How do i get it to calculate it automatically, everytime a record is opened. The way i tried using On Open doesn't work coz if i open to add a new record, i get an error. NB. For existing records only. When i preview, the age should be calculated...
  9. Leaner79

    force date format regardless of locale set

    Hi, i would like to set the date format as DD/MM/YYYY on all my tables, regardless of the locale of the machine. How do i do this. Thanks
  10. Leaner79

    tables and data types (Qualifiers)

    Hi, I have a table, i have set one of the fields as Integer. I would like to be able to add > and < qualifiers with the numbers and not get an error message. Thanks
  11. Leaner79

    List items on one line on a report...HELP

    Hi, i have a table and i'd like to view the data in that table in a report. the table has 2 fields, Date & Medication The table looks something like this Date Medication 01/02/2002 TDF 01/02/2002 Z5H 01/02/2002 IPP 01/03/2002 LLP 01/03/2002 PHT 01/03/2002...
  12. Leaner79

    Can Shrink and Can Grow Properties help

    Hi, I would like help with the property fro shrinking subforms I have a report that has several subforms. One of these subforms has another subform within it. I'd like to have the report shink if there are few records, and grow of there are more. Please Help
  13. Leaner79

    Calculate Age Automatically

    Hi, I have a form that has a bunch of fields. The 2 major fields i'm most concerned with for now are the ones for date. Age - Should contain the age of the person DOB - should contain the date of birth of the person The Age should be calculated automatically by subracting the DOB from the...
  14. Leaner79

    form and subform data should be sent to a report

    Hi, I have a form with 3 subforms. All of the tables share the same primary key so they are linked.. I would like to have a report that prints the curent record displayed. Hpw can i have the report have subreports?
  15. Leaner79

    Createing a report that links to a form that has subforms

    Hi, I have a form, Patient..and it has 3 subforms.. I want to create a report that will show all data(including the data in the subforms).. But only for the highlighted record.. The primary key for the main table is ingMasaNo Please help
  16. Leaner79

    Print a report for single record

    This is my situation. I have a form(Patient Form)with many subforms. I want to create a button on the Patient form. This button will generate a report for only the highlighted patient. The report should also include the information in the sub forms. I hope i've explained myself better. Thanx
  17. Leaner79

    Print a report for single record

    hi, I'd like help with creating a report. I want it to have a report created for a single patient who is highlighted in a form
  18. Leaner79

    Populate field with username

    thanx for all the help
  19. Leaner79

    Updating records only if changes have been made to the records.

    Thanx for all the help guys
  20. Leaner79

    Updating records only if changes have been made to the records.

    Hi, I have the following situation. I have a switchboard form which has 1 buttons (Add And Edit) I have a patient record form, which has 2 fields, (DateRecCaptured and DateRecUpdated) Both buttons on the switchboard open the Patient Record form (one opens it in Add mode and the other in Edit...

Part and Inventory Search

Back
Top