Search results for query: *

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

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

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

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

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

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

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

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