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!

Register Log in
  • Congratulations Chriss Miller 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. ElGuapo

    Global scope

    Hi! I am relatively new with php. I have created a page, where users have to register in order to have access to all the forums. The server has PHP 4.2 installed and I cannot find a way to store a variable that I could call from different subpages. I would like to store the UserID. The only...
    • ElGuapo
    • Thread
    • Replies: 1
    • Forum: PHP
  2. ElGuapo

    Calling OpenFile dialog from MSAccess modules

    Does anybody know how to use an OpenFile dialog in MSAccess. I know it has sometnih to do with using dll files, but do not know how to do it. Thanks in advance for your help! Rok
  3. ElGuapo

    Outlook 98 Automation problem

    I have a program that uses Outlook automation to send e-mails generated from a Access database. It works fine with Outlook 97, but a problem appears when using Outlook 98. The programs brings up a dialog, where it promts the user that another program is trying to send an email through VB and...
  4. ElGuapo

    How to display hex data?

    Is there a function in VBA, that would display hex code of a certain character in a binary file (e.g. character A has 41 for hex code, how could I get that 41 out?)
  5. ElGuapo

    Reading the Date stamp of when a file was created

    Use the filedatetime function. ElGuapo
  6. ElGuapo

    Charts from MS Access data

    I would like to create a page that uses MS Access to create charts and graphs on an ASP page. Can anyone suggest me how to that an which of the softwares available on the web to use. 10x in advance. ElGuapo
  7. ElGuapo

    rounding single or time formats

    This function will display a number rounded to the nearest 1/4: Function round_number(data) dim number number= data-int(data) select case(number) number = data - Int(data) Select Case number Case Is > 0.875: number = 1 Case Is > 0.625: number = 0.75 Case Is > 0.375: number = 0.5 Case Is >...
  8. ElGuapo

    rounding single or time formats

    I do not think so, however it is not complicated to write your own function to do so. Case u need help I could be of some assistance.
  9. ElGuapo

    IN

    Instead of using the IN operator use the OR operator. If Me!VehicleNumber.Column(5)= "820" OR "822" OR "824" ... Usually it is better to lookup the data in a table then typing it in into a funciton, but depends on the situation you have. ElGuapo
  10. ElGuapo

    Export to html, can I format the results?

    For a powerful export to HTML, access built in functions are not the best soultion. I do this a lot, and the best way to do it is to use VBA. It requires advanced knowledge of both VBA and HTML, but results are worth it. ElGuapo
  11. ElGuapo

    How do I round a value to 1 decimal place in a function

    Another option just crossed my mind: iif([field1]<0;fix([field1]);-fix(-[field1]) +1) ElGuapo
  12. ElGuapo

    palette source property

    Does anybody know how to use the palette source property in forms and what does it apply to. Thanx, ElGuapo
  13. ElGuapo

    Align center verticaly

    Does anybody konw how I could make a table to be in the center of the screen verticaly? ElGuapo
  14. ElGuapo

    Opening Internet Explorer

    Hello again! Your post was truly very helpful. Now I have encountred another problem. I would like to open two different files using the IE at the same time. If I use your function twice, the second it openes both of the files in the same window, so the first one opened cannot be viewed...
  15. ElGuapo

    Printing access reports into pdf

    Hello! I have an access report that I am outputing to pdf for use on a web page. I do this by using the Pdf writer. That works fine. However I have multiple reports that need to be saved as pdf files, so I have automated the process by using the VB. I now control the pdf writer dialogs by...
  16. ElGuapo

    STILL need urgent help with adding time values together PLEASE

    You can write a global function to calculate the total time, but what you will have to do is to calculate the minutes and seconds separately becuse access built in time functions don't work properly for what you need. I will assume, that you won't be using hours in your syntax and that you will...
  17. ElGuapo

    Opening Internet Explorer

    I have written a procedure that generates a HTML page cointaining data from a database. The user inputs the data to be written to the page usig a form. Now I would like to create a button that opens the created web page for preview in IE. I know how to do it using the shell function, however I...
  18. ElGuapo

    Automating the File-Import-Text Delimited routine

    In my opinon the best way to automate the importation of data into acces tables is to use the VB. That way you will have complete control of the happening and will not be vunerable to stupid errors that occasionaly appear when using the access built in macros and queries. Set a recordset that...
  19. ElGuapo

    Using Automation

    I have been trying to automate output to pdf files for quite some time now. So far the best way I have figured to do so, was to use the sendkeys dunction to control the dialogs. However this does not work well, so I would like to inprove it's preformance. Today, thanks to JoeMiller, I have been...
  20. ElGuapo

    Select profile window after the docmd.sendobject

    I have written a module that sends emails that are generated from a database once a week. The proggie runs on a locked workstation. When I use the sendobject command it prompts me to choose the profile in MS Outlook (97). This prompt window stops the execution of the module. I have solved this...

Part and Inventory Search

Back
Top