Search results

  1. G

    Outlook email combo box

    8/13 I travel frequently and it is helpful to my email recipents to know where I am located. Currently when I construct an email I type my current location, current date, and current day at the top of the email e.g. From Somewhere USA 8/13/09 Thurdsday Can via VBA a series of combo box be...
  2. G

    IIF Nested?

    I have a report based on a crosstab query with columns [ABC], [BCD], [CDE], [DEF]. I want to compare the data (dates) in the four columns and display in a new column [XYZ] on the report only the latest date. Original ......[ABC].....[BCD]....[CDE]....[DEF]...
  3. G

    DO not understand - DLOOKUP

    I want to develop a report from my database with various "assignments" across the top with the start date underneath. I have a query named NextOccurance. All assignments i.e. SMART are text, Start Date is Date/Time (mm/dd/yyyy). On a report using a unbound text box for the control source I...
  4. G

    Multiple users add info thru restricted form - How?

    3/24/2009 I have "inherited" an Access database, because I have some training and can generally 'get' Access to do what I want, albeit, not efficiently. This Access database tracks the start and end dates of 'assignments' for many units (ships). The database appears to be 'normalized' as...
  5. G

    Export to Excel

    2/24 I have read with great interest this thread http://www.access-programmers.co.uk/forums/showthread.php?t=157331&highlight=query+export+excel and with some modification it does what I want to do; Almost. I am using Access 2003 and this is the code...
  6. G

    Skip filing reports w/o data?

    I have a macro that files a particular set of reports; It works properly. Some of the reports occassionally will not have any data, depending on the data being analyzed. I would like to NOT file the reports without data. How would I go about it? Thanks, Gunner...:confused:
  7. G

    Report, subreport, query, fieldname

    I have a report named rpt100 with two subreports srpt100a and srpt100b. The subreports are based on query qry100a and qry100b. Both queries are based on tbl100. I removed a field named 'Comment' from tbl100, as it wasn't useful; Also removed the fieldname from both qry100a and qry100b. When...
  8. G

    Form displayed diff after opening report.

    I have via macro that displays the main interface to my database; frmMain (Maximize). This form frmSelectUIC (Minimize) allows me to select a department number of the data imported for analysis. All is fine, as shown here; http://members.cox.net/mustang31859/access/before.gif However, after...
  9. G

    Form/Report/Query aka how to change criteria value

    I have built a database with only my department in mind that tracks three types of documents; Which works fine. Now some of my fellow department heads desire to use what I have built. This is not a problem as their data structure is the same. The difficulty lies in changing the 30 queries...
  10. G

    How to CALC a Null, Empty or Blank entry?

    I have a report with 8 sub-forms, based on 8 queries, which works great. Four are under the heading issues; the other four receipts. The sub-reports are for four specific time periods. It looks like this; Issues | Receipts Period 1 (10) | Period 1 () Period 2 (5) |...
  11. G

    Make-Table Action query column data

    I use a Make-Table Action query to import data from a linked table into my database. The linked table is on a network server that is automatically updated. One column of the linked table is named "QTY/PARTIAL" and approximately 10% of the 500 records have a "P" after a number i.e. 1000 P. I...
  12. G

    Lost in my database...

    My database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report? Thanks! Gunner...:confused:
  13. G

    Change query criteria value?

    I have a database with 20 queries designed specifically for my department (SAM). A friend would like to use my database i.e. queries, reports, etc., but her department is named different (PAM). The the field names in the each of our imported 'data' is the same, EXCEPT, each record in her...
Top Bottom