Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. oharab

    vba xmlhttprequest API oauth configuration

    The Authorization header is simply a Base64 encoding of the username and password joined with a colon: reader.setRequestHeader "Authorization", EncodeBase64(strUserName & ":" & strOauthToken) There are plenty of Base64 functions out there, but something like this would work Function...
  2. oharab

    Access jumps into the VBA code editor for no reason

    I've had this in the past where it seems to remember an old break point, even if the code around it has changed. I think it's a form of corruption. Try compiling the code (Debug -> Compilie VBA Code), compacting and repairing the database, exporting the code to a file then deleting the module...
  3. oharab

    Send command to RS-232 serial port

    I'm not sure if it's compatible with MS Access forms, but you could try looking into the MSComm control. This will allow you to interact with COM ports. B. ---------------------------------------------- Ben O'Hara
  4. oharab

    Importing GPX Files into Google Maps

    I've not done this myself, but you could try taking a look at http://www.gpsvisualizer.com/map_input?form=google. This will import your data and give you a google map. I'm not sure what it does about hosting, but it looks like a good starter for 10. hth Ben...
  5. oharab

    How do you programmatically expand a url link to its true location?

    These url services just redirect from the shorter/encrypted url to the actual url. Open up Fiddler and watch what happens. A GET is sent to http://www.baidu.com/link?url=mW91GJqjJ4zBBpC8yDF8xDhiqDSn1JZjFWsHhEoSNd85PkV8Xil7qccoOX3rynaE, which is returned with a status of 302 (which means redirect...
  6. oharab

    Wscript PopUp make application modal in MS Access

    Mine works on my machine too. My example uses the same api timer as yours (SetTimer and KillTimer from the user32 lib). Perhaps the OS/version is the issue here. I'm using Access 2003 on windows XP. The same code (with a minor alteration) works in Excel 2007 too. Are you using the exact code...
  7. oharab

    Wscript PopUp make application modal in MS Access

    It's actually dead simple to use, and can be run in a module too. I imported the code into a test database and it worked almost first time. Firstly create a new module (I've called it basMessageBoxTimer) and paste the first block of code into it (there's a handy "copy bas code" button which...
  8. oharab

    DoCmd.Transfertext not working

    I must admit, whenever I'm exporting tables/queries to text files, I rely on this class. It's much more configurable and is often more reliable in my experience. hth Ben ---------------------------------------------- Ben O'Hara
  9. oharab

    Wscript PopUp make application modal in MS Access

    Take a look at the code on http://vbnet.mvps.org/index.html?code/hooks/messageboxhooktimer.htm This will give you a configurable API messagebox that counts down for a user definable time. hth Ben ---------------------------------------------- Ben O'Hara
  10. oharab

    assembly reference not working in C# script

    The S.W.Forms dll is installed in the GAC 'cos that's where it needs to sit to resolve all its dependencies. You may be able to find out what its dependencies are by changing the registry key as mentioned, but what you are trying to do is bypass the GAC, which isn't possible. What is it you are...
  11. oharab

    Parsing out an address

    I've done some quick googling & can't find any software called Sterling with a version of 6.2. Can you give some more details? Regardless of the software, there's usally some sort of string parsing functionality in it. Is there an equivalent to Instr() or Find() that you can combine with Mid()...
  12. oharab

    Aggregating Left Join in NHibernate using QueryOver/ICriteria

    The answer was the JoinAlias method, with an alias placeholder: Comment comment=null; var results=session.QueryOver<Blog>() .Left.JoinAlias(b=>b.Comments,()=>comment) .SelectList( list=>list .SelectGroup(b=>b.Id) .SelectGroup(b=>b.Title)...
  13. oharab

    Aggregating Left Join in NHibernate using QueryOver/ICriteria

    I have two simple classes public class Blog { public Blog(){ Comments=new List<Comment>(); } public virtual Guid Id { get; set; } public virtual string Title { get; set; } public virtual string Text { get; set; } public virtual DateTime CreatedDate { get; set; }...
  14. oharab

    ESRI gdb format

    You should be able to use the ogr2ogr application. Download and install osgeo4w from http://trac.osgeo.org/osgeo4w/ when you install it go to the advanced tab and make sure you install gdal-filegdb: OGR FileGDB Driver (There are details and screen shots here...
  15. oharab

    DLOOKUP Coding

    Your logic is wrong. If your requirement is that the permission is Neither "Coaching Logger" nor "Admininstrator" then you need to use AND. hth Ben ---------------------------------------------- Ben O'Hara
  16. oharab

    Cycling through files in a folder

    You may also want to consider using the FileSystemObject which has a richer set of functionality for working with folders and files IMHO. For your code, I suggest you split things up into individual functions so that your code works like: PSEUDOCODE!!!! for each xlFile in ListOfXLFiles if...
  17. oharab

    Editing a txt file using Access VBA

    The code I've posted doesn't save the document, it just outputs the xml as a string (that was all I needed for my testing). To save the file you need to call the save method of the xml document. hth Ben ---------------------------------------------- Ben O'Hara
  18. oharab

    Editing a txt file using Access VBA

    A couple of extra links you might find useful are http://www.w3schools.com/dom/ to give you the basics on using the XML DOM and http://msdn.microsoft.com/en-us/library/windows/desktop/ms764730(v=vs.85).aspx for the details of using the MS implementation. Using those links you should be able to...
  19. oharab

    Sending Lotus Note thru MSAccess

    As I recall, you just comma separate the addresses: strRecipient="user1@example.com,user2@example.com,user3@example.com" but it's been a while since I had Lotus Notes on my machine. If that doesn't work, try using a semi-colon instead of a comma. hth Ben...
  20. oharab

    Inserting carriage return in Outlook HTML from Access VBA

    You're using HTML email, so doesn't your string need to be in html? objMail.HTMLBody = "Ticket " & intTixNum & " has been entered into Ticket Tracker by " & strEmpName & " concerning " & strIssue & ". <br />" & strSomestr & " " or objMail.HTMLBody = "<p>Ticket " & intTixNum & " has been...

Part and Inventory Search

Back
Top