Search results

Here is my code, as you can I see I am sending a query form to send to a list of email address. These are selected via a tbale of addies. what I would like to do is chnage the code, so not only does it attachment the report but also opens up a browser window so users can add additional...

I have created a report based ion a query based in atable using the inbuilt tools for MS access I went for the email report and send to file options. the code looks like this:- Private Sub Mail_Report_Click() On Error GoTo Err_Mail_Report_Click Dim stDocName As String stDocName = "Data...

OHYR10/1: IIf([ohyr1/1]+[ohyr2/1]+[ohyr3/1]+[ohyr4/1]+[ohyr5/1]+[ohyr6/1]+[ohyr7/1]+[ohyr8/1]+[ohyr9/1]>=1,0,IIf([fh10] Between [yr1engoh] And [yr2engoh],1,0))*[TotalACCperaircraft] the OHYR1/1, OHYR2/1 etc are expression results within the same query It works up to...

I am trying to write a query( design view), I need to count how times someone is in a certain mileage range each year, the problem is because the range is large 30K, once the car/person reaches that range they continue to appear . How can I restart the counter for the next 30K, so they only...

I have created a price list based on a customer's request. I now need to mail merge this list. how do i do this and how do i get around sometimes having a shorter or longer list than the mail merge template thanks for your help, couldnt find a "MS Word " forum

I have two Queries, 1.A make table query which uses "user input" as a parameter filter. 2.I then want to save the table as user input "customer A" 3 Then used the saved table as "customer A" 4. Then uses this newly created table in another query I want to save the first make table with the...

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to...

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to...

Hi , I have the query written and produces the correct results , however I would like to limit the results to two decimal places. It wont allow me to change this in field properties. The seond expression which is $ value does have the options in field properties to limit decimal places...

Oh people, I have been given the task ( aint I the lucky one) of creating a scheduling database based on current WIP ( held on a table in excel) and qty held in another table. The task is generate a report which wil take in to account the current wip add the expected deliveries (quantity) and...

I have created database but I now have 3 questions. I havce changed a subform to view as a pivot chart but I am unable to split and group in a similiar waay as in excel, is this just something I have to accept because otherwise my "lets have a works database" theory is shot. 2nd I would like to...

I have created database but I now have 2 questions. I havce changed a subform to view as a pivot chart but I am unable to split and group in a similiar waay as in excel, is this just something I have to accept because otherwise my "lets have a works database" theory is shot. 2nd I would like to...