Search results for query: *

Is there a function that could help me separate out the following date into year & month. The date is stored as 20030101 rather than 01/01/2003

url = http://...index.htm?(Name=namevariable) I've tried to put the following code into my html page, but it is not showing up. This is index.htm <script Language=&quot;JavaScript&quot;> var qry = location.search var qrytextnosplit = qry.substring(1) var qrytext =...

If I have an Excel spreadsheet that I want to be open inside an Access form, what command should I use? I tried using RunApp and Shell function, but it doesn't seem to work. Any suggestion would be appreciated. Thank you!

My problem is that once the user click on a button, a label would be visible. That part I got it. But after they go to the next record, I want the label to disappear. However, that is not happening. Basically, the only time the label appears is when a user click on the specified button for...

I created a subform and w/in my subform is a frame with 4 radio options (Apple, Orange, Grape, Banana). The purpose of this frame is when the user select a certain fruit, it populates the shopper ID and the current date into the field. And I use the following code: Private Sub...

How can I email my Request.QueryString or part of it to a recepient w/o bringing up Outlook mail form. It just do automatically. once it is done executing the page. If I use the mailto, it brings up that mail form. Any suggestion on bypassing that. thank you.

Is there a way that I can have two users using the form at the same time and possibly updating the information at the same time too. One way I was thinking was to open the form as a read-only, and when the user click the update button, then it changes from read-only to editable or something...

I'm not really good with code, but what I'm trying to do is stored the current date field from my form into my table. So what I've done is put =Date() in the Default Value Property and the table field name in the Control Source. But that didn't work.

If current user ID log into the network, I want to have the capability of putting that ID into my current user txt box. Is there a way to do that. I know in DOS, you grab that by using %username% Thank you, -D1004

My page generate the following error, does this mean I have to set my timeout property? error 'ASP 0113' Script timed out /../..Tech.asp The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property...

In ASP, there's an object function called Redirect that allows me to redirect the user to a different url page. Is there a similiar function that exist in Javascript. I know, why don't I just use ASP. The reason is that I don't want to mess up the existing codes already. Thank you so much...

My work place database design really sucks where they include first and last name into one field. However, I need to get the last name to compare with other field, but I don't know how to do that in ASP. I understand you can do that with C++ where you get all the characters until white space...

This is my first time using AS/400, so I'm not sure if i am doing this right. What I am trying to do is create a login application to the AS/400 using ASP. However, I have not create a DSN for the connection. But I'm going to use the connection string instead. When I run, it generates the...

I want to pass the userID & password to AS/400, so what I do is put them into my connection string parameter. However, I can't seem to get it. This is my code: &quot;Provider=IBMDA400;Data Source=blah;Transport Product=Client Access;SSL=DEFAULT; userID = variable1; Database Password =...

Can somebody help me explain how the choose function works. Code: Choose([ServiceCenters]![ID],15,30,46,61,0,0,0,0,0,0,95) If this code is in an update query, and the criteria are met, then it will choose one of this value and updated in the ID field of the ServiceCenters Table?

In one of my page, I compare two numbers. For an example, 12.9% with 9.8%. If 12.9% is higher than 9.8%, then 12.9% is bolded, otherwise, 9.8% is bolded. But somehow, when my program compiles, it determine that 12.9% is smaller than 9.8%. Here is my code: coYR47J78 =...

Hi, I'm like a very very beginner at this, so any inputs are greatly appreciated. What I am trying to do is add my calculated field from the form into my table. What I've done was create a query with my calculated field, then I used that query for my form. After I enter all the information...

Hi, I know that the general rule is not to store the calculated field. But let suppose that in my situation, I have to store it. I create a query to create my form with two calculated field in it, which will populated onto the form when the users enter the data. However, after the users are...

I tried to add the password that the users setup into the database. Basically, they entered their Alias, now they have an opportunity to setup their password. This is the code that I have... But somehow it gives me the following error message when I run it: Error = &quot;Operation must use...

I created a function using Javascript to check whether the users have entered their alias with the following code: function Verify() { if (document.frmProcess1.Alias.value = &quot;&quot;) alert (&quot;Please enter your alias!!!&quot;); } That mean that in my form I need to put name...