Search results

Hi, I need to add a section in a page footer for a report that tallies up values from a field in the query that the report is based on...I will try and describe it as best I can.... The query has a field that looks like this Hours Weight: IIf([Actual Hours]<41,"Low",IIf([Actual...

Hey there...I have written an SQL statement in Access '97 in order to decide wether a figure is "Low", "Med", or "High"...Now I need to set up a way to display the number of Lows, Meds, and Highs...I am not sure of wether you can declare variables in sql or how to go about doing this...the...

Hi there...I was wondering if anyone would be able to help me out to automate two mail merges at one time...I have a Microsoft Access form that opens all the needed documents...when those documents load, I would like the mail merges to be processed so that the user doen't have to do it...i was...

hey there...I need to create a button that when clicked, will update two different word documents through the use of a mail merge using the same data from the form...I was just wondering what kind of coding would be involved in order to process the mail merge and have the two updated documents...

Hi...I am new to Microsoft Access...I am currently trying to use a button on a form to insert text into an already existing Word Document...here is the code i am using so far to access the document... Private Sub Command0_Click() Dim objWord As Object Set objWord = Nothing Set objWord =...

Hey what's up...I have a random question...is it possible to take data from a database and insert it into a specific part of a Word Document that serves as a template...i am working with forms where information is very redundant...but the kicker is that I cannot change the form templates or make...

I was wondering if it is possible to set some sort of trigger so that everytime a new record is added to the database, a report is made and printed out ... i am new to access and any help would be shaweet

THanks SHAWEET Thanks!!! :p

hey what's up...i've been using access for almost a week now...i am trying to create a query that will return just the information associated with the record with the highest "Item #"...just wondering how to do this...i'm not sure if i gave enough information but like i said i am new to...