Search results

True but the difference between saying I'll stay on 2003 to keep things the same, and say "bloody hell, none of the major software companies are supporting this!!!" I'm happy to go to 64 bit when basic things work. I tried to ignore it, but the people at MYOB have no plans, ever, to make the...

True enough. I'm VERY lucky to be administrator and in a position to easily make that choice. Having said that, is wasn't just Access or me, MYOB wouldn't support 64 bit properly either. It caused so many problems in the long run there are very good arguments for everyone removing it. I would...

Get rid of 64bit office. End of Story. It's evil. Run 64 bit windows with 32 bit office.

Very happy to help. http://www.peterssoftware.com/dd.htm Peter's software. It's a cheap module add on. Really works :) Must program a bit to get any really use out of it of course. But it saves you an amazing amount of time compared to developing one yourself. you can private message me on...

I wonder if their customers are as keen to loose features as they are to remove them...hmmmm.

Now I'm really confused :/ The tables are imported from MYOB I tend to never delete them so never noticed this berfore... no relationships are saved yet even this simple beast cannot delete a record, both are plain tables no queries! Check out this screenshot of 2 plain joined tables, I know I...

This screen shot might save some time explaining the situations too!

Ok, I'll start by admitting my SQL-fu is weak, and I tend to just edit what I get from the query designer, it seems to work out *most* of the time... I have a bunch of MYOB table data, I need to compare tables and remove old records from one based on criteria from the other. Here's the rub...

I have mixed feelings...but in the end, resistance is futile. We will be assimilated. I DO have hopes for the merging of windows 8 and tablets data and functionality. Tablets MAY now become useful in the workplace... I see great potential in the new design look for better interface...but I NEED...

fair enough! I'll make sure at the very least I comment the hell out of it then.

but is there anything wrong with the solution I posted after? it seems to work fine.

Solution for those that need it ( I couldn't find this online so here it is): When you remove from a collection of say 16 1 item the collection count changes to 15 immediately. so on the next round of the loop we remove item 2 of 15, 3 of 14 and so on, removing only half of any given...

I think this should be easy; for some reason it isn't. I'm trying to clear an existing class collection. To start with : lngIndex = 1 For lngIndex = 1 To colBars.Count colBars.Remove (lngIndex) Next lngIndex has interesting results. watching it under action, what happens is it works...

Also I find a good place to start is researching topics that may/may not be useful. You won't know what the best approach is till you look at a few. I was browsing this morning and found some data that MAY be helpful depending on which road you go. If I were you I would go over it and file it...

I could help you with access and vba but haven't tried doing advertising...however I do things I don't know all the time. If it were me I would break this down into parts. the front end vba driven database will be a number of steps, but the advertising i would imagine is hosted and distributed...

Also I'm pretty sure this returns the co-oords in "twips" not pixels or mickeys, just so you know.

lol possible but don't see users thanking you for it.

What code are you using? I use this: DoCmd.SendObject acSendReport, "<<sending attachement>>", _ << attachment type>>, <<"recipients">>, , , "<<message subject>>", _ "<<message body>>", _ True is this what you are using? maybe the question isn't clear, don't you just include the...

Just a final note to let you know it all went well - thanks so much for all you help!!! I would love to upload a final version for people to look at but it includes a 3rd party drag-drop module that I don't have the right to distribute freely. Again thanks for making it all possible.

lmao! for fracks sake I'm all over the shop this week. 1680x1050.