Recent content by Gregvg

Thank you for your help. The DateValue function did the trick. My problem was in the dataset. once I cleaned it up the error went away. Now I just need to make sure it can't happen again. Thanks again for your help.

yes it's a bad habit of mine. that didn't correct it but I think that the problem is in the data itself. I see 2 rows that aren't formatted as datetime. I will clean them up and see if that corrects it. Taking out the exclamation point didn't change anything. I'm not the one populating the...

Here is the SQL statement SELECT DISTINCT DateValue([Chemical Usage Log]![application_date_time]) AS [Date] FROM [Chemical Usage Log];

I am getting a data type mismatch which i don't understand because the field is formatted as datetime

I have a field on a table that is a DateTime format and it needs to be that way. I am trying to query that table for all the dates to use in a combobox but I only wat the date not the time. The problem is when I format the field to just date I can't sort it anymore as a date and I can't group...

I have a subform that has all the data from my costing table. In that table are about 7 or 8 fields that are not populated when the rest of the table is populated because we don't have all the pricing information needed yet. I am using the main form only to put in the controls. I have 2 fields...

the fields to update are Plastic Unit Cost Plastic Tray Cost Volume Live Input Cost1 I am trying to mass update a specific bunch of filtered records on a datasheet with one click as opposed to updating them one at a time. I was able to do it with an if statement for each field but I was hoping...

I have a form called CostingForm. This form has a subform called CostingSubform. The subform's data source is a table called Costing Table. The main form has a combobox that has all the "Field names" or headers from the Costing Table that populates with the on open event. I also have a non bound...

I have a form that displays the quantity of plants that we are growing by genus, (marigolds, impatiens, petunias). each genus has many different varieties that can be used to make up the mix. I need to have some type of worksheet where we can put in the total qty and calculate the quantity of...

I have a multi select listbox. I have a cmd button with the following code in it. Me.Text40 = Me.List38.Column(2) That gives me the value of the first item selected in the listbox. But what I need is the sum of all the items selected in the list box. Can anyone show me how to do this?

What bothers me is how the formatting changes. I have 2 axis one represented by a bar graph and the othe by a line graph. Even that changes when the chart is refreshed from year to year. that makes no logical sense to me.

I have a parameter form with a combobox that selects the year for the query that generates the chart, then opens the chart. As far as the data yes it's different because it is a different year but the structure is the same. What troubles me is the actual design of the chart changes even though...

When I refresh the data for my chart for one date range I get a chart that looks the way i designed it. See attachment. When I refresh the data with a different date range it changes the whole design of the chart. See attachment What could possible cause this to happen?

That was it. Thank you very much

This is the first time i have tried to use the dlookup function. I have the following code. The UnitRate and the TotalCostPerMile fields are formated for currency.The VehicleId and The UnitNumber are both formatted for text. I am getting a synyax error in string in query expression [DeliveryId]...