Search results

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

I want a query that gives me something like this from 2 different tables: table1 - AA, AC, DE table2 - AA01, AA02, AA03, AC01, DE01, DE02 query - column 1 - column 2 AA - AA01 ------ AA02 ------ AA03 AC - AC01 DE - DE01...

Hey guys, I need some assistance, please. I'm not that good with VBA, but I was reading some other threads re my problem, but I was a bit confused. they are old threads, I need someone to converse with. I'm using Access 2007. I have a few problems and I want them to be able to be done from...

Hey guys, I need some assistance, please. I'm using Access 2007. I have a few problems: 1. I have a switchboard. I want to click a button, that opens a form with a dropdown list, when I make my selection, it opens a subform in add mode, but the linked field in the subform isn't empty, but...

Wow! I didn't know that. Thanks a lot!

Never mind. I deleted all the spaces from all the names that I've used. It's working now. What I have now is: Mainform name: Visitors Fields: VisitorID, CompanyID, LastName, FirstName, Gender, TelephoneNo, NextofKin, Package (This is a combo box with 2 columns and 5 rows), Status (This is a...