Recent content by modest

  1. M

    Use VBA to CREATE a report

    Wowwww this is old. I'm re-reading this question and remembering all the work I used to do in Access. I'm glad this project sort of fell in the wayside. I'm glad to see Happy's post is helping people.
  2. M

    Updating recod

    Well the issue is are you trying to update through an objects event, or strictly through code. If you have a form attached to a table, you don't need to be messing with VBA, however if you want to strictly do it through VBA then I would look into DAO recordsets. Ex. Dim db as DAO.Database Dim...
  3. M

    Need to randomly allocate a resource based on a change in week value

    I think the reason you're not getting responses is probably due to your terminology/vocabulary. While words have multiple meanings, a fixture is generally used when referring to devices, such as a light fixture or plumbing fixture; it's something that's been installed or added on to property...
  4. M

    Updating recod

    This has to do with attaching a form to a table that has a password field. The form has 3 textboxes; one for the original password, and two for the new password (one is used as verification of correct input). The problem with doing what is shown here is that there is no username associated...
  5. M

    Need to randomly allocate a resource based on a change in week value

    I think the reason you're not getting responses is probably due to your terminology/vocabulary. While words have multiple meanings, a fixture is generally used when referring to devices, such as a light fixture or plumbing fixture; it's something that's been installed or added on to property...
  6. M

    Scrollbar Positioning Question

    bump. .
  7. M

    Scrollbar Positioning Question

    Wondering if anyone found a solution to this yet: 'Put cursor at the end of the text box Me.txtBoxName.SetFocus Me.txtBoxName.SelStart = Len(Me.txtBoxName) The problem now is that even if 2/3 of the textbox is whitespace, the scrollbar still scrolls to the bottom of the box. Anyone...
  8. M

    subform reference

    It'd be nice to have that link in a sticky.
  9. M

    Data Mining

    Interesting Doc. But still, keep it simple. Use a query and the time functions as I previously suggested, it's quicker to construct. If you are in need of something more versatile, use what Doc provided. It will be able to break down your groups easier in the future.
  10. M

    reset listbox

    In the other box's _Change() event, do the following to refresh the list: combo_CostCentreLevel.Requery If you want to reset the listbox's value completely: lstListBoxName.Rowsource = "" lstListBoxName.Requery
  11. M

    Global variables

    There are essentially three kinds of modules: class, standard, and object Class is where your class definitions go Standard is where your commonly used functions should go Object is where functions pertaining to a particular form/report are (it is where the event handling goes) When using...
  12. M

    Check for Duplicate Entry

    Just a supplement to what Bob wrote, The DLookup() will return a Value or a Null. You just need to test if it found anything with IsNull(): If IsNull(DLookup("Invoice_Number", _ "LOE/Facility Construction - Updated", _ "Invoice_Number = " & Forms![LOE/Facility Construction...
  13. M

    Congrats to BobLarson, theDBGuy and PBaldy

    Just wanted to send a congratulations to BobLarson, theDBGuy, and PBaldy for their efforts noted on utteraccess.com. Their generosity has extended here, to Access-Programmers Forum, and though there isn't an official "recognition" page, they still deserve it.
  14. M

    How to cut off part of a string (parse)

    We've posted several functions on this forum that breaks a fullpath to it's corresponding root directory, file path, filename, and file extension
  15. M

    Data Mining

    Just use time functions to break the minutes and place them with their corresponding hours. I stored your data in a table called "Price" SELECT Price.Contract_Date, Price.Current_Date, IIf(Hour([current_time])<10,"0") & Hour([current_time]) &...
Top Bottom