Search results

PersonalHoursSummary_OptionsForm is the form which is supposed to have the options on it with the inactive checkbox.

I don't actually know if this should go in forms or queries or reports. I have a query by form that I am creating. One of the criteria I would like to include is whether or not the consumer is still active. I have this in the original data using a checkbox. I would like to have it that if in...

MSAccessRookie, I'm not certain how I would go about defining this. I know how to write a basic if function, which it essentially sounds like you're asking me to do with two variables. Essentially, it sounds like I would say (in plain[ish] english) between startdate and enddate where...

I'm creating a sum query to base my report off of and I am allowing the user to enter the dates it would like the query to run between using the following syntax in the criteria: Between [Enter Start Date:] and [Enter End Date:]. I would like the user to be able to leave the field blank...

Wow....umm..I feel very silly. I expanded the columns and that fixed the problem. Thank you very much pat.

I have a report that sums up the hours my volunteers have volunteered (per person) and gives me this, their ID No. and a couple other things (name, etc.). Everything looks great in the query I have, but the moment I try to create a report, all of the numbers go weird. The autonumbers don't fit...

Thank you all so much. This information was *very* helpful. :)

And thank for the tip for reducing the # of queries. I've done that before, but it just didn't occur to me this time. :) What is the distinct keyword?

Okay, I apologize because I know this question is probably overworked and I searched the forums for something along these lines, but I apparently haven't been able to find the right search criteria to find the posts on it. I am trying to have a parameter prompt in a query where the user enters...

I am working on a database which due to its complexity (and/or my lack of knowledge of access) has four queries based on two seperate tables. The first table is full of customer data and the second is transaction data linked to the customer data by the customer id no. The queries are as...

I am creating a database to manage the volunteers in my company have worked. I have two databases, one is their volunteer information. The other database is an "HoursDatabase" where I can input the volunteer's ID number, the date, start time, and end time of each time a volunteer has been...

I don't understand. Where do I input this information? I haven't worked a lot with filtering data.

I'm uncertain how to continue, or if it is even possible. I know the forums are generally for more specific questions, but I'm really hoping someone can point me in the right direction here. I've tried searching and help and a couple books, but I still don't know how to proceed. I have two...

I totally forgot about zip files. Silly me. Here is the sample database. I keep receiving runtime error 13 type mismatch

Okay, I don't know if there's a better way to do this. If so please explain how, but otherwise, I need to fix my ?coding? I think? I'm creating this database to track my volunteers' information and to track their hours. I have this set up as two seperate, but intertwined databases. One database...

Thank you Ken

I'm not 100% certain this is a "forms" question; it may simply be a general question. How do I get access to automatically pull up a form when I open the access file? I have volunteers entering data into the form and not all of them are very...computer savvy, so I was trying to reduce the...

Wow...I feel quite ridiculous for not seeing that. Thank you so much for all your help.

My database is the one called Volunteer Database. The database I am using to model my search after is attached as well, search2. My form is not a subform, but maybe it's supposed to be?

Two things: 1. The error message is as follows: Run-time error '2580': The record source 'select * from VolunteerDatabase where LastName LIKE '*adams*" specified on this form or report does not exist. 2. My current coding is as follows: Private Sub cmdSearch_Click() If...