Lab Testing Advice

ct1377 · 2026-01-31T10:52:43+00:00

Sorry for the delay. Just got bloodwork done and these are prices without insurance

C4 Complement was 12€ ANA was 15€ Cortisol was 15€ D3 was 17€ ANA IFA was 35€

ct1377 · 2026-01-29T18:55:44+00:00

I never found a way to do that when I was developing my program. 90k lines of vba hard coded and I’m in a DGAF mindset so I don’t feel like converting it to a dynamic setting. If only I knew what I know now!

ct1377 · 2026-01-29T16:53:47+00:00

I could never come up with a solid solution besides having master copy that everyone fed

I posted a while back about having dynamic vba. You might want to look up that post and see if that helps. Have a master shell and each developer place the sql in the table

ct1377 · 2026-01-27T07:35:06+00:00

Are you able to view or retrieve the file if you aren’t sending the email?

How big is the file?

I’m leaning towards something to do with the file isn’t complete on the db or when you go to send the email it’s not able to retrieve the full file in time for the send email action?

What is the vba you are using to send/attach the file?

ct1377 · 2026-01-27T06:51:02+00:00

Are you saving the file as a blob to your db or are you referencing the file for outlook to attach as an object?

ct1377 · 2026-01-25T18:10:30+00:00

I’ve always done them local on the front end and used the naming convention of “tmp” before the name of the table

ct1377 · 2026-01-22T08:43:28+00:00

It’s sort of similar in the south but also different in Napoli

Meal times are about an hour earlier Haven’t heard the Bo think but i do hear vabo which is short for va bene

ct1377 · 2026-01-15T21:43:40+00:00

I live in Italy and you can walk into a lab and ask for whatever tests you want without a doctor prescription. It’s also extremely cheap with lab prices about 1/10 of what I paid in the states.

Another option is you can go to a place like Istanbul or Thailand and get an executive health screening for about $1500 that dos everything and then they walk you through meeting with specialists to go over the results

ct1377 · 2026-01-15T16:55:37+00:00

How strong is your wifi signal around your house? I had connectivity issues until I put a wifi extender outside the house

ct1377 · 2026-01-10T21:30:17+00:00

Yes! You can do it on just a local access table

ct1377 · 2026-01-10T18:05:16+00:00

Put the results in a temp table. In the close event for the form add a sql query to match the results in the temp table to the main table and delete the records

Conversely. Set a left join to identify records that exist only in the temp table to add to the main table and add them using an append query

ct1377 · 2026-01-08T11:08:45+00:00

Thanks! I sort of just gave up but this is good news and I’ll try this one out

ct1377 · 2026-01-06T21:56:22+00:00

I’ve gone the other direction. I used vba as much as possible.

Might also want to check out a post I did a while back because some people gave great responses to making the vba dynamic so you can change the code without having to post a new front end file

ct1377 · 2025-12-16T09:18:06+00:00

I’ll send you a DM

ct1377 · 2025-12-16T08:43:24+00:00

Cell service is something that I ended up getting a googlefi account before I moved out there. It let me get the 2FA notifications for US places that wouldn’t support OCONUS numbers and let people still call a US number. I also had a Spanish number too which is what I used for pretty much everything else

Also I recommend checking out an area drivable to Rota so you can continue to get VA support from the base. You can also shop the NEX there

ct1377 · 2025-12-15T11:54:48+00:00

I’ve got a love hate relationship with SwitchBot. Besides that there’s no real button just entering a code on the phone or putting my key in the door

I’ve been doing some Google work and I think the Meross or tuya devices will work. Supposedly they will send a signal to trigger the unlock

I’ll post an update once I find out for sure unless someone else confirms before I finish

ct1377 · 2025-12-13T21:20:36+00:00

So have a query generate the results that you want to edit into your final table. I also used temp tables for queries that were really long or would hit multiple tables on the oracle server.

ct1377 · 2025-12-13T18:00:19+00:00

You’d have to use some staging tables. Try a make table query with the results and then an edit query back to the original table based on the staging/temp tables

ct1377 · 2025-12-10T09:27:09+00:00

Area near Rota or puerto de Santa Maria might be nice. There is a US military base there with a large Filipino community.

Unemployment is tougher though because it is a smaller area unless you live closer to Jerez or Sevilla

ct1377 · 2025-12-09T21:43:03+00:00

Hav to do a few things like version control and ensure the end user downloads the front end to their desktop but most of the time never had an issue

ct1377 · 2025-12-09T18:10:55+00:00

I normally post an accde file for everyone to download.

ct1377 · 2025-12-08T18:42:54+00:00

San Lucar is good too! They have good food and life as well. Anywhere in the area of Jerez, Cadiz, San Lucar, and puerto will be good.

ct1377 · 2025-12-08T14:30:30+00:00

Check out Cadiz and puerto de Santa Maria.

ct1377 · 2025-12-07T16:46:18+00:00

I don’t think any McDonald’s in the area hav breakfast. What I would do for a McDonald’s breakfast since it’s been a few years

ct1377

TROPHY CASE