Recent content by CJ_London

My guess would be the file is already corrupted due to sharing - splitting it would not in itself necessarily remove the corruption. According to post #1 you have 4 computers hard wired together with one of them acting as host to the app You have a laptop with the latest version of office...

So far as I am aware you cannot use DAO to update existing data in an excel table. In access you can update an excel table manually, but not by using sql. Never tried it from excel. Might help if you actually specified a table, including headers A quick search suggests using ADO might work...

You still need to know your code - I wanted to find a way to make the detail onPaint event conditional to reduce flicker every time a control was clicked on or the detail section was scrolled. AI told me it can't be done and suggested alternatives such as conditional formatting, UDF, etc. I...

that is hard coding your line positions, requiring a recode if you resize/reposition your controls Perhaps try something like 'identify header row '(assumes header labels are aligned top)' dim ctl as control dim hdrTop as long dim hdrRight as long for each ctl in me.header if...

agree with other comments - I have noticed that unless you reinforce that you are using Access VBA, AI's can slip back into providing code intended for excel. A fair number of functions exist in excel vba but not access vba - latest one it tried to foist on me is the excel Max function, and the...

Not sure if it fits the bill, but you can use sql SELECT * FROM qryView IN '' [ms access;pwd=;Database=pathtoBE.accdb] or simply SELECT * FROM qryView IN 'pathtoBE.accdb' or in VBA you could try this- but requires a form to display the data Dim ws As DAO.Workspace Dim BE As DAO.Database Dim...

Sounds like your afterupate event isn’t working or isn’t called but without seeing it can’t suggest anything else

In the past I have used an ado disconnected recordset for editing data in a continuous form. Parse your xtab recordset into the ado recordset and assign to the form recordset. Edited data can then be applied to the underlying tables, either on a change by change basis, on moving to another row...

Shoes-bury?

or buy another wardrobe 🤔

@DickyP - if you take a look at the presentation you could create your own ‘old style’ message box instead - and perhaps enhance it for those with poorer eye sight Neil’s objective was to have a consistent look across the different styles

You probably need tables along these lines Tblemployees EmpPK empNamr …. ..,,. Tblrotas RotaPK empFK dayID - 1=sunday, 2=monday etc One record for each day an employee works For any given month, use the weekday function to find the day of each week for each day and link to the dayID for a...

really need to establish all the variations but you can combine format and val functions ?format(val("01D"),"000") 001 ?format(val("12"),"000") 012 ?format("310","000") 310 You can extend that to include the last character if there is one ?format(val("31D"),"000") & iif(not...

Please clarify what you mean by SQL Server. MS SQL Server is a RDMBS ( Relational Database Management System.) as is mySQL, PostGre, Oracle Database and many others. So far as I am aware there is no RDBMS simply called 'SQL Server', that term just refers to MS SQL Server If you had said...

One correction from me - you migrate access back end (tables and possibly queries from front end) to sql server, not access and not SSMS. SSMS is just the tool for managing sql server in the same way you would use access to manage access tables (and queries). You cannot use SSMS to create forms...