Search results for query: *

I have a spreadsheet in which I keep track of student's performances in several evaluation points. Row 1 of the spreadsheet is dates (beginning with column C), column A of all subsequent rows describes the evaluation point. The remaining cells in the worksheet is where I enter values (1...

I am trying to vary the verticle alignment of text on the same page of a Word 2002 document. I have attempted to do this by inserting continuous breaks at the end of each section and then setting the verticle alignment on the page setup tab to the appropriate alignment. However, it doesn't...

I have a command button on a form (form1) whose OnClick event is to launch another form (form2) for the user to enter a parameter for a query. After entering a name in a textbox on form2, clicking a command button on form2 displays a report. In the report header, I have a textbox whose value...

I have a text box on a form which can contain multiple lines of text from the result of a query. I have set the CanGrow property of the text box to Yes which allows the text to wrap as desired. I would like to space the lines of the text a little more from one another. If I set the Line...

I have a subreport which is based on a query. This query has a "calculated" field which is as follows: Readdress: [Street]&" "&[City]&", "&[State]&" "&[Zip] The Street, City, State, and Zip fields are within the same query. This combines the above...

I have a query which returns a date in the format of mm/dd/yyy. I would like to return the name of the month associated with this returned value. In other words, if the returned value is 01/13/2004, I would like another field to return "January". I've been able to create a field...

My goal for a group header on a report is to have a header for each month of the year based on a date field within the header. Example: January 4th 6th 13th Febuary 5th 23rd ...ect. (Both the date field and the unbound textbox are in the group header, but the date field is...

I have a report which I think I want based on a query. This report displays different classes taught be different instructors. The format of the report that I want is the following: Instructor1 Classinformation1 Classinformation2 Classinformation3 Instructor2...

I have a form1 with a textbox for a name (as well as other textboxes) and a command button which will move the form to a new record. After the textbox is filled out, a query is run to determine if the name exists in the table. If so, a modal form opens up and lists the name in a listbox (this...

Within my db, I run a delete query. Access prompts the user twice for confirmation before deleting the records. I want to turn this confirmation off shortly after the db opens and then turn it back on before the db closes. I know I can do that on individual computers through...

I have a form that users can input instructor information such as first name, last name, address, etc. The first two fields that are entered are the lastname and firstname. After entering data in the firstname field I would like to filter the information based on the two fields to display data...

I have a form with a textbox that stores a phone number. In order to be user friendly, I want to be able to account for the possibility of entering phone numbers with the standard nine numbers (areacode+phonenumber), 1+areacode+phonenumber, 1+areacode+phonenumber+extension, and...

I've been working on opening a form to a specific record from a command button on a previous form. For some reason, after playing around with it for a while, I can't view records from the table that the form is based. Any ideas what I've done? I'd like to fix this so that I can learn as well...

I have a textbox called patientid and a command button on form1. In the onclick command of the command button I open form2 which also ahas a textbox called patientid. Prior to opening form2 a query is run on the table of which form2 is based to see if there is a record equal to the value of...

I have developed a db for my kids that is made up of simple math problems. I would like to display a timer or clock (I don't know which), perhaps in a textbox that shows the time interval between two events (the time elapsed to answer ... say 10 math problems). How can I accomplish this?

I have successfully opened a record set from a table (I think)containing five records. I want to use VBA to set a unique variable equal to each of the five records, and then perform calculations on these variables (such as add two of the variables together, then three, etc.). How do I go about...

I have a simple form with three unbound text boxes named firstnum, secondnum, sumnum. I populate the firstnum and secondnum with random numbers according to the following code. The student is then to enter the sum of the numbers in sumnum. The code for the form is as follows: Private Sub...

I am using Access 2000 and have a database that will eventually be placed on a server. As I copy the database back and forth between my hard drive and the server as I'm working on the DB, I lose the ability to open reports from command buttons on a form. The reports are still there and the VBA...

I have a database that I want to create an MDE file of. When I attempt to do this, I get an error message of Access being unable to create the MDE file. I think it may be due to the fact that I was experimenting with user-level security some time ago and found that I didn't really want to do...

I have a text box on a form that users enter their name as first name followed by last name separated by a space. I want to ensure the first letters of each name are capitalized. I tried to do this with the following input mask: >L<?????????/ >L<???????? This works for names with the above...