Microsoft Access 2013 Developent

[InspectorHound]

Hi,
I need to develop an Access application and I have not done this in about 10 years. I am using Microsoft Access 2013 and developong a desktop application since I do not have a SharePoint server. I would like to open with a search form where the user can enter three pieces of information. After he presses the search button, a dataset is returned. From this dataset, the user can select one item and get more detailed information on this item. What kind of form do I use to return the dataset (a query). And in the dataset, do I put in a link so I can call up the detailed information?

Thanks.

 

[InspectorHound]

Here is the Query SQL View:
##
SELECT User_profile.[traveler last name], user_profile.[traveler SSN], Trvl_plng_athrztn.[LinkedProfileID], Trvl_plng_athrztn.[Authorized Destination City1], Trvl_plng_athrztn.[Depart Date1]
FROM Trvl_plng_athrztn INNER JOIN User_profile ON RIGHT(Trvl_plng_athrztn.LinkedProfileID, 9) = User_profile.[Traveler SSN];
##

I aslo copied my old form to create the new form that I am using. Could that be a problem? Should I delete the old form from my project? I am really getting frustrated an need to hand this in.

 

[InspectorHound]

Oh -- it works! The only time I am having a problem is when I type in the last name field.

 

[InspectorHound]

It all workd now -- thank you so much

 

[SkipVought]

Why the SPACES before and after the asterisk?

Like "" * " & Me.txtLastName & " *

 

[dhookom]

Good catch Skip. I caught some but not all of the extra spaces.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Think you have too many QUOTES...

Like "*" & Me.txtLastName & "*"

 

[dhookom]

I think you need all the quotes but not the spaces:

 strSQL = strSQL & " AND [traveler last name] Like ""*" & Me.txtLastName & "*"" "

Duane
Hook'D on Access
MS Access MVP

 

[InspectorHound]

Thanks so much for your help. Now -- lets move on to the next step.Should I start a new thread or continue with this one? After the rows are returned in the detail section, I need to select one and return information from another table. what is the best way of doing that?

 

[dhookom]

Start a new thread.

Duane
Hook'D on Access
MS Access MVP

 

[dhookom]

Actually, you should start a new thread in a more appropriate MS Access forum.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

 

[InspectorHound]

Ok. Thanks!