Recent content by superblades

The Due Date is essentially a calculated field, however some tasks dont have a set time to be delivered so in effect they will always have a blank due date if that makes sense? Cheers Brendan

Hi, Wonder if anyone can shed any light to be able to help me, i've tried various forums and googling and not got very far... I have a table which is called 'MasterTasks' essentially there are approx 12 columns and two of the columns are a 'Start Date' and 'Due Date'. Each row is an individual...

Hi there, Wondering if someone could give me some advice... I'm creating a fairly basic case management system in Access 2007 and i'm wanting a way of populating a set of tasks when a case is created... e.g. I have a case table, which contains basic information about the case, case manager...

Hi all, Ive been round the houses trying to solve this issue including going through several tutorials but i cant seem to get what i require to work properly. I'll explain... I have a projects table with a list of projects and a priority assigned to them. What i want to do is create a query...

Hi, I wondering if someone can help me as im a complete newbie :) Ive upsized a database from access to sql 2000 and i had a bit of code written in vb that once i changed a particular field in a table it automatically inserted todays date into another field, i know it still works if i work...

Hi im trying to find a way of starting the access report wizard from a button on a form, anyone know how to do this? Thanks Superblades

could be a permissions error, check ntfs permissons for the backend for the two systems you are having problems with Regards Superblades

still having problems :( UPDATE MyTable SET Logon = LEFT([FirstName],1) & LEFT([LastName],1) & cstr([Employee Number]) All i get is a '0' in the logon field for all entries, the employee number is a string not numeric. Cheers superblades

Hi all, im in need of some advice, i have a database containing a list of people with a unique key e.g. 12345, firstname, surname etc. and im wanting to create either a VBA or Macro that will take the first character of their firstname and surname and prefix this to the unique key in another...