Search results

Way to go👍 I created an app for cataloging photos- it populated the file properties with keywords and used a tree view type form to create and catalog the keywords and view the files in a web browser control But don’t think it meets your requirements as it is not generic enough

Perhaps the OP can provide some example data and the outcome required from that data and clarify what ‘not working’ means - wrong result? Something else?

if that is a possibility in the button got focus event, transfer the focus to a valid control or even txtCurrent

use a button (or any control that has a transparent property (not visible)) called for this example btnBorder. Put it behind your controls and size as required. Ensure you have set a border colour and width - this example uses rounded corners In the detail section create a textbox called...

hmm - still doesn't for me on win 11

I wonder if the OP means the calculation of each value- which could be in the controlsource, the form recordsource or vba on some event

OK, so you have been provided with some opinions as to the advantages/disadvantages of different ways to achieve your objective. Only you and your organisation can decide which is best for you - or contract with a professional for their advice, When making your decision, bear in mind the...

I’m going to look into this suggestion:

It is easy enough to avoid duplication of entries- left join the import table/query to the destination table and only import those records where the destination table is null Typically join on date, transaction amount and detail and the balance Similarly a simple query to compare opening and...

What are you using to capture the data?

@Dvorak - suggest you write your question in your native language, highlight it and select translate (to English) then copy/paste the translation to the thread Assuming Spanish: Le sugiero que escriba su pregunta en su idioma nativo, resáltela y seleccione traducir (al inglés) y luego...

Translated I would like to go in a form [person-sheet] to a record whose field [PN] of text type is known to me in a variable [father]: DoCmd GoToRecord acDataForm, "[person-fiche]", "PN = ' " Father & " '" But it is not accepted. PN is a text field and father a text What's the problem...

If you have multiple known formats in terms of layout and column headings you could use excel automation from access to get them in the right order I have a similar issue with bank statements from different banks in csv and xls files. I have a template table that defines where to find each...

I'm on windows 24H2 and updates are apparently up to date

@arnelgp - that is what I am doing at the moment in the main app

I've done some more testing - in a win10 VM I have 365, 64bit office which was on a fairly old version (2412 Build 18324.20194) and the code ran as expected - the access instance is removed - takes 2-3 seconds. I upgraded to the latest version (2508 Build 19127.20154) and the code still works...

just curious- what affect on the jet plan (if any) if you reversed the join as above and grouped on the other table?

was about to say the same thing, you need an effective from date field and possibly an effective to date field if you do limited time offers. And with regards old prices, be careful with credits - price sold at £100, a bit later price is increased to £110. If you want to credit back after the...