Search results for query: *

I am using Excel 2002 and Frontpage 2002 and am tasked with making part of a Excel spreadsheet dynamically linked to a website. I have not had the need to use Sharepoint and do not currently have any files dynamically linked to our website. I maintain our company's Frontpage website and have...

I have a query where I am trying to count the number of claims issued against a specific insurance company. I have no problem until I impose a date range, then I end up with a listing of the number of claims against a company per date entered. Is there a way to define a date range and still get...

I have a client who would like to, ideally, be able to have a field in a form that is required to be unique, yet is able to have a re-usable default value. For example, an I.D. field with a default option of "n/a". Now, of course, this is self-defeating and contradictory but I can think of at...

I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within...

I would like to create an event which is initiated by entering a value into a specific field and hitting the tab or enter button. It would create a pop up that asks the user if they are certain that they want to keep the value entered. If the answer is “yes” then the newly entered value is...

I am new to Access and would like to know the best way to set up queries for a database that uses 20 - 30 reports. Will it run better with a query built for each report or should I re-use queries for more than one report if possible? I am concerned that if two separate reports are run using the...

I am filling the sender & recipient fields for a logistics company's Invoice table by drawing from a single address table. I enter "new" addresses using two forms (one for the sender field, one for the recipient field) that populate the common address table and the Invoice table's record. As I...

Access seems straight forward at first but take a situation where a client wants to have a single input form to input data into several different tables and it becomes very complicated. Yet, to me, it would seem as though a request for a single input form would be fairly common. Basically...

I am trying to get the code for my form's print button to print a report with the form's current record only. What do I need to do to get it to do this? Here's my code: Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click Dim stDocName As String stDocName = "Agency...

I have spent some time creating a form with subforms from several tables. I want to add another subform that involves a tables whose fields are not currently in the Field list. Is this possible? If so, how can I do this?

I am trying to combine the city, state and zip in a field for my report and I continually find Access is temperamental. Sometimes it works other times not, but more often than not the latter. I get "error" in the field when looking at it from the view window. Although this doesn't give you the...