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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MAPetry

  1. MAPetry

    Creating a dynamic Query

    I need to create a dymanic query. HELP!!! I have a form where the user has the option to input 5 different paramaters. I want to create a query so they can select 1 or all five and the correct data will be returned. I don't know exactly how to do this but am guessing that I need to define a...
  2. MAPetry

    Form Filter

    Is there a way to save the recordset of a user defined filter on a form? Then use that recordset as data for report. Thanks in advance Mary Ann Petry
  3. MAPetry

    Sort report on a calculated field?

    It didn't work says I can not have an aggregate function in order by clause. What I am trying to do is sort a report by the minimum date of a string of dates associated with a project. for an example a project may have (4) action dates I want to sort the projects by min date of their...
  4. MAPetry

    Sort report on a calculated field?

    I have a report where I want to sort on a field value that is generated when the report runs. What I did was insert a text box and assign the value of the text box to be calculated from underlaying data. I want to sort on that value any ideas? Mary Ann Petry
  5. MAPetry

    Report projects by action dates

    I have a report that I need to print a list of projects and their associated "action dates" Report is generated from 2 tables 1.) projects, 2. )Project Actions Need report to print in the following sort order: 1.) Project Type (Field of Project table) 2.) by action date. (listing...
  6. MAPetry

    Multi Select List Box

    I have a database form where I want user to enter: 1.Project (lookup on Project table) 2.Division (lokup on Division table) List box displays query of companies where criteria is division input above. What I need is: 1.)a command to copy the selected companies in list box 1 to another list...
  7. MAPetry

    Create New Record Problem

    OK to get rid of the type mismatch problem I got rid of the lookup and simply made the fax company a blank field with imput value. Now I get a syntax error. but I see no problem with statement.. Heres what I have: stLinkCriteria = "Forms![Fax]![Company]=" & Me!Company...
  8. MAPetry

    Create New Record Problem

    Thanks for your suggestions, Data Type: Since the receiver data for the fax form is a lookup of the company in company table it defaults it to autonumber (which is company primary ID type). and may be my problem Hoever I still want people to be able to open the stand alone fax form and...
  9. MAPetry

    Create New Record Problem

    I have a main company form that has all company information i.e. address, phone, fax, contacts etc. From there I want the user to be able to click the "FAX" or "Transmittal" button and have that open the associated form with the current company as the receiver of the fax or...
  10. MAPetry

    Open Form and add New Record

    I have a main form from which I want to open another form and add a new record with the compnay of the new record equal to the company of the original form. Being VB challenged I am not getting this to work. Following is code I currently have. ANy help would be appreciated. ** Also can...
  11. MAPetry

    Word and Page Numbers

    Thank You that is exactly what I needed MAP
  12. MAPetry

    Splitting a Database

    I have a database that people in my office would like to start using to store different project data in. Current master db has companies, contacts, and other general info. the seperate databases would have project information, transmittals, faxes, contrats, change orders, etc. but would...
  13. MAPetry

    Word and Page Numbers

    I have an over 30 page document in Word that is linked to Access. When the user merges it sometimes it updates the page numbers correctly and sometimes it does not. What it will do is print i.e. "7 of 7" and "8 of 8" instead of "7 of 35" and "8 of 35&quot...
  14. MAPetry

    Disable Shift Key access

    I want to eliminate users from going to explorer and Hitting Shift to enter the database. I read Faq181-143 and that doesn't eliminate the access through explorer. Am I just calling it wrong or is there another way.
  15. MAPetry

    Urgent Query Need...Please Help...

    I have a form with a macro button that opens a query and inputs the project name from the form into the project name of the query (as a linked field).That Works Now I need to: 1.)save that newly created query as a "user" named query ie. need to prompt for user to input new query...
See more

Part and Inventory Search

Back
Top