some issues with DB form

[ghia]

Hello!

im a rookie in Access and VB, i have been trying to finnish a database in a couple of weeks and im at the end of designing it.
i tried chatgpt and Claude to solve my problems in the form, but having trouble getting a solution thru AI.

if you like to have a look at my sample database i would appreciate it a lot.

my problems in priority order:

1: when i switch tabs or use a button in the form, the subform flickers when updating i guess, this i would like to be resolved to make it more appleasing
2: i dont seem to get rid of the "window" marked in Picture as "#2"
3: the two searchboxes "objektnamn1" and "sök objektID" im trying to get a interactive search in, my goal is that while im typing part of the name, i want a dropdown list of the objects that matches with what im typing.
4: i have locked some fields from being edited until i pressed the "redigera info"-button, then it locks back again when i switch post, but this function seem to have stopped working, while designing the form, maybe i could get a "save"- button to lock them again.
5: all in all im open for suggestions in the design and coding to make it look better and work better.

 

[Gasman]

That 'long bar' is a record selector. It is that large due to the depth of your detail section. So just set record selectors to No.

 

[ghia]

That 'long bar' is a record selector. It is that large due to the depth of your detail section. So just set record selectors to No.

sorted, thanks!

 

[Gasman]

For 3, I would use @MajP's FAYT code

Find (Filter) as You Type Controls (Combobox, Listbox, Form)

Here is an Find/Filter as You Type (FAYT) class. This allows you to find/filter lists of comboboxes, listboxes, and continuous forms. The class helps create the capability with a single line of code to instantiate the class. You need to import the class module. Then instantiate a FAYT...

www.access-programmers.co.uk

I would also not have spaces in field/control names or characters like #
It would help if you said which controls are meant to be locked/unlocked?

 

[RonPaii]

I found that when working with AI and Access is to keep reminding it that you are looking for Access specific solutions. It tends to drop into VB or VB.Net type answers.

 

[KitaYama]

I found that when working with AI and Access is to keep reminding it that you are looking for Access specific solutions. It tends to drop into VB or VB.Net type answers.

You may know it, but if you don't :

If you use ChatGPT, you can create custom versions of ChatGPT that combine instructions, extra knowledge, and any combination of skills in a specific purpose. Each of them are called GPT and each GPT is a specialized ChatGPT made for a specific course (Programming, Excel, Politic,....)
When you ask your question in a GPT, you receive much more precise, accurate and more in depth answers. And replies are limited only to the selectd branch.

For example if you add an Access GPT to your account and ask a question in that GPT, all answers will be limited to Access.
Here's a part of my GPTs.

If I click Ms Access Copilot and ask a question, I won't see any answer about VB or VB.net. All replies are specific to Access.
There are thousands of GPTs, and you have to find a suitable one for your questions.
To add a GPT, simply click Explore GPTs in your left navigationbar and search for one.

I use only ChatGPT, but I think other AIs offer similar services too.

 

[mike60smart]

Hello!

im a rookie in Access and VB, i have been trying to finnish a database in a couple of weeks and im at the end of designing it.
i tried chatgpt and Claude to solve my problems in the form, but having trouble getting a solution thru AI.

if you like to have a look at my sample database i would appreciate it a lot.

my problems in priority order:

1: when i switch tabs or use a button in the form, the subform flickers when updating i guess, this i would like to be resolved to make it more appleasing
2: i dont seem to get rid of the "window" marked in Picture as "#2"
3: the two searchboxes "objektnamn1" and "sök objektID" im trying to get a interactive search in, my goal is that while im typing part of the name, i want a dropdown list of the objects that matches with what im typing.
4: i have locked some fields from being edited until i pressed the "redigera info"-button, then it locks back again when i switch post, but this function seem to have stopped working, while designing the form, maybe i could get a "save"- button to lock them again.
5: all in all im open for suggestions in the design and coding to make it look better and work better.

Hi
I took a quick look at your Database which is in fact 1 Table which you have copied from an Excel File.

Points to note are as follows:-
1. that you should not use spaces in field names
2. you should not use any of the following characters in field names !"£$%^&*()_+-=][}{#'@:;?/.>,<

You are recording details of Multiple Landowners in the one table when their details should be in a Related Table.