Search results

Oh I give, I give, you're such a wit. (Half wit.) If you are an example of round, I'll take square as a compliment.

You can go paste some more code, you're an expert of course. Or swab a deck oh round one. I'm still learning the (basic) Access ways. You got a problem with questions? Yep, I never claimed to be an expert in Access. But I do know how to sniff out a solution. None of which I've seen come from...

That's the point, dumb terminals didn't do anything other than input/output data. Everything was centralized, like our brain. Tall ships still draw big crowds. I've seen it estimated that 70%+ of business still use legacy applications. Now why is that? One of my old clients, Revlon, bought into...

Already answered in another post, the simple answer is that I'm not in the USA where I can count on 100% connection time. Stores that have twenty cashiers need to keep selling even if a road crew destroys a cable and replacement/connection is a week out.

Do you really want me to go there with you? Let's start with something you might understand, and my second issue (they kept the first) of the USCG license I got at age 19, being the youngest and first ever under age 30 to pass on the first try with a practical exam that was 80 years old. The...

Working on it. Most of the "experts" have no idea what I'm talking about, as MOST, I presume never have worked in the environments I have. They "play" with access but haven't done an enterprise application. Just my educated guess from some of the comments. There's a big difference between...

I just saw your post after submitting mine (#20). Yes, we've had this discussion before, and I'm aware of all the points you made. Despite that I remain without a solution that I am comfortable with. I've tackled some of your points on requirement, unknowingly, in post #20. I also did a lot of...

A subset of all the BE data that has changed since the last synch needs to be aggregated and compared for changes (by the centralized "Data Momma"). The most recent version then sent to the field BEs. I played with composite keys for a BE ID to records, but that got complicated for the local BE...

I guess I should clarify again what I mean by multiple BEs. Store one has a BE. Store two has a BE. Region A for stores one and two has a BE. Ad nauseum. Corporate has a BE. All must synchronize at some point (either continuously or periodically). The problem I'm still struggling with...

Thanks, for some reason I didn't see your #11 until now. My web pages are getting a bit jumbled. I don't know if it's my unreliable ISP, Edge browser or this site.

Thanks for that sample db. I am looking it over right now. Follow up. I asked why it's so complicated in VBA, in most of the sites I've searched for, especially given that I've seen it done with macros (not VBA) in a demo video. But I was never able to convert the macro to VBA to see how it...

I'm not sure what you mean by "dictionary". What spaces are you seeing in a table name? Underscore is not a "special character" it is a common delimiter used for coding. Although I don't use it to separate Order_Details, I do use it in the multi-language and helps parts of my system. I want...

Without looking at the source code for Access, how can you know it's not possible? A great test would be to fire of two or more large append queries at the same time against a BE table from two (or more) FEs and see what happens. This video may explain better why I have a "reference"...

Thanks for all the help. I now have Burt Charles Smith copying like a mad man. My next step will be to add sequential numbers instead of date to the Entity code. New question for that. This page seems to have gone nuts on me wehen replying, and I can't see why. @moke123 Thanks for your...

Okay, I've taken a breath, and maybe it's time to go back to my original plan of using my own IDs and not autonumbers. For one thing, I always thought it was silly of M$ to assign them when the record goes dirty and now before update. My old designs had host codes on all record IDs to avoid...

If what MichaelRed says in the article is true, about two users being able to get the same autonumber for a table record at the same time, then we have a really big problem in the autonumber algorithm in Access. I'm so far using random autonumbers, and I'm the only person entering records. But...

It's just a reference number. The user can add/change to anything they want in the entry form. I just default to a sequential number that they can use or not. (However, for something like an order number, the user can't change these on a whim--so we have two types of usage. That depends on the...

Okay, I've been warned to link to cross posting and here is the one I just made with Richard Rost's site: Sequential Annual Coding in Microsoft Access (599cd.com) I don't think it will get answered anytime soon, I was mostly responding to one of his videos. I won't repeat what I wrote there...

I ran across some confusion on .Field(0), with some claiming it's always the ID and others saying no. So if it fails I'll go back to the field name proper. If I can remember how.

Yep, that post was about the copy, which I've solved. Even though moving to a new record became a later post in the thread. I tried to keep it simple this time, with just the basic question.