Search results

  1. S

    Calendar Calculations

    reply Because I'd like to know how it works for another project, just thought I'd ask here if anyone knew..... I once knew it but without using it, I forgot it.
  2. S

    Calendar Calculations

    Hey random question guys... Whats the algorithm for determing the first day of a given year? Example: Sun 0, Mon 1, Tues 2, Wed 3, Thurs 4, Fri 5, Sat 6 f(2004) = 4 = Which is Thursday January 1st, 2004, was a Thursday. THANKS!
  3. S

    Listbox Hightlight / Selected

    Ok Thank you for your post's I will take a look at them and report my findings !!!
  4. S

    Listbox Hightlight / Selected

    Yes Yes, by clicking on the item in the listbox, the other values are calcuated. I believe that the code only visually highlights the items, therefore I need code that actually selects the item.
  5. S

    Listbox Hightlight / Selected

    I have been looking all around these forms and cant get any answer ! I have a listbox on a form that is part of a record selecting process. When the form first opens, no items in the listbox are highlighted. I need a way to make the first item in the listbox highlighted when the form first...
  6. S

    Why is this so difficult?

    ..... For some reason now, whenever I change an objects top property the object moves to the very top of the form! How can this be so difficult? Shouldn't there be a place to define the X and Y coordinates on the grid?
  7. S

    Why is this so difficult?

    I am trying to dynamically move objects on a form. For instance I have a button or image that I want to move over to the right when something else is clicked... As far as I know the answer has to do with the "Top" and "Left" property, but changing this value through code has no effect.
  8. S

    Weird Problem !!!

    Hey I am using Access 2000 from Office 2000 and I am having a weird problem! I am adding a button to my form to add code to the On Click event for that button. Everytime I click the button I get the error: --------------------------------------------------- The expression On Click you entered...
  9. S

    Mouse Wheel / Combo Box / Change Records

    Anyone ! Anyone !!?
  10. S

    Mouse Wheel / Combo Box / Change Records

    nothing? Anyone have any idea, or is my question to unclear?
  11. S

    Mouse Wheel / Combo Box / Change Records

    I have a combo box that is used to select records from a table. This is ment to be the primary way a user is to move from one record to another. However, I also like the ease of using the mouse wheel to scroll through records quickly. Problem: When the mouse wheel is used to scroll through the...
  12. S

    Combo Box Creates New Record

    Excellent ! DoCmd.RunSQL "Insert Into Table1 (TheDate, First, Second) " & _ "Values (#" & Me.Combo0 & "#, 0, 0)" Me.Combo0.Requery I have been playing around with the DB you posted, I kind get of the idea of how it works... I just have a question about this line in your code. I...
  13. S

    Combo Box Creates New Record

    Here's a sample of what I want I made a sample DB about my topic. If anything else is unclear please let me know, thanks so much for taking a look!
  14. S

    Combo Box Creates New Record

    Anything else? I cant figure it out !
  15. S

    Date Calculations

    Nice Thanks for the help, I am working it out right now !!
  16. S

    Combo Box Creates New Record

    More problems ! Hey, I tried your code and these are my results.... When I type a value not currently in the list, the MsgBox comes up with the text "The record does not exist, would you like to create." If I click yes, the MsgBox runs in and endless loop, just keeps poping up. If I click...
  17. S

    Disabling a Textbox

    Yes! Totally what I was looking for, thanks so much!
  18. S

    Disabling a Textbox

    Hello All ! I have a few textboxs that get their values calculated by a query. I believe Access automatically sets the textbox so that calculated values cannont be changed but I am still able click on the textbox and attempt to input values (I get beeping noises letting me know I cannot input)...
  19. S

    Date Calculations

    Hello All ! :confused: When given a specific weekday date, I need to determine the dates of the rest of weekdays within that current week. All I need is Mon, Tues, Wed, Thurs, Fri, I do not care about saturday or sunday. Example 1: Given date 7/27/2004 (which is a tuesday) I would like to...
  20. S

    Combo Box Creates New Record

    Hello All ! I am currently using a combo box to find records based on a list of dates (which is primary key) of a table. What I need: When I type a value into the combo box that is not on the list, I want to be prompted with a message like "This record does not exist, would you like to create...
Top Bottom