Search results

  1. V

    A little help with a calculated field

    Hello, Can someone please help with this expression? I have a table with text field Cust_ID and a Number field MCounter. I would like to put in an expression as source in a form Text field based on the same table to AGGREGATE all MCounter values for a Given Cust_ID Something like...
  2. V

    There may have been an error evaluating the function

    Creating a new form by copying and renaming an existing form gives error Hello, Hello I keep getting the error after I copied a form and saved under a different Name ++++++++++++++++++++ A problem occured while Microsoft Access was communicating with OLE Server or ActiveX control. There may...
  3. V

    Incrementing Numeric field value

    I have this bit of code in a routine. CustNum is a Numeric field with a number I need to increase by one With the code below It comes always as 1 Set Db = CurrentDb Set rs = Db.OpenRecordset("Miracle_Cloth_Main", dbOpenDynaset) On Error Resume Next rs.AddNew rs!Name = NewData rs!Cust_ID =...
  4. V

    Storing unchanged data ONLY ONCE in a table

    Hello, I have a COMBO box which currently finds the last record from a table of Records with RecorNum as the primary key based on a Cust_ID with following as source SELECT Cust_ID, Max(RecordNum) AS MaxRec FROM Miracle_Cloth_Main GROUP BY Cust_ID ORDER BY Cust_ID; This works very well. When...
  5. V

    Syntax for DSum function for Currency fields

    I have a Number field with value as DSum function where the criteria is Textfield which works well. =DSum("[MCRef]","Miracle_Cloth_Main","[Cust_ID]='" & [Cust_ID] & "'") It doesn't show the SUM when the type of textBox is CURRENCY Can anyone suggest IF Ineed to change the syntax ?
  6. V

    Summing One field for Default Value of another

    I have two Numeric fields in my Table, MCRefill and MCTot. Actually MCtot is the sum of all MCRefill for a given Cust_ID I have the following expression in the Default value of MCtot in my form showing both the fields DSum("[MCRef]","Miracle_Cloth_Main","[Cust_ID]='" & [Cust_ID] & "'")...
  7. V

    Saving a Record AS A NEW RECORD from a form

    Iam very new to ACCESS. So please do forgive me for believing that the "SAVE AS" function in ACCESS is as easy as something similar we do in Microsoft Word. After searching this forum and others I realise that there is no easy way and it is considered as some thing for serious users. (with...
  8. V

    A quick question about ComboBox for the experts.

    I Need to eliminate repeat entries of Names in a Combo pull down list I have since found out that this is possible with the DISTINCT directive in a simple query like SELECT DISTINCT [Name] FROM Miracle_Cloth_Main ORDER BY [Name] DESC; as the source property of the combo box. It looks like...
  9. V

    Entering data using ComboBox for search.

    Hello, Below is the main data entry form of my application. We disrtibute a product called MC Cloth to Shops to display. After a month we visit again and take stock of products sold, replenish and the shop pays for the products sold. the Database keeps a record of the shop, products displayed...
Back
Top Bottom