Search results for query: *

The Drawing toolbar worked great. Thanks!

Below one of the questions on the form are several lines on which the user can type a response. However, since the lines were entered with the underline key (_) the lines move over when the users type their response. If they format the text to be underlined, the line created by the underline...

I'm working on a database for a hair salon. On the data entry subform I would like to be able to select a service from a combo box (pulled from tblServices) and then have the corresponding price automatically appear in txtPrice on the form. I originally set the control source for txtPrice to...

...in the OnClick event of a button on the frmSelectGroup. Make sure the options in the drop-down list of the combo box on frmSelectGroup are spelled *exactly* the same as the field names in the table. --------------------------------- stDocName = "rptContactGroups&quot...

I have an Access 2003 database with a table and a form containing contact information and 20 Yes/No fields. The names are tblMaster and frmMaster. The check boxes represent up to 20 different groups that the contacts can be a member of. I've created another form (frmSelectGroup) which allows...

I want the form to display course info and instructors from past semesters as well as the current semester. Only courses that are currently being offered should appear in the combo box's drop down list. When the user is assigning instructors to classes for upcoming semesters, they may select a...

I am creating a database for use in an educational institution. One form (frmCourseInfo) contains fields for the user to enter the following: course description, course abbreviation, course number, and if the course is still being offered. The last field is a check box called...

Is there a maximum number of pages that can be exported from Access 2002 to a Snapshot file? How much memory is required to export large reports? I'm trying to export several reports into snapshot files. The smaller reports seem to work ok, but the 12-page report crashes every time. Sometimes I...

I have an Access 2002 database with user-level security that is split into a front end and back end. When I'm logged into the network as administrator, everything works great. When I'm logged into the network as a user, I get different messages. If I try to log into the database using a...

...calculate the actual check amount. I originally created the adjustment field in the subform as an unbound text box, but when I enter a value for one investor, the amount is distributed to *all* of the investors. How can I get the subform to let me enter different adjustment amounts for each...

Thanks for the great help!

I am creating an Access XP database for oil well royalties. Each of the wells has 3-5 working interest investors, each with equal percent ownership of the royalties. When the royalty check is distributed, the payment amount does not always come out perfectly equal. For example...

...of deleting the extra rows, but I don't know how to make it loop through a certain set of events. I need it to check the active cell to see if it contains text. If it does, then it needs to do the following: *Move down one row *Delete 7 rows *Move down 5 rows *Delete 10 rows Thanks in advance!

One more question, when I use the /user switch as suggested in the Microsoft article, the login screen comes up with the cursor blinking in the password text box instead of the user name text box. Is there a way to make the cursor first appear in the user name box instead?

The user switch works great. Thanks!

I've set up user-level security on an Access XP database. Is there a way to "clear out" the name box on the logon form so the name of the last person who logged in is not displayed when the database is opened? Thanks.

My Access XP database contains several reports. For each report the user needs to be prompted to enter a beginning and ending date which are used to select records from the database. I've created a form and query which work w/ a single report. Is there a way to use this same form to allow...

I have a database that uses several combo boxes which allow the users to select an item from the combo box list. The list entries are stored in a separate "lookup" table. If a desired entry is not in the list, the Not In List event is used to allow the users to add the new entry to...

...in the "Link" box. The original db size w/ no pics is 1 MB but it increased to 3.8 MB after adding online one image. How do I create a *link* to the images instead of embedding them? For each image the user needs to be able to click a command button on the form, then browse his...

I'm creating a database of house properties and would like to display up to six images per property in the database (Access 2002). The images for each property will be stored in separate folders inside C:\Properties. I would like to use a command button to allow the users to browse through the...