Search results for query: *

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

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

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.

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.

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?

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

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

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

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

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

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

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

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

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?

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

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

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

thanx for all the help

Thanx for all the help guys

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