Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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?

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

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

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

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

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

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

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