Search results

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

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

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

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

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

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:

Hi All, Please help I'm trying to merge the following with Type = Other in to one record:- Table1.Account Number Address Postcode Type Table1_1.Account 11111 1 High St AB1 1AB Main 11111 11112 1 High St AB1 1AB Other 11111 11111 1 High St AB1 1AB Main 11112 11112 1 High St AB1 1AB Other 11112...