Search results for query: *

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

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

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

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

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

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 have two columns in an Excel spreadsheet. The first (A1:A10) has all possible text values (abcdef) in each cell. Each cell in the second column (B1:B10) has only one of the possible text letters (ex. b in cell B1). I am looking for an Excel formula (or some technique) that will allow me to...

I am trying to create this query as part of an Access app. I am familiar with SQL but I am stumped by this query. I have two tables: tbl_Member MemberID (pk) autonumber Lname (text) WatchOffGroup (text) Example Data MemberID Lname WatchOffGroup 1 Smith 1 2 Jones 2 3 Green 3...

We are using 2003 Server. Is there a way to list all currently connected users so we can notify them if we have to reboot the server? Thanks John

I found an easy way to search LONG data type fields for any text string. I created a new Crystal Report, based on a query that selected the LONG data field from a table. Once I had the data in Crystal, I chose File, Print, Export and chose to export as an Adobe PDF file. Once the report was in...

How can I allow the user to use the built-in FilterByForm and ApplyFilterSort menu choices by using a command button instead of using the Access 2000 menu bar. I want to allow the user to click a "Choose Case Number" button to filter on the Case# DB field and then apply the filter. Then I...

Is it possible to have a use click an ActiveX Calendar Control and have the selected date value passed to an Access query? If so, how do I make this work. Thanks, John

How can I best allow a user to click on a date on an Access 2000 ActiveX Calender Control to only display the records in a subform that meet the date criteria selected on the calendar? I need to know, specifically, what to do and where to do it because I am new to Access and VB. I have a Form...