Visa Database

R

rascot123

Registered User.
Local time
Today, 10:51
Joined
Jul 30, 2016
Messages
33
I would like to create a database for visit visa business.
Fields are as below :
ID#
Country I want country selected from list.
Type of visa e.g. : tourist visa 1 month, tourist visa 3
months, leisure visa 1 month, leisure
visa 3 months
Days e.g. : one month visa, 3 months visa
Customer rate e.g. : selling price to customer
Processing time e.g. : some visa will process in 7 days, some visa
within 10 days and some within 15 days.
Documents e.g. : documents have to submit to Embassy
(passport, Photo etc...)
Please comment how to arrange and what are the options I can include in form etc....
 
Did you already tried something ? Or do you want us to give you a working solution that meets all your requirements ?

I would start by making a diagram with all the tables/enums. Once you have a basic layout of the database, check if you can normalize it. Once that is all done, you can start making forms.
 
Looks like you already arranged it. Also add these lookup tables:
countries
length of visa
rates
process times
documents

and if needed, a child table to the Visa, tClientDocs, to hold the signed documents.
(but this may not be needed)
 
In form for example in two field how can I resize one field ? When I select field
automatically selecting all fields. Please comment.
 
Not sure what you mean. You don't resize fields when you enter data.
If you mean you want to alter the design of the table fields,
Then just edit the table design and change the field size.
 
Yes, I mean I want to alter the design of the table fields in form.
To alter what is the step please. In menu what to do. When I try to click one field and move to increase/decrease size all fields are selecting. I want to select only one field in form. I hope my point is clear.
 
Please, I need reply for my question. I want to alter form control in my form.
 
No, not clear.
You don't have to resize the fields on a form. They just show whats in the field.
You can stretch the box wider if needed. (In design mode)
 
I want to reduce or increase length of box to left or to right. I hope now you got my problem now. what is the steps to do this please.
 
I'm not at my PC at the moment and I can't remember the correct name for it. Open your form in design view and select all of the controls you want to move, then right click and in the list of options displayed, you will find some formatting options. You have to switch off the automatic something or other. Now you will be able to resize any control without affecting any other control.

Sent from my SM-G925F using Tapatalk
 
Last edited:
As per my table fields in case of Dubai there will be 4 category visas. Bahrain, muscat, Qatar, Saudi will be two categories. I want these categories by drop down selection when I see the country name. So I need drop down under respective country. How can I do this please. Do I need extra table for this?
e.g. : Dubai have tourist visa and leisure visa. both have 1 month and 3 months.
 
Last edited:
I assume that you solved the original question?

Sent from my SM-G925F using Tapatalk
 
I guess you already have a table for the country and a table for the different categories.
All you need is a intermediate table who store all the possible combinations.
Then you can use that to make a query to populate your drop-down list.
 
Reducing box lengths for every data is a waste of time.
 
Dear Grumm,
Please clarify this through an example from my database fields to make combo box.
What is difference of list box and combo box.
 
I want user not to use table from my database. How can I hide it and once I need it how can I keep it open.
 
I don't know how to do combo box or list box on the basis of my database.
Please comment through example. I need on my COUNTRY field.
 
You must log in or register to reply here.

Similar threads

P
Solved Database backup
Replies
16
Views
822
Isaac
Isaac
Y
Import-export permit tracking system
Replies
13
Views
747
mike60smart
mike60smart
T
please help me with db, stuck with option group
2 3 4
Replies
64
Views
2,153
TipsyWolf
T
S
Refactoring an Access Database
Replies
14
Views
1,221
Pat Hartman
P
isladogs
Access Europe User Group - Wed 4 June: Orchestrating Office: Amplifying Access with Multi-Application Automation (Domenico Ruggiero)
Replies
2
Views
285
isladogs
isladogs

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom