Search results for query: *

I have a table with 2 primary keys: Unit and Type Each record has a field called allocation(number) What I would like to do is find the total "allocation" for each type in a query. Another way of putting this is I would like to know my total number of items from all the units combined broken...

I would like to know if I can copy one record (the currently displayed one) from one table (the table the form is based off of) to another table using a form button. I've been searching but all I've found is how to move all the records at once. Anyone know how to do this? Thanks.

I don't know if I can explain this properly but here goes. I have three tables. Personnel(ServiceNumber[primary key], Name, Initials, etc...) Operations(OperationName) DeployedPersonnel(ServiceNumber[foreign key], OperationName[foreign key], start date, end date) DeployedPersonnel as you can...

Hi I have a table field that uses a lookup combo box. The values are: "green", "yellow" and "red". Is there any way I could make the background or names actually appear those colours as well? Thanks.

The users of my database are going to edit/add/delete records in the database using forms. The problem is when they open a form the first record appears in the field boxes and they begin to edit that record thinking they are actually adding a new record. I have a button that clears the...

I have a form that displays personnel data with the start and end dates of their work term. What I would like to do is notify someone who accesses the form if the end date on any of the records is the current or past date via a pop up or something to that effect. How would I do this? Thanks.

I am trying to export a report into excel but my field that have yes/no datatypes do not appear in the spreadsheet. Any way to make this work? Thanks!

First off I'm a beginner Access user but I'll try to explain what I want to do as best as I can. I am creating a inventory database where each sub unit (number based, 741 744 and 748) can update a main table with what inventory they have. This is done through a form where each unit is...

Hi, sorry I'm not very well versed in Access but here goes. I am running Access 2000 sp-3 and I made a whole bunch of reports using the wizard. 4 are made from single tables and 4 are made with queries that narrow down those single tables. Now, when I go into access and try to click and...