Search results for query: *

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

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

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

How can I get the results from a sum field of query to display in a textbox on a form that is linked to a separate table. Thanks in advance. Jeff

How do I get certain textbox's to change backcolor but other to remain the same. I have a report that needs to change the backcolor of textbox's that contain the word "Warning" to red. The problem is it changes all the textbox's backcolor not just the one specified. Does anyone have any ideas...

I have a main form with part of the table's info located on it and another form that pops up under certain conditions. Both forms are linked to the same table. What i need is for the pop up form to be on the same recordset as the main form when it pops up. I know this is a simple question...

I need some help coding a combobox to compare against a query to see if the date of the combobox selection is 365days more than the maxdate of of the same combobox selection in the table. I have the query that produces the maxdate for each episode of the combobox selection. Now I need help...

How can you make a cell's value based on another cell's value. For Example: If cell B1 is "Miami" I want cell A1 to be "MIA". I know how to do this with the IF formula but that only works for 1 condition. The problem is cell B1 might be "Dallas" and then I would want A1 to be "DAL" Thank...

Is it possible to link a normal form(pop up) so it behaves as it where a subform to the master. The main form has a command button that pops up another form with different info pertaining to the main form records. The main for has its own table and the pop up has its own table. There is a one...

I have a subform with a combobox and checkbox. I would like to make the checkbox invisible if there is no value in the combobox. I can't seem to make this work by using the .visible function in the code. I know this is real simple, does anyone have a snippet of code or suggestions on how to...

How do you set the focus to a field in a subform in the after update event of a field on the mainform. It's got me bamboozeled. THanks, Jeff M.

How can you format the background color of a textbox if a certain condition is met? Like a checkbox is checked true so the background of a textbox on the same form needs to be a certain color in that condition. Thank you, Jeff M.

I have a form that is used to take equipment out of service. There is a combobox that is populated from a link to the equipment database. There is a checkbox for out of service. When a piece of equipment is selected out of service in the first DB i need to make sure that the table in the...

I need help creating a query that will return multiple records with a maximum/last date. There are two fields in the table F1=Category F2=Date Pumps Motors Instrumentation The category has about 9 different selections you can make. I need the query to return the latest record from each...