Newbie to the world of Access - Help required for form & report buidling

[myem1983]

Dear Seniors,

I've no clue how to use MS. Access I'm still struggling because I have to prepare something which could help me and my colleagues.


I was wondering if we could prepare any form on Access and from that form a report generates which we could use as our help this will not only solve our major problem but will also help us to work more efficiently. Therefore my colleagues pushed me to write here for any solution.



We need a form in Access in which we input following details:

B/L Number (this will be text, numbers and special characters combination)
Vessel Name (it will be a text or may be combination of text & numbers or text, number and special characters combination)
Voy (it will be a combination of text & number or maybe text only and some times number only)
Arrival Date (this will be a date in this format DD-MM-YY)
Courier Dispatch Date: (this will be a date in this format DD-MM-YY) (this date will be used three different places)
E-mail Address (this will be email address could be one or more than one)
Mobile Number (this will be a mobile number could be one or more than one)

Once we enter above information and generate report then it should appear as below:

Date: (Report Generation Date)
(Auto Serial Number)

Ref: ARRIVAL NOTICE SENT CONFIRMATION / B/L # xxx/xxx/12345

Dear Sir,

Subject B/L shipment is expected at Karachi / Port Qasim on “vessel name & voy” dated: xx-xx-2014.

Please note we have already sent arrival notice to consignee by following mean(s):

a) Courier dispatched on xx-xx-2014 to the address mentioned on B/L
b) E-notice sent via email on xx-xx-2014 on EMAIL ADDRESS (if more than one email ID then appear all email ID’s separated by ,)
c) SMS Alert sent on xx-xx-2014 on mobile number: 03xx-xxxxxxx (if more than one mobile number then appear all separated by ,)

Above email notification is for your record and we request you to update shipper about the same.

We thank you for entrusting us and assure you of our best services. If you have any suggestion, query or comment please feel free to contact undersign.

Regards,
-----------------------------------------------------------------------
Is this is possible to achieve in ms access? Please advise.

Thanks in advance!

[ranman256]

Yes, this is what Access if for...
build a form with all your controls.
(you will need to know the names of the objects, you can rename them to make them understandable , rather than textbox1, set the name property to txtVessell or such.)
build a query that uses these as reference. In the query, it will use criteria from the form forms!myForm!txtVessell.
this query is the datasource for the report.
put a button on the form to open the report (use a wizard)

user picks the controls to fill, then clicks the open report button
the button opens the report, the report is a query looking at the table and the form for criteria.