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 Chriss Miller 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. dar149

    Open Access from Intranet

    Thanks for the post. I found the above solutions on the internet, but they didn't solve the problem. I think I'll just have them open the database from their desktop and forget about the intranet.
  2. dar149

    REPOST

    Thanks for the reply. I had also posted to Internet Security with no response there either. I have put in a new thread to Information Security.
  3. dar149

    Open Access from Intranet

    I want to hyperlink from the Intranet to an Access database. If I put a hyperlink in FrontPage to Word, Excel, or Powerpoint, and publish, the application opens and I am able to use the application When I try to open Access I get the following message: "The publisher could not be verified...
  4. dar149

    REPOST

    I want to hyperlink from the Intranet to an Access database. If I put a hyperlink in FrontPage to Word, Excel, or Powerpoint, and publish, the application opens and I am able to use the application When I try to open Access I get the following message: "The publisher could not be verified...
  5. dar149

    Hyperlink not working

    I want to hyperlink from the Intranet to an Access database. If I put a hyperlink in FrontPage to Word, Excel, or Powerpoint, and publish, the application opens and I am able to use the application When I try to open Access I get the following message: "The publisher could not be verified...
  6. dar149

    Hyperlink on Intranet

    I want to hyperlink from the Intranet to an Access database. If I put a hyperlink in FrontPage to Word, Excel, or Powerpoint, and publish, the application opens and I am able to use the application When I try to open Access I get the following message: "The publisher could not be verified...
  7. dar149

    MS Access Link on FrontPage Page

    I want to hyperlink from the Intranet to an Access database. If I put a hyperlink in FrontPage to Word, Excel, or Powerpoint, and publish, the application opens and I am able to use the application When I try to open Access I get the following message: "The publisher could not be verified...
  8. dar149

    Result of Expression not sorting as Date

    I have no idea, I just typed it in and it gave me the lowest date from whichever field had the lowest date for each record. Is there a better way to do this? I have three fields in each record that contain dates. I want the least recent date of the three fields to display for each record.
  9. dar149

    Result of Expression not sorting as Date

    What would you use in place of minimum?
  10. dar149

    Result of Expression not sorting as Date

    This is the code of the query: SELECT [Contractor Table].Contractor, [Contractor Table].Administrator, Minimum([GLExp],[UmbExp],[WCExp]) AS [Minimum Date] FROM [Contractor Table] WHERE (((Minimum([GLExp],[UmbExp],[WCExp]))<>0) AND (([Contractor Table].Active)=Yes)) ORDER BY...
  11. dar149

    Result of Expression not sorting as Date

    I created the expression in a query field. Minimum Date: Minimum([GLExp],[UmbExp],[WCExp]) is one of the fields.
  12. dar149

    Result of Expression not sorting as Date

    I have a query that finds the minimum date value from three date fields. When I sort the result it sorts as text rather than by the actual date. I have used the following expression: Minimum Date: Minimum([GLExp],[UmbExp],[WCExp]) I tried formatting the field as a date, but if I sort or use...
  13. dar149

    Consecutive sorts in Excel

    What I mean by "it doesn't work" is that it sorts the first two times I bring up the data sort dialog box. But the third time I bring it up it resorts the spreadsheet, wiping out the two previous sorts. It starts over as a new sort.
  14. dar149

    Consecutive sorts in Excel

    I know that you can create a consecutive sort for four columns by sorting first by the two least important columns and then a second sort by the two most important columns. Example: The first sort is by LName and then by FName. The second sort is by Hours and then by Hourly Rate. If I want...
  15. dar149

    &quot;This database is in an unexpected state...&quot;???

    This recently happened to a database I have. It was opened by a user who was using 2000. Did they inadvertently do a partial convert?
  16. dar149

    Import Word Form Fields into Access Tables

    I am importing Word fields into various Access tables. The database is normalized with referential integrity turned on. However, when I run the code to populate the tables, it is done one table at a time. So if I have a one-to-one relationship with referential integrity turned on, it won't...
  17. dar149

    Subquery Help

    Thank you so much... It worked perfectly!
  18. dar149

    Subquery Help

    I have two tables, tblCompanyInfo and tblContacts. I am trying to find all Companies that have a record in CompanyInfo but no record in Contacts. lngCompanyID should not exist in tblContacts. I came up with the following SQL to put in the criteria for lngCompanyID, but it's not working...
  19. dar149

    Copy Sheet to New Workbook with Hyperlink

    I did try saving the workbook to the hard drive of the pc I'm running from, but the links remain broken.
  20. dar149

    Copy Sheet to New Workbook with Hyperlink

    I found that if I save the workbook the hyperlink is reestablished. However, because this program will be run from a cd that is read only, I am unable to save it. Can you think of any other way to establish that link?

Part and Inventory Search

Back
Top