Search results

  1. L

    Snapshot Viewer Download

    I'm looking for a URL to direct a customer to download the Snapshot Viewer...i checked past posts and they all directed me to the microsoft site...which doesn't have it as a download anymore...if anyone knows a place to get this it would be greatly appreciated Thanks!!!
  2. L

    Comparing Times

    Hi there...i am having trouble comparing time values in a query...the values are given from different subforms ... i am trying to make an "assigning" function form for referees...so i need to make sure that only referees that are available for a particular game appear on my selection form....i...
  3. L

    Group Sorting

    hi there... i am formulating a report that needs to sorted based on each record's "Status"... the status can be either "R", "Y", or "G"...i have "Status" as a grouping category, but the problem is that I need it to go R, Y, then G...which is not in any alphabetical order...is there a way with...
  4. L

    Listing All Records Between Two Dates

    I am supposed to make a report based on a query that lists all records found between two dates...here is the problem though...one value is supposed to be inputted by the user (this date is the week ending date) the second date is supposed to be the first day of the week.... I need to know if...
  5. L

    Command Button for SubForm

    Hi All, I have a form with two subforms on it....when the main form activates I would like a command button that "adds a record" to execute automatically... the name of my main form is: frmmainfrm the name of my subform is: frmreleasesubform the name of my command button is: cmdaddrecord is...
  6. L

    Exitting a Command Button's Sub Routine

    Hey there...I have a form with several command buttons to perform various record functions...i am trying to structure a Public Sub Routine that checks the form's controls for null values and exits the command button's routine if there are any null values....I'm just wondering if this is possible...
  7. L

    Populating Second Form Based on First

    Hi there...I need to produce an application that allows users to enter in a project number on one form, then click a button to bring up a second, different form that contains additional information corresponding with the project number entered on the first form...they are both based on the same...
  8. L

    Getting Data From Query

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

    Variables in SQL?

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

    Automating Several Mail Merges

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

    Button To Create Several Mail Merges

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

    Insert Into Word

    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 =...
  13. L

    Inserting into Microsoft Word

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

    Report Trigger

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

    Help a Newbie Out

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