Search results

Hello , is there something like a binary_checksum function in Access (2003). (MSSQL aggregate func) I'm trying to create some sort of synchronization between Access & another DBMS and I want to know if something on a particular row has really changed (I cannot use a 'Modified' date or a...

Hi, Consider that you have a main form 'Project' and attached to that a subform 'Tasks'. I created a button on my main form 'Insert default tasks' so when a user clicks the button, i trigger some code to programmtorically insert the records in the tables Tasks. I never leave the forms...

Hello, Rather then to use MyField:Iif(Isnull(Field1);0;Field1) when building the field list in a query, there should be a function which eliminates null values (and replace them by a 0), i thought it was Znull(Field1) in Access 97 but Access2000 doesn't seem to support that ??? How wrong am...

Hello, Is there a way to let certain cells (in a datasheet view of a subreport/table) act as a combobox (e.g. to select some predefined values from another table) Regards, Yves

Hello, This must be simple i guess. I'm trying to display a total (sum) in my main form from values out of my subtable. Thus Price = SUM(UnitPrice*Units) of all products entered in the subtable. How can i do this ? Kind regards, Yves.

Hello, I made a form (Access2000) that is bound to a query and put a combobox on it where the user can select a certain (existing) projectnumber from the list. The initial projectdata (e.g. projectnumber, client, startdate) is allready stored in a table and these fields are made available in...