Search results

Waterfly: I think I have run up against a brick wall as I cannot workout how to show just the one record . Hopefully Minty or one of the other members can salvage this post . Regards Ypma

WaterFly: My cunning plan did not work out, so I took Minty's suggestion and created a sub form . I not sure if I am quite there, but close . query1 is the sub query which gives the result . USED ACCESS 2010 Hope that's ok Regards Ypma

WaterFly: Thank you for responding, I have read you post again and tried to create the db. as per your posts table structure. Using my latest db. demo what would your expect to seen in the query for Jane ? and any other examples of data you would expect to see the query ? If my structure is...

Waterfly. Not sure what moderated means, still I wish to know if my example database was of any use ? I have not attempted to address the sub query solution that Minty gave you . If my demo db. did not address your problem please let me know why so that I can lean something too. Regards Ypma

Waterfly: is your problem resolved ? I Ask the questions, as you have not responded to mine or Mint's post. Regards Ypma

gerrywiles :May be the blind leading the blind , but I start the export of the query by highlighting the subject query and right click and click export to excel. This then takes you to export form which allows you the option to specify export options .you then click the Ok and follow to the end...

The-Doc-Man . As someone who has benefit enormously from your informed posts and solutions I would like to add my good wishes to you and your wife for a speedy recovery and back to normality. Fellow grandfather Regards Ypma

WaterFly : I was thinking how I would do it prior to Minty's post and will post if for what is worth . My solution seems to work fine providing a members status is only valid for one of the Membership status. w sql view #SELECT PersonDetails.MemName, IIf([LifeMem]>Date(),[LifeMem],Null) AS...

If your report is based on a query have you considered adding a criteria in the date column of the query example > #01/01/17# or even beween two dates . Hope this will be of help to you Regards Ypma

NauticalGent: You got it in one. By removing the spec the code ran as it should do , thank you. Regards Ypma

Yesterday 01:52 PM NauticalGent: Thank you for you suggestion, which I will try later , as my 77 year old body is playing up. I was wondering if my access problem is a common fault with access 2010 ? Will let you know how I get on in due course . Regards Ypma

NauticalGent. Point taken , I have now added my code. Note this code works ok on old specification but not new one Regards Ypma

Hello, my problem is that I am trying to export a query to a text file. I followed the procedure which worked when clicking the Run button and created a specification. When viewing the saved exports the specification is there. But when if try run the code in VBA I receive "The text file...

Re: message show in popup box when record inserted in database CJ I failed to make you code work , I even tried to put it in the control source of a text box #=currentdb.tabledefs(tname).recordcount# No Joy. I have taken up too much of your time and will have to admit I am struggling . Thank...

Re: message show in popup box when record inserted in database CJ London, thank for staying with me. I was not sure how the record count was achieved, hence I created the list box Max to get the last id number. I am confused dot.com as to where the last count is calculated . Sorry to be a pain...

Re: message show in popup box when record inserted in database CJ London, I have been playing around with the function you kindly supplied, but does not seem to work correctly, I have a list box with a query record source to the subject table and criteria Max.which provides me this the record...

Re: message show in popup box when record inserted in database Thank you CJ London for you most welcome suggestions, I will experiment and report back. For your information the records are imported remotely from the same source . Thanks again . Ypma

Re: message show in popup box when record inserted in database Good evening fellow access users. I would like to know if it is possible to create a pop up messgage when a new record is inserted into the backend of the database . If so a few suggestions would be appreciated . This access 2010...

Plug and JHB, thank you very much for responding to my cry for help. I will test both suggestions to see which one suits my end game which is to sort by time .

Advise required. I have query with a date time field which is populated with a now time when it was created . I am trying to filter records that were created yesterday "date()- and records for to day "Date(). I have tried using the "or" , but failed to selected records containing todays date...