Search results

  1. J

    May I Pick Your Brains?

    Well, to explaing the flow issue. We have an older system that we are moving accounts off of and onto a new system. On "Date X" all accounts with the given prefix from the "Phase 1" list will have been moved to the new system (which my team does not have access to), and then on "Date Y" all...
  2. J

    May I Pick Your Brains?

    So, I have a new project that I'm putting together for my team, and I'm sure it's something simple, but I'm at a loss for how to go about this. Any help you guys can provide would be greatly appreciated. I have two lists of accoutn prefixes, phase 1 and phase 2. All accounts with a prefix...
  3. J

    Why is logic not logical in Access?

    It seems as if the values I'm getting are the grand total from the entier table, instead of the values for that specific date. I'm not really sure why I'm getting counts that high.
  4. J

    Why is logic not logical in Access?

    Thanks Banana. So, I gave it a try, and as I was hoping for, I got the prompt to enter an Input Date, but the values it returned were way off. Any idea what might have caused that? dbDamo, is this were I'd enter the Parameter fields like you had mentioned? I was looking for a specific box...
  5. J

    Why is logic not logical in Access?

    Here's the crosstab query without any filtering. What would I need to add in order to get receive prompts asking for a start date and end date? TRANSFORM Count(Entries.ID) AS CountOfID SELECT Entries.Process, Count(Entries.ID) AS [Total Of ID] FROM Entries GROUP BY Entries.Process ORDER BY...
  6. J

    Why is logic not logical in Access?

    The problem is...it didn't ask me for anything. When I rn the 1st query in it's own, as I wanted, two prompt windows come up asking that the user supply a start date and an end date, which is what I wanted. Now, the next process needed to be a crosstab query that would provide my breakdown...
  7. J

    Why is logic not logical in Access?

    Hey folks. I could really use your help again. So, I created a query that lists all the transactions entered with a certain entry date, and as a criteria used "Between [Enter Start Date] And [Enter End Date]" which worked like a charm. Next, I wanted to have a crosstab query that would run...
  8. J

    Stumpped again...

    Hello everyone. YOu guys have been a great help so far in getting my database up and running for my department. I've been able to get most all of my main Entries form completed and behaving as desired....with one exception. So, I've created a functioning link between the Function combo and...
  9. J

    need help displaying record in listbox based on parameter selection in combobox!!

    Thanks again Scooterbug. I appreciate your breaking that down for me. Hopefully I will have time this afternoon to play with that myself and see what I can come up with.
  10. J

    need help displaying record in listbox based on parameter selection in combobox!!

    Ok, so I'm looking at the tables you used. In the Associate table, did you create this field as a lookup to the ID number in the site table, or did you you simply type the 1's and 2's and create a relationship between the two? Sorry, I really am completely new to this. I just started...
  11. J

    need help displaying record in listbox based on parameter selection in combobox!!

    Scooter, your example is exactly what I'm trying to do!!! Awesome! Thank you for the sample. It'll take me a little time to reverse engineer it so I understand exactly how you pulled these pieces together, but I'm sure I'll figure it out.
  12. J

    need help displaying record in listbox based on parameter selection in combobox!!

    Well, I did in fact use a lookup, per the guidence of this guide. This technique worked great for my Function and Sub-Function synced combo boxes. http://msdn.microsoft.com/en-us/library/bb404901.aspx The problem is that I have not been able to repeat the process on the Site Associate level...
  13. J

    need help displaying record in listbox based on parameter selection in combobox!!

    Ok, I'm a little turned around here. I am trying to do a similar thing here, but lack the training to know how best to do this. I thought I found a way, but it's not working. Reading this thread has me even more turned around. Situation: I have a form that I am working on. One of the fields...
  14. J

    Rebuilding. Am I on the right path?

    That makes sense. Thanks for the warning. So, when creating my primary table, I'm just going to create two placeholder fields on the table, then when creating the form, I'll create two combo boxes and have the values from the combo boxes saved to the two place holder fields. If I'm taking...
  15. J

    Rebuilding. Am I on the right path?

    Thanks for the link. I'll see how I can try to apply it.
  16. J

    Rebuilding. Am I on the right path?

    Ok, I think I know how I can ask my first question. In my Input table, I'm trying to create two lookup fields. Both fields will refer to the Process table. There are about 20 items processes on this table which belong to one of five functions. As it stands, when I click on add the Function...
  17. J

    Rebuilding. Am I on the right path?

    There ensues the issue....there were no backups. The maunal back up that I had created, two weeks prior, had been deleted by someone in another department. Thus the body buried in my back yard...*doh! I didn't say that* LOL.
  18. J

    Rebuilding. Am I on the right path?

    Hey there folks. I could use a little help. I have a database that our department has been using for a few years. The associate that created it is no longer with us. The beginning of this month, the VBA module became corrupt and the back up I'd used before had been deleted by a clueless...
  19. J

    Is this possible...

    Awesome. I'll give that a try this afternoon and we'll see how things go. Thanks again. You guys are great.
  20. J

    Is this possible...

    Thank you both for your replies. Reading your reply, DCrake, makes it quite obvious to me that I am going to need more advanced training than what I have found to date. Can you guys recommend a site that would provide some in depth tutorials on the more advanced techniques for crafting...
Back
Top Bottom