Recent content by d1004

Suppose I have two types of time field. One is in military time, and another is regular. For example 1610 ---- military time for 4:10 435 ---- regular time for 4:35 I need to make this two fields consistent in order to subtract them to get the completed time. But I don't know how to approach...

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!

I will...thanks for letting me know...All this time, I never star it.

Ohhh, that works..But now I have another dilemma...But it doesn't relate to this issue..Anyhow, thank you very much.

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

It still give me the same error message.

Well, I used the following codes, but it gave me the following errors: Dim objMail set objMail = Server.CreateObject(&quot;CDONTS.Newmail&quot;) objMail.From = &quot;blah@blah.com&quot; objMail.To = &quot;blah@blah.com&quot; objMail.Subject = &quot;Testing&quot; objMail.Body =...

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.

I tried the environ(&quot;username&quot;), and it works for Window 2000 OS, but it wouldn't let me for Window 95. Is there any other method? Thank you

What if I had the Default Record Locking as No Lock because that seems to let two users use the form without one going into read-only

I tried all this, but what is happening is that let's say user 1 open the form and use it. Everything works great. But when user 2 open the form, it is read-only, and the userID field populate the user1 ID rather than user2. I guess what I am trying to do is to have a capability where both...

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