Search results

Cool, thanks for that, I think I see what your saying. I’ll play around with it tomorrow and see how far I get with it. I could do the source as sql or just as a query, I started off with the query idea. if I get stuck I’ll post on my mock-up to see if you can help or show me where I’m going...

Hi Pbaldy, Thats what I was hoping and planning however I just can’t workout how to get only the things that are ticked in the record queried by username to show in the list. can you think how I can get headings from the query on to the drop down list? thanks, Malcolm

Hey All, I'm redesigning my front end, just wondered if anyone can think of a way to filter a drop down list depending upon which user is logged on? For example if the user called 'Manager' is logged on then the options in the list would be say: Manager Diary, Reception Diary, Customer...

Hi June7, Thanks for that, its a very interesting point which I hadn't thought of like that before, we used to type in the end of day figures and I was looking to calculate them, however of course your way they will be updated in real time over the day too. Many thanks, Malcolm

Hi, I am looking to sum some records in one table and paste the total in to a record in another table. I'm struggling a bit with my Run Sql command (I'm not that great at SQL commands in VBA). Initially it didn't seem to work, however I put the SUM part in single speech marks and that seems...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)