Recent content by ashows

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

Since each contact could be a member of more than one group (i.e., more than one Yes/No box could be checked), I used the following code 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*...

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

I'm working on a database for oil well check disbursements. The table tblOwners stores the investor names and their investment interest percent for each oil well. When a royalty check is to be disbursed, the appropriate lease is selected and the total check amount [CheckAmt] is entered by the...

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

I've imported a text file into Excel but I don't need every row of data. I've started on a macro to automate the tasks 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...

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!