Recent content by dedren

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