Search results

Let me start by saying, I am not sure if a Report would be my best option here or if a printable Form would be optimal. Anyway, doing a manning database to calculate number of employees versues number of authorized employees (military). I want this to show as a column for percentages ... ie...

I am helping someone re-do their database and they would like the autonumber id to reset each year back to zero; something like yr&cnt (070001). This would need to be saved as the auto-generated id number for that data entry; again resetting automatically each 1 January. The next data entry...

How would I get a report label to print exactly what is in a form dropdown list on an open form? I have my sorting and everything else working perfectly (using hidden triggers), now I simply need the report label to simply show what dropdown list I chose on the form. I cannot use a record...

I noticed that there were several threads about hiding the Access Window and have read through them all... It seems like it would be something that I could use, but I can only get it to "grey out" the access window. It will not allow me to click on anything but the form itself (which is...

How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...

I love all the email post information that is available, but I haven't been able to find exactly what I am looking for... Suppose a customer enters a computer workorder request. Then upon completing the form, your boss wants it to automatically send your office an email "your.office@here.com"...

I have an application supply file database that will pull a single application list of multiple applicants for a certain job and certain office. The problem is this report has to pull data from a single table, but several things are playing out in it. I created a form with the following...

I created a report database that rely's on both default data and user entered data. Unfortunately the default data is going to be different for each office and needs to be easily updated as needed. So I created a "default data table" and named it DefaultData_tbl; and has these field names in...

I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such: The initial is 30 days after supervision started or annual performance report completed The midterm is 120 after supervision started or...

I am working on a report that gets printed once or twice a week. The manager would like this report to print the year and the increment number (for that year) on the report. For instance, when the first one for 2007 is printed the increment number will look something like 2007001 and the...

I created a report that lists names in alphabetical order according to their status. The status choices are MSP, THP, VET, NAF and OTH. These are chosen from a dropdown menu in the form which pulls this list from a status table. In the report I must list them in the order above but without...