Search results for 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...

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

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

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

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

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

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

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

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

...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 anyone recommend a good starter VB book for access. Thanks, Mary Ann Private Sub Create_Fax_Click() On Error GoTo Err_Create_Fax_Click...

Thank You that is exactly what I needed MAP

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

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

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.

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

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

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

...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 the...

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

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