Recent content by samson

I use =currentUser() together with work group security file. There is a wizard to instal the work group. Takes abit of time to set up, but, I wouldn't be without it Simon

I'm trying to add the customer's name to calls logged by Samsung software. When a call starts a DDE is sent to form [log], to filter on phone number. Once the telephone call is finished, a new record is sent to an access file table[log]. I then want to send the name of the customer to the new...

Wayne, I've not explained it correctly. Once the call is ended, the Samsung software sends a new record to form [log]. I then want to edit this record with the customer name, etc. If I do a record count before the new record is logged,then when the record count is added by another record, I can...

Wayne, Sorry for the late reply. That worked a treat. I was messing with it for hours, trying to split the filters into different events. I now have another problem with my telephone calls being logged with the name from the customers form. Once the telephone call is finished, a new...

I'm trying to filter out telephone calls logged by an isdn line to my customer form, so I can tell how many calls turned into orders. The code works filtering one 1 field [Phonenumber1], but if I try to filter on the second field aswell [phonenumber2], the results show records including isnull...

Ok, i've changed the joins to right join from bank transactions to the other 3 tables. This at least does show all the payments made with bank info. But it doesn't show all the payments before bank trans. I can now use the 3 separate queries to include ALL the payments for each separate table...

Hi, This is my first post, previously I have always found an answer in the search. I want a query to join tables: sales receipts, purchase payments, wage payments, all left Outer joined to bank transactions table. At the moment I have 3 separate queries to show sales receipts joined to bank...