Recent content by rscott1989

Im not too familiar with reports and how they work, but i am willing to try. It would have to look like the one in word. Otherwise I couldnt use it.

Hello. I am trying to take the data that is put into a form or report and export it to a certain document in word. The user will be filling out a Reciept. On the form there will be a to and from box for them to fill out, along with many other options. Once the user enters in all the data...

Hello everyone, I have 3 fields on a form PU_POINTS, SU_POINTS & 2_MILE_RUN_POINTS. The user enters a number 1-100 in each of these fields. If the user enters a number in any of the 3 fields of anything less than 60 then I want it to check a fail box. If the user enters all numbers 60 or...

Sorry i am still learning this. I am not getting an error when i use the conditional formatting, I dont get anything. Thats why i think im just not inputting it correctly is there a way to use VBA insted? (Which im still not too savvy on) something like If expiration date > 90 - start_date...

im using access 2010. Im using it in one of my forms. I am attaching a pic.

I am trying to get my expiration date field to highlight a certain color once the date comes closer. I have weapons qualification dates. The user will input the date he/she qualified and then a expiration date (6 months from that day) automatically pops up. Now what I want to do is once the...

I have tried the Dlookup, I keep getting errors. maybe im not doing it right AvgOfTOTAL is my field name TOTALQRY is my query name Table1 is my table name I want to print the number given in the "AvgOfTOTAL" field in the text box on my form. I appreciate your patience, as i am still quiet...

Ok now how do i move the data from my new query to the display on the form i want it to?

YOU ROCK! Thank you :D

I am trying take all the data from one field "TOTAL" and Average it out and print it in one of my forms. I would also want this data to update automatically as the totals are updated. I am attaching some screen shots of what I am talking about The first pic is the totals field that i want to...

I have a number of charts that correspond to form fields. Once the fields are filled out and the form is saved I want the data automatically to update in the chart. I tried inserting a button to allow the user to manually do it, but it says that it is unavailable. The charts update when i...

Mihail, Thank you! That is a much easier way! Now I am running into another problem. It all works fine, but the values are being defaulted to something weird. I am attaching a screenshot I want all the fields to start out blank Thank you!!

OKay i figured out how to grey the fields out using the check box...... This is the code i used in the on click event, Private Sub Check658_Click() ' M4 If Me.Check658.Value = True Then ' for check1 use your check box name Me.DATE_M4.Enabled = True ' for text1 use your textbox...

Thank you so much! I will remember that if there is a next time! All is working well now :D Thanks again!!!

I do not seem to be doing this right. I tried the way you told me (THANK YOU btw) and now i get an error. Something wrong with the code. I am attaching a screenshot of what i want to do. when a box is checked, all the data in the corresponding field will be available to edit. If a box is...