Recent content by Dmak

If your subform is bound and your checkboxes are bound controls then they are updated on the fly. For logging hours I'd use a table called tblTaskHours, that would include StaffID, TaskID, Hours and DateWorked. From this I'd create a query to total the hours for each task and compare to the...

Need to sleep now fella, hard day! If no one else provides a solution I'll post one up tomorrow for you. I know the answers but I'm just too tired! BTW add your rough location on your profile. G'nite :)

BTW are you really wanting to create a new table? Seems to me like you want to just create a new record???

Below is a little snippet of what I'm working on at the moment. Should help. Can't help much more as I've had a couple of beers. http://allenbrowne.com/casu-04.html You'll need some if statements for the checkboxes I believe. Better to use a list box if you can, then you can just use the...

As an alternative I'm tempted to use Google app sync, as linked below. https://tools.google.com/dlpage/gappssync Sending events to outlook should be easy enough. It would be nice to go direct though.

Going to have to bump this. I too have looked around for a solution but nothing solid yet. Has anyone got anything working with regard to this?

This is really appreciated, thank you!

Hello there. I have a query with 3 text fields; Title, FirstName, Lastname. I've concatenated them with Fullname: [Title] & " " & [Firstname] & " " & [LastName] so it produced eg Mr John Smith. Slight problem is there isn't always text in all fields and I get redundant spaces. Not a major...

Thanks for your responses guys, much appreciated. I have another problem now. I have a query to feed a report and I set the criteria to today " Date() " on the DateAdded field and it returns nothing. The field is displaying a time as well as a date. Even if I format it, it returns nothing...

I'm using the DateAdd function and also Date + 14 etc and DateAddW (user defined, provided by MS) The problem is as soon as I try to add more than a few days the results I get are very odd. For example if I add 10 days I get a result that is months in the future, if I add say 14 days I get a...

Hi, Just a quick one. I want to store currency amounts but not use the currency format. My DB is set to use all currencies and provide in all currencies. Do I use the SINGLE data type? Cheers, Dan

EDIT: Works fine as it is. Cheers. I feel a touch cheeky asking but how could I include non null blank fields in this?

Perfect, thank you! :)

I have a calculated field in a query that provides the names for task lists and the number of tasks in each list within parentheses; NameCount: [TaskListName] & " (" & DCount("*","tblTasks","[TaskListID]=" & [TaskListID]) & ")" This works nicely and provides; ListName1 (2) ListName2 (10) etc...

Works a treat, can't thank you enough, cheers :D