Search results

Hi Bob, Thank you for your response, I have change the CurrentDate to =Date() instead of =Now() and have applied the vb code above to the Mainfrm load event .. but the subform is blank ...

Sorry ... Subform is called "EmployeeDashboardSubfrm" and the control is called "Weekending" It is located at the top/middle is the Mainfrm ....

Hello, 1st ..thank you for the replies ... i have tried all of the suggestions but none have worked ... I have attached the DB ... Thank you in advance....

Thank you for the response ... Quick ... and probably a stupid question ..but .. I would put/apply the code above on the main form ...yes? like a on load event ?

Hello, I am trying to filter a sub form based on a unbound field value on the main form but have had no success. I have tried numerous things such as vb code, and query filters but no luck .... what would be the best approach? Thank you in advance,

Ha! ... I can be so silly sometimes ... I figured it out and can't believe that it was that easy !....

Hello, Just wondering .... is it possible to update/data entry on multiple tables using a data access page? If so, how? I've been playing around and searching for examples but can't seem to get anywhere? Any assistance is appreciated :D Thank you in advance, Arv

Hello, Is this for a "form" or Data Access Page"? ...

Hello, I have a DAP that is used by many to enter data. When the user enters data one of their steps is to select their managers name. I would the DAP to send a email to the user (entering the data) and their manager once the new record they (The user) has entered in to the database. Is...

So ... if i use "B" .... Then I would use the function weekenddate (chkdate as date) as date while weekday(chkdate)<>vbsunday chkdate=chkdate+1 wend weekenddate=chkdate end function as an Afterupdate event? Is my assumption correct? Thank you in advance ....

Thank you for the suggestion gemma-the-husky.... Actually ... I think I screwed up my 1st post .... I should of stated that I want the default value to be the "Weekending Date" I did resolve the 1st is however ... Previous code =([comments_timestamp])+7-Weekday([comments_timestamp],7)...

Hello, I am current designing a form the has textbox called "comments_timestamp" which is has a default value of "=Now()" I have another textbox on the same form that is called "Weekending Date" I would like to populate the "Weekending Date" textbox with the weekending date based on the...

Hello, I am trying to create a report that will display images, the issue i'm having is with empty whites spaces.... when I run the report ..... it will display images were it needs to but when there isn't a image to be displayed ... I get a blank white space .... I have no idea how to...

LOL ..wow must be a good case ! and thanx for the comps .... In regards to this ... No I'm not in any hurry... next week is fine. Besides ...I'm still working it and it will probably change by then anyways :) Take care and hope you have a great weekend. Arv

**** Update **** Okay.... I think I'm on track now .... here is the latest version .......

Hello.... You will need to add.... Me.[FieldName].SetFocus

I feel so stupid ..... I resolved the "Hours not displaying" issue.....I had the drop down bound to the wrong column

Question ..... In regards to the Hours issue... (currently displaying the Record ID instead of "1:00") Since I'm using the the Hourstbl for drop down purposes ....I really don't primary key ....or do I add another column for Actual Hours? Reason I ask this is because ...whenever I try to...

I'm starting to see the mistakes I made ......

Amazing! ... thank you ...Ummmm....can I do anything to help ?