Search results

Many thanks for the reply. However that gives me a #Name? error. I have just this as source in another field in the Form which works well to give the ALL total. =Sum([MCNEWdisp]) where MCNEWdisp is a numeric field in the table I have tried DSum and have this as the Source Value...

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

Many thanks for your reply. Combo116 is redundant as many others. Only Combo 114 has two events attached to it. Upon searching various things, I discovered that the problem perhaps is with the the ON Click code of the NEW RECORD button which is the only button in the form and the main...

Many thanks for the suggestion which I have tried This code suggested in another forum seems to work rs!CustNum = DMax("CustNum","Miracle_Cloth_Main") + 1

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

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

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

Many thanks for the URL, but I couldn't see the usage for CURRENCY type of data under the examples. in my case I have used =Format(DSum("[Discount]","Miracle_Cloth_Main","[Cust_ID]=" & [Cust_ID]),"Currency") Where [Discount] is currency and [Cust_ID] is string. and the field where the...

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 ?

Hello Mstef Many thanks for your reply and example. I have looked at the example. What I am trying to do is for a PDA application where the info is required (when a customer is revisited) on a form field (without having to open and look at the table) To keep it simple I try to use only one...

Hello neileg, Certainly not, especially when I don't know coding at all. The reason is I am developping this to run on PDAs(Handhelds) to be synchronised with a database running on a desktop. After trying out various PocketPC based databases I realised that keeping everything simple is the only...

Hello, Many thanks for yur reply. I think you are right. The method you have shown is a hard way as I have more than 30 field but It works. Here is the modified code for the button.(I haven't done all fields yet ) I have some auto fields like dat and some calculated fields Please let me know...

I have since found this code for a Button to create a New record from recordset clone and created a button. The button creates a new record without any entries exceptthe auto number Could you please suggest how to complete this and make it work Private Sub Save_Record_Click() 'Private Sub...

I have tried the code below which saves a new record but doesn't copy anything. Any help to get it to copy the fields will be much appreciated Private Sub Save_Record_Click() 'Private Sub cmdDupe_Click() 'On Error GoTo Err_Handler 'Purpose: Duplicate the record in the form. Dim NewKey As...

Not exactly. I have come across more elaborate ways using additional carry over routine etc. I was wondering if anyone has come across with more ingeneous ways of doing this using ACCESS or VB code For your info I am not a coder or have good experience.

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] & "'")...

Hello Neileg, Many thanks for the reply. Actually I need to do this by code, attaching thecode to an event or other property of the form.

Hello, Many thanks for the reply. I am familiar with the form navigation. What I am looking for is to change items in a record and save as a NEW record. The Navigation can only make the changes and save an existing record or create NEW record from scratch.

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

Hello Uplate and everyone, Iam pleased to say that against all odds I have a SUPERCOMBO which does all these with a single table. Enter New Cust_ID Pulldown a list of UNIQUE Cust_ID to select the Cust_ID Go to the Last record for the selected Cust_ID I have the code below for the Combo...