Search results

Ok, trying to take a different approach, but I don't know if this can even be done, since I can't say I've ever seen this, except in a cross-tab query, which isn't quite what I'm looking for. Is it possible to have a form, where new records populate to the right, kind of like a spreadsheet...

2 hours of my life I'll never get back, please help. I have AuditTrail implemented perfectly in my database. Works like a champ for one of my forms. I believe I've replicated the exact same setup on another form (i.e. AuditTrail field named tbAuditTrail, BeforeUpdate event on the form, etc) yet...

Aww, come on. I know how you all love Treeviews. :rolleyes: Anyone able to help?

Still fighting to understand a darn thing about treeviews. What I was hoping to do was create a kind of knowledge base that I could integrate into a larger database I'm using. I wanted for each entry to have a category, short description and then longer details. Then for the treeview to display...

I'm not sure, but did you attach the right DB? The one you attached and the one I attached look identical and are behaving the same way. Thanks for the help though.

I definitely didn't describe my problem well. Attached is a sample database. Problems I'm having with the database as it stands: 1. Open the case form. View the notes. Everything looks ok. But scroll to Case #2 and you'll see the notes from Case #1. Refresh the listbox and now it will...

Ok, this is interesting. The listbox is displaying the contents of Note1 even though I'm on note XX (where X is any other number). But if I click on the listbox and go to Record - Refresh it fixes it and displays the correct notes. SO.... how would you make it do that from code? I've tried...

I have a search form (Form A) that as I type in a text box the contents of the listbox refreshes to show only those items that match the text in the text box. When you double click on any of the items in the listbox it jumps me to a detail form based on the ID field. On the detail form, there is...

Ok, closer still, but now I'm getting an error when I try to do the insert. I figured the viewing is the easy part, I'll do that last and get the data input part down first.

Greatly appreciated, Pat. Definitely some food for thought. I'll play with it for a day or so and see if I make any headway. Thanks again.

I must be severly missing something. I've attached a mockup of my database. After several hours, I cannot get it to function the way I was hoping. Any assistance you can provide is REALLY appreciated. Thanks!

Ah, I see where you're going, but it's not quite what I'm looking for. The idea is that UserA opens the form and there in front of her is a page that has a listing of all the metrics she's responsible for the month of January 2005 and next to it is a field where she has filled in the values for...

Ok, I see what you're saying, but I'm still confused. (Really feeling like I'm lost in my own bathroom :) ) I was initially thinking of a form that would arranged like so: MetricMonth (populated drop box that jumps the user to a specific month)...

I'm sorry if this isn't the correct forum to be posting in, but I wasn't sure where "I'm very familiar with Access, but I need to do X and I'm not even sure where to begin"-questions go. I need to create a database that collects monthly metrics for an entire team. So I setup tables met_Metrics...

So I'm guessing this can't be done?

Lagbolt, Best way I can explain it: Cases Reviewer 1 Case 1 Case 2 Reviewer 2 Case 1 Reporting By Date All Cases by Date Closed Cases by Date By Reviewer All Cases by Reviewer Closed Cases by Reviewer etc. Basically you'd click on "All Cases...

Holy Crud! Thank you so much. That should be more than sufficient to get me started. That's really appreciated man. You made my Monday! Just out of curiosity, once I have this up and running my next goal is to have a second main node for reporting. I assume I'd have to staticly define each...

I have a form, with a tabbed interface. On each tab is a subform showing a continuous form with records matching criteria. I'd like for the name of each tab to also include a count of the items in each subform on each tab. Is that possible? So the name of tab 1, instead of "Opened Cases"...

Windows Mobile 2003 does support Access Databases being moved onto the device, but there are no built in apps to view the data. There are several free or reasonably priced applications which will let him/her view the data and even modify it (changes will sync back to the desktop DB). A quick...

Ok, now things aren't giving me errors so I'm going in the right direction. But I'm back to my original question: Currently, my treeview is returning the reviewer EVERY time he shows up in the tblCases table. Obviously, I'm going for unique values here, but have no idea how to make that...