Search results

Hi Just quickly, i think you will need. To identify the function you are evaluating (column for that). The rest is just maths. You need to identify the time the machine is on. Total on = Elapsed time - (time off1 - time on1)+(time off2 - time on 2) etc test time = Test ended 1 - test started 1...

What about: Debug.Print rs!Method ? T

Hi Again I would write a function for this... You can use a User Defined function in a query. The parameters for the function would be date first arrived on site and reporting calendar month/year and perhaps if valid the date the demurrage ended. The costs would be constants in the function -...

Good luck.. We all had to start somewhere and I am still learning. There are always more than one way to do things. Its finding what's best. :) T

This is how I would do it... Private Sub Basic_Inspection_Click() CheckCompletion End sub Private Sub Certifying_Staff _Click() CheckCompletion End sub ..etc Sub CheckCompletion () ' or function... Dim blnComplete As Boolean blnComplete = False if me.basic_inspection = true...

Very true Dave.. AND easier to read/follow :)

Hi Again Re-reading your original post, I don't know what you are using your query for.. You can dynamically change a static query. But what are you using the query for? If your using it for a record source you can use the .RecordSouce = mySQL driven by the After update event on the combo box...

Hi Just a quick response as I should be somewhere else :) Agreed with vbaInet as Approved & Declined should be mutually exclusive. Also, if you are referring to a subform or another sub form then the syntax changes. You need to refer to the parent form and then the subform container etc.. Look...

HI your checkcompletion function IMHO is flawed. I dont think its good to concatenate all the conditions to look for a string of 1's I would loop through the checkboxes and if anyone of them is false the result is false. If all true then the result is true. Also I would also check if the...

If Items is your foreign key, then I would have thought this would populate itself when you enter information in the personnel or date allocated fields :confused: T

Hi I have had a quick look. In your qryDemurrageCalcDetails you need to take ElapesedDays minus LowerRange as your demurrage time for each range. you THEN need to sum the totals of each range for each container. (Ignore any minuses) HTH Tim

Hi This is how I would construct the SQL If Not IsNullOrBlank(Me.txtFrom) Then strWhere = strWhere & "tblXYZ.StartDateTime># " & Me.txtFrom & "# AND " End If If Not IsNullOrBlank(Me.txtTo) Then strWhere = strWhere & "XYZ.EndDateTime<# " & Me.txtTo & "# AND "...

Hi It looks similar to code I have. I have used .display instead of .send.... However, if you put some error handling in so that the objects are set to nothing after an error, this may help... (or may not - I'm guessing) HTH T

Hi I deal with BOMs and this is how I handle them..... Basically a BOM can contain other BOMs and a recursive method is required..i.e. calls itself. This method enters data into a temp table that contains a parent material and its children Sub BOMMethod(rst As DAO.Recordset, strAssembly As...

Hi All I use an Allen Browne function. SQLDATE Works for me...http://allenbrowne.com/ser-36.html

I have clicked "Allow trusted location on my network". I also tried to run the database of my desktop. I am currently thinking that I should redesign my UI to be without a scroll bar and replace it with buttons. The code is entirely within my Access application and does not affect anything...

I have recently been told of an error with one of my databases. The error number is 2926. The description is "Because of your security settings and current security policy, this control is disabled. To modify your policy and enable the database, use the Message Bar". On investigation, my copy of...

Hi I am not entirely sure what you are trying to achieve. But could you use a global variable? Also you could copy the form object into a module to copy attributes. You could set the default value of the second from depending on the values in the first form.... I hope this helps..if not..if...

:)Here is more detail on how I get the text into the email. However, I guess your situation will be different and you may need to create a recordset and then loop though it.. Private Sub cmdEmail_Click() Rem...

I am not sure on what you are trying to do. But if you are locking controls using VBA then you will not see this in the properties of the form. If you run the form & the VBA you should be able to see if the controls are locked. The properties box shows the state of the form when it is first...