Search results

Hello, I've been researching but haven't found this yet. I'm looking for a way when I click a button, a screenshot or snapshot is taken and saved to a specific file location. Anyone have any thoughts?

Hello, I built a database for tracking absences and tardies that multiple depts use in our company. The request was made to add a department filter, which I am doing and almost done, but i'm running in to a problem. On the opening page, there is a report section that originally had 2 drop...

Hi, I'm running a query that needs to pull dates from another table as its criteria. As in, I have 2 fields in another table: [start] and [end] I go into the query and on the date criteria: "Between [date range]![startdate] And [date range]![enddate] I run this, and it never ends...Access...

Hi, I need some assistance on a form. I have a query that runs against 4 linked tables and pulls the data to a local table. I would like to create a form that shows the last time the table was updated and then a button to update the local table. It should go run the query from the date it...

Hello, I'm running in to some challenges with a query. I'll give you the cliff notes version. I'm trying to compare accuracy from what our vendors say they are sending us to what we actually received. I do a left join from what we received to what they sent and also some inner joins based on...

Hello, I'm creating something that will be used like a report card here at work. The manager will be printing this report out, sitting with his coworkers, and grading them on their duties. I have the form created that captures the data no problem at all. Here is where I am stuck... He wants...

Hello all, I'm creating a sort of "scorecard" for our managers to use when sitting with coworkers reviewing their work. On the form I have a 50 yes/no check marks (10 calls, each call has 5 check boxes). I am looking for a way to get percentages based on how many calls were graded. I tried...

Hello all, We are working on a new database that is to serve as a project tracker. We are having some difficulties and were hoping someone here could assist. This may be tough to follow so I’ll try to explain the best I can. Projects will be entered in to a form that has 3 sections. The...

I have a table that has two columns. Name and date. I need to have the query pull all of the dates in the past year and report on them. I have completed that part. The other part of this is, I have a counter that just counts how many dates the name has attached. I need to have the query...

Hi- I'm looking for assistance or to find out if it is possible to create a report that when opened first opens a list of names. Once a name is selected, the actual report opens up with that persons criteria. Any ideas?

Hi all- New here, and to an extent new to Access. I spent lots of time in Excel and really think Access can handle this request better based on what I know about it. I know there have been many attendence questions before, but this one is specific to our company. Our company has a policy...