Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Mr2006

  1. Mr2006

    Date range

    01-Mar-08 30-Jun-08 1 $2,500.00 $2,500.00 01-Mar-08 30-Jun-08 1 $2,500.00 $2,500.00 15-Mar-08 15-Apr-08 1 $9,679.22 $9,679.22 16-Mar-08 19-Mar-08 16 $50.00 $800.00 16-Mar-08 19-Mar-08 16 $150.00 $2,400.00 24-Mar-08 1 $436.59 $436.59 26-Mar-08 26-Mar-08 1 $330.00 $330.00...
  2. Mr2006

    Date range

    Yes. exactly.
  3. Mr2006

    Date range

    Yes, this is the right data but for the money part, is there a way to get the result based on the month we are in. example, if we pay monthly $1000.the result sould be $4000.00 for the above example. The respns is that we have alot of recurrent requests for year long that we pay monthly...
  4. Mr2006

    Date range

    I have a query that I would like to run to get how much money have we paid in a period of time. SELECT ProjectAct_tbl.StartDate, ProjectAct_tbl.CompletionDate, ProjectAct_tbl.Rate, ProjectAct_tbl.AmountReimb, ProjectAct_tbl.Quantity FROM ProjectAct_tbl; Example: Start date completion date...
  5. Mr2006

    Template

    So if the document in PDF format or word format, how can I convert it so I can add it as Picture.
  6. Mr2006

    Template

    yes. It is a specific design that looks very strange. The background of it looks like the globe in top of someone's head. I am not trying to be funny. but that is what it looks to me. The combany wants all thier reports to come with this type of background. I thought about making copies and...
  7. Mr2006

    Template

    All, I have a company template that we must use in reporting. I can not use anyother design. I want to see if I can use this temlate to be part of access database. is there a way to do this?
  8. Mr2006

    Auto Number

    dhookom, will this be for a form after update event...
  9. Mr2006

    Auto Number

    I would like to create custom autonumber that will contain the following: firstletter from firstname first letter from lastname dateof birth. John Smith 04/05/2008 JS04052008 How can I go about doing this? Thanks
  10. Mr2006

    <div> </div>

    Hello, I have an invoicedetail_tbl that has invoiceDetaildescription field (Memo). I see before the text some time and at the end of the text </div>. some time I see <div>&nbsp;</div> it happens randomly. Sometime, I do not see it at all. Some time when I open the form, I see it Any...
  11. Mr2006

    Screen Resolution

    Hi All, We have several people in our office with different screen size. Some use laptops. Also, some people because of vision problems, the font size is very large and the resolution is not the same like the rest of the people. Now, the Access database we use appear different from once screen...
  12. Mr2006

    VB

    Thank you for all the feedback and suggestions. JBinQLD (Programmer): That is exactly what I am looking for (Principle) since I know how to use access by itself with a little, very little in the coding side. fneily (Instructor): If I knew about the course when It was offered, , I would have...
  13. Mr2006

    VB

    Hi ALl, I have been looking for classes to teach VB for access to improve my skills, but everything I see is in the .net area. Do you suggest any school or on line courses, good books. I took access classes but usually I do not learn anything new in them.
  14. Mr2006

    MsgBox Day

    Thank you so much for your help. I will try to take it from here
  15. Mr2006

    MsgBox Day

    Hello All, We have several scheduler in the office who schedule for different people work orders. I want a msgbox to appear if one scheduler try to schedule same employee for different work order that falls between or on the same two dates. (startdate and enddate). It is Ok to schedule, but we...

Part and Inventory Search

Back
Top