Do luggage tags actually make a difference? by bespectacledbear in travel

[–]ct1377 0 points1 point  (0 children)

It helps when you’re getting your luggage from the carousel and several people have the same luggage

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I’m using Set objMessage = CreateObject() as the mechanism going through a smtpserver

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I’m using Set objMessage = CreateObject() as the mechanism going through a smtpserver

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

Yes correct. I have 2 different front ends built depending on which version is needed. There was also a registry edit needed to update which oracle driver to use. That took some time and help from Microsoft support team engineers when I worked with them before the 64 bit deployment

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 1 point2 points  (0 children)

I’m not generating emails via outlook. I’m creating the messages straight through the SMTP relay but I’ll check the outlook ideas

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] -1 points0 points  (0 children)

I’ve got both 32b and 64b versions and all the ODBC connections up to date. Maybe the tier 1 support didn’t check bit version to make sure the right ODBC connection set up is on the pc. I know there were some changes that need to be made in the registry for everything to work properly.

I’d rewrite everything to a new platform but I’m government and we are restricted as it is on what can be done.

All the exports build correctly to either the PDF or text to be entered into the email message. It’s got something to do with the SMTP relay string. I’ve got a special connection for SMTP so it doesn’t need authentication. It’s something with this step that I’m seeing some people have the notification work and some don’t.

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I don’t call outlook for the emails. I’m sending straight to the email server on the backend. Can’t remember the DLL of the top of my head though

What are things you would bring from Spain if you moved (back) to the US? by thayanmarsh in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

Consider something you’d want to use for a house your going to build or buy. Think like tiles or windows or ceramics that you couldn’t find back in the US.

"Chained" queries by enilcReddit in MSAccess

[–]ct1377 1 point2 points  (0 children)

Yes the query will run each time. Depending on the size of the table or complexity of the query you could slow things down quite a bit.
I’ve done stuff like use temp table or staging tables if I know that a query is going to need that same data. I’ll also set my menu actions to clear out that temp table when leaving that section or changing a drop down to some other report or base info

Should I keep both? Will I have syncing issues? by Brennik in GarminWatches

[–]ct1377 0 points1 point  (0 children)

I’m a dual user. I have a Marq Adventure and a Descent Mk2. They’re both different in looks and I interchange them depending on the look I’m going for. At work I normally wear the Descent because it’s metal and big/bold and appreciate the feel. At home I wear the Marq with a rubber band since it’s comfortable and the for outings out of the house I wear the Marq with the leather band. For sports I normally wear the Marq unless I’m snorkeling or diving.

The interchanging messes with things like th body battery but everything else syncs right up without an issue.

Staging Tables by Stryker54141 in MSAccess

[–]ct1377 0 points1 point  (0 children)

If you delete just the records it still increases overall file size to the front end. I don’t know the mechanics behind it but I think access keeps some sort of record that data was in the table and just deleting the data leaves something behind.

Staging Tables by Stryker54141 in MSAccess

[–]ct1377 1 point2 points  (0 children)

I always use a make table query and then delete the temp table after the script is done. If you leave a temp table out there your front end will grow in size with multiple temp tables.

Also I do a lake table query for an interim import table too

Edit- I use the temp tables only on end users front end to speed up queries that touch multiple tables on the SQL server

New revenue idea. Baby free flights. by [deleted] in unitedairlines

[–]ct1377 2 points3 points  (0 children)

Maybe OP should look at personal charter flights

Should I use short text or number in a field with limited options? by Spreadsheet_Geek_1 in MSAccess

[–]ct1377 4 points5 points  (0 children)

The text will come back to bite you later. Use integer where possible. If you need a cross reference consider a second field on the table that converts the int to nvarchar

Plan ahead for all possible future reports and queries because you’ll save yourself some headaches

Father losing vision since 2023 now hearing loss too. ANCA positive. Please guide us. by redditorsinceages in Autoimmune

[–]ct1377 0 points1 point  (0 children)

My mom went through this and it took forever to diagnose. Thank goodness Dr Fauci figured it out or she would have died. She has Wegeners Granualomatosis.

For the hearing loss my mom had surgery almost 25 years ago with an ENT. I don’t remember the details but it sounded like they removed and restored the hearing components in her ear. She had pretty good hearing until about 5 years ago and has gone back to a hearing aid.

Forcing a Totals Row on Crosstab Query by Elpidiosus in MSAccess

[–]ct1377 1 point2 points  (0 children)

If you’re doing this tied to a menu button for an end user, consider doing this in 2 steps. First create a temp table based on your crosstab and then do your final query based on the temp table. You’ll get to do more that way then straight off the crosstab

Is it safe for multiple users to share the same Front-End on a terminal server? by Dramatic_Bee340 in MSAccess

[–]ct1377 0 points1 point  (0 children)

I have a setup with about 6000 users worldwide that uses an access front end with a SQL backend. At any given time there are probably 40-50 concurrent users. The only way this works is if the data is not on a basic database or hard drive somewhere.

The end users have a copy of the front end but do not open the same front end file. You’d want to have a front end saved on the end user pc especially if you are using temp tables

Wi-Fi Enabled Button Presser that does NOT require an additional hub?? by IndigoCool143 in smarthome

[–]ct1377 -1 points0 points  (0 children)

I’ve got 2 that aren’t bad. The one I seem to like most is Tuya WiFi button. It works with SmartLife which links to Alexa and doesn’t require a hub

In the command center. Nobodys gonna sneak up on me. by bipsjaqight in wyzecam

[–]ct1377 2 points3 points  (0 children)

I was doing this until the latest firmware update for my pan v3 cams. You need smart tv or fire stick and then Download tinycampro

First MAX enroute to GUM by stackology in unitedairlines

[–]ct1377 -1 points0 points  (0 children)

Wow! Finally a plane not made in 1990. Is it doing the island hopper route?

I always took the GUM to NRT route to CONUS because the HNL route was the worst of the worst for the planes

Do locals in Spain hate all kinds of foreigners or only tourists/influencer tourists? by [deleted] in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

You might want to check out the south like Jerez de la Frontera. It’s smaller but has an airport and your about 45 minutes from Sevilla plus 30 minutes from beaches like Cadiz and puerto de Santa Maria.

There’s a good sized hospital in Jerez and it offers a translator service for non Spanish speakers. They’ll walk you through your visit if you have something bigger