Search results

  1. nhorton79

    Cutting Optimizer

    Maybe: http://www.optimalprograms.com/cut_2d_x.htm Sent from my iPhone using Tapatalk
  2. nhorton79

    Cutting Optimizer

    We use a piece of software /plugin called eCut for CorelDRAW which does nesting based on the shapes selected in the file. It is written in VBA, as CorelDRAW has this available in the background just like Word,Excel,Access etc This is however a paid license but only 60 euros Sent from my...
  3. nhorton79

    Cutting Optimizer

    The keyword you might be looking for is “nesting”. Don’t know how to do this using vba but that keyword might help Sent from my iPhone using Tapatalk
  4. nhorton79

    Changing DSN linked tables to DSNLESS tables

    My clients have no access to tables from a traditional sense. I run as accde. With front end and separate backend however in the deepest depths I have a list box that has a list of tables and if you double click one it can open the table data sheet in readonly. Don’t know why, just sometimes...
  5. nhorton79

    Changing DSN linked tables to DSNLESS tables

    Interesting concept using fixed tables to hold the connection strings and other info. Although I may have to skip that idea, as part of my admin area on the front end client has access to the tables, and I wouldn’t want anyone to have access to those tables and possibly see any info. That’s...
  6. nhorton79

    Changing DSN linked tables to DSNLESS tables

    One more question. My database is normally run from inside our organisation, however I sometimes do some development from home. Whenever I try to connect from home it can’t find the tables as the Home pc doesn’t have connection to the internal IP address of the server, but when I try to connect...
  7. nhorton79

    Changing DSN linked tables to DSNLESS tables

    Thanks Ridders. Sent from my iPhone using Tapatalk
  8. nhorton79

    Changing DSN linked tables to DSNLESS tables

    Hi RuralGuy. I have a question. When I want to make a change to the database, i.e. add a new field to a table. Is it just as easy as going to my backend database, adding the new field and then running the fixconnections function again? Or are there any additional steps? Sent from my iPhone...
  9. nhorton79

    Changing DSN linked tables to DSNLESS tables

    Just found this today after having some issues on a particular workstation that continually asked for connection, hence deciding to go DSN-less. Thank you thank you thank you!
  10. nhorton79

    Create appointment in Outlook with formatted body

    Thanks for that arnelgp. It was certainly looking like an option, but it felt slightly clunky and didn't appear to do everything I needed it to do. I have searched and searched, far and wide, high and low and I finally found something that seems to work really well...the WordEditor and the...
  11. nhorton79

    Create appointment in Outlook with formatted body

    I have attached my database I've been working on, which is currently just the table and forms. There are some misc. functions I was playing around with in there also. I intend to get this working outside of my production database and then import in the tables, forms and any modules that make it...
  12. nhorton79

    Create appointment in Outlook with formatted body

    Hi Cronk, getting error and crashes outlook “remote procedure call failed” Tried both with my field and just sending an empty string. If I comment out the body line the appointment gets created perfectly... so this is the only thing holding me back at present. Sent from my iPhone using Tapatalk
  13. nhorton79

    Create appointment in Outlook with formatted body

    Hi Mark, Thank for the pointer there but have tried with and without this declaration. That was my attempt to generate a byte array which, according to Microsoft, is what appointment bodys take...
  14. nhorton79

    Create appointment in Outlook with formatted body

    Hi All, I am wanting to setup appointments in my Access database, and then have those appointment populate to Outlook 365. I have setup the table (tblAppointments) with the necessary fields and have created a form to handle these (frmAppointments). I have some VBA code which is mostly working...
  15. nhorton79

    Need Help with VBA code

  16. nhorton79

    Need Help with VBA code

    Still learning myself but in your 2nd problem try: <CODE> If nz(Me.Text6,"") = "" Then Msgbox code Elseif nz(Me.Text10,"") = "" Then Msgbox code Else Code as you had it... End If </CODE> Normally you would just say Null, rather than "Null", which is a string. Sent from my iPhone using Tapatalk
  17. nhorton79

    Spell check

    Try looping through all text boxes on the form using: For Each ctlVar In Me.Controls If ctlVar.ControlType = acTextBox Then <= Put your spell check code here End If I’m away from computer at the moment but something like like should be able to help you with a little tinkering...
  18. nhorton79

    Run Time error: 3020 when I move off the record

    What’s the event and code that is calling this function? Sent from my iPhone using Tapatalk
  19. nhorton79

    Decryption SHA1

    What are you trying to achieve with the decrypt? If you're trying to check whether a password entered equals the stored encrypted password you're better not to decrypt. Just check whether the password entered (encrypted) equals the stored encrypted password. Something like: IF...
  20. nhorton79

    The code in this project must be updated for use on 64-bit system

    Have a look at this... https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx Sent from my iPhone using Tapatalk
Back
Top Bottom