Visa Database

[rascot123]

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.

 

[rascot123]

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]

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]

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]

??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]

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.

 

[rascot123]

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]

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]

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]

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.

 

[Minty]

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]

How to put an unbound text in form ?

 

[Minty]

Click on text box in the designer ribbon. Drop it on your form.
I would strongly suggest you do some video tutorials and follow them through to get the basic concepts of Access. You are trying to run before you can walk at the moment.

http://www.access-programmers.co.uk/microsoft-access-tutorials/

 

[rascot123]

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]

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

strText = "Some text here and a new line" & vbcrlf & "Starts here"

 

[rascot123]

Dear Minty,
Excellent. That reply what I need. Thanks a lot. Worked out.