Search results

Sure, First Ill post my SQL: SELECT Vacation.Login, Vacation.Type, Vacation.VDate, Vacation.Memo FROM (Vacation INNER JOIN [Warehouse Info] ON Vacation.Login = [Warehouse Info].Alias) INNER JOIN [Alias Fullname] ON Vacation.Login = [Alias Fullname].Alias WHERE...

Thanks a ton for the help! How exactly would this work with selecting multiple fields, for example: only one field is distinct, the other fields can all contain duplicates

So I've discovered the HideDuplicates property, however when I enable it it doesnt work at all EDIT: I mean the property does nothing, the report looks exactly the same

I have a spreadsheet style report that acts as a calendar. It works fine and retreives all the data I want (vacation days taken) for each person, however if somone takes more than one vacation day in a week (the report only shows the data for a selected week) they will show up on two rows. I...

I don't really know alot about Outlook and its calendar/appointment system, but I was wondering if it would be possible to have a form in access export data to a blank calendar in outlook when a button is pressed?

When you say there is nothing to add up im assuming what your adding up is null values? If this is the case you could just wrap your calculation in an Nz() function and it would return zero if the sum was null.

Too fancy for my tastes :o I mean more along the lines of sports like Hockey and American Football

The fact that Fifa doesn't use video replays for reffing is what makes it not a sport in my book. I mean come on, its 2010, almost every professional sport in the world (in fact every sport I can think of) uses some form of video replay to assist in tough calls.

Im assuming you mean the ripple effect is occuring on your calculated fields? If the fields are calculated through a query you should be able to just make two querys (One for Pre July 1st and one for Post July 1st) and then have a union query to combine them to give you all your records, or if...

I think I may have solved it, simply added a range parameter to the macro call

So all of my users can run my macro to import data from excel into the access database, however sometimes they will ranomly get the following error Action Failed Macro Name: Import Condition: True Action Name: TransferSpreadsheet Arguments: Import, 10,Offline...

You have spaces in the names, you neeed to either surround them like so: me![Total labour charge] = ...... or change the names so there are no spaces

Ok so I've figured out what I need to happen. I need to have a monthly calendar be displayed. Then I need the calendar to display names in the cells of the applicable days where sombody has taken a vacation day.

So I need to create a calendar to track vacation days for employees. Currently I have a table that stores all the data I should need to make the calendar (employee name, vacation date, ect ect) however Im not sure where to start with actually generating the calendar, isn't this something that...

Yes I do believe that is the add-in I downloaded, I will give your code a try and see if it works out for me, thanks!

So I've been looking for a way to automatically save my reports as PDFs in Access 2007. I have downloaded and installed the Microsoft add-in that is supposed to allow this. I can see the add-in inside of the office menu and it works fine, but I'm looking to tie it to a button with some VBA code...

I'm pretty certain that there isn't a way around it, in the one book I read it stated that if the password is lost so is the database, but then again it was just one of those dummies books so there could be a more complex way in

To me it looks like the problem isn't within your code but in the printer settings on your users computer. Have you double checked that the printer is installed to their machine and set as default? Have you tried printing other things from there computer?

Im running Access 2007 and everything is inside of a trusted location. I seem to have fixed it now by adding the save function into the VBA code instead of having it in the macro and then having the macro call the VBA code, somehow the macro save wasnt working properly, hence the conditions of...

So I'm in quite a pickle here and I have no idea why. I have a button at the bottom of a form that is used to edit some details. All it does is save the details and then run a few lines of VBA code, which disable warnings and run two action querys (one to append and one to delete) before...