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

  • Users: yogi71
  • Content: Threads
  • Order by date
  1. 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 =...
  2. 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...
  3. 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...
  4. 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...
  5. 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