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

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

    Double Filtering from a Subform

    I have a subform that I use to list some items. On that subform I made the OnClick property below: DoCmd.OpenForm "frmSAR", , , "CaseNum= '" & CaseNum & "'" & " AND " & "ctlSARID = '" & txtSARID & "'" It doesn't work though, and instead gives me a dialog box asking for txtSARID. txtSARID is the...
  2. dedren

    Allow Users to Add Links to Files

    I am using the Issues DB from Microsoft http://office.microsoft.com/en-us/templates/issue-database-TC001218693.aspx I want to give my users the ability to add links to files stored on our network. Each record of an issue in the DB should allow different files to be linked to it. This is how I...
  3. dedren

    Different Primary Key Data Types for a Junction Table

    When I first designed this database several years ago I chose to make my main table’s primary key a hybrid of the year and an autonumber so that it looked like this: 11-1234. This means that its data type had to be Text. Now, in an effort to create a junction table it has come around to bite me...
  4. dedren

    How to Link Related Cases?

    My database manages investigative cases. Once I open a case I would like it to show related cases based on last names. Currently the main form has several subforms pulled from multiple tables. When I try to create a query that filters by the last name it brings up no results. I think this is...
  5. dedren

    Adding additional fees to balance and subtracting payments

    On a form I am trying to display the following with data from different subforms: casebalance + sum of additional fees - sum of all payments=current balance I started with the following expression: =Sum((sbfBalance.Form!InitBal+sbfFees.Form!SumFees)-sbfPayments.Form!SumPayment) I found out...
  6. dedren

    Selecting Memo Fields to Display in a Report

    I am trying to generate a report, using some options that the end user selects from a combo box on a form or, if possible, right from the queries that generate the report. The combo box has a list of memo fields that the user can choose to use when populating the report. My problem is that the...
  7. dedren

    Printing a Print to File file

    I recently received an email of a report I was expecting. The extension on the file is .prt so I assume it is a document created when you use the 'Print to File' checkbox in the Print dialog box. Problem is I have no clue how to actually print or even open the file. I have tried Adobe, Word...
  8. dedren

    Monthly Report

    I thought I had solved this problem but I was terribly wrong, so I hope someone can help. I have two tables, [Balance] and [Payments] 1. For every record I have in [Balance] I could have an infinite number in [Payments] 2. Both tables use [CaseNum] to be linked to one another. 3. Both tables...

Part and Inventory Search

Back
Top