Gemini and Access VBA

Does anyone else using Gemini to help them code?

Gemini tells me that a lot of access developers are.

So far it hasn't cost anything, and I hope it stays that way.

Gemini can code useful utilities really quick, and clean up code, and easily create otherwise difficult sql statements.

Sometimes we discuss the best way of doing things, the pros and cons.

reddit.com
u/Key-Lifeguard-5540 — 10 days ago

The back end still doesn't know what front end changed the data

The back end engine (using linked tables) should automatically peek at the network packet header and grab the calling computer name natively during a data change, so that if you are logging data change events in the back end, it will at least know what machine made the change! They've had 15 years to do this, they should have done it by now imo.

reddit.com
u/Key-Lifeguard-5540 — 18 days ago

The dreamworld vs TV

TV is lame compared to the dreamworld. With TV you can watch someone's made up story, but in the dreamworld you are a participant and it all seems rather real. Sometimes I feel like I am spying on people's lives. I'm there as much as anyone else, perhaps more so, because I am also aware of my secret self that no one can see. What a lovely beach house I was in this morning. The few people living there are renters. On the beach side, people on yachts wave to you as they go by. It's like we live in four different realities, this physical reality, an imaginitive reality, the dream reality ,and the inner reality. TV is like imagination. The inner reality is by far the most foreign to our present physical reality.

The inner reality encompasses everything and sees far more than this little segment, and yet, if you realize what you really are, the perspective within this focused reality is completely different. Here in this forum I can talk about things that are useless to talk about in my daily life. The Seth material is the closest thing I have found to the greater truth, beyond this present life, it validates. How is your state of being this morning How is your physical body and all its sensory adaptations. Can you take a moment off everything.

reddit.com
u/Key-Lifeguard-5540 — 1 month ago

Simultaneous Lives

Since a so-called past life I have witnessed was completed, shouldn't this present life also be completed as far as my more expansive inner self is concerned?

My inner self and reality are tricking me into thinking that time is a real thing and that I am causing things to happen in this dream-like state.

I am an actor on a stage, imagining that I am doing things, along with everyone else.

I sense that none of the props are terribly significant, in the end all that matters is how the inner self benefits from this game of many lives.

There are legions of beings congregated beyond time and space, all benefiting from all that is happening here.

We can go as deep into dreamland as possible or necessary, but we will always wake up from this.

The more I ponder this, the more wondrous this reality seems.

Everything seems so beautiful, and yet tragedies happen every day.

But what is the tragedy, someone you love terribly is suffering or dying.

I think of the song, lessons in love.

That's all that's really happening.

In a beautiful land.

reddit.com
u/Key-Lifeguard-5540 — 1 month ago

What happens when you die?

What I think is, first you must realize you no longer have a physical body. That adjustment will depend on your beliefs. It's better to keep an open mind. Next you will exit this physical dimension and find yourself examining the life you just experienced, so that you can completely assimilate what just happened from all perspectives. You will realize that you have lived other lives and that you are not any one of those personalities, you are something more. What happens next I am not sure of, but I think it depends on the progress your overall being has made. Worst case you are still deeply attached to physical reality, wandering on some astral plane, anticipating another chance to incarnate. Best case you are very much aware and easily abandon any attachments and re-join your spiritual family on some more advanced plane where opportunities are more variable. I think Seth says something similar but feel free to educate me, thanks and have a great day.

reddit.com
u/Key-Lifeguard-5540 — 2 months ago

I am a valid being

Why does that sound funny.

What if someone said to me, 'you sir, are not a valid being'.

Sorry but we are not accepting any more applications this week for valid beingness.

Have a nice day..

reddit.com
u/Key-Lifeguard-5540 — 2 months ago

Annoying Access Features

The "AutoIndex on Import/Create" Feature. Who needs this. I imported my tables into a new database and it added so many new indices that it deleted some relationships, to make space for the indices I guess.

reddit.com
u/Key-Lifeguard-5540 — 2 months ago

Amazon more expensive than SDM

Disappointing that amazon is 20% more on items such as popular shampoos than Shoppers Drug Mart.

If you don't price compare amazon will take advantage of you.

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

Reincarnation tree

I can't imagine what a reincarnational tree might look like. We could jump from one family tree to another, throughout the centuries, in different parts of the world. It makes me think that from a reincarnational pov we are probably all more related than we imagine.

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

Spontaneous OBE

Is it ok to relate an OBE that I had where I didn't use the tapes?

I have since purchased the hemi-sync tapes but have not yet succeeded in having the same depth of experience.

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

