Search results for query: *

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

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.

This is a really stupid question, but can I put that function inside my Private Sub UserID_Enter() Thank you!

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

I haven't change any codes. The only thing I've changed is that I've added more records into the database. So far, my database contains about 17,000 records. I don't think I have max out my capacity.

So do you have any suggestion as to why it takes so long to generate my report? I try to index certain fields as well as compact my Access database, but it still takes 10 minutes to generate the page. The thing that it puzzles me is that it didn't take this long before?