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!

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

Search results for query: *

  • Users: Mr2006
  • Order by date
  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...
  16. Mr2006

    Combo Value Msgbox

    It worked perfectly. But one problem is that he combo can be left blank which will not work. If the purchase date is not null, making a choice in this field must be mandatory. Thanks
  17. Mr2006

    Combo Value Msgbox

    Hello, I have a combobox that have yes and No value. The row source is Value List. The name of the combo is shippingneeded I want a message box to pop if someone chooses yes. The msg will be “Call shipping dept at 222.” If no, then nothing happen. I truly value your suggestions!!
  18. Mr2006

    Set Focus

    Thank you so much. It worked perfectly.
  19. Mr2006

    Set Focus

    Hello, I have the following codes in the load event. If the purchase date field is not null, the user must choose something from the combobox (shipping needed). Right now, the box pop up but if we select Ok in the msgbox, it close the form. I want to be able to have the cursor set in the...
  20. Mr2006

    if statement

    Hello I have a calculation formula in a field, [workdays]-[offdays]-1. the result sometime shows negative number. I want to include in the formula if the total is negative, the result will be zero. Any Suggestions!!

Part and Inventory Search

Back
Top