Search results

I have searched but I might not be entering the right keywords. I have a table1 on SHeet1 with a list of EmpID and EmpName. On a seperate sheet, table2, I have a drop down list compiled from the EmpID. Next to the drop down I have a blank cell. I want the blank cell to return the EmpName that...

I have start date (E2) in table 1. Table 2 has a start date,an end date, and a budget number. StartDate EndDate BudgetNo 9/1/09 2/28/10 1 3/1/10 8/31/10 2 9/1/10 2/28/11 3 My formula needs to show that if Table1!E2 falls between these certain dates than it will...

I guess this is the correct forum section for this. I apologize if it is not. I have a query that gives a list of all the address, city, and state locations for our deliveries in one day. If I export the results to excel and copy/paste into MS MapPoint it will analyze the data and plot the...

I am missing something. I am trying to output a single record into an email. I have it outputting the whole table. Can someone review and possibly push me in the right direction. Private Sub Command65_Click() Dim stDocName As String Dim sFilter As String Dim strPath As String...

I have a simple expression criteria to open a report. I have used this same code to open reports since forever. All of a sudden I start usingthiscode in a new 2007 db and I keep getting "THE EXPRESSION IS TYPED INCORRECTLY, OR IT IS TOO COMPLEX TO BE CALCULATED...." What the heck is going on????

I have attached a picture for what I am trying to do. I have a list of names on the left in subform one. The detailed information on the right. I want to select a name in from the left and have the record information appear on the right. Can anyone point me in the right direction or link me to a...

I was curious is this could be done. My company has our orders automatically numbered according to the day it was written. Is there any way to break out the information automatically in to another formatted field. EX: 0812310001 08 = year 12 = month 31 = day 0001 = ticket number I want the...

I am not sure how to explain this, but here it goes. I have a sales report with three major categories for each salesperson. I am ranking the salespeople in each category. Is there a way add a field that ranks salesperson by category. Salesperson Dollars Rank SalesCount Rank Warranties Rank...

I have a 55 page contract in Word. I have to update these contracts every 6 months. The things that need changing are in my database. Is there a way I can just insert the data from the database so I dont have to search and paste through 20 contracts at a time. I tried to import the text from...

I am trying to total out the final portion of my report, but I cant get the report to run. The computer tells me that it cant recognize [text52] to sum it out. Can anyone tell me what I am doing wrong by looking at the image.

I have a crosstab query where I can compile the totals per day that I want. What I need to do is then group these days into weeks by the following Sunday for a week ending total. How can I link each day for its corresponding week ending date. I attatched an image if it helps.

My main report shows deliveries and types by month. At the bottom there is a subreport that totals everything for the year. However if you go back a month or two or three, etc the report show the total for the year, not up until that month. Any Ideas on how to total up up until the selected month?

I have seen genius at work on this forum. I have a table for the drivers and I have a tble for the dates. What I need to do find a way to log their trips that will work like this form. See example. Any suggestions?

I have searched, but found no reference to my exact question. I have a list of drivers I need to create a checklist for each day. The Parent form is the day and the subform is the list of drivers. What I would like to do is have a command button automatically enter all the drivers that are...

I have a report that compiles all complaints. I want to grab the date from the first record and the last record from the report and put it in the report header, then Long Format the date to show only the month and year. Can anyone help on this one?

I have searched, but I cant find a thread for this. I have a calendar that I input when people are going to be off. If there is nothing for that date then the record is blank. I have a form that opens when the db opens attached to the date on the switchboard. If no one is off then the form...

I would like a MsgBox to pop up at 2:00 everyday similar to a outlook reminder. Send in the 2:00 Report Is this possible?

I am sending an email from a form and it almost works the way I want it to. I need to accomplish two more things. Here is an example of what the subject needs to be: 2:00 Report Wednesday March 15th, 2006 I cant get the values into the subject line at all. I can get the info into the body, but...

I have a subform that populates the same data for every day. What I would like to do is have an OnClick even fill in all the records at once. I have tried a method of pasting, but I am sure I am either doing it worng or there is a better way. My code: Private Sub Command65_Click()...

I have to put a simple report in the body of an email. I am running limited resources and am looking for a basic code to do so. Private Sub Command28_Click() On Error GoTo ErrorHandler Dim strToWhom As String Dim strSubject As String Dim strMsgBody As String strSubject = "Fax Delv and Driver...