Search results

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

The Cost Per Mile updates on a yearly basis but once that value is established on a specific date I don't want it to update again on the data table so i have history. that is what i am trying to do with the form. Lookup the value on that day and pass it to the data table. i hope this makes sense...

That solved one problem but now I am getting a type mismatch error. Is there a better way to pass that data to the table? Once i have the lookup value needs to become static. If the value changes on the Lookup table it can't change on the form.

I have a form called "Input Information" that writes to a table called "Data". I have a field on that form called "Unit Number". I have another text field on the form called "Unit Rate". I have another table called "Vehicle List". 2 of the fields on this table are "Vehicle Id" and "Cost Per...

as a first time poster to this board i hope that i can get an answer to what is probably a very simple problem. i have the following code that isn't updating the field. it's suposed to look at the date field and if it is null then enter the date. if the date is already there then go to the next...