Recent content by bobburg

How do I get a menu like: Data Files, Process, Reports, Utilities in MS Access 2007.

For some reason the font of my drop drop box is to small. Does anyone know how to make the selection in my drop down with a larger font?

A good example I am working with is a Parent Table recording requests from suppliers such as an Request for Tender, Request for Quoute, Request for Proposal or a Request for information. The Primary Key would be the record number for the type of request. The primary table contains data on the...

Just wondering if you came up with a solution. I am also having the same problem you are. Would appreciate if you could let me know if you get a reply that works.

I have very limited knowledge in Access. What do you mean by looping through the controls.

I have a form that has header information and a sub-form that has detail informatiion on quotations. The user is supposed to enter data into both, however I have found some users any enter data in the header and leave the details contained on the sub-form blank. How can I force the user to enter...

Thanks for your reply. I need to do it at the table level. Any idea how that is accomplished?

How do I make a field required but only when another field in the same table has data?

I have a report of employees that are late in their activities. I want to send an e-mail automatically to each employee on the report, weekly, with a msg warning them. Their E-mail address is in the report in a field called EmailAddress. How would I do this? PS: limited knowledge with access.:(

Dave, Scott is right. The autonumber is only a unique identifier. If you want to clean the data base and start from the beginning, delete all the records and go to tools/data base utilities/compact and repair. It will start your auto numbers at 1 again.

Help with 1 form, 1 report and 3 tables. You need to show a releationship between tables. Go to the design of the first table and make the autonumber an indexed field, no duplicates. Go to the second table and make a field called Hotelnum in the design mode. Select indexed, duplicates allowed...

How do you draw in access? Is there a tool bar for this?

I have a form which uses a query for entry to the table. One of the fields in the query is a calculated field which shows in the form. The calculated field returns a number from 1 to 5. Rather than showing this number I would like to show a round stoplight that changes color for each number. I...

I have a single form set in form view. Record Selectors, Nagivation buttons are set to No. Data entry is set to yes. Cycle is set to current record. The problem is I want the user to enter one record at a time and to exit each time. When the form is accessed by using a mouse with a wheel ,by...

They are calculated fields. There are 12 to deal with. one for each month of the year. I tried doing the iif statement backwards and it works except two problems. It looks at the 0's which I don't want and I max out on the IIF statements. I guess I could use mulitiple queries to have the max...