| Thread | Last Post | Replies |
|
| How do I combine access templates that are offered on the "office. | 07 Apr 2005 23:50 GMT | 1 |
I am trying to create a database for my wife for Mary Kay. I need to be able to input product info, customer info, and use those databases to create orders. I have been to the "office" website under templates and it appears that a combination of the templates offered would work ...
|
| Problem with a linked table | 07 Apr 2005 23:13 GMT | 1 |
I've got a form based on a table in my application, and I have a command button that does some processing after filling in the fields for a record. When the button is clicked, I first call Me.Refresh to ensure that the record is saved. My command button procedure then calls a ...
|
| Finding a percent in a pivot table | 07 Apr 2005 18:49 GMT | 1 |
I have multiple queries that have data which was accumulated. I was able to calculate the totals of each field at the bottom. However I now need to find percent. When a person selects "no", it enters a 1 in the box, and totals the number of "no" answers. Now I need the ...
|
| wHY DO ALL MY NUMBER FIELDS KEEP ROUNDING IN ACCESS | 07 Apr 2005 18:13 GMT | 2 |
I just started using access created table with number fields. Set the number fields to long integer, fixed 2 decimal places. Everytime I put a number in it round up or down and I see XXX.00 in the table. How do I turn this automatic rounding off
|
| query question | 07 Apr 2005 18:10 GMT | 2 |
I am looking to have my query to pull info from a table and not to return any duplicate values. In my table I have a date column and I want to populate (from this query) a combo on a form with just one listing of each date in table.
|
| Help in clearing table contents no "tools" in toolbar | 07 Apr 2005 17:35 GMT | 1 |
I have a MS Office 2000 Access program that I would like to clear the data out of. The problem is that I did not write the program and it has data (approx 2500) records that I would like to at-least delete for Privacy Act reasons. There is no reason to give this program to ...
|
| Restructure lots of fields | 07 Apr 2005 13:45 GMT | 2 |
I have a collection of qualitative information on a large number of investment funds. For each fund there is a manager (lots of related details); dealing terms (lots of related details); firm (lots of related details) etc My fund table has the following fields
|
| Trace table links in Access 2000 | 07 Apr 2005 06:11 GMT | 2 |
I have inherited a database which is split and containes linked tables. I need to obtain the file path to the linked tables to source the backend data tables.
|
| One table or two? | 07 Apr 2005 06:03 GMT | 2 |
I'm designing an employee evaluation program. Most of the items being evaluated at rated as either Satisfactory or Unsatisfactory (e.g. Employee is punctual), but a few are free comments (e.g. Areas for improvement). Should I keep one tblRatings and have an unused boolean or ...
|
| Need help with expression for Table | 07 Apr 2005 00:55 GMT | 1 |
I want to have Access add the next number in a sequence to the Next Record automatically. My format is D-2467 and I want Access to add the next number which is D-2468? Can anyone help me do this? Thanks. Your help is appreciated.
|
| Site info Table Design | 07 Apr 2005 00:53 GMT | 1 |
I am a coordinator for the local AARP tax aide program. I want to create database for the local sites that I run. Site table. How can I construct the Site Info Table so I can add it to the volunteer info form and be able to select multiple sites and the different
|
| How do I link tables, or queries | 06 Apr 2005 23:33 GMT | 2 |
I need to link tables, or queries so that an existing table which contains names, and address information can be linked to another table where information about that employee is entered. This way the information on the second table is linked to the appropriate person's name. ...
|
| 3NF & Table Relationships | 06 Apr 2005 23:29 GMT | 2 |
Help me, please! I am putting together an automated Time Card Entry Database based on a timesheet and other reports already existed in Excel. I have the following fields on this form as follows: 1. Week Ending: automatically populates with "mm/dd/yyyy" date format from
|
| How do I use a list box to open a report based on a single record | 06 Apr 2005 19:37 GMT | 1 |
I've created a form (as a menu) and on this form there is a button. When I press this button it opens a list box. The list box is based on a query which has selected customer id, first and last names from my database. I also have a report which will provide me with specific ...
|
| Multiple subgroup entries for one person | 06 Apr 2005 18:07 GMT | 1 |
I have a table with peoples names, and multiple questions to be filled out by a supervisor. If this is to be done 4 times a year, can I have sub groups for each person so that I don't need to have all 4 sets of questions in one row?
|