Search results

Thanks. Pat Hartman I di as you suggested and get this... set parameter

I am using a foreign key to set a field that is part of the ordering. As it is a number I am guessing it is sorting numerically (the kp value). What would I need to do to make this sort alphabetically? Thanks

I have a continuous form. I put: DoCmd.SetOrderBy "[StrataPlanNr],[ServiceLines]" to sort the form when it loads. There is something wrong with this code. Q1: What? Q2: Is there a depository of documentation from Microsoft or others about the syntax for such statements?

SELECT Calendar_T.kp_Calendar_ID, Calendar_T.kf_StrataPlan_ID, StrataPlan_T.StrataPlanNr, Calendar_T.CalendarMonth, Calendar_T.Service_Project, Calendar_T.Cycle, Calendar_T.CalendarSchedule, Calendar_T.LastTimeDate, Calendar_T.NextTimeDate, Calendar_T.[Last Contractor], Calendar_T.Notes...

Thanks. Just as a general query on this problem, when does one use a ! Instead of a . In creating a path

SELECT Calendar_T.kp_Calendar_ID, Calendar_T.kf_StrataPlan_ID, StrataPlan_T.StrataPlanNr, Calendar_T.CalendarMonth, StrataPlan_T.SearchItem, Calendar_T.Service_Project, Calendar_T.Cycle, Calendar_T.CalendarSchedule, Calendar_T.LastTimeDate, Calendar_T.NextTimeDate, Calendar_T.[Last Contractor]...

This doesn't work. The form is a join table Calendar_T and StrataPlan_T. The StrataPlanNr comes through a foreign key. The code says something like StrataPlanNr could be from more than one table in SQL. What should I do? Strip out my data to protect the privacy of my db and then share it? Thanks

I am coding a search button on a form based on a Query. If I want my search to return on the value of one of the table fields does the code need to refer to the Query or the table? The on click code Me.SearchText.SetFocus Me.FilterOn = False Me.Filter = "...

I solve the problem. I need to delete the relationship between kp and kf StrataPlan, delete the row soure for the look up. recreate the look up and then creat a one to many between the Kp & kf StrataPLan. Now my lookup does not show duplicates of my strata plan nrs. stratas are condominium...

I will strip out my db and upload. Thanks. Tonight. PST

ELECT StrataPlan_T.kp_StrataPlan_ID, StrataPlan_T.StrataPlanNr FROM StrataPlan_T INNER JOIN Quoting_T ON StrataPlan_T.kp_StrataPlan_ID = Quoting_T.kf_StrataPlan_ID ORDER BY StrataPlan_T.StrataPlanNr;

T

I have a lookup on a foreign key that associates a strata to a task. So I use the lookup to provide a strata plan nr. It seems with each new record I create and assign a strata plan nr my value list grows by one value of that nr. Is there a known cause for this?

On the advice of a fellow forum member I starting to normalize my database this weekend using kp and kf. One of my buttons that navigates from a list form to a record form now shows a window that says,"Enter Parameter Code, Contractor_T.ContractorCode". What is it asking for? How can I code the...

Thanks. I will read this closely later today. Are we talking visual basics when you say 'clause', as in a line of code?

If you want to know how basic my knowledge is at present, SQL, clause? There are things you don't know you don't know. that's where I'm at.

Thanks

Thanks.

When one creates a query from two tables what determines which fields one includes in the query?

Very new to access. trying to learn the basics. What is your recommend on the best beginners resource?