Visa Database (1 Viewer)

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
After I enter all datas nobody have to enter any more in any field except combo box field. In combo box field I need in property sheet in data tab
lock : No
How to do this.
 
Last edited:

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
In addition to fields, seldom I need a small window fly and come to the record
and display in form. Because in some record there will be special information.
How to do this please. I hope my explanation is clear.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 21:16
Joined
Jan 23, 2006
Messages
15,394
rascot,

There are many free youtube videos concerning vba, comboboxes etc.. Have you tried working through a few simple tests to get a better understanding of concepts?
Good luck.
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
Dear jdraw,
In went through many vba and combo box. Now I am not talking about that.
I am talking about sometimes I need display in my form screen some other information. That information will be extra, in addition to fields. But this extra
information will not come to the form screen in all records. Only some records, as per my requirements. It can be once I press a command button certain information have to display. Then again I will press the same button. Then it will vanish from the screen. I hope you got my point. Please comment.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 21:16
Joined
Jan 23, 2006
Messages
15,394
??Not enough info??
Perhaps you can give us an example or 2 showing specifically what you are experiencing.
It isn't clear to me:
- what the extra info is;
-where it is coming from;
-is it being stored somewhere;
-what command button and what associated code?
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
Let me put this in this way.

ID#
VISA TYPE
CUSTOMER RATE
DOCUMENTS REQUIRED
NOTES

I made a form as per the above field. I am talking about NOTES filed.
Sometimes there is no NOTES in some record. When there is NOTES in record
there NOTES field will display. Otherwise NOTES field will not display in a small window.
Can I get it done this way ?
I think this is called pop up. yes?
When I enter each record some times I will not have NOTES in some record, and some records
I have NOTES.
 
Last edited:

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
Just assume there is three fields
ID#
TYPE OF VISA
SUPPLIER
In supplier field I don't want it display in my form except I click a command button? Can I do that. How. Please reply to my question.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 21:16
Joined
Jan 23, 2006
Messages
15,394
If you have a form, and it is BOUND to your table, then
the control for Notes will display data if data exists in the Notes field of that record.
If the Notes field in the table is empty, then nothing will show in the Notes control on the form
for that record.

Good luck.
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
Dear jdraw,
I agree what you said. I know that also. I am just talking about pop up a small window when I press a command. As you said NOTES control will be showing even if data is not there. I need in different way. When I press a command button there should appear a pop up windows in small size. In case of there is no data in NOTES no need to appear. Even no need to appear empty control box in NOTES field. Now I hope you got my point.
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
I need a text box with around 20 line list in my form. Once I change record to record I don't want to change this list. How can I do this in my form just for display. The form is ready with me. Please comment.
 
Last edited:

Minty

AWF VIP
Local time
Today, 02:16
Joined
Jul 26, 2013
Messages
10,374
Just use an unbound text box and display the data you need in it.
If it is a list that you need to populate use an unbound list box.
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
I can drop text box on form. But I need data in text box constant in all record.
No need to change data in any record when I drop.
I just dropped label. But when I enter return button line not changing.
Please comment.
 

Minty

AWF VIP
Local time
Today, 02:16
Joined
Jul 26, 2013
Messages
10,374
What data do you need? if it's just free form text you can put a new line in the label by pressing shift & Enter at the same time.

If its a string and you are creating it in code then something like
Code:
strText = "Some text here and a new line" & vbcrlf & "Starts here"
 

rascot123

Registered User.
Local time
Today, 06:46
Joined
Jul 30, 2016
Messages
33
Dear Minty,
Excellent. That reply what I need. Thanks a lot. Worked out.
 

Users who are viewing this thread

Top Bottom