Search found 6 matches

by schnoesel
Tue Oct 10, 2017 9:57 am
Forum: Deutsch
Topic: Leere Datenbankeinträge ignorieren
Replies: 1
Views: 4661

Re: Leere Datenbankeinträge ignorieren

Habe mein Problem selbst gelöst. Ich habe nicht die Filtermaske benutzt, sondern die SQL-Abfrage. Mittel EXISTS-Funktion und IF-Statement konnte ich prüfen ob meine Zeile/Datensatz mit meinen gewünschten Parametern vorhanden ist. Falls ja, konnte ich diese also einfach abfragen. Falls nicht, greife ...
by schnoesel
Tue Oct 10, 2017 9:55 am
Forum: Label Design & Printing
Topic: Filter via Visual Basic or deactivate failure messages
Replies: 3
Views: 1423

Re: Filter via Visual Basic or deactivate failure messages

I solved the problem on my own. I made a manual SQL-Filter. I made a IF statement with the EXISTS-function. If the row was existed, then I made the filter as I wanted (with the second row) and if not, I changed the column/row to something empty but existent.
by schnoesel
Fri Sep 29, 2017 3:14 pm
Forum: Deutsch
Topic: Leere Datenbankeinträge ignorieren
Replies: 1
Views: 4661

Leere Datenbankeinträge ignorieren

Hallöchen, Ich besitze zwei Datenbankzugriffe für zwei verschiedene Filter. Nun ist je nach Filter die eine Datenbank leer (bzw. es gibt halt keine Ergebnisse): ID Dog Line Text 1 apr 1 This is text for 2 jam 1 Hey there i am 3 apr 2 my little fella 4 bob 1 check this out for what 5 jam 2 not very a...
by schnoesel
Thu Sep 28, 2017 5:02 pm
Forum: Label Design & Printing
Topic: Filter via Visual Basic or deactivate failure messages
Replies: 3
Views: 1423

Filter via Visual Basic or deactivate failure messages

Hey there, I have a data base like the following: ID Dog Line Text 1 apr 1 This is text for 2 jam 1 Hey there i am 3 apr 2 my little fella 4 bob 1 check this out for what 5 jam 2 not very amused ... In my form I filter by "Dog". Then I want to have the text on my label: For Dog "apr" it is "This is ...
by schnoesel
Thu Sep 28, 2017 4:51 pm
Forum: Label Design & Printing
Topic: Lookup-Table in Visual Basic
Replies: 2
Views: 1362

Re: Lookup-Table in Visual Basic

Thank you very much. This helped a lot!
by schnoesel
Tue Sep 26, 2017 4:42 pm
Forum: Label Design & Printing
Topic: Lookup-Table in Visual Basic
Replies: 2
Views: 1362

Lookup-Table in Visual Basic

Hey there, I'm using NiceLabel Pro and I have an issue regarding lookup-tables for pictures in VB. I have a variable (VARI) which can be empty or not. I placed a picture on my label with the VB-script: if VARI = "" then Result ="" else Result = "Path to picture" end if I have a lookup table like thi...