Search results

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

Thanks John, I changed all the names to generic descriptive ones to give a bit more meaning to others. Just testing your amendments now.

I'll give this a try, thanks :)

I'm adding data to several tables with a single form using INSERT SQL and the Dmax method to sort relations. On one of the tables there is the potential for duplicates which I want to avoid. Please can someone provide an example of DMax or DCount or other method that I can use to decide...

Thanks for your thought and feedback, much appreciated. I'm still to decide. I'm sorely tempted to keep records for both options and ditch whatever is deemed unnecessary down the line. Self referencing could clearly be more useful with nested subtasks but will take longer to code and maintain...

I've almost completed a little task manager add-on for my main database. It's nice and simple but I want to add subtasks so a user can break a main task down into logical steps. The question is, should I create a new table for the subtasks or should I use the existing tasks table and create a...