Search results for query: *

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

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

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

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?)

Use the filedatetime function. ElGuapo

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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