Visa Database

[Grumm]

I would give you examples with fields of your database. But what do you already have as database ? Can we get a demo version of what you have ?

 

[rascot123]

let me put this way.
I have four fields in my form.
ID#
VISA CATEGORY
COUNTRY
MEMO
in ID# will be 1,2,3 serial numbers. VISA CATEGORY will explain as :
Dubai tourist visa 1 month
Dubai tourist visa 3 month
Dubai leisure visa 1 month
Dubai leisure visa 3 months
Bahrain tourist visa 1 month
Bahrain business visa 3 months
Oman tourist visa 1 month
Oman business visa 3 months
so on......
Field of "VISA CATEGORY" in my form I need as a combo box.
I want to use combo box to search. Once I select VISA CATEGORY as combo box
whole fields have to change as per my selection of combo box. I hope you guys
got my point. Please explain in simple way, because I am growing student in this
field. I tried several time to achieve this skill. But I could not do. If I get favor from anybody a to z information I can do this.

 

[Grumm]

Since you asked for a demo :
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=64492&stc=1&d=1479292287

In the file you have a very limited database. And a form who show you how the combobox is working.
When you select a country, it will show you all the visa's from that country.
Hope that will help you.

 

[rascot123]

Dear Sir
I like your reply very much. I don't have much idea programming.
So I like only wizards in access and tables so on... as I usually do.
That is what only I expect from you too. This is the reason why I want you to
exucate me from you COMBO BOX

 

[Grumm]

Well, when you add a combobox in access, you can actually use a wizard to get the data you want. But yes for the second one you need a little knowledge of sql and vba.

 

[rascot123]

Do I need to know VBA just for creating a combo box for my simple database?
You can just give me how to do that in step by step wizard.

 

[Grumm]

Have you downloaded the file ?
You can see that there is some vba between the combobox of country to update the visa combobox.
So yes you will have to learn a minimum of VBA. That is why some people here asked you to see the videos : https://sites.google.com/site/msaccess457966vmfjg/form-controls/combo-boxes/combo-box-videos

 

[rascot123]

Great! I achieved what I want. I got idea of wizard in combo box. done.

How to hid table design view, table view?
because I do not want to show those things to users.
How to give password in my ms access database?
How to hide a box in my form? Once I need that hidden box I need to bring out that by a double click or by similar thing. How?
I hope you got me.

 

[rascot123]

Please reply to me.

 

[rascot123]

nobody reply to me pls reply.

 

[rascot123]

When you select a country, it will show you all the visa's from that country.
How to do this things ? Please reply also.

 

[Grumm]

Well in the RowSource proprety of the visa dropdown-box there is a query :

SELECT Visa_Category.Id, Visa_Category.Visa_Name FROM Visa_Category WHERE (((Visa_Category.FK_Country)=[forms]![Demo_Form]![Selection_Country])) ORDER BY Visa_Category.Id;

So basicly it will select all the visa records that are linked to the selected country.
Then there is a small VBA code to trigger the update :

Private Sub Selection_Country_Change()
    Dim ctlCombo As Control
 
    ' Return Control object pointing to a combo box.
    Set ctlCombo = Me.Selection_Visa
 
    ' Requery source of data for list box.
    ctlCombo.Requery
End Sub

Of course that code is a little overkill and can be done in 1 line. But this was only to show you vba code.
So yes, you need to know VBA code in order to program in Access.
(Or you can record macro's)

 

[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.