Recent content by jminn0311

I have a table as follows: Date Shift Upgrage1 Upgrade2 1/1/11 Shift1 .50% .75% 1/2/11 Shift2 .25% .85% 1/3/11 Shift3 .95% .35% 1/4/11 Shift4 .65% .45% There is a lot of data in this table and I need to be able to query...

I figured it out with the use of a union query although it took me a while. Thanks for ur comments!

I have two tables in separate databases that I need to retrieve information for a report. The tables are identical in each database but I cannot link them because I only need the information to show up on the report and not any forms that are available to the users. How can I accomplish this...

Thanks for the reply. Your advise is appreciated! I used something a little different to format it. =Format(DMax("DateOfIncident","qryIncidentInvestigationReport"),"yyyy")

Can anyone help me with some coding for a textbox in the header of my report that would return the maxdate of the records from the query on which the report is generated? Sorry about the run on sentence! Thank you.

I have a simple popup form used to select the year to query a report. The problem arises when other desktops try to access this form from the control button. The form will not show for them but works fine from my desktop. Is there some sort of user level security on forms that i need to disable...

I have a form that is emailed to management detailing my days activities. I wrote some code so data is pulled from the form and written to the body of the email so opening the file is not required. I also have a chart that I would like to insert into the body of the email, but the coding...

Thank you!!

I just need the data from the last seven days it was entered irregardless of todays date.

I am querying a table and need the last seven days records. The problem is over the weekend data is not entered so I only get 5 or six records from my query. I need some sql to pull the last seven records even though it is not todays date -7. SELECT tblPlantFeed.Date, [ep]/120000 AS C2...

Does anyone have an idea on how to export a chart into an email and let it show up embedded into the body of the email? I have figured out how to do it as an attachment but no luck with the embedded part. Thanks Jeff M.

Does anyone have some simple coding for a command button that will show records that start with a particular letter. I have a table with a productname field and I want to show only the records that start with the letter "A" in the product field, on the form. I know this is simple but not for...

I have a spreadsheet that I need to calculate the averages for cells that have no specific pattern. I manually change the background of the cells that need to be averaged and was wondering if there was an easy way to do this. Something like =averageif background=red or =averageif...

The code for the calculate button is as follows. The two other textbox controls are calculated in an after event sub. Thanks for all your help on this. Private Sub Command50_Click() Dim lbs_gal As Double Select Case Me.PRODUCT Case "RP" lbs_gal = 0.498 * 8.3385 Case "C3"...

I had tried that already but it won't update the textbox when the calculate button is pressed. If you select a new record for the form then the textbox updates to the new value.