Search results

Col - you are one sad, miserable git (my opinion) and most people don’t think like you so it will be appreciated if you don’t imply they do

My experience is with northwind - if I download and open with 32bit access, all well and good. If I then try to I open the same file (having previously opened with 32bit) with 64 bit I get errors. Same if I open the other way round

Providing the OP doesn’t then try to open the file. If they do, I doubt their client can. OP would need to provide a new virgin copy

Don’t think the OP has said what the newer version is - if 64bit, it may not convert to 32bit mdb.

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