Search results

Thanks Micron - yes it does run at the moment, as I think we have established that 59 arguments is the limit. The tables I reference are on an SQL server, with linked table in my database. All of this as you say unmanageable code is just to come up with an email like this: Dear Matthew This...

Was that a slap on the wrist vba? might be too subtle for me... but i ALWAYS go to google to look for answers first, amongst other things i typed "compile error too many arguments, " but i didnt find that clear page that you had. firstly i typed in "too many arguments" and reached the...

That'll be it - seems like there are 59 in this routine. I'll do some research to see if i can work out what ParamArray means! Thanks Ian

Yeah it is rather isn't it - if there is a better way it would be good to know, but i am not much of a coder, and this is a system that helps the charity i work for, operate smoothly and I don't want to mess it up! I'll go away and count now, but I think if there was a difference in the numbers...

I am not really sure what that means Gasman to be honest. The thing is however ugly it looks it has been working, and i just want to add another field - which i thought would be simple!

Hi jdraw, Thanks for replying, much appreciated. Sorry I must have slightly changed the code before pasting, but i have rectified it now, and the code def runs ok. But the problem still remains, if i wish to add another field to the Call Remote line, and the DoRemote line I get "Too many...

Hi all, I have taken over some code and am struggling with a part of it. The code below works fine and does what it needs to do. I have added a couple of new fields to it, and that was fine too. However, I have reached the point where i can't add anymore fields as I get "too many arguments"...

Thanks Both, that will give me something to look at and explore. Much appreciated. Ian

Yes that is what I need. Sorry if i wasn't clear Plog and if it was too garbled. Ian

Hi all, Hope this is the right place to put this. For 20 years I have developed a pretty good database system for looking after pretty much every aspect of the 1200 events we put on as a charity (arts alive and flicks in the sticks). We have an SQL sever (online), and an Access front end...

when i use this code - and add a date filter so i only look at future dates - it brings back zero results. SELECT dbo_Venues.ID, dbo_Venues.VENUE, dbo_EventsFlicks.datefield FROM dbo_Venues LEFT JOIN dbo_EventsFlicks ON dbo_Venues.ID = dbo_EventsFlicks.VenueID WHERE...

Hi jdraw, this tutorial seems to be excluding records that one has typed into a table. rather than looking a two tables and providing a list of venues form one table that dont appear in the other. is that right or have i missed something? I am not much of a query designer so i liked the idea...

Thanks folks, a few pointers there - will have a go now and see what i can do... i have tried the unmatched query wizard, but it didnt provide the expected results! Am realising the query is going to need to be more complex - e.g. i need to see if a venue is A: a current venue and B: that they...

Hi Guys I have been trying to work this out using posts from previous queries, but i cant seem to fathom it out. i have a table called Venues and a table called EventsFlicks. they are connected by fields Venues.ID and EventsFlicks. VenueID. What I would like to have is a list of venues that...

Thanks both for replying. Strange how these things work... you comment on getdate() made me think - given the command does work, then it must be talking directly to the sql server. sure enough when i searched for a OpenConnection command, i found a connection to an old server. once i...

Hi Thanks for replying. i took out the getdate WHERE clause, in case. It created an email with hundreds of dates in for that venue but that one record was still missing. the code skips over that date/record (1st july 2018) having googled getdate, i can see anyway that it shouldn't work in...

Hi All, have been scratching more than my head about this one for sometime. hope i can explain it properly. i have a database with 1000 records on it. on a form i will have a filter on which shows me all the events coming up for one venue. i have a button which if pressed generates an email...

Thanks, that worked a treat!

Hi, hope you can help. I have two tables: Venues and Events. The Events table has a field called VenueID which tells me which venue the events will be at. What I would like is a list of venues that haven't booked for the coming season. so within a given date period, I would like a list of...

Thanks all, have found solution. the field curAdultTP is defined elsewhere and has not been defined correctly.