Search results

  1. Y

    Attendence In/Out Arrange

    Hello Malik, as a user like you and not a programmer i would create two queries. to achieve your aim.Open query 2 to see my idea . Other members might be able to give you a better solution. Regards Ypma
  2. Y

    Greetings from the Netherlands :-)

    Reinier ,Welkom, The_Doc_ Man thinks 71 is getting on, i go slightly better at 78 , so the point is age is just a number. Regards Ypma
  3. Y

    Sequential Number in Access form(invoice box)

    I too use the DMax() function .My example is activated on the after update event of the Last Name , you can use what ever suits you. #If IsNull(Me.OrderNumber) Then Me.OrderNumber = DMax("OrderNumber ", "Invoices") + 1 End If# I have not post for awhile so am just offering my example ...
  4. Y

    Sending Text Message

    Thanks to all of you who replied to my request for the suggestions and ideas I will in due course check out the various links provided. Isladogs . My example of the to addressee was incorrect it should have Been To rst![Phonenumber@sms.textapp.net] "Obtain from the Query I would use as a...
  5. Y

    Sending Text Message

    Advice is sort. I am happy about sending emails to clients, using a word document , for the content of the email, linked to a Query as the Data source . The requirement now is send a short standard text message via SMS.textapp.net . My initial thought is to create a function. Example...
  6. Y

    VBA Code to show all dates between a range

    As a user and not an expert. i would use a form with fields name startdate and EndDate, Then have a query with the based on the table and in the criteria use something like Between [Forms]![frmReporting]![StartDate] And [Forms]![frmReporting]![EndDate] Hope this is useful Ypma
  7. Y

    Sum Total data and Save to a table with VBA

    Agnister. You are welcome , don't forget that each time you click your command button the existing table will be over written. Regards Ypma
  8. Y

    Sum Total data and Save to a table with VBA

    Agnister . If you open my demo the result in the new table would be : ~DateLastOfNQCG_Month Category TOT 09/01/2019 Credit £150.00~ If you require a command button ,open the create table query . If the desired result of my example is not what you require ,what is...
  9. Y

    Sum Total data and Save to a table with VBA

    Angister, I am a user not a professional and my solution would be to create a query to group and sum the credit category.Then change the query into a make table type query . Hope example helps Regards Ypma
  10. Y

    running count query

    Paul , the dCount did the trick, thank you very much. Bob
  11. Y

    running count query

    Seasonal Greeting to One and All. Advise is sort , i have a simple query which counts the source field that have been grouped . SQL View #SELECT Count(TblDemoData.ID) AS CountOfID, TblDemoData.Source FROM TblDemoData GROUP BY TblDemoData.Source;# This work just fine, however when i tried to...
  12. Y

    Request For Template

    There are a number of templates included in the Access 2010 and there is one named Students, plus many more. Regards Ypma
  13. Y

    Simple Purchase and Sales Db

    draw: Thank you for your suggestions , I will certainly view the links you provided, as I approach my Eighties I find my brain is like an elevator that works but does not stop at all floors! . I have not tried creating a stock control database before and tried to reinvent the wheel and dug a...
  14. Y

    Simple Purchase and Sales Db

    To anyone who can advise. I am trying to build a simple non commercial data base for my son who is starting a venture by buying old golf buggies and refurbishing them ,which are then sold or if cannibalised he sells the component parts. I have looked at the Northwind database, which is far too...
  15. Y

    Update a Field

    Plog, I think you are correct, I had not thought it through , so will go back to basic and start again taking on board your comments . Thank you Ypma
  16. Y

    Update a Field

    [U]Updating a field within a called record Good evening fellow Access users. I am trying to update a field in one table based on the same named field in another table For example the sales form as a tick box which is ticked when an item is sold, I then require to update my stock list to...
    • ypma
    • Thread
    • Replies: 2
    • Forum: Forms
  17. Y

    Unrecognised database format error

    munkeyroot, This question was asked Yesterday and The DOC MAN responded , its worth a read. Regards Ypma
  18. Y

    WANTED: Old Access 95 file with password

    Colin, I have a cd " Running Microsoft Access 20000 Pt No 0970002173 for windows NT/98 if this would be of use I will try and zip it and send to you. Bob
  19. Y

    Print no duplicates

    in addition to PBaldy's advise. Have you considered using the hide duplicate option in the properties drop down of the each field . Plus grouping by in the header and footer' I have had a play with it and will upload my effort , which is not perfect, but might point you in another direction to...
  20. Y

    Email to more than one addressees

    Firstly thanks to all who responded to my request. In the end I achieved the result I desired as follows; 1 Created flyer in word 2 Merged the word doc to my database query , which contained the record set and the email addresses of the clients who need to receive this flyer. 3. Clicki...
Back
Top Bottom