Search results

Pat, i asked for advise and expected constructive replies , you did just that , i did not take you post as a put down , but took you comments on board . Regards Ypma

Thanks to all of you that commented on my post. The point that a date picker is what it says on the can, is well made. I was initially testing at table level and Pat put me right there. The idea was for the user to enter a date in a date field on the form, resulting in a date and time element...

arnelgp thank you for your quick response. i have entered general date in the date time field ,general drop down. Not sure what you mean "add Format Property of the textbox." sorry if i am no being very clear. Ypma This is at table level only .

Advise sort. I have created a new date field in my table and set the Date format to general . When using the date picker to enter a date, only the short date is shown . I have tried the format mm/dd/yyyy hh:nn AM/PM, however the result shows short date plus 00 00 and not the hours and minutes...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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