Search results

Thank you very much for responding Kay. I have all of my queries in order and am about to prepare my macros. I have a ton of queries to run, which will now become macros. So, from there I will organize the macros into groups to simplify the procedure. Thanks for your help, ;)

These would be the positions to fill, the could easily have name such as supervisor, lead sales, inventory and so on: Position A Position B Position C Position D _(Jones)_ _(Barnes)_ _(B Smith) _(M Gale)_ These positions will be filled with...

Sounds simple enough. Thank you.

Yes, you did answer that question. My question today, was how to design the macro, or where to find information that would guide me through the process. As I stated, I'm new to Access and just learning about macros.

I'm new to Access 2007. Can anyone please explain to me how to design a macro group to run a nember of queries in sequence or where I might find information that will instruct me in how to do this? Thank you.

Hello, I have a question regarding designing a query to obtain a specified single record or row from a table. Is this even possible? I understand top value and least value queries and filters. I've also done a lot of research in how to obtain a specified number of top or least value records. I...

I have the basic information being input into a table using a basic form. Everytime I input the information it's dated. Need to store the information by date so that I can graph the performance from one date to the next, over the course of months. When I input the information, each time into...

Thanks for your reply. I'm using Access 2007. When you say code are you referring to VBA? Or using MS Access code? What type of code would you use?

Hello, I have a basic question: I'm new to access and I'm just learning about how to create macros. Can you please tell me if it's possible to run a series of queries by using a Macro that includes these queries in sequence? It's my understanding that you can run a series of macros in a group...

Hello, I'm not sure if this is a question specifcally for the tables board or for reports. But here is my question: I run statistics that are based on many queries and I need to store the results of the queries on a weekly basis according to the date the queries are ran. Is it best to store the...

What I presently have are skill categories that are based on calculated expressions. These categories contain all of the employees and they have been grouped according to the expressions used and ranked in desending order. I was going to base a top rank query on these categories to obtain the...

For some reason I'm getting the same error when I try to run any of the macros manually. What I was saying about a query assigning a true value, was basically a way for the system to simply designate or check the the yes/no box to a "yes" value. rather than the user having to do it manually. The...

Hi David, I went through the file you sent me and I believe it would be easily executed this way. It would appear that through your form, you would designate the position, run the query and then check the allocated box. Is this correct? Then you would designate the next position, run the query...

Thanks a lot for your help ... if it works maybe I'll be able to hire more staff to do this type of stuff on the weekends, instead of me having to do it myself ;)

I really appreciate your help. As you can see, I barely know some things about Access, and nothing about VBA.

Hmmm so what your suggesting is to manually check the allocation box after every step of the process, to eliminate that employee from being placed in the next step? Yes, I do think that would work. However, I would like for the entire process to be automatic. I've read up on Macors and I believe...

I'll have to go through the DB to remove the sensitive information before I can post it online. This DB is being developed to function online. My plan was to develop it using access and then migrating it to MS SQL Server. I realize at some point, I will have to employ an IT professional to...

Please forgive me if I sound ignorant. I'm really new to access. Your suggestion sounds like a very interesting concept. Would the allocation happen as a part of the expression of the query or as a check box, like with your first suggestion? I can understand check boxes and true/false values. If...

Thanks for your reply. However, I'm not sure what your referring to? I was thinking of a top query to locate the top ranked employee to be placed in a position, with another query that will contain a column for the employees that have been placed. Every subsequent step would have a subtraction...

Hello, I have a couple of ideas for how to accomplish this task. But I'm not sure what the best way would be. So, I thought I would present it to you experts. Here's the task: I'm currently filling various positions in my company, according to priority. Using the ranking positions of my...