Search results

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

Hey Gasman, It is all over the shop, its a textbox that is fed from a selectable combo that feeds a table with dates for various diaries in table fields, also with user access. Thanks again for your help, the following code worked for me: DoCmd.RunSQL "UPDATE tbl_Net_Diary SET " &...

Hi, I am trying to run an Update Sql code line where the destination in the table is variable, however I just cannot quite get there. The line of code that I am using is: DoCmd.RunSQL "UPDATE tbl_Net_Diary SET & [Forms]![frmBackground]![subfrmHome]![txtDiaryFeed] & =...

Hey, thanks for that - all worked perfectly!! Malcolm

Perfect, that all worked!! Thanks Guys!!

Hey Moke123, I got that to work for the dates, however when I select the Department from my ComboBox list it just pulls through the Field Name which is displayed in my textbox txtDiaryFeed, can you help with this please? =DLookUp(" [forms]![frmbackground]![subfrmhome]![txtdiaryfeed]...

Hey, I have a form which I am looking to select from a list and display information from a table in to a textbox using DLookup. So I need the control source DLookup to be something like the following: = DLookup ( txtDiaryFeed , tbl_Net_Diary , TheDate = txtLocalSystemDate) I just cannot see...