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 derfloh 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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?
  3. 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
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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!!
  9. 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...
  10. 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!!
  11. Mr2006

    Group records only if date and ID is the same

    How can I group records for the same EmployeeID that falls between any specified dates? For example: an Employee may travel from Boston to New York and from New York to Maryland and from Maryland to Boston as final destination. The start work day is 08/01 and the end work day is 08/05. Travel...
  12. Mr2006

    Date field if not null, Value must be entered

    I have Purchase date field in the database that is not mandatory field. But I want if someone write a date in this field, the combobox under it for Yes and no to be mandatory. Any suggestions
  13. Mr2006

    Dependent Listboxes

    I have one listbox dependent on other. I want to be able when I click on the the row in the first list box, it shows the records related to this row in the second listbox. Right now, it will not do it unless I click on the second listbox. Note: the listboxes used to be combboxes depoendents. The...
  14. Mr2006

    Box Grow according to dates

    I have been working oin this report for a while. It works now butI need the following codes to make the box grow to match the start date and end date. right now, it grows according the number of days. Instead, I want the trip total days to show in the timeline showing startdate and end date in...
  15. Mr2006

    One row instead of Many

    Hello, I have two tables Events_tbl and Traveler_tbl. The relationship is one-many. on a monthly basis, I prepare a report for the month events. I want instead of having each traveler's name in one row, I want to be able to group all the travelers in few rows. to be clear, the report now is...
  16. Mr2006

    Electronic Approval

    I need to create a query to obtain manager approval. We have several managers in our office and each manager has several staff who request several payments to several vendors. I created a query that the managers can run with parameter to show the records that his staff entered so he can approve...
  17. Mr2006

    Securing Database

    I have a database that reside in the common drive. I did not slplit the database. It is used by multiple users. it has not reached 10 users at any given time. I would like to pprevent any user from accessing the tables directly by pressing f11 or by pressing the shift key when strting the...
  18. Mr2006

    Calculate number of days excluding start and end date

    , I want to count the days between two days and exclude the start date and end date in a report Example, Start date 01/01/2008 and enddate 01/03/2008 the result will be 1
  19. Mr2006

    Invoice number/Vendor

    Hi, We have several vendors who submit invoices to us regularly with invoice number and sometime without invoice number. In the case we have invoice number, in the invoice number field (text), I want to be able to have codes to check and see if the invoice number and the providerID submitted an...
  20. Mr2006

    Creating a Signature field in Staff Table

    I have a staff_tbl that I would like to add field in it with everyone's electronic Signatures for later use when they need to print the Signature in the report. I will scan everyone's Signature in a secure folder. I want to be able to select the name from the combobox and the Signature will be...

Part and Inventory Search

Back
Top