Search results

I think its something to do with left joining (Whatever that is)... I will put up the SQL statement when i have a chance.

Hi, I'm not that great with Access but would like to ask for some advice. I have 3 tables all linked with an ID number (one to many) I create a query which I want to display the notes field from each of the 3 tables for each personID.. The problem is that say in one of the tables the person...

problem is that how would the textbox know the correct record to display so that it links with the current record being displayed in the form? how would it know what surname to display if there was no link between the tables? sorry just a bit confused.

Hi me again I have a form which is populated with data on a student. Problem is I want to add a textbox which displays the students surname, but that surname is located in another table called students. I tried selecting the table and field in the data source for the textbox, but I just get a...

DoCmd.FindRecord "'" & Search & "'", , , , , acAll didn't work so I did this instead: DoCmd.FindRecord "" & Search & "", , , , , acAll and it worked!! dank je wel voor u helpen.

this is driving me insane.. Surname.SetFocus Search = InputBox("Please enter the Surname", "OrderSearch") DoCmd.FindRecord "'" & Search & "'", , , , , acAll but it displays no results! I did a 'MsgBox (Search) to see if it was grabbing my variable and it displayed what I had typed so the...

I created a field called surname which is enabled. Dim search as string Surname.SetFocus Search = InputBox("Please enter the Surname", "OrderSearch") acSearchAll, , acCurrent, True if I type this, then it works and it finds the name Allen and goes to the page on the form: 'DoCmd.FindRecord...

Ok, did that and pointed the focus to the studentID field in the form. I now get a nice message saying: Microsoft access cant move the focus to the control studentID is this because its greyed out on the form? if so is there any way of ungraying it? sorry , this database wasn't made by me...

ok thanks now I get an error that says A macro set to one of the current fields properties failed because one of the arguments in the findrecord action argument. when I use this: DoCmd.FindRecord "[Students].[surname] ='" & Search & "'", acEntire, False, acSearchAll, , acCurrent, True

I didn't miss what you said and i really appreciate how helpful you have been, I typed this: Private Sub Command96_Click() On Error GoTo Err_Command96_Click Dim Search As String Search = InputBox("Please enter the Surname", "OrderSearch") DoCmd.GoToRecord , acGoTo, "[Students].[Surname] = '"...

Dim Search As String Search = InputBox("Please enter the Surname", "OrderSearch") DoCmd.GoToRecord , acGoTo, "[Students].[Surname] = " & Search How is this? I'm getting a type mismatch though... I'm trying to goto the record which is on the current form by searching a table and its...

Hi this is the error im getting: A macro set to one of the current fields properties failed because one of the arguments in the findrecord action argument. The record that im trying to find is on the current form, I have a find button which the user clicks and it asks for a surname. I then...

Hi I'm trying to search for a surname on a form from a table called students. I want the result to goto the record on the form. The tablename is Students and the field I want to search is called Surname I wrote this code: Dim Search As String Search = InputBox("Please enter the Surname"...

No Joy Now it doesn't even display the end time in Expr1 if a time was specified. Still just the #Error when end time is empty

Hi that displayed a valid time if and end time was specified but if there was no end time it still comes up with #Error

Thanks for your help, I'll give that a try

Expr1: IIf(IsNULL([End_Time]),"N/A",[End_Time]) Thats the statement I'm trying to run but it doesn't seem to work. Still an #Error value appears in the column. Basically End_Time is just a couple of different strings mashed together. But the problem is that sometimes these strings are blank...

oh and is that Manny from grim fandango ? I loved the game

I tried this: Expr1: IIf(IsNULL([End_Time]),"N/A",[End_Time]) but still the field shows up as #error if the End Time is an empty value

Ok so if I have a null value.. I think its just a null value..