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!

Recent content by lshippee

  1. lshippee

    do not have necessary permissions . . .

    Rick, Thanks for your reply. I get only the error message noted above when I try to open the database -- no logon prompt. In the secured.mdw report I find the following: Workgroup Information File: \Secured.mdw User Name: MyName Workgroup ID: swtrial1 Groups: Name: Admins Group ID...
  2. lshippee

    do not have necessary permissions . . .

    I've used the security wizard for the first time as a trial to learn about it -- and I have some learning to do! The end result is this error message when I try to open the secured version: You do not have the necessary permissions to use the *:/*.mdb object. Have your system administrator or...
  3. lshippee

    need to generate a date

    Thanks for the reply. I thought dateserial relies upon the system date. I need to generate the date based on user input. Can you enlighten me further? Leslie Shippee Information Analyst
  4. lshippee

    need to generate a date

    I need to generate a date that is the last day of the month from a given, changeable start date based on two optional time periods, 18 or 36 months. That is, the start date is entered in one field, the number of months for the time period is in another. The third field would contain the last...
  5. lshippee

    Field values not sorting on report per sort specifications

    Thank you. I found that by rearranging the order of the fields to be sorted in the sorting/grouping setup, I was able to achieve the report I wanted.
  6. lshippee

    Field values not sorting on report per sort specifications

    I have a series of reports based on queries in a database that accepts data input via a web form. The queries were designed with ascending sorts on selected fields. SELECT tblRegistrations.ProjectNo, tblWorkshops.WkshpName, tblRegistrations.LastName, tblRegistrations.FirstName...
  7. lshippee

    Group header title being split up from Group info on new page

    Erin, You could try this. Open the report in design view and select the group header. Click the grouping and sorting button and look at the options in the bottom half. You can elect to keep a group together with just the first detail or with the entire group. If you choose first detail, the...
  8. lshippee

    problem with now() after changing field from text to date/time

    Thanks! I got the query to run properly by changing to date().
  9. lshippee

    database results showing datatype mismatch in criteria error message

    For drowland -- Thanks for the tip. I was able to get the query to run in the underlying database by changing to date(), but . . . I am still getting the criteria mismatch error message when rerunning the database results The results worked beautifully when I had the date field cast as a...
  10. lshippee

    problem with now() after changing field from text to date/time

    I am willing to post my query -- how do I do this?
  11. lshippee

    problem with now() after changing field from text to date/time

    I have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000 database that...
  12. lshippee

    database results showing datatype mismatch in criteria error message

    Initial problem: Have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000...
  13. lshippee

    Internet Explorer vs. Netscape re: password protection

    I've put the code below in a page on my site per the instructions BEFORE the <HTML> tage on the page: <% pagePassword = &quot;<STRONG>cesaone</STRONG>&quot; passwordForm = &quot;<STRONG>employeeswelcome.htm</STRONG>&quot; IF Session(&quot;pwfield&quot;) <> pagePassword THEN IF...
  14. lshippee

    using a &quot;phantom&quot; url

    Thanks Pete & Robert, My host company is happy to set me up with additional pointers; however, they say they can't (won't?) have it point to a subdirectory of the site, only to the main page. Do I need a new host company or only to enlighten them to the possibilities? Have you had your host...
  15. lshippee

    Accessing a database with Frontpage?

    Adding to what Delorfra says, FP2000 has the nifty database results wizard (Insert, Database on the menu) which, if you don't have the database connection already set, will do that for you (the database must be imported to your site first). To do this, choose File, Import in FP2000 which will...
See more

Part and Inventory Search

Back
Top