Hello

I'm new here and I know that both the afterlife and beforelife exist, at least, I have my own proof.

Also, communication with those that see things that we may not see, also exists, in various ways, from visions to dreams to coincidences to visitations.

The unknown may seem frightening at times, but i've learned that nothing can harm me unless I allow myself to get involved, so I am never at the mercy of what I don't know.

With ability comes responsibility, but nature has built-in protections, otherwise someone would be able to destroy everything.

We have free will, no one is forced to participate.

The decisions we make on the other side may seem inexplicable now, but are for our own good.

Man, in his weakest state, forces his will upon others, not understanding the coarse he has set up for himself.

No one is perfect, and yet everything is perfect

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

Many lives

What I tell you I swear is the truth.

I went out of body while wide awake, healthy and sober, and travelled to a place where I saw what appeared to be a large card file, where each card had the vital statistics for a life, name, date of birth and death, place of birth.

I actually floated above the file, and the cards would part, and I could enter a life and 're-live' it in a way that would completely blow your mind.

It was like I had a god-like view of the life, I could feel everything totally from everyone and know everything.

I was a female in my last life in eastern europe where my ancestors are from.

I was a maid/slave in a land owner's country estate house.

The life I am having now is far better.

So i know without a doubt that we live many lives, or that at least I have.

It makes sense because why would we only live one life.

How can we grow in wisdom and experience from just one short life.

This current life has been peppered with unusual experiences, i always look forward to what may happen next.

I hope I don't get banned from this subreddit because its a drag to have your posts removed.

I was recently banned from r/afterlife because I speak like I am an authority on things, and yet I am only talking from experience. A lot of people seem to be afraid that they might get an afterlife review, so the last thing they want to hear is that they will be given that opportunity because it's a natural part of our learning/awakening process.

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

Prime wasn't saving me much on shipping because I don't need things the next day

So that leaves the movies and to be honest I didn't mind paying for prime just to get the movies however the pay extra for no commercials went too far. They lost me over a couple of extra dollars which I guess they really need. I think their marketing strategy is a loser.

reddit.com
u/Key-Lifeguard-5540 — 3 months ago

What do you do?

If you buy something and before you even receive it you notice the price has dropped by 30 percent. You would like to return it and purchase it again at the lower price, right? But then if you're honest about it, they want a restocking fee that makes it not worth returning. So what do you do? You open the box and say it's damaged so you don't get a restocking fee. Duh. Lol.

reddit.com
u/Key-Lifeguard-5540 — 4 months ago
▲ 3 r/bell

I'm done with bell, changing providers asap

Their data connection around Brampton is totally unstable and they keep raising the price of my plan and they only offer 1 plan for people that have their own phone, a plan which has way more data than I need and too expensive. What a joke, years ago you had to pay through the nose for data and now all they offer is way too much data. Also, home internet gets slow during the evening and stops working occasionally.

reddit.com
u/Key-Lifeguard-5540 — 4 months ago

Help with error 2114 - Microsoft Access doesn't support the format of the file, or the file is too large

How do you guys display a logo in your reports?

I use an unbound image control, and when the report opens, I pass the image control to a procedure that sets the picture property to the path of the logo (jpg or bmp).

I have error trapping in all my procedures and functions, and error 2114 is the only error I ever see, and it happens usually once a day, and it can happen on any machine, in any report.

One of the users suggested that it might be associated with the error 'cannot open any more databases' - if they get that error and then try to run a report, it is simply out of memory, but I can't seem to replicate the error myself.

Below is a sample of the code.

It doesn't matter if myPath points to a jpg or bmp, the logo is a small file less than 200k on the server.

Image1 is an embedded image object with no control source, that is used to display a logo.

Private Sub Report_Open(Cancel As Integer)
   Call myDisplayLogo(Me!Image1)
End Sub

Public Sub myDisplayLogo(ByRef objImage As Access.Image)
On Error GoTo Error_myDisplayLogo
   Dim myPath As String
   If objImage Is Nothing Then Exit Sub
   If TypeName(objImage) <> "Image" Then Exit Sub
   myPath = myDatabasePath() & myLogo()
   If objImage.Picture <> myPath Then
      objImage.Picture = myPath
   End If
Exit_myDisplayLogo:
   Exit Sub
Error_myDisplayLogo:
   LogError Err.Number, Err.Description, "myDisplayLogo", , False
   Resume Exit_myDisplayLogo
End Sub
reddit.com
u/Key-Lifeguard-5540 — 4 months ago