Search results

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

Ok, I think i figured out the calculations in my form. However, when I go to export data to excel the fields all say expr 1, expr 2, expr 3 etc... These fields all had names. I think there is some miss communication between my table and queries but I am afraid if I mess with it I will make it...

Hey! Ok everyone I need some help! I have been working on the same project for several days now. I must have done something because everything now has a table1. before the name. This is messing everything up, my calculations arent working anymore! I dont know what I did!!

Thanks everyone! I think I figured it out! Just took some playing around with!

Im not sure if i am understanding what you are saying. I am trying to not view it like a table in the form. I want to view it how it is in Excel. Or somehow embed a link to the Excel sheet in my Form.

Hello, I am trying to take data from an Excel sheet and post in the form, The Data in the Excel sheet preforms automatic calculations based on criteria on the additional pages in the Excel Doc. All I want to do is move the Excel doc to my Access form, and have it still preform the...