Search results

You need VBA code there 1. Open Excel 2. Open Workbook 3. Find the data by referencing the sheet and range 4. Import what you need 5. Quit Excel

I believe the answer is going to be in what you consider a professional form style. The example you provide is going to tell you what you have to do. We could assist in letting you know how hard it can be.

I tested what you're doing with A2016 and it's the same. I don't see this as a new thing. For instance, when you write code with variables that aren't tied to a specific type, which we refer to as "late binding", the compiler overlooks those details and allows you to continue writing your code...

Test your accde file and make sure you have good error handling I would worry more about the previous point, add some login form to serve as the only security before making things more complicated, once you see the product is viable and will grant you sales, migrate it to a secure platform if...

I think the OP has posted 4 threads already and has not replied to any.

I like udio too https://www.udio.com/songs/qtZrU73ehZvvj3m35gRfuR

Well, it depends on the customer, right? some of them are very impressionable while others are knowledgeable. Some of them might want to create proprietary stuff and others don't give a damn. There are all kinds of situations but I do agree it's not wise to do everything yourself. I personally...

Thanks. I didn't know it would do such a thing but it would help explain other side effects like the slowness for such a mundane task. I'll check it out.

Do you have any functionality in mind? Here's a basic example of a search text box that responds as you type and filters the results with the added benefit of displaying an image when no results are found...

I tried that once, I also went way beyond the 40k forms. It worried me when I tried to rename them to a consecutive number according to their order of appearance in the AllForms collection with a For Each loop: it skipped some forms. I would guess it becomes erratic when you have that many...

Testing has been mentioned multiple times. Here's what ISTQB, an authority in the subject, says about that: 1. Testing shows the presence, not the absence of defects. Testing can show that defects are present in the test object, but cannot prove that there are no defects (Buxton 1970). Testing...

I personally prefer: Data tab > Get External Data group > From Text button

Wow, 138 posts now. OP, are you ever going to mark this as solved? Because they are impossible to define. Too many factors are at play. If someone tells you it's 1k forms, what if all of those forms have 1 label each? Do you think your computer is going to struggle? Likely not, if you have a...

I don't know who Tim Abell is, I'm talking about Access. But think of it this way: 1. Single Access file is near its limit 2. Export/Import objects dedicated to a certain aspect of the application to new file 3. New file has fresh limits If you're certain you will reach the file limits, then...

What is the progress of your understanding so far? Access has tools to share code across frontends, it also has tools to import/export frontend objects if necessary. That alone gives you endless capacity.

Basically, your thread got derailed, you've been told the topic was not clear and you still have not found a solution. I doubt anything here is a solution to what you need. We're not even sure you know what you need. If what you need is the number of forms/reports that can be created, or how...

After 50+ posts, I suggest making another thread asking something along the lines of: > How to build a scalable frontend solution for continuous development in Access? > How to optimize a frontend solution to avoid being stopped by the limits of Access? Having your data in an external source...

Those screenshots show ways to use external sources, like: The references window grants access to external libraries. The external data ribbon tab offers data extraction methods. The code snippet shows an HTTP request for external sources. Controls have path fields to specify external sources...

I'm sorry, what is this? How about this? And this? Or probably this? Got anything to say about this? And I'm not even done.

It's is the same with all the tools, and everything in general. For example, if I'm going to design a dam, the first thing I need to ask myself is why I need a dam. That's the first step, not the second, and I need the dam because I need water, that's the main purpose. And some people might...