Search results

If I remember correctly, it is for taking photos from a webcam.

You can get cross platform ideas here: https://refactoring.guru/refactoring These are Access' limits: https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c Here's a few ideas: Save your images and attachments as paths Divide the app in multiple...

Add a third way, he might be using parameters, replace and what not. 🤷‍♂️ Better wait for confirmation.

In order to send square brackets to hell, it is recommended to use ONLY the following for anything you have to name in the application: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghjiklmnopqrstuvwxyz0123456789_

At the end of the day, the only thing you should worry about is that your string is formatted correctly. In Access, when you have names with special symbols, such as a space, accented vowels, or others, you must use brackets. If your names do not contain special symbols, you do not need to add...

Read this post for an example to create dynamic controls on the fly: https://www.access-programmers.co.uk/forums/threads/creating-combo-boxes-on-the-fly.329522/post-1898500 If you have 5 different rooms: tbRooms: RoomID, RoomNumber (~5 records) If you have 20 different components for each room...

Just wanted to give a word of caution, given my pentesting experience and trying to secure the stuff I expose to the web. If you're happy with it, good. Just for your reference, here's an obscured snippet of the attempts my server has received today, I just bought it a few hours ago and I got...

I'm talking about a situation where you need a new record that looks a lot like an existing one. You can just copy the original record and change the content in one or more fields to avoid re-work. A few examples that come to my mind are job applications, recipes, medical diagnosis, etc.; they...

I believe a business rule would justify that if the original record shouldn't change and when a new record needs to be created based on it.

I made a simple test with 3k rows and after clicking Recalculate it does recalculate, it takes a while but the status bar shows the process. Does the status bar show you anything?

Just a thought... are you perhaps changing only the code and not triggering any change on the worksheet?

There is a much better solution for that which consists of filling out forms online through a web application. If you had this intermediary between your current Access application and your teachers, you could remove the hassle of managing filenames, barcodes and OCR technology (solutions that...

I opened a workbook to test the behavior. If the code is in a sheet, it won't run from the immediate window unless the sheet's Code Name is specified, like: Just please do not confuse sheet name with sheet Code Name. They're not the same and I myself have made the mistake at some point. The...

That’s strange. It should work, but if it’s not found, it likely means it’s not defined in that scope. Are you sure you’re not trying to run the function from the Excel VBA IDE while it’s defined in the Access VBA IDE? Make sure you’re in the right environment.

For those setups, the SaveAsText method can also be helpful, as it exports the code from the form module. Right now, I recall Form.RecordSource, DoCmd.BrowseTo and NavigationButton.NavigationTargetName as the main ways to modify the form within a subform control. If we search for lines that...

Check out Stripe https://docs.stripe.com/api/versioning There are plenty of tutorials out there. Keep in mind that Access lacks security. Access can perform the HTTP requests to carry out the transactions (I think, I've used the platform but not in Access). They have a no-code version, maybe...

1. Initially, the form has no RecordSource. 2. When you provide a RecordSource using the FilterMe function, the form assigns a ControlSource to your textboxes with the help of the setFormsHtmlTag function. 3. In your original setFormsHtmlTag routine, the ControlSource for the textbox is set...

That change is problematic, though. It's the reason behind the solution given in this post of the other thread. I don't think changing your backend columns for a frontend feature is a good idea.

When I was writing my code for that other thread, I noticed that changing the form's RecordSource property modifies the textboxes' TextFormat property. That's probably what is happening here. Anyway, you can fix it by changing the property again to rich text, so, this should work: Private Sub...