Recent content by vicsalt

Thankyou all for your support, suggestion's, now sorted

Thankyou this has sorted my Issue :) Happy Bunny

So, I use the 2 dates to establish time differences, are u suggesting if I change the format to US all dates within the table will be US format ?

I have a table being populated via various forms etc, I am capturing dates and times via VB depending on various states. My issue, 2 fields is being populated in the wrong formats as in mm,dd,yyyy (American) when I need it in English Format dd,mm,yyyy. My colleague worked on the code , he...

Can you help , I have 2 drop down boxes , the Ancillary dropdown filed are dependent on the value chosen in Machine ID. I have a query that looks at the value in Machine ID and provides a list of Ancillaries related to this choice. The query work fine as in I chose a machine , run the query...

All sorted thank you all for your patience and solutions. I had a few silly issues 1. the field name on the form was "ID" not "WOID" this was the source name , and a missed "S" in the code, "requests" not "request" Thankyou again and special thanks to GaP42 for the solution

Sorted ! 2 issues 1. The Name of the fielsd was "ID" not "WOID" which is the control source 2. The Code ponted to the table "WorkRequest_tbl" it sould have been "WorksRequests" Thankyou all for your assistance I have spent a very long time , with your help the problem is solved

Yes Step 1 - Raise WO that gets a unique no "WOID" Yes Engineers may not fix the issues and log off the job, another engineer can then select the same WO. Yes Work orders exist , and no record will exist in the engineer table until its selected the control name in the WO table and the...

Added Option Compare Database Option Explicit Compile error: Method or data member not found Option Compare Database Option Explicit - I added this line Private Sub selectjob_btn_Click() - This Line is now highlighted ? EngStartTimeDate = Now() Live = True Dim WOIDAccept As Integer...

Im getting a error at the start (Red Text) it maybe because the WOID in the WorkRequest_tbl doesn't exist until the form is closed ? Thoughts please Private Sub selectjob_btn_Click() EngStartTimeDate = Now() Live = True Dim WOIDAccept As Integer Dim strSQL As String WOIDAccept = Me.WOID...

Sorry for any confusion, no nothings changed just my wording , in that i need to create some sort of flag in my Works Request table that I can use to filter out those that are live etc. I have no relationships set between tables only within query's ? not something I have ever done ? I...

As mentioned the only relationship between both tables is the WOID field 1 to many as in 1 WO in the worksrequest table to many in the engineer table

All I want to do is enable a WIP filed in the WorksRequest_tbl to "True" so i can filter out those records when Engineers review "Open" jobs

Please see detail in Gap42 response,

2 tables WorkRequests_tbl - This is when the Key field is created "WOID" EngineerWO_tbl- This is where all the engineer data is being stored The WOID is a 1 to many relationship , there is 1 work order, but there can be several engineers logging on and off the job until its fixed. The...