Search results

there is a command-line exiftool.exe to write those attributes/tags. there Tags that are read-only (no). on this list: https://exiftool.org/TagNames/EXIF.html sample by ChatGPT: Sub WriteMetadataWithExifTool() Dim ExifToolPath As String Dim FilePath As String Dim Title As String...

i am on win11 and it does not terminate the app normally. so as i have suggested keep the .Quit thing and the Kill thing. since when it got closed normally (via .Quit) the Kill thing will not find the Window handle or PID and will exit quietly.

try using ChatGPT or CoPilot. this one is an answer from ChatGPT: Sub ReadMP3Properties() Dim sh As Object, folder As Object, file As Object Dim filePath As String, col As Integer filePath = Application.GetOpenFilename("MP3 Files (*.mp3), *.mp3") If filePath = "False" Then...

you should expect that not all "attributes" are present on the file.

use: rs.Edit

not entirely true, the OldValue for new record is it's Default value. if the Default Value is 0, then that is the OldValue for new record.

then avoid switching combo's or switching Row Source Type to avoid any anomaly. "Now I Am Become Death, the Destroyer of Worlds."

change the Line Spacing property of Description textbox to any value other than 0.

the normal approach is you don't save the Stock quantity on the table. you add them up (from the beginning inventory + qty received - qty issued). in your case, since you are saving it to the Stock Qty field, add this formula to the BeforeUpdate (or maybe AfterUpate event): [Stock Qty] =...

it says on the ouput textfile that it create temp index on the expression: S.CompanyID = C.ID always index on the joining fields and on the Where clause field of your query.

M.Wolfe wrote the article, maybe he has a better explanation.

you can also try this: Public Function AgeInYearMo(ByVal dob As Date) As String Dim m As Integer, y As Integer Dim u As String, s As String m = DateDiff("m", dob, Date) y = m \ 12 If m < 13 Then AgeInYearMo = m & " month" & IIf(m > 1, "s", "") Else m...

i browsed your old post and you seem to have Sharepoint on your premise. why not use it? someone here more experience on Sharepoint will enlighten you.

then you request 1 Dedicated PC that will perform as the Server for your database. this PC will be open 24 hours. i have done this many times. have a "strict" time schedule. the pc should be given a "rest time" and all users must be notified of this. pick a time (during lunch time is the best)...

yes, but will Mostly (and for sure) result in database corruption. for the OP, does your users use your db 24 hours or just as you goes out after office hours? if it 24 hours operation then you need to make your pc open 24 hours (that is no problem if you have A/C).

if you are connected to your Network, you can create a Folder (on your pc) and put the Backend there. then you can create a shared folder from this folder, so that all users of your db can connect to your folder. you should add account Everyone (with all rights/previlege) to this folder. you...

can't you create a shared folder on your computer?

goodluck Madam Barbara! I think you are more knowledgeable with regards to programming in Access than Nicole.

i have similar issue with CJ, using Win 11, Office 2024 x64, it does leave access in memory.. you can still use app.Quit on your app, together with "force-killing it". since if Access close normally, the "kill" sub will not find the access window handle and will exit without message (if you...

just tested your code, and i get the msg "Process terminated successfully" (after uncommenting all msgbox). it means, that still the other instance of Access is still alive when i issue the command: accApp.Quit