Recent content by CJ_London

there is also debug.assert

A friend of mine worked for the local council (he's retired now). Their hours were something like 37 1/2 hrs/week. Any time over could be taken as time off in lieu. (TOIL!). He used to start early and finish late to avoid the traffic and typically built up 10-15 hrs/week. Enough so every year he...

What about using stop?

So what if the amount is 12760? Or greater than 25520? What is the correct tax?

I think just set the format property to #0.00 will achieve that

think you need to include a 'back' button in case the user mistypes. You can also disable the period button after it has been tapped txtPeriod.enabled=instr(txtResult,".")=0 so it re-enables if the user backs over it and disable all buttons(except the back button) with...

Agree with plog.simple in principle until you look at the taxes table. So I would add what would be the expected return for an employee on a pay period 12,and a paycheck of $2244? Or a paycheck of $5000? And an employee on a pay period of 26 and a paycheck of $3000?

I was going by this comment Bu accept docmd is an alternative

You can just use Set Popout=new frm_employees Just ensure popup property has been set at design time - it is ignored when form is opened as a subform Would still need to set some of the popout form properties such as caption and visible. Perhaps also apply any filter criteria to match the...

On my phone so cannot check What about using refresh? Or just recalc the required control? Sounds like the same effect you get on a scrolled textbox - it returns to the top when it loses the focus

You mean so users cant tamper with them? And what level of security do you want? At a basic level, hide the navigation window Or right click on the query and select hidden Or prefix the query name with ‘usys’ Or Rename your file .accdr None are particularly secure as all can be easily...

I've used sql to clean around 1m rows of data from a monthly produced excel file. Sql: Appends data to a temporary table, all fields treated as text and an indexed hash value of all fields (excluding PK) created to subsequently identify duplicates looks for and removes duplicates in the table...

I think you will find that (perhaps because) the listbox is unbound, the underlying values have not been updated. Perhaps a poor analogy but a bit like going round the supermarket and putting things in your basket - but they aren't yours until you've been through checkout adding a Requery to...

What event are you using to run the code? Form open? Load? Current? Listbox afterupdate? Something else?

it was just a suggestion - I've experienced slow performance when CPU/Memory is those sort of levels but looks like that is not the issue here