Search results

Many thanks for the reply. RecordNum is my Primary Key. I have tried SELECT Cust_ID, Max(RecordNum) AS MaxRec FROM Miracle_Cloth_Main GROUP BY Cust_ID ORDER BY Cust_ID; as the source property of the Combo which works fine and brings up a sorted list of Cst_ID without duplicates. Could you...

Hello Gemma, Many thanks for the reply. As I mentioned elsewhere in this Forum this application has to run on a PDA and then synchronise with a DESKTOP without errors. So I try to keep only one table and one form .Of course this necessitates, multiple entries of customer name in one column. I...

Many thanks for the reply. I try to use the Combobox to enter New customer names and create New records from last records by pulling down the customer name . To pull down the customer names I only need ONE entry per customer from the recordset. For creating New records I need to search and go...

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

Ah, I am so glad you are back Uplate ! I had been thinking the same thing and tinkering all day but hasn't go any further. I agree with you fully but First of all I can't get the DISTINCT clause working to only select the value once from repeated entries. Here is my Souce property for the...

As this is thread about Combobox, please allow me to post this question which I presume is somehow related. I have the source property of a combo only used for entering new Names and finding the last record like this: SELECT DISTINCT Miracle_Cloth_Main.RecordNum, Miracle_Cloth_Main.Name FROM...

Using NotInList Property. Many thanks for your suggestions about exploiting the events capabilities of the powerful ACCESS. Though I already visited the NotIn List property, in the beginning,I left it for the reason of empty fields in the Name column, I guess. (Not sure!) I have now a nearly...

I have tried with the DISTINCT directive in the source property of the combo to eliminate the repeat entries. The problem is the combo doesn't add the new values to the field leaving empty fiels. I can condense the list by sorting DESCENDING. This makes it necessary to copy values to a second...

Hello Uplate, I have one or two issues which forced me to copy theNamer value. The first was that the Wizard somehow included the RecordNum field (Autonumber and Primary Key) in the source properties of the Combo bringing up the RecordNum value in the pull down as DEFAULT making it difficult to...

Hello Uplate, Many thanks for your expert guidance. If someone would have told me about DISTINCT clause. I could have saved a week trying to copy to a second field. The main reason I wanted to do this was because of cluttering of the Combo pull down. Your suggestion should make the search...

Hello, No problem, I shall explain again. The application needs to run on PDAS(Handheld) and be synchronised with a desktop. So I keep everything simple, just one table and one form. I use a ComboBox with some extra code (other than generated by the wizard) to enter a NEW Customer Name and later...

Many thanks for your help. THe COMBO has only one purpose, to Enter a NEW Customer record and choose the CUSTOMER you are visiting. So far it is working. It is not the MAIN field for the whole table. So keeping it empty except for a new entry doesn't matter and help to keep the pull down neat...

What I am trying to do is simple and use just one TABLE and ONE FORM . Nothing complicated. I am really amazed how a simple thing can become complicated like this. I mentioned that our sales people go to a new shop with a PDA and if it is the first visit, simply pull down and enter the shop and...

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