Recent content by steve111

hi I have a table called "groups" each record in that table has the id number and the description of that record. I have 200 records example no description 1 tyre 2 wheel etc now I want to advise a planner "up front"what I want to build although we...

hi, I have a form that has a drop down box in it this drop down box allows me to select a number and that number refers to a part description if I select the same number more than once . the query I run will show that number and description as many times as I have selected it in my...

thanks for all your help . works great steve

I cannot download that . in china we get very restricted sometimes did you use another formula to make it work or did I type it wrong? thanks steve

hi this has come as a PHP file can you please explain how to open that thanks steve

hi still got same problem =DSum("cost","[all events]","eventid = " & [me].[eventid]) I have changed the field name in th formular as I had got it wrong in my first post I have attached the database for you to see steve

HI I am getting a "name" error if I put this " =DSum("cost","all events",[eventid]) I get the total in the table if I put this the " me.eventid is when I get the error if I put the form name and eventid I still get the error steve

hi no , the form "all events" is the subform steve

hi I have a table called allevents and another called tblevent the 2 forms that I use are linked by a field called eventid the table tblevent will have say eventid 1 but the all events could have many records linked to eventid 1 in the table called allevents there is a cost...

thank you both working great now steve

hi I have a form that has a long date in it example sunday, 06 March 2016 I want to be able to sort my query without sunday in it I have tried the "left" function and the crtieria not "sunday" but neither work any help appreciated steve

hi yes that's what I need steve

hi, I have daily tasks ( unticked ). lets say 7 days worth in my from tasks. that I can see when I tick that days task or 2 days tasks as completed from the list of tasks these 1 or 2 tasks will disappear and the next days or next 2 days task will appear in my form called tasks...

hi , i have tried that. but it then don't allow any dates or eventid to duplicate i would like to duplicate the eventid if the date is different i would like to duplicate the date if the event id is different i want to end up with something like this "eventid 1" maybe 500...

hi, I have a table that say has 1000 records in it called " all events" I have a subform called tasks which comes from a query from the table " all events" at present the query is set to "no" on the completed field I also et the date field to <=now() + 7 so I only got 8 records in my subform...