Search results

Hey guys, I got a pretty simple one I think... I'm using Access 2007 designing a 2000 DB. I am creating a simple service order db for a client. I have the following: SERVICE_LOG - Table ORDER_QUERY - Query SERVICE_ORDER - Report I'm currently trying to figure out a way to create a macro...

Okay, I'm sure this is an easy fix. I just can't figure out how to do it. I have a Job Log database that I created a couple years ago. I have recently been asked to make a few changes to it. We use this to calculate how much time each employee has spent on a job, as a job log, and also as a...

I am having some trouble with user security. When I initially set up security on a database, it automatically assigned user pin numbers but now when I try to add a new user, it is asking for pin numbers. Is there some way to create pin numbers using the same convention that Access uses? or is...

Now I realize that this isn't necessarily what the reporting in Access was designed for, but in order to make it more user friendly, I have been asked to design a letter through report rather than to use the mail merge function in Word, which upon printing will update that it has been printed...

I'm not sure if this is possible in Access, but I was wondering if there is a way to automatically run an Update query when a report is printed. More specifically, I have confirmation reports, and I want the date printed and confirmation sent fields to be updated upon printing. I have an...

Okay, so I don't know if this is possible, or what I must do if it is. Here is what I am trying to do. I run a database which tracks student registration at camp. One of the things we do is assign students to certain cabins. These cabins each have a limited capacity. So, in one table, I...