Database Question

klaus

Expert
Licensed User
Longtime User
I had a look at your program and made some changes:
- renamed buttons ex: Button8 > btnFind
- modifyed Sub btnFind
- modifyed Sub btnAdd
- modifyed Sort function
and some others.

Questions:
- Sort function, how do you see it, I modifyed it but don't know how you want working
- What is the Find function supposed to do ? In your code you remove the filter and do nothing else.
- What is the problem with Saving the Data ?
Is it saving the csv file with mnuSave or is it with your Save button?
For me both are working well.
- What is the cmbType_SelectionChanged routine supposed to do?
It seems that you want to enter more data?

It seems that there is a kind of mix up between the content of your csv file and the headers.

I made the changes according to what I suppose the different functions should do, but it is dificult to give you good advices without knowing exactly what you want to do.

Best regards.

EDIT removed source code
 
Last edited:

wm.chatman

Well-Known Member
Licensed User
Longtime User
Hi Klaus

Ein herzliches Dankeschön
Es ist schön, wieder von Dir zu hören und Danke für deine schnelle Antwort!
werde deine Fragen folge leisten, melde mich zurueck.
Let me think about how to Answer to each Q correct, so they could be understood.

Mfg
WmC
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
Danke Sehr für deine schnelle Antwort!

I will try to Explain :
- Sort function: I want to sort the db either by txtArea or txtDepth or txtMaterial,using the correct txtBoxes.
- Find function: enter a Search criteria for TxtArea, txtDepth or txtMaterial using TextBox txtArea, txtDepth, and txtMaterial to find one oft the three using the correct txtBoxes.(suche nach something) This way i am able to search for one of the three. Problem with saving the data: I thought this did not work correct. If it does, thats even better.
- cmbType_SelectionChanged : add data if need be in txtAre, txtDepth, txtMaterial.
- One thing I did forget Klaus, I do need a Datums eingabe feld, for DataFound !

Hope this will Help to Understand how this is suppose to Work.

Danke Dir Klaus
William
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
Bitte die Zeilen kennzeichnen wo Fehler vorhanden waren
Please let me know where the misstakes were made..
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
Dir Klaus

after testing, Search (Find) for Chatman, the comButton btnPrev, btnNext do not respond.
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
Dir Klaus

after testing, Search (Find) for Chatman, the cmdButton btnPrev, btnNext do not respond.
With menuBar Prv and Next we have the same Problem
Also adding new Data does not work anymore the txtBoxes stay Populated and will not allow to add new data into txtBoxes
 
Last edited:

klaus

Expert
Licensed User
Longtime User
Sort function:
you can sort either
- in the menu where you have 3 possibilities to select
- or with the Sort button this one sorts the table according to the selected field in the menu.
You say : I want to sort the db either by txtArea or txtDepth or txtMaterial,using the correct txtBoxes.
The Texboxes have nothing to do with that. You must select the filed that you want to sort and this is done in the menu.​

Find function:
I implemented it that way:
- click onto the Find button
- the TextBoxes are emptied
- enter the search criteria in the respective Textboxes and click on the same button. You can notice that the button text is changed.
- the table is filtered
In the case you mention, with Find Chatman. There is only 1 record so the Next and Prev buttons have no effect because there is no next and no previous record. If you enter search criteria in mode than one TextBox the table is filtered according to the non empty fields. If all three are empty the filter is cleared.​

- cmbType_SelectionChanged : add data if need be in txtArea, txtDepth, txtMaterial
What kind of data do you want to add, in what field. How do you want to save them. How to go back from that function.
I am afraid that using the same TextBoxes for different data entries would be confusing for the user.​

To enter a date, the Calender control would be the best one.​

To see the changes I made is very easy, you open B4PPC, load the old file. Open a 2nd one B4PPC and load the new file. In that way you can compare both source codes side by side. I would have to do the same to find the changes.​

As said before, there is a mix up between the content of the csv file and the headers. You have for the first record:
Area: Blue
Datum: Floride
Material: 123456789
Type: Silver​

It would be a big advantage, especially for testing, to have a concret data file.​

Best regards.​
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
Ein herzliches Dankeschön

