Search results

I've been trying very, very hard to get a scheduled task to run a macro that I've created. The macro runs a few queries then exports a report to a pdf on a daily basis. If I double click my vbscript file that I created the reports generate correctly. No prompts come up, no errors, works...

I would like to do some simple error validation on a form of mine. Basically compare two input boxes and if box1 is greater than box2 display an error message then bring the user back to the form so that they can fix it. I just need to exit the function and go back to the form. What am I...

This is a good one, get ready..... The problem: I'm hoping it is possible to print selected pages from a single report pending weather a certain condition is met. The details: The users of my report are being dispatched from 2 locations instead of 1. Both groups need only parts of the...

I am prompting for user input inside of a query like this [Enter a unit number] in the criteria field. This query is being called by a report. I would like to verify that this value is a four digit integer and would like to display an error message and reprompt the user for input if an...

I would like to have a report call a form for input then call the report without calling the form when a button is pressed. Confused yet? It's causing a recursive loop and I can't figure out a solution other than creating a loader report that contains a doCMD that opens the form that calls the...

I would like to display a calendar that allows users to select a start and end date and then filter a query based on the selected date range. I'm having a difficult time understanding how a form can be used to collect data, then pass that data to a query, then generate a report. Idealy the end...

Does anyone know if it is possible to return the values that are what a user inputs in [Enter Start Date] and [Enter End Date] in the results of the query? I would like to have the start date and end dates to be returned so that I could use them to filter other joined queries. Thanks in...

I have an access database that stores a truck number, mileage, and time stamp of log on and off times. I would like to be able to create a report that displays the total miles driven per month for all units. My first attempt grabbed the maximum and the minimum mileage values and then...

I've ran into a little dilemma when I attempt to use the MIN and MAX features from the Total: option in the design view of access. My data is and must stay stored as a string, however the string contains only numbers between 1 and 1,000,000. I'm attempting to return the correct minimum and...

I'm attempting to return the total number of rows in a query for a year(month >="200801" And <="200812"). Then I'm hoping to return the amount of rows that only meet a certain criteria like month >="200801" And <="200802". I'm using access and have been using the design view thus far. I don't...

I have an access database setup with usernames and zipcodes. I'm attempting to only return zipcodes with 2 or more unique usernames in them. I am not wanting to return the zipcodes with duplicates of only a single username. What is the easiest way to acomplish this? Thanks in advance, BRUMSHINE