Search results

I have got this code to work for filtering the data from one combo box: 'Forms.Form1.UserLogsubform.Form.Filter = "[Username] = Forms.Form1.Combo2 Or Forms.Form1.Combo2 Is Null" 'Forms.Form1.UserLogsubform.Form.FilterOn = True 'Forms.Form1.UserLogsubform.Requery And I got the following code...

The converted macro gives me DoCmd.ApplyFilter "", "[UserName]=[Combo2] Or [Combo2] & """"=""""", "UserLog subform" however it doesn't work. I am working with the following code which works for filtering users but does not show all records when I select the blank...

Well I thought that I could but I don't seem to be able to - Please help!! :-(

I have just seen your example using the macro, thats amazing!! Thank you!!

Hi DBguy, I prefer everything to be VBA, so if thats possible that would be great. I just picked up my example from a Youtube video.

Hello, I have a table that logs all my users activities\changes etc and I would like to be able to filter by Employee or Action but I cannot quite get this right. I have my combobox grouped so I can see all my users but when I filter by a user I cannot see the whole table unfiltered - how can...

Okie Dokie, will do. I hadn't really though about that. Thank you.

Hello, I'm trying to update my table with a button on a form after a procedure has run to show the next date due. So it could be Weekly, Monthly, Quarterly etc. I have used the following which works On Update but not with Run SQL: If [Frequency] = "Monthly" Then NextDate = Null [NextDate] =...

Hi, I am trying to use RunSQL update and I want to use 2 lines for 2 sentences to store. I am trying to use vbCrLf, can I use this in the SQL Line? (eg & vbCrLf &) This works fine is MgsBox etc. If not is there another way I can do this please? Thank you DoCmd.RunSQL "UPDATE...

Hi All, Thanks for your responses, I have attached a mockup of the part of my database that I am seeking help on - hopefully this will give a better idea of what I am looking to do. Malcolm

Hi, Yeh that would make more sense. I will extract part of it and upload it. Malcolm

Hi June7, I have 22 devices just now and adding more, I just used 4 as a quick example. Do you have an example that might help me or can you point me in the direction that you are thinking please? Thank you, Malcolm

Hi Gasman, Yeh that would make sense, I keep the record of testing with details etc in another table, the table I am speaking about is the table which holds the device names and is really just to show what is left to test, the idea is the next blank date record is the next to test, but I cannot...

Hello, Part of my database is for tracking testing of devices, we test one device each week and record the test date. I am looking to do 2 things, but I cannot think how to do them: Device 1 16/04/2022 Device 2 23/04/2022 Device 3 Device 4 1. I want to show on my form the next device...

Hello, I'm looking to re-do my Error Handling as it seems to be quite messy, at the moment I use the same code in each VBA entry; On Load, Click etc. I have a large system with lots of forms etc so I was looking to call a module that would hold the error handling in it for all area's. I use...

Thank you the DB guy, that worked brilliantly and helped me with a couple of other DLookup issues that I was having too!! Malcolm :cool:

Hello, I'm having issues updating a record for a diary database. I have the following code which should update the record where the date selected in the form textbox called txtLocalSystemDate and in a column in the table selected from a list on the form called txtDiaryFeed. Its complicated...

Cool, thank you for that, I will get to it tomorrow :-)

Thanks for that guys, I will have a look at it. Its not something I have done before so I am hoping there will be a sample code on your blog Uncle Gizmo. If not do either of you have a sample code I could adapt? Many thanks, Malcolm

Hello, I'm not sure if what I am trying to do here is simple or not and my brain hasn't really came up with a way to do it so here goes: :) I have a table which holds my data like this: Booking Arrival (D/M/YYYY) Departure (D/M/YYYY) Nights Cost 1 1/1/2021 3/1/2021 2 100 2 2/1/2021...