Recent content by CJ_London

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...

depends on what the app is doing. DAO is probably easier since the form sort/filter actions will work out of the box. But it is potentially less secure if you don't tie down who can see what in terms of the back view - tables, queries etc (i.e. hide that access navigation window). You should...

Decide first whether you are going to connect to sql server using DAO or ADO (although you can do both if relevant). DAO typically means you will be using linked tables, ADO means you will be creating recordsets as required and assigning them to form/combo/listbox recordsets. Performance wise...