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...

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...

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...

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.

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...

Hello everyone. I have a query which pulls a field that has a data type set to "Yes/No". I have set the following parameter in the query design: Like [ELIGIBLE FOR REHIRE/YES OR NO] & "*" I want to be able to pull yes, no or all. Does anyone know why this would not work...

Hello everyone. I created a parameter in a query which allows me to ask for a particular date range each time I run a query. I used the following: "Between [TYPE IN BEGINNING INS ELIG DATE] And [TYPE IN ENDING INS ELIG DATE]" How can I leave this prompt, but pull all dates when I run...

Hello Everyone. I have a query which displays records with ID's ranging from 01 to 300. When I use the following prompt: > [type in beginning ID]and<[type in ending ID], and I type in 01 and 2000, I only get records in the 100 range. I understand the SQL structure is reading 1 is less than 2...

Hello everyone. I have added an &quot;EditDate&quot; field to a table. I want this field to automatically update to today's date if anyone edits the record.I have the default set to, =date(), but it doesn't change if I edit the record. Any ideas? Thank you for your time and help.

Hello everyone. I have a combo box that sorts by last name. If I have three &quot;Smiths&quot;, and I choose the second &quot;Smith&quot; on the list, it still displays the first &quot;Smith&quot; on the list. How can I get it to display the record for the actual &quot;Smith&quot; chosen on...

Hello everyone. I have a subform that displays many records. I need the cursor to automatically go to a new record on the subform. I can not use the data entry property because I need all records to show. Any ideas on how to accomplish this? I appreciate your time and help. Have a great day.

I have a form that displays records from a union query. I added a subform to show addition records from another table. When I create my combo box to &quot;Locate a record based on value in combo box&quot; it will let me pull over the field names that I want to show in the list. But, when I...

On a form,I have a record showing ID, firstname and lastname. I created a combo box to find a record based on the last name. The problem is that we may have three &quot;Smiths&quot;. The drop down box will show all three &quot;Smiths&quot;, but the first &quot;Smith&quot; record is displayed...

I have a report where I need each company to show on separate pages. So, I put the break in the footer of companyname group. It is also important to put the companyname field in the group header because if the company information is two pages long, the correct company needs to show with this...

I am networking for the first time. I will have four people using the same database. I understand the importance of having primary keys in all tables, but is this enough to have a true multi-user database? Do I need to split the database in-order for them to use the table at the same time? I...

I linked a table from an access database to a blank access database. The table shows with the link icon, but when I double click on it, it will not open. Any sugguestion? Is there anything special you should do before linking a table? Thank you!