Search results

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

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?

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

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