Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. christopher007

    Open main form goto rec AND rec on subform

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

    Open main form goto rec AND rec on subform

    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.
  3. christopher007

    Open main form goto rec AND rec on subform

    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]...
  4. christopher007

    Open main form goto rec AND rec on subform

    the procedure is in:- Form_Load()
  5. christopher007

    Open main form goto rec AND rec on subform

    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, ".")...
  6. christopher007

    Open main form goto rec AND rec on subform

    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...
  7. christopher007

    Open main form goto rec AND rec on subform

    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...
  8. christopher007

    Open main form goto rec AND rec on subform

    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...
  9. christopher007

    Open main form goto rec AND rec on subform

    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...
  10. christopher007

    Find Function in Excel not in Access

    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
  11. christopher007

    VBA functions in Queries

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

    Find Function in Excel not in Access

    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.
  13. christopher007

    Problems with Fields in queries

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

    Problems with Fields in queries

    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...
  15. christopher007

    Form wont go into datasheet view ?

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

    Form wont go into datasheet view ?

    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?
  17. christopher007

    HELP PLEASE !!!!

    Jim, your a star, thanks very much, much appriciated Chris
  18. christopher007

    HELP PLEASE !!!!

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

    Form name appears in new record row.

    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...
  20. christopher007

    HELP PLEASE !!!!

    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...

Part and Inventory Search

Back
Top