Search results for query: *

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...

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...

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 =...

Thanks Karl. I knew I was close.

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...

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...

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...

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...

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...

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

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...

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...

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"...