Travel Agency Database - advice and help appreciated!

[WayneRyan]

Edd,

This is a reference problem, you could search here, but get
your code in design view. Choose Tools --> references
Make sure that Microsoft Data Access Objects is checked
and promoted (moved up) as high as it can go.

Wayne

 

[Sharky II]

oh my god

you're a feckign star

now how do i get the dynamic_query query to load up in a form instead of a data sheet????????

although sometimes the datasheet is more useful. i'll provide both options if i can!

 

[Sharky II]

Guys the only way i can think of opening it in a form is if i make a form which contains the fields from the Dynamic_Query query, and then get users to

step 1) enter fields (into original search form not the dynamic_query form)

step 2) press cmdRunQuery button to bring up the results in datasheet view

step 3) THEN get users to click a button to bring up the results displayed in the dynamic_query form.

I actually REALLY NEED the query results to show up in the customer11 form (main form) however so that the relevant trip details etc can be accessed. i could make a copy of it but things (like control sources) might get messy then.

any ideas lads?

 

[Jack Cowley]

You can create or copy your existing search or display form but use Dynamic_Query as the Record Source. Place the word Search Results at the top of this form so the users are not confused. In your code, after the code that saves the Dynamic_Query add"

DoCmd.OpenForm "NameOfSearchResultsForm"

Now when the click the button on the search form it will be replaced by a form with their search results...

That is how I would do it...

Jack

 

[Sharky II]

PERFECT!!!!

 

[same2r]

i am new to database. i need to maintain a databse for my travel agency
i need to keep all customer profiles and their trip details and all. how do i make it
please help

 

[John.Woody]

You could look at developing your own or perhaps http://www.msmltd.co.uk/ might be of interest to you.

 

[Simon_MT]

Edd,

I looked at your initial database and I would tempted to put all the Travel options from tblDestinations into a Subform and on Click one of the Destination consider Appending into a Table of Clients_Interests and a flag of "E" Expression of Interest. If they make a booking the Flag changes to "T" for Travelled or something along these lines. This wy you can add Destinations without having to re-write the Form each time.

Searching for clients I drive a Menu and on the Search Form store the type of Search.

Then create a Private Function

Private Function ClientsCriteria() As String

    With CodeContextObject
        If .[Search] = "A" Then
            ClientsCriteria = "[Client Address1] like '" & "*" & .[Field2] & "*" & "' or [Client Address2] like '" & "*" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "C" Then
            ClientsCriteria = "[Client Co Name] like '" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "E" Then
            ClientsCriteria = "[Client Email] like '" & "*" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "I" Then
            ClientsCriteria = "[Client] like '" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "N" Then
            ClientsCriteria = "[Client Surname] like '" & .[Field1] & "*" & "' and [Client First Name] like '" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "P" Then
            ClientsCriteria = "[Client Postcode ] like '" & .[Field2] & "*" & "'"
        ElseIf .[Search] = "T" Then
            ClientsCriteria = "[Client Tele ] like '" & "*" & .[Field2] & "*" & "' or [Client Tele2 ] like '" & "*" & .[Field2] & "*" & "'"
        End If
    End With

End Function

From the Search from then open Clients:

Function ClientsEntry() As String

    DoCmd.OpenForm "Clients Details", , , ClientsCriteria

End Function

Simon

 

[Simon_MT]

I have had a look at your database.

There are some ideas:

You should use the power of a relational database.

Create a Table DestinationTypes (D) Discovery, (E) Expedition (L) Lifestyle.
In the Table Trips the Destination should be 9 corresponding to the Table Destinations

Depending on the how the Agency buys in holidays packaged or bespoke you may need another table Destination Details. Pricing is not included nor the Carrier / Airline. You may need, if charter flights are used, to create Flight vouchers?

Each member of the party may have to treated as an individual to marry up with Card Details and next of kin. There may also be groups of people wanting a holiday and Numbers within each booking may well be required.

The Telephone Log and Trip details could be on same Form but on tabs.
The Telephone Log should have dates.

MS San Serif the standard Form Font could be replaced with Arial.

This is only scratching the surface but it you are looking to do a Travel system as you well know the devil is in the detail. Flights have to treated with care as I have experienced a situation where a charter flight was over-booked thankfully I had proof of purchase for all my seats.

Simon

 

[Chev Frost]

hey sharky did you complete this?