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 derfloh 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: *

  • Users: Xeseus
  • Content: Threads
  • Order by date
  1. Xeseus

    Linking Excel via Sharepoint to Frontpage

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

    How do I quantify the instances of a value over a date range?

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

    No-Duplicates Field with a default?

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

    Best way to maintain billing rate history?

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

    Field Validation that controls Cursor Advancement

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

    Re-Using Queries

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

    Problem w/Auto-Numbered Primary Key

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

    Template needed for database w/single input form

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

    How can I code button to print a report w/current record only?

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

    Can a field not in the Field list be added to a form after it's been c

    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?
  11. Xeseus

    Problems manipulating text data - Access XP 2002

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

Part and Inventory Search

Back
Top