Search results

  1. R

    Filter and unfilter subform(datasheet) based on combobox

    thanks man!! I'll try that when I arrived in the office today... whew...
  2. R

    linking forms

    Use hyperlink?
  3. R

    Filter and unfilter subform(datasheet) based on combobox

    Nope, It has no brackets, just state. The code Ive got just shows with a bracket and it was working properly (no debugs). My problem is when I try to choose the field ALL, everything is not shown. It should turn off the filter then
  4. R

    Filter and unfilter subform(datasheet) based on combobox

    Hi Folks! I wonder if you could help me out with my problem... I already know how to filter my subform (datasheet) based on a combobox. The problem is, I dont know how can unfilter it... I have a value "ALL" in my combobox so that If I select it, the subform get's unfiltered. I have searched...
  5. R

    How to set the default value (date today) of a listbox

    waaahhhhh!!!!!!!!!!!!!!!!!! Ur the bomb!!!!!!! I got it! I got it! ehehehe, thanks vbaInet! I never thought it would be that fast!!!!!! Now I know... I had to try that several times before I have done it perfectly. I was overwhelmed with the rowsource code that I forgot to change the row source...
  6. R

    Sending a Form in Access to a Webpage

    forgive me mrbethell but your not gonna learn everthing at the same time... Patience and lot's of research and experience you need... = )
  7. R

    Sending a Form in Access to a Webpage

    what does the object PAGES doing? ehehehe, I am using MS 2003 coz we are still heavy users of 2003 in the office (I wonder why they still use it) I have to downgrade to 2003 just to make sure they are compatible.
  8. R

    cant filter using Month(Now())

    ahahaha, actually I don't know the difference vbaInet but that things works for me. I just saw that criteria from microsoft. I am just a bit unsure what would be the difference or the effect of it. My users seem to be very happy with the monthly query = )
  9. R

    How to set the default value (date today) of a listbox

    The double click event will display the date and time when clicked twice. The reason why I set that to double was that I want to minimize so much changes whenever the cells in the datasheet were clicked. I am not sure if the Before_update event will make the listbox work so that when it was...
  10. R

    cant filter using Month(Now())

    I think I already encountered that.. I used this criteria. Replace SalesDate with the name of your field...
  11. R

    How to set the default value (date today) of a listbox

    I have another temporary solution but I still haven't hit the right thing... Whewww... This thing really makes me sick... I tried to change the event property of the textbos so that whenever it was double clicked, the date and time will appear. However, this is not exactly what I want to do. I...
  12. R

    How to set the default value (date today) of a listbox

    Tnx vbaInet! However, I am using a datasheet tracker on a form that works much like an excel spreadsheet. The reason for this is that I dont want users to feel much like difference between access and excel. Also, it allows multiple updates and let's you see a wide array of data. Not sure if I...
  13. R

    How to set the default value (date today) of a listbox

    I've found a temporary solution by pressing CTRL + ; for date today or CTRL + : for time now but I don't find it user friendly... It works best if I could use the dropdown button and have the time or date today. It is easier for users that way because some users may not even know the key...
  14. R

    How to set the default value (date today) of a listbox

    I've got stuck to this problem in access wherein I cannot set the default value of a listbox to the date today. I am currently making an AHT (Average Handling Time) in access but seem to have no luck. In excel, I know how to make it but not in access (please see sample AHT in excel) I know how...
Back
Top Bottom