Search results

Hello: I have a database in which I keep track of associates. One of the fields is for their business position (i.e., buyer). This field is a combo box. I ‘ve created a form so that when add new associates, I can click on the down arrow at the Business Position field and select one of the...

Hello pbaldy: Can you tell me what the code would be? This has become more involved than I thought. Teach me once and I'll always remember!

Hi pbaldy: I don't quite understand what you mean by changing the setting. Do you mean change "limittolist" from No to Yes? I tried that and nothing happens. Is there an Event Procedure I need to enter? P.S.: I kind of new to Access and am using 2003

Hello: I've created a form for training employees, and I have a combo box for job positions (that way we won't get spelling errors). So far, I have 2 positions listed: Buyers, and Assistant Buyers. That is all that will be required for this workshop. However, there could be a strong possibility...

I am keying in data based on evaluations submitted by participants from a workshop. I'm keeping a tally going as to the number of participants respond to each question. I'm not having problems with that in the report... I have keyed in 30 participants evaluations, and when I run the report, I...

:) It works! This is absolutely wonderful! It's doing exactly what I want it to do. Thank you so much!

:eek: I have this really neat database of projects that my department has completed, and now I want to make it very user-friendly so that anyone in the department can use it. I have a switchboard that lists the different "business channels" in the company (if you click on any one of the bus...

I have a database that captures all the documents we create for training purposes. I've created queries so that reports can be run off by business channels (and it's all nice and neat on a switchboard - click the business channel you want, and there's the report of all documents for that...

Mark, unfortunately, because the document is the same in both project, it didn't make sense to have 2 different stock numbers for the same document (let's not confuse more people than we have to). How do you change the rules to allow duplicates? Thank you.

I have a database that controls what projects we are working on and what documents are tied up to that particular project. Each document has a 5-digit stock number for ordering (a number for English, and a number for French). These numbers are unique to each document (no duplicates allowed)...

I am using Access '97. I'm working on a new database based on Projects we do in the office. I have created a form that the managers fill out with the basic information regarding that particular project. Now, there are times when they don't have all the information on hand at once to key it...

Combo Box listing still not working Chewy: I am confused. I've tried your solution, but nothing is working. Here is what I have done, whereas: combo18 = the field Stocknumberlisting = the database that contains all the data Programs = the table that has the information for combo18 Is there...

I'm almost finished with my database in Access 97, but for one little problem. I have a combo list box that will require additions to it. Instead of going back to the table that controls that combo box, I want to be able to type the new information into the field and have it automatically...

Elana, I took your advice and read those 2 articles from the MS Knowledge Base. I ran the sample database to see what these macros do - it's exactly what I wanted. I applied the principles to my database in the English and French fields ... AND IT WORKS!!!!!! Thank you so much to pointing me...

Elana, Thank you for your assistance. The suggestions you made were most helpful regarding entry validation. However, that was not quite what I was looking for. The Primary Key, ENGLISH, is set to Index: Yes (no duplicates) There will always be an entry (stock number) in this field, because...

I want to prevent users from keying in duplicate values in 2 fields in an Access 97 database that holds stock numbers used in our department's printed materials (numbers are used for others to order the materials). As our materials are printed in English and French, the fields are called...