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

  1. dedren

    Double Filtering from a Subform

    I should tell you that there are 12 people in this office that want to kiss your face for fixing this.
  2. dedren

    Double Filtering from a Subform

    GLaDOS approves! That works perfectly!! Thank you both for your help with this. PHV: Might I ask why yours worked?
  3. dedren

    Double Filtering from a Subform

    PHV: txtSARID is a text field on the form that I am trying to open. It should be 'filtering' based on the value of a text field on the subform called ctlSARID. Both of these fields refer to an autonumber field (SARID) in a table (tblSARlst). TheAceMan1: I tried this code but I got the error...
  4. 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...
  5. dedren

    Allow Users to Add Links to Files

    Well, there is no question it is more secure, but it virtually eliminates innovative changes. I have been working with Access DB for 5 years now and barely know anything because most changes I can't test or see the results myself. Either it works and we keep it or it doesn't and we do without it...
  6. dedren

    Allow Users to Add Links to Files

    What I try to do is getting a complete solution together in TextPad and just copy and paste stuff into Access when I can. Additionally, since I am on their time, I have little time to bug fix, so if it doesn't work right away I end up having to wait days before I can do more.
  7. dedren

    Allow Users to Add Links to Files

    I use Access 2003. The problem is I can't even edit my DB without first consulting IT and the last time I dealt with references I had to get approvals which took way too much time and was not worth the effort. So if there is any way I can avoid doing that again, I'd jump on it. It is also why I...
  8. dedren

    Allow Users to Add Links to Files

    Thanks kjv1611, 1 & 2. The field is called FilePath and it is in the table as a Hyperlink type. Is that what you meant? 3. Most of my users don't know what an address bar is and are far below the knowledge of what an average PC user possesses. I would really like to keep it iPhone simple for...
  9. dedren

    Sending Email via OWA

    Were you able to find an answer to this? I can't, or don't understand how to, use any of the solutions presented so far because the only information I have about Outlook Web Access is the website address, my user id, and password. I can't install any additional software and don't have access to...
  10. 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...
  11. dedren

    Different Primary Key Data Types for a Junction Table

    I am not sure what would happen, which is part of the problem. Yes, it is only seven tables (see attached image), but there are lots of forms, sub-forms, and reports.https://docs.google.com/leaf?id=0B2fxStZCLNTJNTRlY2U4Y2ItOGUyOS00M2U2LTgyNjUtMWI5ZjU5NTMxNDJi&sort=name&layout=list&num=50
  12. 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...
  13. dedren

    How to Link Related Cases?

    Also, just to make sure I understand. To normalize this properly I would just need to create a separate table with the primary keys of tblCase and tblNames and have each table establish a relationship with it?
  14. dedren

    How to Link Related Cases?

    Ah, that makes a lot of sense. This was my first database and I was learning through Google, as I went along, under serious time constraints. I think I can convince the team to hold off on this as I normalize the table and split the DB between front end and back end, which should also solve the...
  15. dedren

    How to Link Related Cases?

    I believe I can search a subform because Forms!frmCase.sbfInvolvedParties.Form!LastName worked to reference the control of subform2, but it only checked the first control of subform2's datasheet. Also the article on this page gives the syntax to do it...
  16. dedren

    How to Link Related Cases?

    Not sure why that didn't work, maybe making it a TinyURL messed it up; here's the full link:https://docs.google.com/fileview?id=0B2fxStZCLNTJM2JkZjUyODMtOTU4Mi00Yzk0LWE3ZWItMjg0NDg4YjkyMDcw&hl=en
  17. dedren

    How to Link Related Cases?

    Here are table relationships: tblCaseMain - Has the bulk of the case information. CaseNum is the primary key. tblNamelst - Holds all the names and has many names per CaseNum. NameID is the primary key (not used) but I use CaseNum as the foreign key in this table. Here is how it works for the...
  18. 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...
  19. dedren

    Adding additional fees to balance and subtracting payments

    Your guess is pretty darn close. All involved tables are linked with the alphanumeric field called [CaseNum] (ex: 09-1234). The main table is: [tblCasesMain] The balance table is: [tblBalances] with [InitBal] as the pertinent value. The fees table is: [tblFees] with [FeeAmount] as the pertinent...
  20. dedren

    Adding additional fees to balance and subtracting payments

    I couldn't edit my last thread to ask if it mattered whether I put this control in the main form or in the form footer. I get the same #Name error for both currently. A little more history on this: Before I had to add "Fees" to the balance I had a field in the header section of the payments...

Part and Inventory Search

Back
Top