Search results for query: *

My fault, it works thanks to all who input into helping me, thank god there are people with out eristic tendencies. Cheers Chris

I have checked my code, cant see nothing wrong, still all I get is the main form filtering correctly but cant filter on the subform, it goes to a blank record and there defiantly is a related record id=9 for record id=45.

Ok So I now have this code :- Dim namMain As String, namSub As String Dim sfrm As Form, Criteria As String namMain = "service customers" namSub = "SR" Criteria = "[ID] =45" DoCmd.OpenForm namMain, , , Criteria Set sfrm = Forms(namMain)(namSub).Form sfrm.Filter = "[ID]...

the procedure is in:- Form_Load()

Ok I have searched on the openArgs and think the code below should work though I do have a couple of quick question:- Dim sfrm As Form, rst As DAO.Recordset, Idx As Integer Dim idClient As Long, idDeal As Long Set frm = Me!Deals.Form Idx = InStr(1, Me.OpenArgs, ".")...

Thanks for the reply, however may be I am not making it clear, I am trying filter/select a record on the main form then select/filter a record on the subform. On the main form I need to filter on [id] and also [id] in the subform which is a related table. Suppose I want to write code to select...

Sorry should of read :- Code is:- Dim stLinkCriteria As String stDocName = "service customers" stLinkCriteria = "[ID]=" & Me![List0] DoCmd.OpenForm stDocName, , , stLinkCriteria Qestion: How do use a AND condition in my stLinkCritera string so I can filter on field [id] on...

Ok this is the code I know how to use to open a form and filter on a field in the main part of the form:- Dim stLinkCriteria As String stDocName = "service customers" DoCmd.OpenForm stDocName, , , stLinkCriteria What I am having trouble with is trying to filter a related record in...

If I have two tables Table1 & Table2 with a one to many relation ships, create a form with Table1 and Table2 as subform. I now want to open this form from another form and select a record in the main form and a related record in the subform. Could someone be kind enough to show me how with VBA...

Instr({somestring}, {character}) returns the postion of {character} in the string {string} Is exactly what i was looking for so will give it a go, i couldnt find this in access anywaere builder help ect Much appricated Jim Regards

Can I use a vba function that I have written in a query, im getting undifined function if i try this.

Does anyone know, how you can search for a character in a string like the Find function in Excel. I have a field Full Name that is first name and surname together; I need to strip out the first letter of the surname to sort on.

Roy, absolutely right, have got Full Name in another table in the query, now working properly. Thanks a million Chris

I have a simple select query that has no criteria, therefore shows all records, I want to use the left function to strip out the first letter of a field called “Full Name” which is the primary key of the table, however if I write Prefix: Left([Full Name],1) I get this error “The specified field...

OK I have just examined the code and sorted it thanks.

I have set the properties of a form for datasheet only by default view and view alowed, however, when i open the form from the database window it goes into datasheet view, when i open the form from a command button created by wizard using docmd.openform it goes back to form view. Any ideas?

Jim, your a star, thanks very much, much appriciated Chris

Thanks but have checked all this so far please see my other post which i think explanes my problem clearer.

I have re-written my problem that’s already posted just trying to make it a bit clearer. I have a main form – sub form, were usually in the sub form, on the new record line, the foreign key field usually is filled in with the primary key, what im getting in access 2000 is the forms name not the...

I have a table names Staff Members with fields, Name, Job and Area. I have a second table names Courses Attended with fields Name, Course and Date. I have a relation ship between Name and Name in the to tables, ref-integrity turned on and one to many shows ok in relationships. My question is...