Search results

I have a scheduling database that my company uses to manage our customers deliveries. We would like to make this database more intelligent by adding some logic and I am not quite sure how to proceed. On the form frmDelivery, the user inputs all the header information for the delivery, in the...

I have a query that is looking at the Lot Delivery Date (LOTDELDATE) and summing the quantity of units that are due to be delivered that day and summing the number of boxes associated with that lot. It look at the State and groups them by day and state. I want to add the status field and have...

Hi everyone. Let me see if I can word this correctly. I have a report that shows by State how many lots we are have coming out everyday. It shows the month and then lists each day underneath that. Then it shows the next month and lists each day under that. I need to add a subreport that also...

How can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening. Any ideas? Thanks

I am having trouble keeping focus on a field in a subfrm when I click the next button for the next record. I have a frmQuiz. This shows the quiz question. I have a subfrmUserAnswers, where the user enters the Answer ID in the field UserAnswerID. This form clears to a new record when the Next...

Ok. I Lied. I Thought That Did It But It Made It 1905 And Depending On How I Arrange The Mm/dd/yy, I Get All Different Dates. I Could Really Use Some Help On This!!!

Ok. I figured it out. Here is what I changed the code to in case anyone else has this same problem: CurrentDb.Execute "INSERT INTO tblQuizzes ( QUIZNO, [DATE], LOGON )SELECT " & intNQ & " , " & Format$(Date, "yyyy-mm-dd") & ", '" & Environ("Username") & "'"

Ok. I changed it from NOW() to Date and it goes through with no problem. However, it still shows in the tbl as 30 Dec 99. I can't figure it out. It shows correctly in the unbound field on the subfrm. \ CurrentDb.Execute "INSERT INTO tblQuizzes ( QUIZNO, [DATE], LOGON )SELECT " & intNQ & " , "...

When I pasted CurrentDb.Execute "INSERT INTO tblQuizzes ( QUIZNO, [DATE], LOGON )SELECT " & intNQ & " , " & Now() & " , '" & Environ("Username") & "'" in I get Run Time error 3075: Syntax error (missing operator) in query expression '06/08/2005 10:59:19 AM'.

Date/Time no formatting.

I have this code that a member helped me create in one of my forms. However, the date that is being input into the table is 30 Dec 99. It won't change no matter what the code is changed to. The date is showing up correctly in the subform, it is just not inputting right into the table. Private...

In my database the user inputs a new job to schedule delivery. The user inputs the main job information and then inputs the lots to be delivered in a subform. After the user inputs the lot and plan information, a message box pops up asking if the user would like to input Options for this lot. If...

Help Ok. I have changed my reports a little bit. We are going to get more specific with the areas. So 1 = SouthEast 2 = SouthWest etc. So I have a text box that I want to only show the total for Area 2. It will only total Area 1. Not sure how to get around that. If...

Still Trying It is still only total Area 1. It's not adding in Area 2

Hello. I hope someone can help me. I have a report with several subreports. I am totaling $ amounts to get some statistics for our customer service department. I have subrptForecastSummary that shows the total $ amounts for each delivery area. I have an unbound text box in my report header that...

I have a form that assigns numbers for our projects. As long as the year is different you can use the same number. Basically this is used to show how many projects we have had each year. December 22nd starts our 2004 count. I need to have the numbers start over from one. I'm not sure how to do...

OK. STILL NOT SHOWING ME THE RESULTS IF THERE IS NO RECORD IN qryYearlyTotals. I think it's the months field. Not sure how to add that. SELECT tblSalesman.SalesID, tblSalesman.SalesmanName, qryYearlyTotals.Current, qryYearlyTotals.Months, qryYearlyTotals.Years...

Query Like this? SELECT qryYearlyTotals.SalesID, qryYearlyTotals.SalesmanName, qryYearlyTotals.Months...

Sorry Pat Sorry Pat. This is just so frustrating!! SELECT qryYearlyTotals.SalesID, qryYearlyTotals.SalesmanName, qryYearlyTotals.Months, nz([SumofTotal$])+nz([qryYearlyTotalsOptions].[SumofAmount])+nz([qryYearlyTotalsCounterTops].[SumofAmount]) AS Total FROM ((qryYearlyTotals RIGHT JOIN...

QUERY OK. THE [MONTHS] FIELD IS NOT INCLUDED IN TBLSALEMAN. MONTHS IN THE QUERIES IS MONTHS: DATEPART("M",[CONTRACTDATE]) HOW CAN I GET THIS TO SHOW IN THE NEW QUERY AFTER USING THE TBLSALESMAN TO JOIN THEM WITH?