Search results

Both. My plan is to fiddle around on the side for a while, get a few extra bucks and, more importantly, more experience. Then one of my club clients is going to say "Hey, this thing you did for my club is really great, can you make one for my business?" Boom. (Yes, of course it's going to be...

My current plan is to tap into the clubs and societies market, producing quite small, simple apps that are disproportionately useful to people who are usually volunteers trying to run a club in their spare time. I've already done a few that I can expand on. It's the sort of thing that the...

Hello. Thanks for your reply. a) Yes, the db is split. My version is Access FE with the BE in sharepoint tables, because I share it with one or two other people in the club. If I give it to other people to use, I was thinking access FE and BE, b) Yes, I have a website. c) Nothing major. A...

Hi, I am a hobby Access-ist, if that's a word, who learned from a book or two for fun and have used what I learned to build a database for my club, which, after being used and improved for several years, now does pretty much what I want and of which I am relatively proud. Being realistic...

That's exactly what I was hoping to do. Just couldn't work out how to mimic the original, though...

Ah, Yes. Sub-reports. Hadn't thought of that. Stupidly obvious, now that I think of it, but I don't do a lot with reports. Thanks.

Hello, I am putting together a database for an association of clubs of which I am a member. The association currently produces its membership directory by someone typing out the information manually into a word document. They don't want to change their format at all (see picture). Is it even...

Hi. I am looking for a piece of code that will look in a field and if it contains just one letter character, add a "." to the field after the letter. If the field is null or already contains more then 1 character, it should be left unaltered. Many thanks.

I have searched and read half a dozen "read only" threads. None of them get a definitive solution. Every now and then, for no discernible reason, my database has a message that says "This database has been opened as read only. You can only change data in linked tables. To make design changes...

I resolved this by changing opentable to opendynaset and using findfirst instead of seek. Takes a heck of a lot longer to run the query, though...

Hi, arnelgp, This issue isn't as solved as I thought it was. My application is in an access front end linked to sharepoint tables. When I run the code as is, I get "Runtime error 3219: Invalid Operation" on the line: Set rs = db.OpenRecordset("tblPatrons", dbOpenTable)...

Good. Sorry I wasn't more help.

Sorry, I lost sight of this. Have you resolved it yet?

Yes and yes. Thank you both very much indeed. :)

Hi, arnelgp, Yep this is awesome, thanks. I thought I knew a bit of code, but I have read the code and SQL thoroughly - and I have absolutely not clue what you have done there or how it works... I'm putting it down to magic... (same goes for Plog's solution, too...)

I think we might have an "across-the-pond" error here. My dates are dd/mm/yyyy - I suspect you might be using mm/dd/yyyy...?

Hi, Plog, This is awesome. You are very kind to go to all this trouble. Being very aware of not looking gift horses in the mouth, the module does not appear to be working completely as I think you intended. It is returning all of the annual payments in January, instead of in the...

Okey doke. Example attached many thanks

Yeah, that's what I was worried about. I thought it might not be possible. No. All I have is the information as above, which is imported from elsewhere. I have no control over the format. The best way I can describe it is as a spreadsheet with 12 or 24 months along the top, a row for every...

The data is imported so I have to work with what I have got. I am just looking for cashflow - so a monthly gift shows up every month, an annual gift shows up only in the relevant month, a one-off shows up once... Thanks