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

    Problem w/FontBold Prop

    I have a report that I want certain field to print bold. I created this yesterday and It worked fine report previewed and printed great. Today someone prints out and all is printing in bold. The preview looks corect. and it prints correct to the ink jet printer. but for some reason(???) it...
  17. MAPetry

    Filter/Save As query

    I have a table with an unbound field I want to use as my filter criteria. I have a query set up with the required fields. What I want to do is either write code (limited experience) or create a macro that will. -- Open the query, save it as a user entered name, then filter the query based on...
  18. MAPetry

    Merge to Word HELP!!!

    In your Word document. Go to INSERT, FIELD, (all), DOCPROPERTY, Options tab at bottom. The custom fields that you added will be there and you can click "add to field". Since I had so many custom fields I put a "*" in front of the fields I entered so they would pop up in...
  19. MAPetry

    Merge to Word HELP!!!

    I GOT IT TO WORK. I am Soooo happy this has been bothering me all weekend What you do is: 1.) create your Word document tamplate 2.) Under File, Properties, Custom, Add the field names you want to link to Access For the type select a choice (text, number, etc.) For the...
  20. MAPetry

    Merge to Word HELP!!!

    I agree with you the second choice. Being unfamiliar with VB I am stumbling my way through. I have set up corresponding field boxes in word and need to link to access but am unsure of which command to use to link. I downloaded some sample code that says to use...

Part and Inventory Search

Back
Top