Recent content by dwrpsych128

I am trying to create a form that allows the user to select a detective and multiple case statuses (such active, inactive, dna, filing, etc.). The form is intended to allow the user to determine the number of assigned cases. The form is tied to a query and the criteria that I've set up in the...

So I work with pivot tables all of the time but I believe I came across an issue today that I am not sure how to deal with. So my boss loves my use of pivot tables in determining case clearings for each of the detectives in the division. I recently showed him that when he double clicks a given...

Thanks for your reply. What I am trying to do is streamline my data extraction and automate as much as possible. I created a macro in Access 2010 that runs several queries by property crime type (burgs, mvts, vehicle break ins) based on the previous 3, 7, 14, and 30 days and exports the output...

I have a macro in Access 2010 that I created and now would like to run it automatically. I would like it to run when I open Outlook and press a button to execute. I have to tried to research a way of doing this but havent had much luck. How would I set this up? Also, would it be better to run...

Good afternoon everyone, Please bear with me as I a new to macro writing. I'm using Access 2010 macro builder and I cant understand why when I run my macro I get an error box that says: "Microsoft Access Cannot find the name Queries you entered in the expression." I tried running it without...

So I figured out that when I removed the record source field in the Form Design View the form worked like a charm!! I guess the various fields that I queried were already pointing to go to the form. The form is only being used to search info, not make any modifications to the database. Although...

Ok so I do I go about fixing it. It's so intermitent. It was just working and now doesnt?????

I've been racking my brains on this and I cant seem to understand why Form appears to be fine in Design View but when I click over to Form View none of the fields appear. My Form's Record Source is to a query that I have set up. Below is the SQL. I'm trying to provide this Form to be able to...

I have a form that has the following fields: Ticket Date From, Ticket Date To, Pawnshop, Property Category, Item Description, Make, and Serial Number. The purpose of this form is to allow an unexperienced user of Access to query a database. Thus far, when I specify the query to include dates...

I have a form that has the following fields: Ticket Date From, Ticket Date To, Pawnshop, Property Category, Item Description, Make, and Serial Number. The purpose of this form is to allow an unexperienced user of Access to query a database. Thus far, when I specify the query to include dates...

Greetings, My name is David. I would say that I definitely stronger in excel than access, but I would consider myself an intermediate user of access who is very willing to learn from others here. I live in Denver, CO and very much enjoy the outdoors. David