Search results

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

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

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.

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

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

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

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

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

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.

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

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.

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

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

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

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

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

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.

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

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

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