Search results for query: *

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

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

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

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

In Access 2007, I named my training reports like this..."(t) All Training" and I named my personnel reports like this..."(p) All Employees" so my SELECT query could easily select either training or personnel reports. I use this query to populate a listbox of personnel reports... SELECT...

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

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

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

Thank you, the calculations worked perfectly. John

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 & ", "...

Thanks for your help. John

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

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

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

I am using MS Access 2000. When I finish a personnel report and want it to appear in the personnel report's list box, I preface the report name with (rpt). The query below selects reports that begin with (rpt) and populates the personnel report list box successfully. SELECT...

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

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

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

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

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