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...

no luck at all !! at the end of the insert script, i inserted some code to jump to some record and jump back to the record where the insertion took place, but no refresh of the subform data ! still trying to find a solution. regards Yves

The events triggered by your buttons are not in Module1 but in your form's 'environment code' --> Node 'Microsoft Access Class Objects' --> Form_<your form> My mistake.

ALT+F11 opens visual basic editor --> search for your project (lefthand pane), then expand until 'Modules' --> 'Module1' becomes visible, doubleclick this node --> search for the ambigeous function or sub and remove one of them. Hope you find it. Regards, Yves

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...

Perhaps you linked the data of the subform to a query that's per definition not editable, like a query which has a GROUP BY statement. Could you check that the query is editable, i.e. is there a last row visible with the * where you can put new data ? (If your form is attached to a simple...

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

Sorry, i misunderstood you, it's working perfectly ! Thanks, Yves

If i'm using a table-layout to show the subreport, i can't make the field 'Total' field which is in the subform visible , any solution?? Thanks for the assistance. 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...