Search results

  1. NigelShaw

    PTRSafe Question? 32/64 bit office question

    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...
  2. NigelShaw

    Excel

    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
  3. NigelShaw

    Distance between two points (Lat Lon) VBA

    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
  4. NigelShaw

    Google Maps picture into word document

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

    Outlook calendar (Delete and update)

    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
  6. NigelShaw

    how to know which command button is clicked

    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...
  7. NigelShaw

    downloading file with FTP

    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...
  8. NigelShaw

    how to know which command button is clicked

    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...
  9. NigelShaw

    VBA Virus?

    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...
  10. NigelShaw

    Question Change name of control vba

    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
  11. NigelShaw

    popup form co ordinates

    Yeah, I know the feeling .........
  12. NigelShaw

    popup form co ordinates

    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.
  13. NigelShaw

    popup form co ordinates

    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
  14. NigelShaw

    popup form co ordinates

    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...
  15. NigelShaw

    Can't post - error message

    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...
  16. NigelShaw

    SetLayeredWindowAttributes

    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...
  17. NigelShaw

    Ribbon Combo Box

    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
  18. NigelShaw

    could this be done with MsAccess

    Hi Alan I used clarity for a while. My wife has a vinyl logo business and still uses it. It's quite eay to use and has good modules ie production, reports, invoicing, analysis, job cards etc and some good tools ie gerber edge, vinyl cad cut cost creation tools. It's downsides are cost and speed...
  19. NigelShaw

    could this be done with MsAccess

    Hi Alan I'll send you an email tonight. Not sure why you had a return do I'll check that out. Thanks Nidge
  20. NigelShaw

    could this be done with MsAccess

    Hi Alan Would you post the link of the schema or a sample db to date? I'd be interested in co development. I too have started to make something similar to Clarity and want to fill the gaps that it lacks. I have already deloped a grid view of job lists and production scheduling which I have now...
Back
Top Bottom