schön, wieder von Dir zu hören und Danke für deine schnelle Antwort!

1. Hier möchte ich ein Gebiet auswählen können (Fund Eingabe), und auch als Add Eintrag wenn Auswahl = Find. Dementsprechend werden dann auch die anderen txtBoxen Populated.
2. Hier nach Datums Suche, dementsprechend werden dann auch die anderen txtBoxen Populated.
3. Müsste eigentlich eingabefeld für Datum sein. Wird ein neuer Fund gemacht, gibt es die Möglichkeit das Funddatum hier einzugeben. Zb. Add
4. Diese txtBox beinhalten mehrere Materialien zur Auswahl. Zb. Eisen, Silber, Gold, Bronze, Kupfer, halt die Buntmetalle. Also hat diese ComboBox mehere Einträge (Ausswahl) für den Anwender, aber auch das Wort Material selbst ist vorhanden. Wähle ich Material kann ich so auch andere Eigenschaften eingeben zb. Spore, Pfeil, Lanze, etc.
5. Links neben dem LabelMaterial = 4fett, ändert sich die Eigenschaft je nach auswahl das Materials, Nummer 4 rechts des Bildes.
6. Der letzte Post, ist eigentlich das Original. Müssten nur ein paar Änderungen vorgenommen werden,
7. Add/neuen Datensatz einfügen clears all TextBoxes of there Properties, und wir können neue Daten einfügen.
8. Wie gesagt Klaus hast Du jetzt dass Orginal und ist für meine Zwecke nutzbar.
9. Bei weiteren Fragen bitte Kontaktiere mich einfach.
10. I know ist hard to Understand what I write, or say what is „needed“. Please stand by...
11. I am not a man to Forget things… exept my last Wife!

Hope Getriebe/Transmission Arrive in 14 dys. Sick last weeks…
If I could get my Head clear it might help
Not to forget B4ppc, it’s a new try… working with Tb now, I need to get used to it.

PS. Danke für deine schnelle Antwort! Thank you for your Quick Answer!
Again, thank you. and Forum
Best regards
William
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
hi ceaser
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
sorry, forgot the E v
 

wm.chatman

Well-Known Member
Licensed User
Longtime User
TRUIdb Update:

Hi

Thank you Klaus for your Patience, your Help, and your Quick Response.

Starting to look like a good db UI, this is cool. Without help I would be down under. I like it.

How can I Populate tb2 with the Excising data from tb1 automatically?
Added a Hide and Show function for tb2. Still need to get straight with the Button Hide / Show function.
Button Hide / Show Tb2 could withstand a test; it takes two clicks for a respond. Do not know why?
Also, I still do not understand the FIND Situation? It works great for Area (Object/Datum) not tested yet. But how do I move to the next data sentence please? Material = Objekt now.

Respect Klaus, ohne hilfe geht wenig.

Thanks Sir
have a nice wk end Klaus. Wuensche Dir Gesundheit

Best regards
William
 

wm.chatman

Well-Known Member
Licensed User
Longtime User

to all users: have a nice WE
 

klaus

Expert
Licensed User
Longtime User
Here is an updated version.

Changes made:
- updated csv file, in the table the 2nd column is object in the file it's date
- updated put txtObject and txtDatum at the right place
- loading table2 done, why do you need it, Table1 could do the same
- button "hide" OK in Globals tb=1 should tb=2

The FIND function filters the table according to the content of the textboxes.
If you want the FIND function find the 1st matching row without filtering, this must be done by code by testing each row if it fits the find parameters.

Best regards.

EDIT: removed the source code
 
Last edited:

wm.chatman

Well-Known Member
Licensed User
Longtime User
ja, ja this i had seen also but I know it had only been fisible = false, was working on using tb2 darn it.
also made changes to a cpl of lbl headers on frm.

Gebiet/Area
Funddatum/Data found
Objekt/Object

(The FIND function filters the table according to the content of the textboxes).
correct, this I understand Sir

Specci48 gave me a nice thougt using lb
Q: is it possible to receive a click reaction from tbl?


Thanks very much Klaus!

Best regards
William

melde mich spaeter
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…