Search results

  1. M

    Union Query - Yes or No to search again

    Hello, I am using the following union query to search serial numbers from 5 different tables. SELECT[WORKSTATION].UnitModel,UnitPart,UnitSerial,PONum FROM[WORKSTATION] WHERE(((WORKSTATION].UnitSerial)=[Enter Serial No.])) UNION ALL SELECT[LAPTOP].UnitModel,UnitPart,UnitSerial,PONum...
  2. M

    Vbyesno

    Hello, I am using Access 2003 I have a database I have created for a church cemetery. It has approximately 425 records. I created a form that I can query a last name and bring up the form if the record exists. If no record is found, a MSG box will say it doesn't exist. I added some code to...
  3. M

    Calculating Years Months Days DateDiff

    Hello, I have created a cemetery database in Access 2003. I have three fields; BirthDate, DeathDate, and Age. Under properties in the AGE field in CONTROL I am using the following syntax: =IIf([DeathDate],(DateDiff("m",[BirthDate],[DeathDate])\12 & " years and " &...
  4. M

    VBA Code Cemetery Database

    Hello, I am trying to enhance a cemetery database I created in Access 2003. All of the graves are in one table. The queries work fine. However, I have created 4 Buttons to expand on the record. The four buttons go to 4 different sub directories. When the record is found, the user can click one...
  5. M

    Sql union query-where clause dates

    Hello, I am trying to pull records for computer equipment that the test date has exceeded 90 days. I am trying to modify a union query to make this work. I have several tables that I have to search. I cannot change the structure so I have adapted to it. This is the code I am trying to modify.I...
  6. M

    Calculating total number of records from union query

    Hello, I am using the following UNION QUERY to total up equipment tested for a report. SELECT "Laptops Tested" AS PCEQUIP, Count(*) AS RECORDS FROM [LAPTOPS] WHERE (((Date)Between [Enter Start Date] AND [Enter End Date])); UNION SELECT "Workstations Tested" AS PCEQUIP, Count(*) AS RECORDS...
  7. M

    Union Query - Multiple records on one report

    Hello, I have a database that has over 20 tables in it and am using Access 2000. Unfortunately I cannot change the structure as it performs specific functions, so I am stuck with it. I have created a Union Query from these tables yaking data from 5 fields using the Serial Number entered by the...
  8. M

    Counting test records from multiple tables in one report

    Hello, I have been trying to create a report to count equipment tested between two dates: I am using Access 2000 (old I know) and I have 21 different tables with the fields laid out the same. For the moment, I will list five of the tables: Servers, Laptops, Printers, Workstations, and...
  9. M

    Preventing negative numbers in report

    Hello, I have a report where I have equipment tested every 90 days. I have a field called TEST DATE formatted using the medium date format (07-Mar-14). I have another field called RETEST DATE where my query adds 90 days and displays the Retest date as (07-Jun-14). I have a unbound box...
  10. M

    Hello

    Hello, I have been playing with Access 2000 & 2003. I enjoy it, but get frustrated a lot of times. I don't understand VB code. I have tried to parallel "strings" and examples with my projects. Sometimes I get lucky. I hope to learn a bit more on this site. I am most grateful for any help I...
Back
Top Bottom