Search results for query: *

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

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

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

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 have several hyperlinks in a workbook. I want to copy the sheet containing the hyperlinks to a new workbook using code. When I record the macro, they hyperlinks work in the new workbook. When I run the macro, it shows up as a hyperlink, but the link is broken and it goes nowhere. I used...

I have a database table that has numbers in sequential order. There are 99,000 numbers. However, there have been deleted records, so there are around 8000 numbers that aren't being used. Is there a way to get a list of all unused numbers?

I have a database table that has numbers in sequential order. There are 99,000 numbers. However, there have been deleted records, so there are around 8000 numbers that aren't being used. Is there a way to get a list of all unused numbers? Thanks...

Does anyone know how to code F2 and then Enter feature in VBA? I tried recording, but it doesn't produce the same result. I have a cell that contains 13 numbers. I have the field coded as text because the number originally has dashes and spaces, which I delete. When the number is...

When I copy a bordered list from Excel and paste it into an email message, the borders disappear. Everyone else can paste the data with the borders. My Editor is set to HTML just like everyone else. If I change the message to rich text, the borders display, but I would need to change it for...

Does anyone know if the Networkdays function can be used in Access? In help it says it's a spreadsheet function. Thanks...

I'm trying to do a loop with a variable where the name changes every time it goes thru the loop count. If the variable is called "pastdue", the first time through the loop I'd have pastdue1, the next time through the loop the variable would change to pastdue2, etc. Each variable contains...

I have a form with a filter. The user can select a group and a category. Once I have applied the filter, they want to search the question field (which is a memo field)for specific words and bring up only records that are in the specific group and category, with the key words in the memo field...

I have a query and that has a project id and multiple status dates. Does anyone know what criteria is needed to pull up only the most recent status date for each project? Thanks...

Hi, Hopefully someone has an answer... On the Microsoft Office Programs Toolbar (which opens Word, Excel, etc by a single click on the icon), I have a user that wants to double-click to open the program. Unfortunately, when he double-clicks it opens two occurrences of the program. Does anyone...

Hi, I know how to specify what fields in a Word form go into various tables in Acccess. Can the same thing be done in Excel? I have an Excel Spreadsheet which I want specific columns to be imported into various tables. For Example, I want columns A and B to go into one table and columns C and...