Search results

I agree George. I interpreted Nector's comment that a helpful video tutorial will be made. Let's hope to youtube for all to see.

Nector, See this article by Allen Browne re Inventory.

I used the following code to review headers in some image files. ' ---------------------------------------------------------------- ' Procedure Name: DetectImageFileType ' Purpose: Determine Image File Type based on the file header data from a ' blob/ole field in a table or file on...

arnel, I am checking file header, but have found some issues (heic and ico) I'll check Daniel's article. Thanks

UWD, Do you know what format your blob was in when you loaded it in your database? I did my testing with jpg. I had to work with the Put statement to get the the extracted jpg to render properly. My earlier code resulted in error when trying to display the extracted jpg. This latest code works...

The code below should help in adjusting your procedure to extract OLE/Blob field/data and place it in a jpg file on the file system with a name based on your table. This does extract the blobField data in my tblBlobTest to a jpg file on the file system. Sample execution call with...

dullster, It seems that, although we are16 posts in, readers are not sure of what you are really working with. You have been given the necessary syntax, a link to examples and related comments. We are not clear with your use and meaning of "RecordNum". Can you describe your intent and/or show us...

Future clock may already be designed. Nuclear Clock

Hi Dullster, welcome to AWF!

I see it's genealogy rather than association/clubs/membership. So here is another Richard Rost link.

I agree. It's too bad the OP didn't/hasn't described the business logic or provided examples of before and after. I'm not an accountant, but I don't follow how you could have Invoices and CreditNotes in same table without some means of identifying what is what. Your solution handles it. I could...

MajP, Seems reasonable. This would identify the Rollback/CreditNote which the OP has not explained.

Redstick, Richard Rost (Access Learning Zone on Youtube) has a series of videos on Association/Organization/ etc that starts here. It may be a little overkill for your needs, but Richard is a good teacher and watching the videos may help you with context and approach.

Welcome to AWF, Redstick!

I attempted to do what you've asked, but do not understand your business logic. Hopefully, someone else will understand your request and offer a solution. I added a button and used Allen Browne's code to copy as mentioned in #12 by theDBGuy. I changed your Data Entry from Yes to No so I could...

Please describe-in simple terms- what you are trying to achieve. If a CreditNote is different than an Invoice, how do you distinguish the 2? Should it be a separate table or , if in the same table, don't you need some discriminator? Perhaps you could describe the business process in simple...

Hi Marlon Visser, welcome aboard AWF!

Welcome aboard AWF!

Crystal, Congrats on getting your MVP again. (Just saw the info in the AUG JSON [Maria,Neil,theDbGuy] video in #168). Jeez for a second I thought Musk was retracting MVP statuses randomly.

Hi Frank. Welcome aboard AWF!