Search results

I can :-) The button is on the main screen which does nothing except give the user options of where to go. One of the options is "Backup and Exit" which does exactly that, so the backup will always be the last thing that happens before the system closes. The backup system works fine and the...

It is a single user system

Thank you - I will give that a try :)

It was one of the options I tried, giving me the same error

Good morning :) I have a button on the main screen that the user presses to backup the database and exit the system. I realise it's not the ideal backup solution, but it's what was requested and works for them. The button creates a sub-directory in existing directory "Database Backups" with...

Having a look at it - thanks :-)

It's set to solid. I've tried various different line widths & colours to no avail :-(

Good afternoon, I created a system in Access 2016 which my client has been successfully running for some time now. Her machine has Access 365, but when I install on her machine I remove all Access functionality and it has been 100%. As of today, no box borders are showing on any reports or...

I solved the problem by explaining to the client why what she wanted is a bad idea! In playing around with solutions (including yours to a degree - thanks!) I realised that selecting the contents of a textbox in the On_Click event would mean the client would never be able to edit the contents...

No, no :-) The "Indeed" was for Access, not you!

Thanks - am after selecting the contents of the textbox though, not changing the background colour....

Have that - per my OP - it works for a straight textbox, but for a currency textbox it only selects the currency symbol and the first number. Also, I have 36 forms, some of them with a LOT of controls.... I could be here for a month of Sundays programming each On_Click event.

Indeed...

Damn - I need to select the content.....

I have hit a bit of a snag with moving between fields on a form. If I use the <TAB> key the contents of the field is highlighted (as I expect it to be - I selected "Behavior on entering field / Select entire field" in Options / Client Settings. However, if I click on a field, the cursor is...

Sorted :-) Turns out the CostPer is a text not a number field. Thanks for pointing me in the right direction!

I put a Switch statement into my query as follows (I ignored the sum part for now just to get the switch statement working) CalcCost...

Good morning :) I am creating a report which lists outstanding jobs and their cost. The Cost value is dependent on a "CostPer" field which has a value of "Job", "Each" or "1000". So the calc will be If CostPer = Job Then TotalCost = Cost1 + Cost2 ElseIf CostPer = Each Then TotalCost =...

It shows the tables as correctly linked.... It's as if the queries don't recognise the tables now... I tried creating a new query which looks exactly like the old one - and that works..... I've restored the system to the point where it was before I split the database. Last time, I split it...

Only 4 checked items, none of them marked missing.