Recent content by Jimmyshoo

What i am looking for is code that adds up orders between two dates which the user enters on a form. So between 1st august and 10th august there are ten orders. Then i what the option of them choosing from a combo box a customer. So now i want to see the number of orders between 1st and 10th of...

I tried the first code because its simply a summary query i am trying to run. It says the code is too complex to be evaluated. I tried to write it 3 times. Before posting today i knew how to get a count referencing the form controls in the query grid. However when i added another field to the...

Hello Again thanks very much for the time you are spending on this. I very much appreciate it. The first piece of code looks like what i need but i need to reference the cbocustomer control on the form as well unless i am not reading this correctly the code does not seem to reference this?

Hi Sorry i am not explaining myself clearly I am creating a search form to collect criteria for a filter. To simplify i could do with northwind database If i wanted to create a search form to return (count) the number of orders between two dates and then also be able to break down by customer as...

What i am trying to do is create code so for example you can see how many orders or in this case registrations were made over any given period. I have therefore a customer combobox and a start date and end date text box.i was going to just reference the form fields in the query but it caused too...

Hope someone can point out the syntax problem which triggers error 13 data mismatch problem DtStartDate = [regidate] >= # " & Me.Txt_Startdate & "#" DimDtstartDate as date The text box is on a form is unbound and format is set to shortdate Hope you can help

Hello Wow , that works. I just adjusted or copied and pasted your code over mine. Now i just need to understand where mine was going wrong as it was very similar. Thanks everyone else who replied too. And I will send official thanks in a moment. I thought it would be days b4 I got a response ...

Good evening I am hoping someone can offer me some help. What I am trying to do sounds very simple and I did not envisage having the problems I have encountered To simplify what I am trying to do is move records from a temp table to a permanent table in code So let's say table one has two...

Good evening Just a quick introduction Jimmy from the UK. Interests sports particularly boxing and football,bit of rugby I have been away from the world of access for a good 7 to 8 years. I guess like a lot of people I have joined a) I have a problem and b) my current job which is not IT...