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: *

  1. yogi71

    Want to open a specific form based on a field value in an open form

    I originally had the string assigned to sWHERE in the DoCmd.OpenForm, but decided for consistency and reusability, that a variable seemed the right way to go, that way if I ever change it, I only have one place to change it. I also hardcoded the form names in case of inconsistency in the naming...
  2. yogi71

    Want to open a specific form based on a field value in an open form

    PHV, at first, I was mad that you only gave me a vague starting point, especially when I said my VB skills are very limited. I do understand your reasoning, as I believe we've crossed paths before. I would have preferred a little more help getting started, but your did give me enough to figure...
  3. yogi71

    Want to open a specific form based on a field value in an open form

    I have a form called frmProjects. This form has a field on it called Department, which returns a 3 letter abbreviation for the department in field DeptID. I want a button on this form, that when pushed will open the appropriate form based on the DeptID. If DeptID = PNC, open frmPNC If DeptID =...
  4. yogi71

    Question 2: Trying to output datasheet to XLS file with specific name

    Thanks Karl. I knew I was close.
  5. yogi71

    Question 1: A box that totals several fields from a subform?

    In case anyone finds this post for an answer....since no one answered.... I built a seperate query that did a Sum on each of the Day of Week fields by user and weekEnd date. So it totaled all of Sunday for each week for each user, and all of Monday...etc. Then, in the Query builder of the...
  6. yogi71

    Problems getting default value to appear in form correctly

    The date field started working after I rebooted my computer. Not sure what that was all about. At least I know I did it right. You answered the question for why the Name field wasn't working as expected. I have since made a change to the way things work, and now it works as designed as well...
  7. yogi71

    Question 2: Trying to output datasheet to XLS file with specific name

    My VB knowledge is minimal, I used to be more proficient at it, but I found it isn't like riding a bicycle...at least not for me. Once upon a time, I had a DB that did exactly what I am looking to do, but I can't for the life of me figure out how to code it. I have a button on a form, that when...
  8. yogi71

    Question 1: A box that totals several fields from a subform?

    I have a form, frmSubmitTime. It has a subform, frmTimeSheetReview which is a Datasheet. In subTimeReview are columbs, Name, Site, WeekEndDate, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday I want to put a field on frmSubmitTime that takes the values of Sunday...
  9. yogi71

    Problems getting default value to appear in form correctly

    The Name field is a ComboBox bound to a field in a table. The Date field is a Text box and is unbound. When the form opens, it lists the last person picked from the Name field and the last date used. I was hoping to automate it to make it easier to use (my userbase is very un-technical), but...
  10. yogi71

    Problems getting default value to appear in form correctly

    Are there any other suggestions, I'm having no luck with this one...
  11. yogi71

    Problems getting default value to appear in form correctly

    Using Access 2010 (64bit) on Windows 7 64-bit I have a form with two fields in it. The first is WeekEndDate. For the default value, I put [highlight #3465A4]=Date()+(7-Weekday(Date()))[/highlight] with the expectation of opening the form and seeing Today's Weekending Date. Instead, I get the...
  12. yogi71

    Redirecting a folder on a network share

    Thanks 58sniper, I was unaware of that ability in Windows. However, this doesn't help me. This command will only allow links on the same machine, different volume. My scenario is: Server A has existing folder "workspace" Server B has been setup to have "workspace" moved onto it. I need a link...
  13. yogi71

    Redirecting a folder on a network share

    I either haven't been able to figure out the right combo of search words, or no one has ever asked this. I have a network share on my Windows server that all users are mapping as their S drive. On the "S drive" is a folder called "workspace" and about a dozen other folders. The "workspace"...

Part and Inventory Search

Back
Top