Search results

In the following query in the WHERE statement I have "QNTY ON HAND" being compared to Reorder_Level. My problem is that "QNTY ON HAND" is a column I made up in the SELECT statement by subtracting UNITS_RECEIVED from UNITS_RECEIVED. SELECT PRODUCTS.PROD_NAME...

Here is the where statement in a query that I did...I think similiar to what you are trying to achieve. WHERE [FORMS]![My_Switchboard]![COMBO8]=[FACILITY].[FAC_ID] AND [APPOINTMENT].[APPT_DATE] BETWEEN Date() AND DateAdd("d", 7, (Date())) What this query that I have written does is give...

I am still receiving the error upon opening the database that says, "The expression you entered has a function name that Microsoft Access can't find" I created an AutoExec macro that includes the Action RunCode with the function name ToolbarsOff(). Do I need to declare the function...

ghudson, When I tried to go to Macro/Action/RunCode/ToolbarsOff() and run it is saying Access can't find the function. Any ideas? Kacy ________ WENDIE 99

Thanks....This is exactly what I needed. Kacy ________ Jaguar xk120 specifications

ghudson, Ok, I looked at that code and I have two questions for you. First, can I put this code in an AUTOEXEC macro so that it will remove the menu bar from every form contained in my database? Secondly, when have the menu bar and toolbars turned off, I saw that you say it also disables the...

In my AUTOEXEC macro I run the ShowToolbar command. When I open this database it includes the toolbar I selected correctly. What I'm trying to accomplish is a way to turn off the form view toolbar. I will be having several users using this database and I would like to take away the ability...

Thanks Wayne! Exactly what I was looking for. Kacy ________ Toys couple

I'm not for sure if I did it right, but when i click on the checkbox that contains the empty project I receive a run time error 2115. "The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field. Is...

I have a check box placed in front of a text box that contains project titles. The user clicks the check box to view reports of the desired project titles. My problem is after the last check & text box access puts a blank check & text box. If a user accidentally selects it says the "project...

I have a form that I call "UPDATE." When a user makes a change, but decides to hit the close button the following message appears....."Write Conflict" "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other...

Works just the way I wanted it. I can put in my date criteria and it gives me the count for ALL facilities for that particular month. Thanks again. Kacy ________ Suzuki sv1000 specifications

I have a table that has all the facility IDs available. I also have a table that has the number of license issued for each facility. I would like to write a query that lists ALL of the facility IDs. and have the number of license issued for each facility. If a particular facility did not...

Here is the query that I am using. I did that with the outer join, but still it does not give me all the records from my base table. SELECT FACILITIES.FAC_ID, COALESCE([2001 HEADER].[HEADER COUNT],0) FROM FACILITIES LEFT JOIN [2001 HEADER] ON FACILITIES.FAC_ID = [2001 HEADER].FAC_ID WHERE...

I'm new with the term of Coalesce, but I am wanting to include all the values from the left table even if they are null. Does access support this "Coalesce" What I'm doing is taking a facility table that lists all of the facility IDs. I am then linking it to a Monthly table that gives...

Bill, Thank you very much.....Exactly what I needed. Thanks again, Kacy ________ Dennie

I was wondering if anyone knew how I could get my report to start on a new page for each record. For example, Project Title : Test Date: 1/23/03 yada... yada... yada... When it gets to the next record I would like for it to be on a seperate page. This is what I am getting ALL on...

John, I tried another query that linked the two together and it seemed to work. Thanks for the advice anyhow. Thanks again, Kacy ________ Sick From Depakote

I have a form that uses two different queries to get all of the data. When I try to update this information within the form, down at the bottom it says this is not an updatable recordset. Is this because it is from two queries? Is there a way around this? Thanks in advance, Kacy ________...

Basically the form Add_Projects is the start page. When you click on Track by Managers you will notice Kacy Reiss as a manager twice. I was wondering if there is anyway to display managers (Kacy Reiss) only once then when you click on View Projects on the Project_Manager form it would...