Recent content by Malcolm17

  1. M

    Solved Union Query Starter Help

    That's brilliant and a great starting point for me, thank you its just what I am looking for, I can play with that now. Many thanks!! Malcolm
  2. M

    Solved Union Query Starter Help

    Thank you, that did work for me, however it did not give me what I was hoping to achieve, maybe it is not a union query that I need. Please can you tell me how I can get the following layout in a query (it will be for a report in the end) (LOCATION 1) (LOCATION 2) Product...
  3. M

    Solved Union Query Starter Help

    Thank you theDBguy. Both queries work on their own, it is just the union query that I cannot get to work.
  4. M

    Solved Union Query Starter Help

    Hi theDBguy When I run the query I get the following pop up message error: Invalid use of '.','!', or '()'. in query expression 'Query1.'.
  5. M

    Solved Union Query Starter Help

    Hi, I have a database that I use for reporting, however I would like to see the total quantity and total sales broken down by locations in one query which I would also then use in reports too. I have never used a union query, however I believe this is they way that I should go? I can't seem...
  6. M

    Find all records ignoring time

    Hi, thank you theDBguy, that worked for me too, I'll keep hold of that for the future. Malcolm
  7. M

    Find all records ignoring time

    Hey aenelgp, Thank you for that, that was the trick that I needed, I'll be able to use that in other areas as well now. :) Malcolm
  8. M

    Find all records ignoring time

    Hey theDBguy, I think that is probably exactly what I was trying to get to, however when I try to run the query I get an error. I have attached this part of my project, please can you have a look to see if you can see where I am going wrong with it? Thank you, Malcolm
  9. M

    Find all records ignoring time

    Hi Ranman256, I don't really understand what you mean by that, please can you tell me a bit more. Did you mean this, NewDate: Format([CreatedDate],"dd/mm/yyyy") - (I don't think you do) I did try this and it didn't work for me. Malcolm
  10. M

    Find all records ignoring time

    Hi, I have a form that displays the date of any records that I would like to see for a specific date in a query, however the timestamp that I am using has the time. How can I find all records in my query for the date that I am looking for? I'm trying the following but it is not working...
  11. M

    Find Record for Subform

    I've played around with this all day and have tried various scenarios and can't quite see what I am missing. I have attached a pared down example of my front end, please can you have a look at it for me? When you open it, open the maintenance form, select a Room\Area, eg 111, the idea is to...
  12. M

    Find Record for Subform

    Hey Paul, I'm not making much sense with that code, when I run it I get an error on the following line: .FindFirst "RoomArea = " & lngPK Error is: Runtime error 3464 Data type mismatch in criteria expresson I have tried to use the text line too and it returns the no record message, but the...
  13. M

    Find Record for Subform

    Hey All, I'm looking to click a button on a continuous subform that will select that record (ID) and then display (use subform.visible = true) and then hide the subform where I have just clicked the button, I'm ok with most of the code but I am having issues with finding a code that will allows...
  14. M

    Field plus 1

    Oh deer!! I've just looked to make sure that the textbox is called Chase, I'm going to look stilly now as it is called Chased, the button is called Chase. Well that was an enjoyable hour being frustrated - as I thought, when I name it properly in VBA my code works Me.Chased = Me.Chased + 1...
  15. M

    Field plus 1

    Thats what I though!! Private Sub Chase_Click() Me.Chase = Me.Chase + 1 End Sub Gives me the error: Run-time error '438': Object doesn't support this property or method I have tried various things like: Chase = Chase + 1 Me.Chase = (Me.Chase + 1)
Top Bottom