Search results

Perhaps you have added and removed so many controls over time, you have reached the finite limit - used to be around 700 Suggest create a new form and copy all controls from the old form

Very none pc , these days it’s not women who get pregnant - it’s people🥴🥴

use vba to change the name of the pdf either when it is created or after (use the name function) I use outlook automation to creat the email and the pdf Away from my computer at the moment and that does all that so share your vba code for creating the pdf and I can provide a more focused response

Not really clear of the relationship between the two tables - is one supposed to be a total of the other - and how does 0.00 act as a warning? What if there are no values in the table? You might want to investigate using the format property for the control? For numbers there are 4 states -...

As I said, it is a basic editor and needs further development and that is one of the things that needs addressing - I simply asked chatgpt, it produced the code and it worked as is. I did so as a response in a thread asking about the 'dangers' of richtext. If someone want to copy the html code...

you can also run the html file in a browser if you so wish - can't do that with richtext

It needs further development to meet specific requirements but ChatGPT came up with this as a basic editor. Thought I'd share it in this forum. To use, unzip and modify the path in the edge browser controlsource to wherever you put the html file

Just thought I'd ask ChatGPT to create a html editor and this is what it came up with. needs a bit of work - for example, store the image, set backgrounds and the like. But has the basic functionality To install, unzip and modify the edge control controlsource to point to wherever you put the...

It's certainly not Word, but it's fine for the basic formatting requirements. It would be nice if you could include images and tables, all depends on what you want to do. Alternative is to create in html and use the new edge web control which can be used on continuous forms - but really only for...

You might also want to review this link https://www.access-programmers.co.uk/forums/threads/on-off-control-for-continuous-form.324505/

I'm still regularly experiencing this issue. Have to go into task manager several times a day to clear them out.

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?