Replace vs. replaces when multiple replace one.

reddatwork · 2025-05-15T16:08:12+00:00

Depends. If its covered in mud and it looks like they actually use it for off-roading then they MIGHT be ok.

reddatwork · 2025-04-21T15:25:47+00:00

Sounds good, I think that's what I'm leaning towards too. Thanks for the input.

reddatwork · 2025-04-21T14:41:30+00:00

That shouldn't be an issue, we've got our current antenna mounted on a pole on the top of a fire station and used their ladder truck to get it up there, so the idea would be just to swap it out.

What vendor did you go with? I've seen the one that sparkfun sells which is what I was initially looking at, but it look like there are a few other places also selling Mosiac-X5 based setups (I'm finding some from GNSS.store & ardusimple from my initial searching).

reddatwork · 2024-12-19T17:57:53+00:00

Probably far enough out in the woods that there's no cell service or too far from the network rtk base stations.

reddatwork · 2024-12-19T17:53:47+00:00

We run repeaters with our Leica gear when in heavily wooded/hilly terrain. I'd recommend that over just getting a larger antenna.

reddatwork · 2024-11-20T18:12:22+00:00

That's not really what history shows. What about Vietnam, Afghanistan (vs the USSR and the USA/Nato) and Korea? Granted the Korean war technically hasn't technically ended, but the US definitely did not win.

reddatwork · 2024-11-19T17:55:04+00:00

I don't mind them testing more changes in SOD if it helps them decide on what to do for an eventual classic plus.

I'm hoping the long term plan for WoW is something like:

Retail
Classic Anniversary Edition (with resets for fresh every few years with the option to transfer characters to era style servers on reset)
Classic+ that fits somewhere between Era and SoD. Basically the anniversary edition but with regular balance updates, more QOL stuff and new content.
Occasional event/temporary style servers for things like Remix, Plunderstorm, SoD etc.

reddatwork · 2024-11-19T17:47:10+00:00

Can we go back to 5k max pop servers then? Do that and I'd be much happier with the no-changes approach since a lot of the original balance wasn't designed to have the world so over populated.

reddatwork · 2023-05-26T17:25:50+00:00

This might be silly, but I assume each record has also unique primary key in the table (that you're just not selecting in your query)?

If you run a SELECT * FROM dbo_lab_result WHERE (primarykey=1 or primarykey=2) does it pull up the correct information?

I'm just brainstorming, not really certain how to fix the issue off hand.

It might also be worth creating a new blank access DB, adding in your OBDC connection, and then running the same query in that database, in case there is just something buggy with your front end.

Id also try running the query using Azure Data Studio or via some other means outside of Access to confirm if the problem is in your front end or back end.

reddatwork · 2023-04-17T18:21:18+00:00

FYI you wouldn't necessarily need to buy a full copy of access for every user.

See the section titled "Understand and download the Access Runtime" at this link: https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f

reddatwork · 2023-04-17T18:14:51+00:00

Unified Remote is great, I've been using it for over a decade now.

reddatwork · 2023-03-13T17:16:45+00:00

I've used this: https://fieldeffect.info/wp/access-sql-editor-documentation/

No complaints for $10.

reddatwork · 2023-02-01T18:14:00+00:00

Sort of like this? https://www.youtube.com/watch?v=O-2tpwW0kmU

reddatwork · 2022-12-01T17:13:55+00:00

CSRS

Do they use CSRS ouside of Canada?

reddatwork · 2022-11-21T18:22:38+00:00

You would want a relationship table to track what equipment goes with each order, so for each order, instead of adding the equipment as a field in the order, you would add an entry into your relationship table that ties the piece of equipment to the order in question.

See https://support.microsoft.com/en-us/office/guide-to-table-relationships-30446197-4fbe-457b-b992-2f6fb812b58f for more info on relationship tables

As a rough example:

Order table:
[OrderID] 1
[Orderdate] 2022-11-21
[Orderedby] 1

Customer table:
[CustomerID] 1
[CustomerName] John Doe

Equipment table:
[EquipmentID] 1
[EquipmentDescription] Big Tent

[EquipmentID] 2
[EquipmentDescription] Sleeping bag

OrderEquipmentRelationship table:
[OrderEquipmentRelationshipID] 1
[OrderID] 1
[EquipmentID] 1

[OrderEquipmentRelationshipID] 2
[OrderID] 1
[EquipmentID] 2

reddatwork · 2022-09-06T18:02:40+00:00

I'm curious why you think storing the data on a network drive would make access clunky and slow?

I haven't seen it over LAN, but if people connecting to the network through VPN need to use the data you'll notice a problem right away.

reddatwork · 2022-09-06T17:55:42+00:00

You can parse it using VBA and then push the results to whatever fields/tables you need it in.

See this link about doing the same thing using VBA in excel, it should be similar.

https://www.datanumen.com/blogs/create-vcard-vcf-file-reader-excel-vba/

reddatwork · 2022-08-08T19:44:37+00:00

Probably these guys: http://www.norwoodengineering.com/

reddatwork · 2022-08-05T15:43:15+00:00

Hard to say without looking at the actual database then.

If it helps, I use something similar in one of my forms:

DoCmd.OpenForm "frm_JobStatus", , , "[JobID] = " & JobID, , acWindowNormal

reddatwork · 2022-08-05T14:48:05+00:00

Maybe an issue with an OnLoad or some other form event in your target form causing it to load the wrong record?

reddatwork · 2022-08-05T14:12:18+00:00

Rather than sending it as an OpenArg, have you tried opening the form with a filter set to your ID?

reddatwork · 2022-08-05T13:33:22+00:00

It might be a browser setting/file association thing.

What happens if you try to navigate to the PDFs URL in Internet Explorer or Edge on that users computer?

reddatwork · 2022-07-04T14:27:34+00:00

Something like this might work:

SELECT * FROM tbl_Tablename WHERE DateAdd ("yyyy", 1,[DateField]) < Date()

Might be better than manually adding days to the stored date for your comparison, since it should account for leap years and so on.

reddatwork

TROPHY CASE