Search results for query: *

Good evening, lets say I have ten people who have one of three positions. In a table, when I name the position on one field, i want a drop down box in the next field showing just the names that apply for that position. Any ideas on how to accomplish this? I appreciate your time and help.

Good evening. In earlier versions, on a form, you could create a combo box which allows you to search for a record based on the value chosen in the combo box. This option is no longer there in version 2004. Has anyone experienced this? Is there another way to accomplish this task? Thank you...

Thank you for your response. This started after I linked the tables. This is all in preperations to set security. I have three folders in windows. Folder A has the new database with the main table. Folder B has a database that links to the table in the database in folder A. I created the...

Good evening, I have a client that has requested ACL workbook training and I do not know what it is? Can you help? Do you know of a good resource that can help me with the program?

Hello and thank you for your time. I am in sooo much trouble. I have two databases. In the first database I simple store a table of information. I linked this table to the second database where I have created forms and queries for day to day use. I have also created secondary tables on the...

Wow! These are wonderful instructions. Thank you so much for taking the time to spell it out for me. I need all the help I can get. One more question. Is it true that security is set to the application and not the database? If I set up a situation to practice with on my computer before...

Good evening everyone. I have set up my accounts with two users by going to accounts, highlighting users in the group window and clicking on new user. I went to permissions and set the appropriate permissions on each user. I changed the admin password so it will peompt for passwords. But...

Good evening everyone. I have linked a table into my database from another access database. I related the table to the appropriate tables, but it would not let me enforce referential integrity on the relationship. The area is grey on the window. Is there another way to accomplish this task...

Hello Everyone. I have a table where the need to pull three records from the same table is required in one record. Example: A project record shows the project manager, second in command and worker. All three of these people are employees and pull from the employee table. To get this record...

Thank you! This is perfect! You get a star! Have a great day! I really appreciate your help!

Hello everyone. When you are on a form, if you hit the scroll wheel on your mouse, it will switch the records on the form. Is ther anyway to turn this off just for Access? Thank you for your time and help.

You get a star from me as well! I appreciate your help! Have a great day everyone!

Here is the whole SQL for the query. The prompt is on the "InsEligibilityDate" field. Thank you! SELECT OfficePersonnel.EmployeeID, OfficePersonnel.LastName, OfficePersonnel.FirstName, OfficePersonnel.MiddleInitial, OfficepersonnelInsurance.MedComp...

THANK YOU THANK YOU THANK YOU! This worked great. I really appreciate your help! have a great day!

Thank you for your response. This will communicate to them that they need to add the "/" when entering date. But, they want to be able to enter a date just as you do when you enter a date with an input mask on a table. you do not have to put 00/00/00, you just type 000000 and...

Yeah, you know how companies can be. I gave them two dates to use, but they say there must be a way to leave it blank without having to type in dates. Keep me in mind if you think of anything to help with this issue. Thank you!

You have been great Leigh. It works fine without prompts. If I put yes in criteria it will pull yes. same thing with no. But without using a parameter on this field, i will have to have tree queries to get the needed result at the time. AS of now, I'm going to assume that you can't use...

Again, thank you for your response. When I type in a date range it works fine. But, if I enter through the field and leave the parameters blank, it will not pull any records. Is there anyway to leave the field blank and have it pull all records? Thank you!

Hello everyone. I have the parameter on a date field: Between [TYPE IN BEGINNING INS ELIG DATE] And [TYPE IN ENDING ELIG DATE] When the prompt appears, they are forced to use 00/00/00 or it will not let them continue. Is there a way to set an input mask so they will know how to type in the...

Yes, same problem. I tried true/false, -1/1, yes/no. It still pulls all records. Please let me know if you think of anything else. I really appreciate your response.