Recent content by Hutchy

So what I had asked for seems next to impossible, because reports have a max width, which rendered this useless. I, however, used a union query to get the employees vertically instead of horizontally with the with the cost and hours next to them. 2 union queries joined with by a select query...

Perfect! Rispek bredda! :)

Okay, so tried this in my code on my machine and it works... will try it at work. Thanks! LoginName = CreateObject("wscript.network").UserName

Thanks for responding :) I think grabbing the windows login name is a great idea - if possible :) I would have... wbook.SaveAs Filename:="C:\Users" & WindowsLogin & "\Documents\Project\Timesheets (Generated)\" & Me.ProjectID & "_" & Me.EmployeeName & "_" & Me.TimePeriod & ".xlsx" wbook.Close...

I need some help, please. So, I have a database that I've split and have deployed to 7 persons. The thing is, I have three (3) forms: Form 1 Form 2 Form 3 ...that require changing a portion of a line in each form's respective VBA codes. I need to change the directories to where an excel...

Here's my problem... I'm aware if selecting by columns - though I don't know what this does & "/" & and the AS is - but after doing the crosstab query my empname field got distributed as brown, john, doe, john, etc... So, when I tried using TESTPCEQryHrsCost.empname, I got this error Unless...

CAn you help me with something first? How do I get the two crosstab queries to come together in a select query and displays everything without repeating the projectname and activityname? This picture is wrong, it should show the projectname and activityname being repeated.

Wouldn't I have to do that every time a new employee is added? Sounds like I'm going to have a problem :( There's going to be 2 groups of data: planned and actual. So maybe planned on one page and actual on another, if possible? Isn't this with the assumption that I already have a report made?

This is a query, report and vba question. I'm using Ms Access 2007. TABLE 1: projectname, activityname, totalhoursworked, employeename TABLE 2: employeename, employeelevel TABLE 3: employeelevel, rate I created a select query to join the info that I need. SELECT QUERY 1: projectname...

That's great news. because no one responded to your request :( :)

Never mind, I found my answer here: http://www.access-programmers.co.uk/forums/showpost.php?p=1275775&postcount=1

If you want to know why I thanked the OP, it's because that code that he posted helped me :)

No. Never mind, it works! :)

Great!!! Thanks! One more thing - how do I get the records in table 1 to not repeat for each record in table 2? If it's possible.

Thanks for responding Shoji, I will test and let you know :) But just to clarify, that your solution is to what I'm requesting assistance for: Form 1: combo box with [projectname (to bake a cake, to climb a tree, to design a logo)] info (projectname being the fieldname) Form 2: combo box...