Search results for query: *

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.

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.

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

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

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

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

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

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.

What would you use in place of minimum?

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

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

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

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.

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

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?

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

Thank you so much... It worked perfectly!

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

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

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?