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

    Make Insertion cursor go to start of field in an Access 2007 subform

    Thank you for your help. I have found a solution. I have a form that has a Tab Control. On one of the Tabs, I have a subform that has been causing the problem above. I found some code that causes the cursor to position itself at the start of the data in the first field of the subform. In...
  2. johnfrani

    Make Insertion cursor go to start of field in an Access 2007 subform

    Going to Access Options / Advanced and setting the cursor entering field behavior to: "go to start of field" (I thought) was suppose to be a global setting to effect ALL data entry fields on forms and subforms in this database. In my app, it only works for primary forms, not subforms that are...
  3. johnfrani

    Make Insertion cursor go to start of field in an Access 2007 subform

    I have an Access 2007 app. I don't want the whole data field selected when a subform opens (too easy for the user to delete data). I have gone to Access Options / Advanced and set the cursor entering field behavior to: "go to start of field". This works for all of the forms in the app but NOT...
  4. johnfrani

    Ignore first 4 characters in query result

    Thanks for your quick and excellent response. It worked like a charm. John
  5. johnfrani

    Ignore first 4 characters in query result

    ...a listbox of personnel reports... SELECT [MsysObjects].[Name], [MsysObjects].[Name] FROM MsysObjects WHERE ((([MsysObjects].[Name]) Not Like "~*" And ([MsysObjects].[Name]) Not Like "MSys*") And (([MsysObjects].[Name]) Like "(p)*") And (([MsysObjects].[Type])=-32764)) ORDER BY...
  6. johnfrani

    Access 2000 Duplicating Autonumber Field for New Records

    It took me 2 tries to compact and repair the DB (the first one stalled-out) but when it was successful, the autonumber started working correctly. Thanks John
  7. johnfrani

    Access 2000 Duplicating Autonumber Field for New Records

    I have an Access 2000 table with a MemberID field as the primary key. Data Type = autonumber Field Size = long interger New Values = increment Indexed = Yes (No Duplicates) For the past year, the MemberID field has worked correctly creating a unique MemberID number for each new record...
  8. johnfrani

    Text Search in Oracle CLOB

    I have a successful CR 8.5 report based on this query... ****************** SELECT CSCODE."NATURECODE", CSCODE."DESCRIPTION", CSMAIN."ACTDATE" FROM csmain, cscode WHERE CSCODE."NATURECODE" = CSMAIN."NATURECODE" AND CSMAIN."ACTDATE" >= {ts '2007-02-22 00:00:00.00'} AND...
  9. johnfrani

    Group by Similar Values - Not Exact Values

    Thank you, the calculations worked perfectly. John
  10. johnfrani

    Group by Similar Values - Not Exact Values

    I am using MS Access 2000. I am trying to create an Access report that lists and subtotals all the people that have entered our department and lists and subtotals all the people that have left our department for a given date range. This is my query...it works. SELECT tblMember.Lname & ", "...
  11. johnfrani

    Cold Boot = Bad Drive Map *** LogOff - LogOn = Good Drive Map?

    Thanks for your help. John
  12. johnfrani

    Cold Boot = Bad Mappings; Logoff-Login = Good Mappings?

    Thanks for responding, MrMovie. >how is the home directory mapped? There is a login script on our Domain Controller net use g: \\sfpdab.local\root\Data /Persistent:no net use H: /H /Persistent:no net use I: \\sfpdab.local\root\Apps /Persistent:no >when you say you get the wrong drive mapping...
  13. johnfrani

    Cold Boot = Bad Drive Map *** LogOff - LogOn = Good Drive Map?

    I have XPpro on my workstation and our domain controller is a Win 2003 server. When I cold boot my computer and login, my home directory is mapped to the wrong drive. Once I have booted, logged in, and got the wrong drive map to my home directory, I logoff and login again (without re-booting)...
  14. johnfrani

    Cold Boot = Bad Mappings; Logoff-Login = Good Mappings?

    I have XPpro on my workstation and our domain controller is a Win 2003 server. When I cold boot my computer and login, my home directory is mapped to the wrong drive. Once I have booted, logged in, and got the wrong drive map to my home directory, I logoff and login again (without re-booting)...
  15. johnfrani

    How to Strip First 5 Characters from Query Result

    ...report list box successfully. SELECT [MsysObjects].[Name], [MsysObjects].[Name] FROM MsysObjects WHERE ((([MsysObjects].[Name]) Not Like "~*" And ([MsysObjects].[Name]) Not Like "MSys*") And (([MsysObjects].[Name]) Like "(rpt) *") And (([MsysObjects].[Type])=-32764)) ORDER BY...
  16. johnfrani

    Form ---> SubForm1 ---> SubForm2 ?

    I have 3 tables: tblCase: CaseID, CaseNo, Date tblPerson: PersonID, CaseID, Name tblCharge: ChargeID, PersonID, Charge tblCase (1) --- (Many) tblPerson (1) --- (Many) tblCharge I have 1 form and 2 subforms: frmCase - with Tab Control sfrmPerson - on Tab2 sfrmCharge - on Tab2 I want to have...
  17. johnfrani

    Only Select Records with 2 or More of the Same Value

    Thanks for your help. Using your technique I got the query working perfectly. John
  18. johnfrani

    Only Select Records with 2 or More of the Same Value

    This query ... SELECT tbl_Person.Lname, tbl_Case.CaseNo, tbl_Case.Date, tbl_Charges.Section FROM (tbl_Case INNER JOIN tbl_Person ON tbl_Case.CaseID = tbl_Person.CaseID) INNER JOIN tbl_Charges ON (tbl_Person.PersonID = tbl_Charges.PersonID) AND (tbl_Person.PersonID = tbl_Charges.PersonID) ORDER...
  19. johnfrani

    Find records that DON'T have a record in another table

    I found a solution to my problem... SELECT DISTINCT tbl_Member.Lname, tbl_Member.WatchOff, tbl_Dates.Date, tbl_Dates.DOW FROM tbl_Dates ,tbl_Member WHERE tbl_Dates.date= [Enter OT Date] and not exists (select 1 from tbl_Dates a where tbl_Member.WatchOff = a.WatchOff...
  20. johnfrani

    [b]How to Extract Txt from 1st List Based on Txt in 2nd List[/b]

    Thanks, Gavona. I found my solution with the substitute function. I just needed the correct term to search for. John

Part and Inventory Search

Back
Top