Search results

  1. V

    Report not pulling correct dates

    SELECT [PROS Cases].CHARGES, [PROS Cases].[DATE FILED], [PROS Cases].STATION, [PROS Cases].[SPECIAL APPROVAL], [PROS Cases].[OPERATION NAME], [PROS Cases].[CRIM HIST 1], [PROS Cases].[CRIM HIST 2], [PROS Cases].[CRIM HIST 3], [PROS Cases].[CRIM HIST 4], [PROS Cases].[Convicted Sex Offender]...
  2. V

    Report not pulling correct dates

    I have my report set up to pull dates from a form, however the query is not pulling the correct number of records since the New Year, for example when someone enters 10/31/2009-12/31/2009 the report returns 100 records, but when 10/31/2009-01/01/2010 only 3 records are pulled. I can't figure...
  3. V

    Using a multiplication function in a form

    I am using the expression builder in the text box properties, instead of writing the VBA code
  4. V

    Using a multiplication function in a form

    I am probably overthinking this, but I am doing a form where about 50% of my entries will need to be converted from grams to pounds for a later report. Right now I am trying to use a unbound text box in the form using [weight] * [.00220462262] on the "on click" command, however when I try to...
  5. V

    Working with Excel and Access

    Yes, the example gave me some direction. Thanks for all your time.
  6. V

    Working with Excel and Access

    This is the way it is being done currently however, I would like for this procedure to be as streamlined as possible. There are multiple users working with the Data, who are not very computer savvy and I work with a rotating staff, the easier it is for them the less calls I get asking how to...
  7. V

    Working with Excel and Access

    I used an access macro, can I use excel to pull the data in?
  8. V

    Working with Excel and Access

    Ok, I need a little help I am not sure on exactly the best route. What I basically need to do is figure out to output a single record query into a single excel worksheet from an Access form. I have an excel workbook that is set up with about 15 worksheets, that pull their information from the...
  9. V

    Exporting single Query result to Excel Worksheet

    I am still learning VBA, and I am having a difficult time trying to figure out the best way to accomplish this. Years ago a workbook called Locator Forms was created in Excel to populate about 12 federal forms. I want to be able to use a Query to pull the neccesary info from an Access...
  10. V

    using command buttons to archive single records

    I know that this has already been presented, however I am really new to using VBA and don't entirely understand the suggestion. I want my users to be able to move a single record from an open table to a closed table, using a command button on a form. Thanks
View older results
Back
Top Bottom