Search results

Regarding web development stability: it's an open field and one has to choose what they want to use carefully in order to be stable. Well chosen libraries can make for a highly stable and nicely functional web app, but if you just go grab whatever from wherever, it's going to be a mess. We've...

We do this a lot. Many (most) clients want to have on-demand, no-install access to an app, and web apps are great for this. Then you can attached some Access apps to the same db on the side. As for web forms being a bit poor and unstable... not sure about that. To be clear, there's a few...

Citrix/RDP is far easier: you really don't have to do anything to the app other than maybe configure whatever environment settings you need (paths, etc), whereas a remote BE and local FE tends to be a better user experience, IMO. Citrix can get costly: $45/mo/user vs $30/mo for a SQL Azure...

Admittedly, I don't know what sort of side effects this may have. I can find 100 posts where people did this to "fix" their installation issues with no complaints otherwise, but I can't find any documentation on what this thing actually does. I'll ask around a bit and see if I can find out.

Try removing the CTR Extensibility: https://community.spiceworks.com/topic/2049626-removing-office-16-click-to-run-extensibility-component-cascades-into-another (I ran into this the other week and was a pain to resolve)

This actually looks like a real PITA. I'm hardly an Excel guru, but I think if I had to take on the task it'd go something like this: 1) Open the file via automation from Access 2) Find the row with months, determine the "spread" of columns for each month (e.g., Jan: B-AF), repeat and stuff...

I did, sorry. I edited my post to reflect that. Not sure how to delete it.

EDIT: I misunderstood, please disregard this reply (if a mod can remove it, go for it) I've never actually found a good way to do Gantt charts in Access. In fact, I tend to disdain any charting in Access. If you have a little bit of web experience and want to go out on a limb, try hooking up...

My first choice is usually SQL Azure. It's fast, (fairly) easy to set up (creating the account on Azure is by far the hardest part) and relatively inexpensive. I actually started a whole series of articles on how to do this. Try here: https://dymeng.com/resources/azure/ (it's a bit dated at...

Hi Minty - regarding remote backends with an Access frontend, it is a bit of work to get right. I generally categorize into three levels of "forgiveness" when it comes to performance and how much care needs to be given: 1 - Access (JET/ACE) backend: very forgiving 2 - SQL Server (or other...

If we're talking about a subform control's SourceObject property, there is no "attribute" to the property... it's just a string: https://msdn.microsoft.com/en-us/vba/access-vba/articles/subform-sourceobject-property-access Therefore: = SomeSubControl.SourceObject As mentioned, the () is for...

A bit dated at this point (Access 2010 and 2013 web solutions are not defunct/deprecated), but there's other means that are pro/con'd here: https://dymeng.com/web-enabled-access/ (for a better maintained version, see the link in the first paragraph) Basically you're probably looking at...

Why using parentheses after the SourceObject and ActivePage? Parentheses are used to access an element of a collection or array, which are not what you're working with. Example = .SourceObject(.Name) should be... = .SourceObject SouceObject contains a string that is the name of the form...

Try running it in the immediate window: ?DLookup("[NCR#]", "[Input Query3]", "ID = 12345") Use an ID you know works. This will make sure you have the syntax correct, and may provide a more meaningful error message. After that, try putting the ID into a variable prior to using it: Dim ID As...

Try wrapping your field name and table in square brackets (or better yet, don't use special chars in field/object names) =DLookup("[NCR#]", "[Input Query3]", "ID=" & [Input].[ID]

In VBA there's (essentially) three different variable scopes that can be used: 1) Procedure level: this is the most common, where the variable is defined (dimmed) within the procedure, and is not visible outside the procedure 2) "Private" or "Module" level scope, which is where the variable is...

Generally speaking, I look at it like this: The Open event's primary use is to validate the form is allowed to open, and cancel out if not. The Load event should be used to more or less initialize the form, as at that point we've already verified that it is able to be opened. Thus I agree...

Also, just as an aside: if you ever find yourself thinking about putting a DLookup (or any other D* functions) inside a query, take a step back and ask yourself how this can be done better. Domain aggregate functions themselves aren't bad, but inside a query they are very bad. (every D*...

Also, rather than SQL Express and a self-hosted server, SQL Azure is quite reasonable for pricing at the lower service tiers and is very easy to use in a situation like this.

You have a lot of data to catch to go over 10GB (the Access limit is 2GB, and most people don't hit that, but tend to migrate to SQL Server for other reasons, typically security). In any case, SQL Server is the next usual step from an Access BE. With that said, there's no reason at all you...