Recent content by bk1010

Thank you arnelgp work a treat

Okay, fair point. I can create an inputbox but I'm not sure how to populate the previous record

All, I currently use a subform where it allows the user to issue a vehicle to an individual , with the issue auto populated. However, I can't think of how to auto populate a return date when the vehicle swaps owner (via query/code). ID Owner Vechicle Reg Issue Date Return Date 2 Joe...

Hi All, I have a query that uses 2 tables, tbl_EmployeeDetails tbl_Assets The query is linked by employee ID. The query returns everything in tbl_Assets and the employee name from tbl_EmployeeDetails. It prompts the end-user to update the date of an asset but I keep getting "This Recordset...

Yeah, so I'm trying to track of over 2000 employees and numerous assets attached to each employee. They order new asset on a daily basis, I'm trying to keep track whether the asset has been ordered and when. I'm don't want to build numerous column on the main table.

Hi all, Just need a bit of advice from my fellow database developers, I'm currently building an Asset database, where the end-user will be able to order stock. I need to implement a section that allows the select the order status (ordered, in-progress, etc.) of an asset, but I can’t think of...

Both, I can see the logic in not storing the data in a calculated field. I shall design a query instead. Thanks for the advice.

Hi All, Is there a way to use calculated field in a table with today's date? For Example: =IIF([OrderDate]<Today(),"Out of Date","Still in Date") Thanks in advance

Thanks arnelgp, The code has worked, however I'm trying to get the subform to update without the user pressing enter. Is there anyway to achieve that? I've tried On Change event but no luck

Hi both, thanks for the reply. The [FromDate] and [ToDate] are textboxes, where the user can just choose a date. It then runs a call function that requeries the subform. Private Function TaskTypeSearch() Forms("frm_Reporting_AllTasks")("frm_AllTasks_Subform").Requery End Function

Hi, this should be simple. I have created a form with a From Date and a To Date, I have coded a filter that updates an attached subform. However, when I change either date I need to press enter into order for the subform to update. I have tried events "On Click", "On Change" , "After...

Minty, Thank you so much, it's worked perfectly!

All, I'm trying to open a form from another subform based on dates, please see vba: Option Explicit Private Sub Sub_UserID_Click() DoCmd.OpenForm "frm_Task_Details", , , "[TDate] = #" & Me.Sub_Task_Date & "#" End Sub However, some dates (eg, 12/08/2019) will open the form correctly but...

Thanks, they are really usefully :)

All, Please help....I am trying to create a bar chart with multiple target lines but I just can't seem to manage it in Access. Does anyone have any ideas? :rolleyes: