Search results

Found this in my stash. Not sure if it is the one i referred to earlier but Hey Ho lol Cheers Nidge

Hi, here is where i found information about this previously- http://ezinearticles.com/?How-to-Build-in-a-Simple-Distance-Checker-Between-Two-UK-Postcodes-Into-Your-Access-Database-in-VBA&id=2408262 what you need on your form text boxes txtPostCodeStart txtPostCodeEnd ( these are...

Maybe this might help http://gpgonaccess.blogspot.co.uk/2010/03/work-in-progress-and-64-bit-vba.html?m=1 From a few of the AWF natives. Cheers Nidge

Hi I haven't checked anything nor have I googled a single thing but I glanced at this and wondered if there was something staring in the face of the confused. If comdlg32.dll works on the 32 bit machines and not on the 64 bit, is it because comdlg32 is exactly what it is? 32? Maybe there is...

Hi Well, either a code example or db example would help for a start. Unfortunately we here at AWF are willing to help and advise but in to do that, we cannot just guess at what you might have done. Post something and we can help further :) Nidge

Hi There is a db kicking around that does just what you are trying to achieve. I posted on to the thread so if you have no luck, search through my posts and you should find it. Cheers Nidge

Hi The db in the link doesn't actually give you the image to paste though does it. Nidge

Hi Phil I'll post a sample db. It's pretty easy to understand when you see it working. I'm out at the minute but will do it later tonight Cheers Nidge

Hi, i think you should either- post the full code so we can see it all and not make us second guess the rest or post a db with the code in. its difficult to assume what else is going on and people will lose interest quite quickly if the info is sporadic, trust me :) we are here to...

Hi The MSINET.OCX is a licenced ActiveX. If you dont have a licence on the machine, you cannot create the oblject. You can register the OCX but not use it unless you have a licence in place. See if it native to Visual Studio Express? if it is, download it as its free from MS. The same this...

Hi, Usually you have to declare variables. for example, i want to save a form name as a string Dim frmMyForm As String frmMyForm = "frmMyFormName" DoCmd.OpenForm frmMyForm without checking, i suspect your issue is the missing ' ! ' when calling forms in Access, its required- If...

Hi to be fair, if there is ever a chance that you download a db be it for helping on here or looking at sample, surely as a developer, you would not just open it without first checking it. If i dl a file from here, i first shift scan it with essentials, then shift open it to look at the code...

Hi I had a routine a while ago that I made to bulk change form properties. If I can remember where I stored it, I'll post it. Basically, in vba, it opened forms in design mode, made changes ( think it was the name ) then saved. Nidge

Yeah, I know the feeling .........

Ok, don't panic and rush to my aid all at once lol :) I have done it and it works beautifully. Cheers Nidge p.s. Sometimes I feel like I talk endlessly to my self without reciprocation lol.

Hi, to try and explain further, i made an image to visually explain. I need to get this reference point Left & Top. Can anyone advise? I am currently using the GetWindowPlacement function but it isnt working right. thanks Nigel

Hi, can anyone help me with form positioning? I need to find the Left & the top of a popup form based on the desktop not the access window. So, if the popup form was say 1 inch in from the top & left of the desktop and the access window was on my other monitor, i would get the position relative...

Randomly enough, you can post to say that you cannot post! why dont you try and put your issue within the post that tells us you cannot post....... the message you are getting comes becasue you do nto have mor ethan 10 posts and you must be trying to a link or an image or something. ITs...

Hi, i am in the process of making a form that, by the click of a button, will open a hole to see the underlying window. the SetLayeredWindowAttributes allows this. Question. My form is a popup and moves freely. i click my button to open the hole and it opens :) My form stops moving and i cant...

Hi Correct me if I'm wrong ( as I don't have means to test right now ) but in order to successfully invalidate a ribbon object, you would have to change its value? Merely invalidating wouldn't necessarily clear it's contents? Cheers Nidge