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: *

  • Users: MAPetry
  • Content: Threads
  • Order by date
  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?

    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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. 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...
  14. MAPetry

    Merge to Word HELP!!!

    I have an Access 97 file that I am trying to link to Word 97. So the user can hit a button in access form that will open Word and merge current record data. Then the user can save and print the merged document. I have approx 35 fields that will be linked. I have downloaded numerous code...
  15. MAPetry

    Populate Text Box

    I have a subform that lists various selected companies, contacts, and phone numbers. I want to automatically populate the phone box (Text)with the phone number of the company. I am doing the exact same thing with the contact and have no problems because it is a combo box and I have written code...
  16. MAPetry

    Database File Size

    I have a database that was approx 5M. then in one day increased to over 8 meg with no real data increase. now it is up to 13M. I went in a erased some tables and queries in a backup but that made no change in file size. Is this common with access or is there some was to refresh file size...
  17. MAPetry

    Allocation table in a subform

    I have a set of records that I want the user to be able to select from and store in a query. I would like to do this in an allocation table format. has anyone done this before if so How? Or is there a shareware wizard that can help in the process? Thanks, MAP
  18. MAPetry

    Print Command Button to Another Printer

    I have two print command buttons on a form. One prints to default printer the other needs to print to a different printer. Is there a line of code I can add to tell it where to print?
  19. MAPetry

    Print a filtered report

    How do I filter a report to only print current record? I have a form that I want to print info for the current record on screen. I know to add a command buttom but need direction on code on how to limit report to the current record. Thanks, Mary Ann
  20. MAPetry

    Populating Text Box

    I have a form for a fax cover table. The user types in the company name and populates the contact and fax number fields with data for the company. Only problem I get the contact part to work but for some reason can not get the fax field to populate. Contact info is in a companycontacts table...

Part and Inventory Search

Back
Top