Search results

I'm sorry, but I really can't post a copy of my database online. It contains sensitive information that can't be displayed on the internet. Is it necassary that I do so, in order to attain an answer to this question?

Hello, After creating a new table, I based a new query on this table. I created the query on several fields in the query and added a calculated field based on these fields. Now when I attempt to run the query or even open the query after saving I get an error code asking me to enter the...

Yes, I was thinking about using the NZ function. Thank you very much for your help!

Thanks for the reply. My purpose for the question is for the following issue: I'm developing a software program. In this instance there will be a contant value of time that will be input. The statistic value will be determined by the distance variable. Whereas, the query formula that will be...

Hello, I have what may be a very basic question. When designing a software program, if you are calculating an amount, using the values of several fields in a table, would it be best to do a calculated field within an additional field in the same table, or to design a query with a calculated...

Hello, I have a form that I've designed to input information into a table. This information will be used to run many queries to obtain calculated statistics. On this for there are options that can be chosen by the user. These options will determine the formula query that will be run to obtain...

Hi Bob, I was able to open your example and it works exactly the way I'd like mine to work. However, when I tried to assign the code it keeps giving me an error, saying that I can't assign another value to the object and the it tried to run a debugging application. It got to the point where the...

Hi Bob, Thanks for you reply. I tried to do what you said. But it hasn't resolved the issue. The number still remains unchanged in the text box, until I press the tab key. Maybe I'm not doing it right? Here's what I did: I first tried to do this through the Build Event function and entered what...

Hi, Was wondering if anyone has encountered this problem and how to resolve it. I've created a form that includes text box fields attatched to spin button controls. Everything works fine with this exception: The numbers within the text box, do not change along with clicking the spin button...

Hi, Can anyone please tell me the procedure for adding a 6.0 (SP4) Spin Button to a form in Access 2007? I've tried to follow the procedure that I've found for earlier versions. But when I click the Spin Button and pull down the property sheet, as instructed, there is no Control Source option...

Thanks a lot I'll take a look at it.

Hello, Thanks for your response! First of all yes, the information that is initially input into the system, is relied upon for the queries. I've already designed the queries that will be ran to produce the desired results. The information is input and the queries produce the results. I'll...

Can anyone tell me if it's possible to create a control or function, within a form, that allows you to view a query result and then subsequently save the query result? What I would like for the form to do is the following: Information is input into the designated fields. Then with a control: Run...

Hey, Thanks so much! Really new to this as you can see ... I have another question, if you don't mind ... Later on in the program I'll be placing employees into various positions according to their rank in the various categories. Here's the problem: People can't be placed into positions...

So, I was right then? Step 1: make an additional Table to house the stat information from the query results. By creating a make table query, with a date column as you stated. Then ... Step 2: Do an Append Query to append that table, which includes the Date:() date field and append that to the...

Hello, Thanks for your reply. Right now I have a single table that contains the employee information for twenty employees. There are a number of fields that contain the various performance categories. The scoring information for each individual category is input into this table. The various...

Hello, Can any one tell me what the best way is to save and store query results, by date? I need to run weekly statistics and then save the results. I've already developed the queries to produce the stat results I need. I now need to store the values every week, in order to run a performance...

Hi Thanks for the reply and the information. I was just wondering if the table generation is always dependent on the queries, in order to update the table everytime it's run. I have many queries and the number continues to grow, to produce the information I require. Many formulas and combining...

I'm actually running the latest version of Access 2007. I was only able to pull up the initial forms of what you had sent to me. It wouldn't allow me to do anything else. It said that it was a "read only" document. I wasn't even able to pull up the SQL info to see what you had done. I had also...

Hi John, Thanks for your help ... Unfortunately, I have read the Microsoft help according to the link you sent and everytime I try and change the alias name of the query within a query, Access automatically says it is closing? I've tried everything, but it shuts down everytime I try to enter an...