Search results for query: *

Hello, I have a question that may be well beyond my abilities with Access, but it never hurts to ask. Here is what I am doing: I would like to have a list be automaticly and randomly distributed among a group ( ie placing the items in their respective initials). The individuals would be...

I was unable to find an answer to this question but perhaps I was not searching with th correct phrasing: I would like each person in my group to have their own Access swithchbord...essentially thier own Access file but I still want them to feed off the same data so any chnages made to data...

I don't know if this is possible or not and if it is, it seems it may be a bit out of my leaugue but here it goes: I have a database in Access 97. Multiple users. It is set up with records on a continuous form and when a person on the team goes in to work on an item, they select their name...

I know this is a simple function but I am not very ACCESS savvy and it has been a while since I have programmed this function. Using '97 I need to set up the code so when I make an update to a certain field, I different field automaticly updates with today's date. Any thoughts!!??

I currently have a rather extensive database that we work off of. What I want to do is to ba able to write notices and post them so they can been seen on the main form. I want the users to be able to see changes everytimr the form refreshes. I can do this with calculated numbers but have been...

In Access 97: Is it possible to create an expandable list such as the ones you see in Windows NT Explorer: + Item One + Item Two + Item Three + Sub 1 + Sub 2 + Sub 3 (Is it called a tree? I can't remeber...my MS DOS days...) Where if i click the plus sign in "Item...

I currently have a few databases that were created with Access 97. We now have one person who has Access 2000 on their system. Since everyone else still uses 97, I do not want to reconfig for 2000. When the user with 2000 cannot open any of the 97 files. What can I do to allow the 2000 user...

I am trying to count the number of times an item is checked in a question with multiple anweres. For example: Record 1: Option 1 - Checked Option 2 - Not checked Record 2: Option 1 - Checked Option 2 - Checked. I want to have the report show: Option 1 = 2 Option 2 = 1 etc. I DO know how to...

I already know how to get text to change based on a value in a field but when I do it, it is doing it to the entire form. For example: When a certain number of days have passed, the formula I have will change the field to Green but when I click on that record it makes that field in all records...

I have a basic report and it has several columns. It has one "status" column based on a list. I am trying to get a report to count the number of each status type that comes up within the report (i.e. Completed = 5, In Process = 3, etc. It is important that it only takes what is the...

I have a report that runs off a form query. The form query is working fine as well as all the componenets but when I run a report to return all record, it will not return records that have blank fields. How do I set up the query or report to make no designation between full records and records...

First I want to thank jaydlewis, Uncle Jack and Rick Sprague. Thanks to you combined assistance I was able to creat a really powerful form query. This question is probably very remedial but I cannot seem to figure out how to fix it. When I created a form, it has multiple fields but when you...

Hi. I am a newbie. I'm not sure if this an easy question or if I have taken an unintended leap into the extreme: What I have is an Access file which consists of only one table. We want to be able to generte reports from this data but we would like to put in perhaps a dialog box that would...