Search results

How many simultaneous users on your database? If this is standalone then you could query that login table at login. If it is 7th login, then delete the first 6 and make this record 1. If this is multiuser, then you might consider the login table to be in the front end where each user gets...

Google translate: Good evening I would like your help.In the following database example, when I put a value in the "Category" field in the "Data" table, I want the "Color" field in the table to be automatically updated with the corresponding value from the "Color" table.Any help is...

Do you record each login to a table?

Hi Heide and welcome aboard AWF!

I created a small table ForecastT shortNoMaxOfIDnumberCarType 019999999Motor 019999998Motor 019999997Motor 019999996Motor 019999994Trailer 019999992Trailer 039999991motor 039999988motor 039999987motor 039999984Trailer 039999982Trailer and used plog's sql name of...

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...